{"status":"ok","count":15,"catalog":[{"product_id":"391357","product_name":"esta eris 1001-1008 series designer straight salwar kameez by pratham fashion surat","brand_name_name":"Esta Designs","cname":"eris","product_seo_url":"esta-eris-1001-1008-series-designer-straight-salwar-kameez-by-pratham-fashion-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/04\/esta-eris-1001-1008-series-designer-straight-salwar-kameez-by-pratham-fashion-surat-2022-04-18_22_47_42.jpg","product_qty":"2","sale_price":"14360","product_price":"1795","product_mrp_price":"1845","catalog_pcs":"8","regular_price":null,"disable_date":"2022-04-21 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Fancy","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":3,"productview":"515","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"18th Apr 2022","salelable":""},{"product_id":"390812","product_name":"esta cubical 1001-1008 series stylish designer salwar kameez wholesale price surat ","brand_name_name":"Esta Designs","cname":"cubical ","product_seo_url":"esta-cubical-1001-1008-series-stylish-designer-salwar-kameez-wholesale-price-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/03\/esta-cubical-1001-1008-series-stylish-designer-salwar-kameez-wholesale-price-surat-2022-03-29_15_59_19.jpg","product_qty":"2","sale_price":"15160","product_price":"1895","product_mrp_price":"1945","catalog_pcs":"8","regular_price":null,"disable_date":"2022-03-31 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":3,"productview":"642","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"29th Mar 2022","salelable":""},{"product_id":"390621","product_name":"esta tribal fancy dress material catalogue wholesaler surat online ","brand_name_name":"Esta Designs","cname":"tribal","product_seo_url":"esta-tribal-fancy-dress-material-catalogue-wholesaler-surat-online","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/03\/esta-tribal-fancy-dress-material-catalogue-wholesaler-surat-online-2022-03-21_18_54_51.jpg","product_qty":"2","sale_price":"11950","product_price":"1195","product_mrp_price":"1245","catalog_pcs":"10","regular_price":null,"disable_date":"2022-03-23 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"10Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":4,"productview":"466","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"21st Mar 2022","salelable":""},{"product_id":"390285","product_name":"esta paisley 101-110 series trendy designer salwar kameez manufacturer surat","brand_name_name":"Esta Designs","cname":"paisley ","product_seo_url":"esta-paisley-101-110-series-trendy-designer-salwar-kameez-manufacturer-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/03\/esta-paisley-101-110-series-trendy-designer-salwar-kameez-manufacturer-surat-2022-03-05_19_14_11.jpg","product_qty":"2","sale_price":"11950","product_price":"1195","product_mrp_price":"1245","catalog_pcs":"10","regular_price":null,"disable_date":"2022-03-07 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"10Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":4,"productview":"596","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"5th Mar 2022","salelable":""},{"product_id":"390282","product_name":"esta kantha indian designer salwar kameez online supplier surat","brand_name_name":"Esta Designs","cname":"Kantha","product_seo_url":"esta-kantha-indian-designer-salwar-kameez-online-supplier-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/03\/esta-kantha-indian-designer-salwar-kameez-online-supplier-surat-2022-03-05_18_54_44.jpg","product_qty":"2","sale_price":"9560","product_price":"1195","product_mrp_price":"1245","catalog_pcs":"8","regular_price":null,"disable_date":"2022-03-07 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Cotton Cambric","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":4,"productview":"514","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"5th Mar 2022","salelable":""},{"product_id":"389967","product_name":"esta zuri 1001-1009 series exclusive designer salwar kameez collection 2022","brand_name_name":"Esta Designs","cname":"zuri","product_seo_url":"esta-zuri-1001-1009-series-exclusive-designer-salwar-kameez-collection-2022","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/02\/esta-zuri-1001-1009-series-exclusive-designer-salwar-kameez-collection-2022-2022-02-21_14_15_02.jpg","product_qty":"2","sale_price":"16155","product_price":"1795","product_mrp_price":"1845","catalog_pcs":"9","regular_price":null,"disable_date":"2022-02-23 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"9Kg","fabric_name123":"Muslin Silk","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":3,"productview":"615","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"21st Feb 2022","salelable":""},{"product_id":"389892","product_name":"esta designer samara salwar kameez catalogue surat online market","brand_name_name":"Esta Designs","cname":"samara","product_seo_url":"esta-designer-samara-salwar-kameez-catalogue-surat-online-market","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/02\/esta-designer-samara-salwar-kameez-catalogue-surat-online-market-2022-02-17_16_37_26.jpg","product_qty":"2","sale_price":"9560","product_price":"1195","product_mrp_price":"1245","catalog_pcs":"8","regular_price":null,"disable_date":"2022-02-19 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Cotton Satin","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":4,"productview":"416","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"17th Feb 2022","salelable":""},{"product_id":"389842","product_name":"esta designes levana salwar kameez catalogue wholesale price surat","brand_name_name":"Esta Designs","cname":"levana","product_seo_url":"esta-designes-levana-salwar-kameez-catalogue-wholesale-price-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/02\/esta-designes-levana-salwar-kameez-catalogue-wholesale-price-surat-2022-02-15_15_54_08.jpg","product_qty":"2","sale_price":"7950","product_price":"795","product_mrp_price":"825","catalog_pcs":"10","regular_price":null,"disable_date":"2022-02-17 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":4,"productview":"569","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"15th Feb 2022","salelable":""},{"product_id":"265045","product_name":"Aria By Esta Designer Wholesale Pashmina Dobby Embroidery Work Suits Collection Online Surat","brand_name_name":"Esta Designs","cname":"aria","product_seo_url":"aria-by-esta-designer-wholesale-pashmina-dobby-embroidery-work-suits-collection-online-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2019\/10\/265045_1634828960.jpg","product_qty":"1","sale_price":"20340","product_price":"1695","product_mrp_price":"1695","catalog_pcs":"12","regular_price":null,"disable_date":"2021-10-21 15:09:20","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":0,"productview":"1024","size_name":"Materials","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"17th Oct 2019","salelable":""},{"product_id":"237645","product_name":"Esta Sarah Cotton Digital Printed Indian Salwar Kameez Collection Manufacturer Dealer At Surat Wholesaler","brand_name_name":"Esta Designs","cname":"Sarah","product_seo_url":"esta-sarah-cotton-digital-printed-indian-salwar-kameez-collection-manufacturer-dealer-at-surat-wholesaler","product_image":"https:\/\/prathamexports.com\/images\/product\/2019\/06\/237645_1634835308.jpg","product_qty":"1","sale_price":"11940","product_price":"995","product_mrp_price":"995","catalog_pcs":"12","regular_price":null,"disable_date":"2021-10-21 16:55:08","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":0,"productview":"538","size_name":"Unstitched","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"27th Jun 2019","salelable":""},{"product_id":"205551","product_name":"Esta Designer Zareena Dyed Jequard Cotton Salwar Kameez Wholsale Price Online Surat Textile","brand_name_name":"Esta Designs","cname":"Zareena","product_seo_url":"esta-designer-zareena-dyed-jequard-cotton-salwar-kameez-wholsale-price-online-surat-textile","product_image":"https:\/\/prathamexports.com\/images\/product\/2019\/03\/205551_1634840675.jpg","product_qty":"1","sale_price":"11865","product_price":"1695","product_mrp_price":"1695","catalog_pcs":"7","regular_price":null,"disable_date":"2021-10-21 18:24:35","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":0,"productview":"495","size_name":"Unstitched","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"30th Mar 2019","salelable":""},{"product_id":"185228","product_name":"Esta Designer Cadbury Catalog Cotton Satin With Heavy Embroidery Work Suits Wholesale Seller","brand_name_name":"Esta Designs","cname":"Cadbury","product_seo_url":"esta-designer-cadbury-catalog-cotton-satin-with-heavy-embroidery-work-suits-wholesale-seller","product_image":"https:\/\/prathamexports.com\/images\/product\/2019\/01\/185228_1634844427.jpg","product_qty":"1","sale_price":"20340","product_price":"1695","product_mrp_price":"1695","catalog_pcs":"12","regular_price":null,"disable_date":"2021-10-21 19:27:07","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":0,"productview":"548","size_name":"Unstitched","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"30th Jan 2019","salelable":""},{"product_id":"171994","product_name":"Esta Design Launch Inspire Catalog Wholesale Fancy Sarees Collection","brand_name_name":"Esta Designs","cname":"Inspire","product_seo_url":"esta-design-launch-inspire-catalog-wholesale-fancy-sarees-collection","product_image":"https:\/\/prathamexports.com\/images\/product\/2018\/11\/171994_1634847123.jpg","product_qty":"1","sale_price":"13377","product_price":"1029","product_mrp_price":"1029","catalog_pcs":"13","regular_price":null,"disable_date":"2021-10-21 20:12:03","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>1<\/span><\/span><\/a>","discount":0,"productview":"612","size_name":"Unstitched","category_name":"Sarees","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"23rd Nov 2018","salelable":""},{"product_id":"170373","product_name":"Esta Design Launch Adorable Pashmina Prints With Swarovski Work Suits Collection","brand_name_name":"Esta Designs","cname":"Adorable","product_seo_url":"esta-design-launch-adorable-pashmina-prints-with-swarovski-work-suits-collection","product_image":"https:\/\/prathamexports.com\/images\/product\/2018\/11\/170373_1634847463.jpg","product_qty":"1","sale_price":"17940","product_price":"1495","product_mrp_price":"1495","catalog_pcs":"12","regular_price":null,"disable_date":"2021-10-21 20:17:43","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":0,"productview":"824","size_name":"Unstitched","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"13th Nov 2018","salelable":""},{"product_id":"168796","product_name":"Esta Designer Launch Arshiyan Catalog Pure Cotton Silk Work Party Wear Suits Collection","brand_name_name":"Esta Designs","cname":"Arshiyan","product_seo_url":"esta-designer-launch-arshiyan-catalog-pure-cotton-silk-work-party-wear-suits-collection","product_image":"https:\/\/prathamexports.com\/images\/product\/2018\/10\/168796_1634878961.jpg","product_qty":"1","sale_price":"21540","product_price":"1795","product_mrp_price":"1795","catalog_pcs":"12","regular_price":null,"disable_date":"2021-10-22 05:02:41","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":0,"productview":"851","size_name":"Unstitched","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"25th Oct 2018","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='356' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}