{"status":"ok","count":7,"catalog":[{"product_id":"401529","product_name":"Hazzel M Prints Basics 1001-1003 Series Latest fancy Pakistani Salwar Kameez Wholesaler Surat Gujarat","brand_name_name":"Hazzel","cname":"M Prints Basics ","product_seo_url":"hazzel-m-prints-basics-1001-1003-series-latest-fancy-pakistani-salwar-kameez-wholesaler-surat-gujarat","product_image":"https:\/\/prathamexports.com\/images\/product\/2023\/09\/hazzel-m-prints-basics-1001-1003-series-latest-fancy-pakistani-salwar-kameez-wholesaler-surat-gujarat-2023-09-16_01_57_24.jpg","product_qty":"1","sale_price":"1797","product_price":"599","product_mrp_price":"649","catalog_pcs":"3","regular_price":null,"disable_date":"2023-09-23 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"3Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":8,"productview":"227","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"16th Sep 2023","salelable":""},{"product_id":"401528","product_name":"hazzel m prints basics 1001-1003 series latest pakistani salwar kameez wholesaler surat gujarat","brand_name_name":"Hazzel","cname":"m prints basics","product_seo_url":"hazzel-m-prints-basics-1001-1003-series-latest-pakistani-salwar-kameez-wholesaler-surat-gujarat","product_image":"https:\/\/prathamexports.com\/images\/product\/2023\/09\/hazzel-m-prints-basics-1001-1003-series-latest-pakistani-salwar-kameez-wholesaler-surat-gujarat-2023-09-16_01_52_41.jpg","product_qty":"1","sale_price":"1650","product_price":"550","product_mrp_price":"600","catalog_pcs":"3","regular_price":null,"disable_date":"2023-09-23 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"3Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":8,"productview":"215","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"16th Sep 2023","salelable":""},{"product_id":"401254","product_name":"hazzel ayesha zara premium collections vol-8 8001-8002 series latest pakistani salwar kameez wholesaler surat gujarat","brand_name_name":"Hazzel","cname":"ayesha zara premium collections vol-8","product_seo_url":"hazzel-ayesha-zara-premium-collections-vol-8-8001-8002-series-latest-pakistani-salwar-kameez-wholesaler-surat-gujarat","product_image":"https:\/\/prathamexports.com\/images\/product\/2023\/09\/hazzel-ayesha-zara-premium-collections-vol-8-8001-8002-series-latest-pakistani-salwar-kameez-wholesaler-surat-gujarat-2023-09-02_14_44_25.jpg","product_qty":"1","sale_price":"1250","product_price":"625","product_mrp_price":"655","catalog_pcs":"2","regular_price":null,"disable_date":"2023-09-09 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"2Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":5,"productview":"276","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"2nd Sep 2023","salelable":""},{"product_id":"400633","product_name":"hazzle maria b mprints 23-4 3361-3362 series designer pakistani salwar kameez wholesaler surat gujarat","brand_name_name":"Hazzel","cname":"maria b mprints 23-4 ","product_seo_url":"hazzle-maria-b-mprints-23-4-3361-3362-series-designer-pakistani-salwar-kameez-wholesaler-surat-gujarat","product_image":"https:\/\/prathamexports.com\/images\/product\/2023\/08\/hazzle-maria-b-mprints-23-4-3361-3362-series-designer-pakistani-salwar-kameez-wholesaler-surat-gujarat-2023-08-05_13_16_14.jpg","product_qty":"1","sale_price":"1250","product_price":"625","product_mrp_price":"675","catalog_pcs":"2","regular_price":null,"disable_date":"2023-08-10 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"2Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":7,"productview":"211","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"5th Aug 2023","salelable":""},{"product_id":"400520","product_name":"hazzel m prints remix spring summer 23 vol-3 nx latest designer pakistani salwar suits catalogue online wholesale surat","brand_name_name":"Hazzel","cname":"m prints remix spring summer 23 vol-3 nx","product_seo_url":"hazzel-m-prints-remix-spring-summer-23-vol-3-nx-latest-designer-pakistani-salwar-suits-catalogue-online-wholesale-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2023\/07\/hazzel-m-prints-remix-spring-summer-23-vol-3-nx-latest-designer-pakistani-salwar-suits-catalogue-online-wholesale-surat-2023-07-31_12_51_11.jpg","product_qty":"2","sale_price":"2097","product_price":"699","product_mrp_price":"749","catalog_pcs":"3","regular_price":null,"disable_date":"2023-08-02 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"3Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":7,"productview":"321","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"31st Jul 2023","salelable":""},{"product_id":"400518","product_name":"hazzel m prints remix spring summer 23 vol-3 nx unstich designer pakistani salwar suits dress material catalogue surat","brand_name_name":"Hazzel","cname":"m prints remix spring summer 23 vol-3 nx","product_seo_url":"hazzel-m-prints-remix-spring-summer-23-vol-3-nx-unstich-designer-pakistani-salwar-suits-dress-material-catalogue-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2023\/07\/hazzel-m-prints-remix-spring-summer-23-vol-3-nx-unstich-designer-pakistani-salwar-suits-dress-material-catalogue-surat-2023-07-31_12_39_10.jpg","product_qty":"2","sale_price":"1950","product_price":"650","product_mrp_price":"700","catalog_pcs":"3","regular_price":null,"disable_date":"2023-08-02 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"3Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":7,"productview":"295","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"31st Jul 2023","salelable":""},{"product_id":"399349","product_name":"hazzel 104 series trendy designer pakistani salwar suits collection 2023 ","brand_name_name":"Hazzel","cname":"104 series","product_seo_url":"hazzel-104-series-trendy-designer-pakistani-salwar-suits-collection-2023","product_image":"https:\/\/prathamexports.com\/images\/product\/2023\/05\/hazzel-104-series-trendy-designer-pakistani-salwar-suits-collection-2023-2023-05-26_12_29_20.jpg","product_qty":"2","sale_price":"4400","product_price":"1100","product_mrp_price":"1150","catalog_pcs":"4","regular_price":null,"disable_date":"2023-05-28 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"4Kg","fabric_name123":"Faux Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":4,"productview":"332","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"26th May 2023","salelable":""}],"oo":"select pm.* from brand_relation_master as brm left join product_master as pm on pm.product_id=brm.product_id where 1=1 and pm.product_price!=0 and brm.brand_id='1283' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}