{"status":"ok","count":20,"catalog":[{"product_id":"388326","product_name":"alizeh sparkle vol 2 1039-1046 party wear bridal lehenga collection wholesale price","brand_name_name":"Alizeh","cname":"sparkle vol 2","product_seo_url":"alizeh-sparkle-vol-2-1039-1046-party-wear-bridal-lehenga-collection-wholesale-price","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/11\/alizeh-sparkle-vol-2-1039-1046-party-wear-bridal-lehenga-collection-wholesale-price-2021-11-25_17_27_52.jpg","product_qty":"2","sale_price":"50064","product_price":"6258","product_mrp_price":"6300","catalog_pcs":"8","regular_price":null,"disable_date":"2021-12-11 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"24Kg","fabric_name123":"Net","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":1,"productview":"644","size_name":"","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"25th Nov 2021","salelable":""},{"product_id":"385602","product_name":"Alizeh Wedding Affair Vol 2 1035-1035 Series Designer Wedding Lehenga Collection Wholesale Price","brand_name_name":null,"cname":"wedding affair vol 2","product_seo_url":"alizeh-wedding-affair-vol-2-1035-1035-series-designer-wedding-lehenga-collection-wholesale-price","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/10\/385602_1634724952.jpg","product_qty":"1","sale_price":"23800","product_price":"5950","product_mrp_price":"5950","catalog_pcs":"4","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"690","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"12th Oct 2021","salelable":""},{"product_id":"384331","product_name":"Maisha Vivaana Vol 4 400001-400005 Series Party Wear Lehenga Collection Wholesale Price","brand_name_name":"Maisha Maskeen","cname":"vivaana vol 4","product_seo_url":"maisha-vivaana-vol-4-400001-400005-series-party-wear-lehenga-collection-wholesale-price","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/10\/384331_1634725259.jpg","product_qty":"1","sale_price":"25475","product_price":"5095","product_mrp_price":"5095","catalog_pcs":"5","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"454","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"8th Oct 2021","salelable":""},{"product_id":"384178","product_name":"Tips&tops Lehenga Catalogue Wholesale Dealer Surat Market","brand_name_name":null,"cname":"lehenga","product_seo_url":"tipstops-lehenga-catalogue-wholesale-dealer-surat-market","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/10\/384178_1634725299.jpg","product_qty":"1","sale_price":"4950","product_price":"825","product_mrp_price":"825","catalog_pcs":"6","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"744","size_name":"Materials","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"7th Oct 2021","salelable":""},{"product_id":"383259","product_name":"Alizeh Engagement Vol 2 Party Wear Collection Lehenga Wholesale Price Surat","brand_name_name":null,"cname":"engagement vol 2","product_seo_url":"alizeh-engagement-vol-2-party-wear-collection-lehenga-wholesale-price-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/10\/383259_1634725552.jpg","product_qty":"1","sale_price":"32640","product_price":"5440","product_mrp_price":"5440","catalog_pcs":"6","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"500","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"4th Oct 2021","salelable":""},{"product_id":"376016","product_name":"Alizeh Presents Sparkle 1027-1028 Series Wedding Lehenga Collection Wholesale Price","brand_name_name":null,"cname":"sparkle","product_seo_url":"alizeh-presents-sparkle-1027-1028-series-wedding-lehenga-collection-wholesale-price","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/09\/376016_1634727607.jpg","product_qty":"1","sale_price":"47800","product_price":"5975","product_mrp_price":"5975","catalog_pcs":"8","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"498","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"8th Sep 2021","salelable":""},{"product_id":"375493","product_name":"Aawiya Rajwadi Vol 2 8001-8008 Series Navratri Special Collection","brand_name_name":null,"cname":"rajwadi vol 2","product_seo_url":"aawiya-rajwadi-vol-2-8001-8008-series-navratri-special-collection","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/09\/375493_1634727757.jpg","product_qty":"1","sale_price":"10392","product_price":"1299","product_mrp_price":"1299","catalog_pcs":"8","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"355","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"6th Sep 2021","salelable":""},{"product_id":"374948","product_name":"Navratri Collection Sakshi Vol 1 Catalogue Designer Lehenga Collection Wholesale Price Surat","brand_name_name":null,"cname":"sakshi vol 1","product_seo_url":"navratri-collection-sakshi-vol-1-catalogue-designer-lehenga-collection-wholesale-price-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/09\/374948_1634727896.jpg","product_qty":"1","sale_price":"6750","product_price":"1350","product_mrp_price":"1350","catalog_pcs":"5","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"468","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Sep 2021","salelable":""},{"product_id":"374845","product_name":"Senhora Bridal Heritage Colour Saga Vol 5 Bridal Lehenga Collection Wholesale Price Surat","brand_name_name":null,"cname":"heritage colour saga vol 5","product_seo_url":"senhora-bridal-heritage-colour-saga-vol-5-bridal-lehenga-collection-wholesale-price-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/09\/374845_1634727928.jpg","product_qty":"1","sale_price":"14997","product_price":"4999","product_mrp_price":"4999","catalog_pcs":"3","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"693","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Sep 2021","salelable":""},{"product_id":"374191","product_name":"Alizeh Sangeet 1023-1026 Series Party Wear Lehenga Collection Wholesale Dealer Surat","brand_name_name":null,"cname":"sangeet","product_seo_url":"alizeh-sangeet-1023-1026-series-party-wear-lehenga-collection-wholesale-dealer-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/09\/374191_1634728127.jpg","product_qty":"1","sale_price":"21180","product_price":"5295","product_mrp_price":"5295","catalog_pcs":"4","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"368","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"1st Sep 2021","salelable":""},{"product_id":"368359","product_name":"Shivali Fashion Riwazz Vol 2 Party Wear Look Lehenga Collection Wholesale Price","brand_name_name":"Shivali S4u","cname":"riwazz vol 2","product_seo_url":"shivali-fashion-riwazz-vol-2-party-wear-look-lehenga-collection-wholesale-price","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/08\/368359_1634729937.jpg","product_qty":"1","sale_price":"10650","product_price":"1775","product_mrp_price":"1775","catalog_pcs":"6","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"540","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"5th Aug 2021","salelable":""},{"product_id":"366290","product_name":"Alizeh Wedding Affair 1020-1022 Series Bridal Lehenga Collection Wholesale Price","brand_name_name":null,"cname":"wedding afair","product_seo_url":"alizeh-wedding-affair-1020-1022-series-bridal-lehenga-collection-wholesale-price","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/07\/366290_1634730576.jpg","product_qty":"1","sale_price":"23805","product_price":"7935","product_mrp_price":"7935","catalog_pcs":"3","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"555","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"26th Jul 2021","salelable":""},{"product_id":"364089","product_name":"Shubhkala Brides Vol 1 1701-1705 Series Party Wear Bridal Lehenga Collection Wholesale Price","brand_name_name":null,"cname":"brides vol 1","product_seo_url":"shubhkala-brides-vol-1-1701-1705-series-party-wear-bridal-lehenga-collection-wholesale-price","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/07\/364089_1634731231.jpg","product_qty":"1","sale_price":"19995","product_price":"3999","product_mrp_price":"3999","catalog_pcs":"5","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"318","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"15th Jul 2021","salelable":""},{"product_id":"360932","product_name":"Virasat Nartaki 2001-2006 Series Lehenga Choli Catalogue Wholesale Price Surat","brand_name_name":null,"cname":"nartaki","product_seo_url":"virasat-nartaki-2001-2006-series-lehenga-choli-catalogue-wholesale-price-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/07\/360932_1634732212.jpg","product_qty":"1","sale_price":"14502","product_price":"2417","product_mrp_price":"2417","catalog_pcs":"6","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"764","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"2nd Jul 2021","salelable":""},{"product_id":"347813","product_name":"Alizeh Mirror Maze Colour Edition Catalog Party Wear Wholesale Lehenga Collection Best Price Surat","brand_name_name":null,"cname":"miiror maze colour edition","product_seo_url":"alizeh-mirror-maze-colour-edition-catalog-party-wear-wholesale-lehenga-collection-best-price-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/03\/347813_1634736636.jpg","product_qty":"1","sale_price":"53310","product_price":"8885","product_mrp_price":"8885","catalog_pcs":"6","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"312","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"15th Mar 2021","salelable":""},{"product_id":"346529","product_name":"Sengora Indian Queen Bridal Heritage Vol 3 2005-2008 Series Designer Bridal Wear Lehnega Collection Wholesale Price Surat","brand_name_name":null,"cname":"indian queen bridal heritage vol 3","product_seo_url":"sengora-indian-queen-bridal-heritage-vol-3-2005-2008-series-designer-bridal-wear-lehnega-collection-wholesale-price-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/03\/346529_1634737044.jpg","product_qty":"1","sale_price":"21580","product_price":"5395","product_mrp_price":"5395","catalog_pcs":"4","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"404","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"9th Mar 2021","salelable":""},{"product_id":"335428","product_name":"Alizeh Mirror Maze Vol 1 Beautiful Party Wear Lehenga Collection Wholesale Price In Surat","brand_name_name":null,"cname":"mirror maze vol 1","product_seo_url":"alizeh-mirror-maze-vol-1-beautiful-party-wear-lehenga-collection-wholesale-price-in-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/01\/335428_1634740487.jpg","product_qty":"1","sale_price":"17770","product_price":"8885","product_mrp_price":"8885","catalog_pcs":"2","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"351","size_name":"Stitched","category_name":"Lehenga","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"18th Jan 2021","salelable":""},{"product_id":"323614","product_name":"Shubhkala Girly Vol 7 1411-1417 Series Designer Look Lehenga Choli Collection By Shubhkala","brand_name_name":null,"cname":"Gilry vol 7","product_seo_url":"shubhkala-girly-vol-7-1411-1417-series-designer-look-lehenga-choli-collection-by-shubhkala","product_image":"https:\/\/prathamexports.com\/images\/product\/2020\/10\/323614_1634746533.jpg","product_qty":"1","sale_price":"9499","product_price":"1357","product_mrp_price":"1357","catalog_pcs":"7","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"695","size_name":"Stitched","category_name":"Lehenga,Boutique Collection","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"28th Oct 2020","salelable":""},{"product_id":"319594","product_name":"Alizeh Heritage Vol 2 1005-1008 Series Designer Lehenga Collection Wholesale Rate Surat","brand_name_name":null,"cname":"Heritage vol 2","product_seo_url":"alizeh-heritage-vol-2-1005-1008-series-designer-lehenga-collection-wholesale-rate-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2020\/10\/319594_1634747754.jpg","product_qty":"1","sale_price":"24228","product_price":"6057","product_mrp_price":"6057","catalog_pcs":"4","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"610","size_name":"Stitched","category_name":"Lehenga,Boutique Collection","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"12th Oct 2020","salelable":""},{"product_id":"313671","product_name":"Virasat Lucknowi 1053-1056 Series Designer Flair Party Wear Gown Collection Wholesale Rate Surat","brand_name_name":null,"cname":"lucknowi","product_seo_url":"virasat-lucknowi-1053-1056-series-designer-flair-party-wear-gown-collection-wholesale-rate-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2020\/09\/313671_1634750200.jpg","product_qty":"1","sale_price":"16940","product_price":"4235","product_mrp_price":"4235","catalog_pcs":"4","regular_price":null,"disable_date":"2021-10-20 00:00:00","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":"411","size_name":"Stitched","category_name":"Lehenga,Boutique Collection","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Sep 2020","salelable":""}],"oo":"select pm.* from relation_master as rm left join product_master as pm on pm.product_id=rm.product_id where 1=1 and pm.product_price!=0 and rm.type_id='12' and rm.type='subcat' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}