{"status":"ok","count":20,"catalog":[{"product_id":"400837","product_name":"Shubhkala Flory Vol 37 Festive Collection Fancy Gharara Dress Suppliers","brand_name_name":"Khushboo","cname":"Flory Vol 37","product_seo_url":"shubhkala-flory-vol-37-festive-collection-fancy-gharara-dress-suppliers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/06\/shubhkala-flory-vol-37-festive-collection-fancy-gharara-dress-suppliers-2023-06-07_14_57_36.jpg","product_qty":"10","sale_price":"9000","product_price":"1800","catalog_pcs":"5","regular_price":null,"disable_date":"2023-06-17","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"5Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"187","size_name":"XL","category_name":"Readymade,Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"7th Jun 2023","salelable":""},{"product_id":"386228","product_name":"Mrudangi 2028 Series Designer Sharara Gharara Readymade Dress Collection","brand_name_name":"Mrudangi","cname":"2028 Series","product_seo_url":"mrudangi-2028-series-designer-sharara-gharara-readymade-dress-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2022\/08\/mrudangi-2028-series-designer-sharara-gharara-readymade-dress-collection-2022-08-09_16_21_01.jpeg","product_qty":"15","sale_price":"4796","product_price":"1199","catalog_pcs":"4","regular_price":null,"disable_date":"2023-06-10","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"5Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"1241","size_name":"S | M | L | XL | XXL","category_name":"Salwar Kameez,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"30th May 2023","salelable":""},{"product_id":"400087","product_name":"Shubhkala Flory Vol 36 Designer Wedding Wear Gharara Sharara Dress Exporter","brand_name_name":"Khushboo","cname":"Flory Vol 36","product_seo_url":"shubhkala-flory-vol-36-designer-wedding-wear-gharara-sharara-dress-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/05\/shubhkala-flory-vol-36-designer-wedding-wear-gharara-sharara-dress-exporter-2023-05-23_12_02_12.jpg","product_qty":"10","sale_price":"7200","product_price":"1800","catalog_pcs":"4","regular_price":null,"disable_date":"2023-06-03","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"5Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"238","size_name":"Free Size","category_name":"Readymade,Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"23rd May 2023","salelable":""},{"product_id":"399007","product_name":"Arya Designs Noorani Saga Vol 7 Latest Designer Gharara Dress Partywear Collection","brand_name_name":"Arya","cname":"Noorani Saga Vol 7","product_seo_url":"arya-designs-noorani-saga-vol-7-latest-designer-gharara-dress-partywear-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/05\/arya-designs-noorani-saga-vol-7-latest-designer-gharara-dress-partywear-collection-2023-05-04_17_05_52.jpg","product_qty":"10","sale_price":"15640","product_price":"3910","catalog_pcs":"4","regular_price":null,"disable_date":"2023-05-14","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"5Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"308","size_name":"Free Size","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"4th May 2023","salelable":""},{"product_id":"398151","product_name":"Arya Designs Noorani Saga Vol 5 Partywear Gharara Designer Dress New Collection","brand_name_name":"Arya","cname":"Noorani Saga Vol 2","product_seo_url":"arya-designs-noorani-saga-vol-5-partywear-gharara-designer-dress-new-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/04\/arya-designs-noorani-saga-vol-5-partywear-gharara-designer-dress-new-collection-2023-04-19_16_25_49.jpg","product_qty":"20","sale_price":"16775","product_price":"3355","catalog_pcs":"5","regular_price":null,"disable_date":"2023-04-29","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"9Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"200","size_name":"L | XL","category_name":"Readymade,Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2023","salelable":""},{"product_id":"397990","product_name":"Twisha Vaani Vol 24 Colors Heavy Designer Suit Supplier","brand_name_name":"Aanaya","cname":"Vol 24 Colors","product_seo_url":"twisha-vaani-vol-24-colors-heavy-designer-suit-supplier","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/04\/twisha-vaani-vol-24-colors-heavy-designer-suit-supplier-2023-04-17_16_39_39.jpeg","product_qty":"5","sale_price":"5180","product_price":"1295","catalog_pcs":"4","regular_price":null,"disable_date":"2023-04-27","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"4Kg","fabric_name123":"Net","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"150","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"17th Apr 2023","salelable":""},{"product_id":"380936","product_name":"Wanna Laila Designer Readymade Women Ethnic Wear Sharara Dress Collection","brand_name_name":"Wanna","cname":"Laila","product_seo_url":"wanna-laila-designer-readymade-women-ethnic-wear-sharara-dress-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2022\/03\/wanna-laila-designer-readymade-women-ethnic-wear-sharara-dress-collection-2022-03-02_18_13_30.jpeg","product_qty":"9","sale_price":"6690","product_price":"1115","catalog_pcs":"6","regular_price":null,"disable_date":"2023-04-23","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"6Kg","fabric_name123":"Rayon","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>1<\/span><\/span><\/a>","productview":"743","size_name":"M | L | 3XL","category_name":"Salwar Kameez,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"13th Apr 2023","salelable":""},{"product_id":"397628","product_name":"Dresstive Seher Designer Wedding Wear Gharara Dress Online Suppliers","brand_name_name":"Dresstive","cname":"Seher","product_seo_url":"dresstive-seher-designer-wedding-wear-gharara-dress-online-suppliers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/04\/dresstive-seher-designer-wedding-wear-gharara-dress-online-suppliers-2023-04-12_13_37_04.jpg","product_qty":"10","sale_price":"16995","product_price":"3399","catalog_pcs":"5","regular_price":null,"disable_date":"2023-04-22","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"9Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"172","size_name":"Free Size","category_name":"Readymade,Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"12th Apr 2023","salelable":""},{"product_id":"397218","product_name":"Aanaya Vol 158 Partywear Gharara Dress Designer Collection Exporter","brand_name_name":"Aanaya","cname":"Aanaya Vol 158","product_seo_url":"aanaya-vol-158-partywear-gharara-dress-designer-collection-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/04\/aanaya-vol-158-partywear-gharara-dress-designer-collection-exporter-2023-04-06_14_39_20.jpg","product_qty":"5","sale_price":"7980","product_price":"1995","catalog_pcs":"4","regular_price":null,"disable_date":"2023-04-16","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"7Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"196","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"6th Apr 2023","salelable":""},{"product_id":"396743","product_name":"Megha Export Serine S 98 Colors Pakistani Designer Suit Catalog Collection","brand_name_name":"Megha Exports","cname":"S 98 Colors","product_seo_url":"megha-export-serine-s-98-colors-pakistani-designer-suit-catalog-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/03\/megha-export-serine-s-98-colors-pakistani-designer-suit-catalog-collection-2023-03-30_12_13_37.jpeg","product_qty":"5","sale_price":"5396","product_price":"1349","catalog_pcs":"4","regular_price":null,"disable_date":"2023-04-10","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"4Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"117","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"30th Mar 2023","salelable":""},{"product_id":"396360","product_name":"Arya Sing173 Designer Partywear Sharara Dress New Collection Supplier","brand_name_name":"Arya","cname":"Sing173","product_seo_url":"arya-sing173-designer-partywear-sharara-dress-new-collection-supplier","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/03\/arya-sing173-designer-partywear-sharara-dress-new-collection-supplier-2023-03-24_14_47_13.jpg","product_qty":"50","sale_price":"2235","product_price":"2235","catalog_pcs":"1","regular_price":null,"disable_date":"2023-04-04","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"1Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"172","size_name":"S | M | L | XL | XS","category_name":"Readymade,Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Mar 2023","salelable":""},{"product_id":"395272","product_name":"Mrudangi Celebration 2041 Colors Fancy Sharara Suit catalog Wholesaler","brand_name_name":"Mrudangi","cname":"Celebration 2041 Colors","product_seo_url":"mrudangi-celebration-2041-colors-fancy-sharara-suit-catalog-wholesaler","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/03\/mrudangi-celebration-2041-colors-fancy-sharara-suit-catalog-wholesaler-2023-03-07_13_18_19.jpeg","product_qty":"3","sale_price":"9755","product_price":"1951","catalog_pcs":"5","regular_price":null,"disable_date":"2023-03-17","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"7Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"241","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"7th Mar 2023","salelable":""},{"product_id":"395082","product_name":"Anjubaa Vol 12 Fancy Party Wear Sharara Suit Catalog Dealer","brand_name_name":"Anjubaa","cname":"Anjubaa Vol 12","product_seo_url":"anjubaa-vol-12-fancy-party-wear-sharara-suit-catalog-dealer","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/03\/anjubaa-vol-12-fancy-party-wear-sharara-suit-catalog-dealer-2023-03-03_12_20_50.jpg","product_qty":"3","sale_price":"7180","product_price":"1795","catalog_pcs":"4","regular_price":null,"disable_date":"2023-03-13","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"6Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"392","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Mar 2023","salelable":""},{"product_id":"394963","product_name":"Mrudangi Gulabo 2009 To 2013 Party Wear Gharara Designer Dress Wholesaler","brand_name_name":"Mrudangi","cname":"Gulabo","product_seo_url":"mrudangi-gulabo-2009-to-2013-party-wear-gharara-designer-dress-wholesaler","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/03\/mrudangi-gulabo-2009-to-2013-party-wear-gharara-designer-dress-wholesaler-2023-03-01_12_22_31.jpg","product_qty":"5","sale_price":"9975","product_price":"1995","catalog_pcs":"5","regular_price":null,"disable_date":"2023-03-09","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"8Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"233","size_name":"","category_name":"Salwar Kameez Single,Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"1st Mar 2023","salelable":""},{"product_id":"394693","product_name":"Anjubaa Vol 10 Partywear Gharara Sharara Dress New Collection Supplier","brand_name_name":"Anjubaa","cname":"Anjubaa Vol 10","product_seo_url":"anjubaa-vol-10-partywear-gharara-sharara-dress-new-collection-supplier","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/02\/anjubaa-vol-10-partywear-gharara-sharara-dress-new-collection-supplier-2023-02-24_14_36_37.jpg","product_qty":"10","sale_price":"7396","product_price":"1849","catalog_pcs":"4","regular_price":null,"disable_date":"2023-03-05","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"4Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"308","size_name":"Free Size","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2023","salelable":""},{"product_id":"391508","product_name":"Arya Designs Blush Vol 2 Party Wear Gharara Sharara Suit Catalog Wholesaler ","brand_name_name":"Arya","cname":"Blush Vol 2","product_seo_url":"arya-designs-blush-vol-2-party-wear-gharara-sharara-suit-catalog-wholesaler","product_image":"https:\/\/kapdavilla.com\/images\/product\/2022\/12\/arya-designs-blush-vol-2-party-wear-gharara-sharara-suit-catalog-wholesaler-2022-12-17_13_25_40.jpg","product_qty":"6","sale_price":"37560","product_price":"4695","catalog_pcs":"8","regular_price":null,"disable_date":"2022-12-27","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"12Kg","fabric_name123":"Chiffon","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"207","size_name":"L | XL","category_name":"Readymade,Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"17th Dec 2022","salelable":""},{"product_id":"380481","product_name":"Alizeh Almora Vol 5 Semi Stitched georgette Suit Catalog Wholesale price","brand_name_name":"Alizeh","cname":"Almora Vol 5","product_seo_url":"alizeh-almora-vol-5-semi-stitched-georgette-suit-catalog-wholesale-price","product_image":"https:\/\/kapdavilla.com\/images\/product\/2022\/02\/alizeh-almora-vol-5-semi-stitched-georgette-suit-catalog-wholesale-price-2022-02-19_19_32_11.jpeg","product_qty":"5","sale_price":"6380","product_price":"1595","catalog_pcs":"4","regular_price":null,"disable_date":"2022-12-15","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"7Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"267","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"15th Nov 2022","salelable":""},{"product_id":"385730","product_name":"Aashirwad Kashish Designer Readymade Sharara Dress New Ethnic Wear Collection","brand_name_name":"Ashirwad Creation","cname":"Kashish","product_seo_url":"aashirwad-kashish-designer-readymade-sharara-dress-new-ethnic-wear-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2022\/07\/aashirwad-kashish-designer-readymade-sharara-dress-new-ethnic-wear-collection-2022-07-26_13_31_57.jpeg","product_qty":"3","sale_price":"9196","product_price":"2299","catalog_pcs":"4","regular_price":null,"disable_date":"2022-10-20","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"6Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"768","size_name":"Free Size","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"12th Oct 2022","salelable":""},{"product_id":"387671","product_name":"Vouch Mi Moh Colors Plus Party Wear Dress New Catalog Wholesale ","brand_name_name":"Vouch Mi","cname":"Moh Colors Puls","product_seo_url":"vouch-mi-moh-colors-plus-party-wear-dress-new-catalog-wholesale","product_image":"https:\/\/kapdavilla.com\/images\/product\/2022\/09\/vouch-mi-moh-colors-plus-party-wear-dress-new-catalog-wholesale-2022-09-18_18_17_56.jpeg","product_qty":"3","sale_price":"18075","product_price":"3615","catalog_pcs":"5","regular_price":null,"disable_date":"2022-09-27","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"5Kg","fabric_name123":"Net","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"249","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"17th Sep 2022","salelable":""},{"product_id":"382522","product_name":"Rewaa Parampara Vol 1 Designer Exclusive party Wear Readymade Collection","brand_name_name":"Rewaa","cname":"Parampara Vol 1","product_seo_url":"rewaa-parampara-vol-1-designer-exclusive-party-wear-readymade-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2022\/04\/rewaa-parampara-vol-1-designer-exclusive-party-wear-readymade-collection-2022-04-11_19_19_40.jpeg","product_qty":"6","sale_price":"55846","product_price":"3989","catalog_pcs":"14","regular_price":null,"disable_date":"2022-04-21","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"15Kg","fabric_name123":"Fancy fabrics","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"362","size_name":"L | XL","category_name":"Salwar Kameez,Readymade,Designer Dress Single,Kurti Single,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"11th Apr 2022","salelable":""}],"s":"select pm.* from relation_master as rm left join product_master as pm on pm.product_id=rm.product_id where pm.type IN (1,2) and pm.product_price!=0 and pm.product_status = 'Publish' and rm.type_id='531' and rm.type='subcat' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 40"}