{"status":"ok","count":20,"catalog":[{"product_id":"4143632","product_name":"Deepsy D 4066 Latest Designer Cotton Embroidered Salwar Suit Exporter","brand_name_name":"Deepsy NC","cname":"D 4066","product_seo_url":"deepsy-d-4066-latest-designer-cotton-embroidered-salwar-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/deepsy-d-4066-latest-designer-cotton-embroidered-salwar-suit-exporter-2024-06-15_11_46_57.jpeg","product_qty":"10","sale_price":"1099","product_price":"1099","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-15","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"31","size_name":"Chiffon Dupatta | Cotton Dupatta","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"15th Jun 2024","salelable":""},{"product_id":"4143631","product_name":"Ganga Fashion Shanaya C 1135 C Hits Designs Ladies Suit Supplier","brand_name_name":"Ganga Fashion","cname":"Shanaya C 1135 C","product_seo_url":"ganga-fashion-shanaya-c-1135-c-hits-designs-ladies-suit-supplier","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/ganga-fashion-shanaya-c-1135-c-hits-designs-ladies-suit-supplier-2024-06-15_11_41_52.jpeg","product_qty":"5","sale_price":"2145","product_price":"2145","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-25","moq":"0","avail":"add","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Silk ","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"24","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"15th Jun 2024","salelable":""},{"product_id":"4143616","product_name":"Dinsaa 254 C Festive Wear Style Designer Pakistani Cotton Suit Ensemble","brand_name_name":"Dinsaa Suit","cname":"254 C","product_seo_url":"dinsaa-254-c-festive-wear-style-designer-pakistani-cotton-suit-ensemble","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/dinsaa-254-c-festive-wear-style-designer-pakistani-cotton-suit-ensemble-2024-06-14_16_41_28.jpeg","product_qty":"5","sale_price":"1125","product_price":"1125","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"19","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143615","product_name":"Dinsaa 254 B Latest Festive Wear Style Designer Cotton Embroidered Dress Collection","brand_name_name":"Dinsaa Suit","cname":"254 B","product_seo_url":"dinsaa-254-b-latest-festive-wear-style-designer-cotton-embroidered-dress-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/dinsaa-254-b-latest-festive-wear-style-designer-cotton-embroidered-dress-collection-2024-06-14_16_41_27.jpeg","product_qty":"5","sale_price":"1125","product_price":"1125","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"17","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143614","product_name":"Dinsaa 254 A Pakistani Fancy Embroidered Designer Salwar Suit Exporter","brand_name_name":"Dinsaa Suit","cname":"254 A","product_seo_url":"dinsaa-254-a-pakistani-fancy-embroidered-designer-salwar-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/dinsaa-254-a-pakistani-fancy-embroidered-designer-salwar-suit-exporter-2024-06-14_16_41_27.jpeg","product_qty":"5","sale_price":"1125","product_price":"1125","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"18","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143613","product_name":"Dinsaa Maria B 254 Hit Colors Pakistani Cotton Embroidered Suit Wholesalers","brand_name_name":"Dinsaa Suit","cname":"Maria B 254 Hit Colors","product_seo_url":"dinsaa-maria-b-254-hit-colors-pakistani-cotton-embroidered-suit-wholesalers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/dinsaa-maria-b-254-hit-colors-pakistani-cotton-embroidered-suit-wholesalers-2024-06-14_16_35_43.jpeg","product_qty":"5","sale_price":"3375","product_price":"1125","catalog_pcs":"3","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"3Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"27","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143610","product_name":"Dinsaa 259 Fancy Style Cotton Embroidered Designer Salwar Kameez Ensemble","brand_name_name":"Dinsaa Suit","cname":"259","product_seo_url":"dinsaa-259-fancy-style-cotton-embroidered-designer-salwar-kameez-ensemble","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/dinsaa-259-fancy-style-cotton-embroidered-designer-salwar-kameez-ensemble-2024-06-14_16_27_29.jpeg","product_qty":"0","sale_price":"1050","product_price":"1050","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"outofstock","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"14","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143609","product_name":"Dinsaa 258 Fancy Designer Cotton Suit Summer Wear Collection","brand_name_name":"Dinsaa Suit","cname":"258","product_seo_url":"dinsaa-258-fancy-designer-cotton-suit-summer-wear-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/dinsaa-258-fancy-designer-cotton-suit-summer-wear-collection-2024-06-14_16_27_28.jpeg","product_qty":"0","sale_price":"1050","product_price":"1050","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"outofstock","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"13","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143608","product_name":"Dinsaa 257 Pakistani Style Designer Cotton Salwar Suit Exporter","brand_name_name":"Dinsaa Suit","cname":"257","product_seo_url":"dinsaa-257-pakistani-style-designer-cotton-salwar-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/dinsaa-257-pakistani-style-designer-cotton-salwar-suit-exporter-2024-06-14_16_27_27.jpeg","product_qty":"20","sale_price":"1050","product_price":"1050","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"20","size_name":"Cotton Dupatta | Chiffon Dupatta","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143606","product_name":"Dinsaa Sana Safinaz Vol 1 Cotton Embroidered Designer Salwar Suit Wholesalers","brand_name_name":"Dinsaa Suit","cname":"Sana Safinaz Vol 1","product_seo_url":"dinsaa-sana-safinaz-vol-1-cotton-embroidered-designer-salwar-suit-wholesalers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/dinsaa-sana-safinaz-vol-1-cotton-embroidered-designer-salwar-suit-wholesalers-2024-06-14_16_18_23.jpeg","product_qty":"10","sale_price":"3150","product_price":"1050","catalog_pcs":"3","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"3Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"21","size_name":"Cotton Dupatta | Tabby Silk Dupatta","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143603","product_name":"Zaveri Saima 1327 Readymade Designer Cotton Suit Collection","brand_name_name":"Zaveri","cname":"1327","product_seo_url":"zaveri-saima-1327-readymade-designer-cotton-suit-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/zaveri-saima-1327-readymade-designer-cotton-suit-collection-2024-06-14_16_04_34.jpeg","product_qty":"5","sale_price":"1575","product_price":"1575","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"32","size_name":"","category_name":"Salwar Kameez Single,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143602","product_name":"Zaveri Saima 1326 Fancy Printed Cotton Readymade Salwar Suit Exporter","brand_name_name":"Zaveri","cname":"1326","product_seo_url":"zaveri-saima-1326-fancy-printed-cotton-readymade-salwar-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/zaveri-saima-1326-fancy-printed-cotton-readymade-salwar-suit-exporter-2024-06-14_16_04_34.jpeg","product_qty":"30","sale_price":"1575","product_price":"1575","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"33","size_name":"M | L | XL | XXL | 3XL","category_name":"Salwar Kameez Single,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143601","product_name":"Zaveri Jil Mil 1216 Latest Designer Embroidered Readymade Organza Collection","brand_name_name":"Zaveri","cname":"1216","product_seo_url":"zaveri-jil-mil-1216-latest-designer-embroidered-readymade-organza-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/zaveri-jil-mil-1216-latest-designer-embroidered-readymade-organza-collection-2024-06-14_15_54_53.jpeg","product_qty":"5","sale_price":"1785","product_price":"1785","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Organza","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"18","size_name":"","category_name":"Salwar Kameez Single,Designer Dress Single,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143600","product_name":"Zaveri Jil Mil 1215 Designer Readymade Organza Suit Exporter","brand_name_name":"Zaveri","cname":"1215","product_seo_url":"zaveri-jil-mil-1215-designer-readymade-organza-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/zaveri-jil-mil-1215-designer-readymade-organza-suit-exporter-2024-06-14_15_54_52.jpeg","product_qty":"5","sale_price":"1785","product_price":"1785","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Organza","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"23","size_name":"","category_name":"Salwar Kameez Single,Designer Dress Single,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143599","product_name":"Zaveri Jil Mil 1214 Designer Festive Wear Organza Kurti Bottom Dupatta Set","brand_name_name":"Zaveri","cname":"1214","product_seo_url":"zaveri-jil-mil-1214-designer-festive-wear-organza-kurti-bottom-dupatta-set","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/zaveri-jil-mil-1214-designer-festive-wear-organza-kurti-bottom-dupatta-set-2024-06-14_15_54_52.jpeg","product_qty":"35","sale_price":"1785","product_price":"1785","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"1Kg","fabric_name123":"Organza","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"20","size_name":"M | L | XL | XXL | 3XL","category_name":"Salwar Kameez Single,Designer Dress Single,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143596","product_name":"Zaveri Nabiya 1325 Designer Cotton Salwar Suit Readymade Collection","brand_name_name":"Zaveri","cname":"1325","product_seo_url":"zaveri-nabiya-1325-designer-cotton-salwar-suit-readymade-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/zaveri-nabiya-1325-designer-cotton-salwar-suit-readymade-collection-2024-06-14_15_42_30.jpeg","product_qty":"5","sale_price":"1275","product_price":"1275","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"16","size_name":"","category_name":"Salwar Kameez Single,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143595","product_name":"Zaveri Nabiya 1324 Fancy Designer Cotton Printed Readymade Suit Exporter","brand_name_name":"Zaveri","cname":"1324","product_seo_url":"zaveri-nabiya-1324-fancy-designer-cotton-printed-readymade-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/zaveri-nabiya-1324-fancy-designer-cotton-printed-readymade-suit-exporter-2024-06-14_15_42_29.jpeg","product_qty":"30","sale_price":"1275","product_price":"1275","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"20","size_name":"M | L | XL | XXL | 3XL","category_name":"Salwar Kameez Single,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143592","product_name":"Sumitra 104 Colors Latest Designer Banarasi Saree Wholesalers","brand_name_name":"Sumitra","cname":"104 Colors","product_seo_url":"sumitra-104-colors-latest-designer-banarasi-saree-wholesalers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/sumitra-104-colors-latest-designer-banarasi-saree-wholesalers-2024-06-14_15_22_10.jpeg","product_qty":"5","sale_price":"9720","product_price":"1620","catalog_pcs":"6","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"6Kg","fabric_name123":"Banarasi","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"21","size_name":"","category_name":"Saree,Saree Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143589","product_name":"Fepic IR 21016 D Latest Embroidered Designer Organza Salwar Suit Suppliers","brand_name_name":"Fepic","cname":"IR 21016 D","product_seo_url":"fepic-ir-21016-d-latest-embroidered-designer-organza-salwar-suit-suppliers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/fepic-ir-21016-d-latest-embroidered-designer-organza-salwar-suit-suppliers-2024-06-14_15_03_20.jpeg","product_qty":"5","sale_price":"1099","product_price":"1099","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Organza","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"18","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""},{"product_id":"4143588","product_name":"Fepic IR 21016 C Pakistani Style Embroidered Unstitched Suit Collection","brand_name_name":"Fepic","cname":"IR 21016 C","product_seo_url":"fepic-ir-21016-c-pakistani-style-embroidered-unstitched-suit-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/06\/fepic-ir-21016-c-pakistani-style-embroidered-unstitched-suit-collection-2024-06-14_15_03_19.jpeg","product_qty":"5","sale_price":"1099","product_price":"1099","catalog_pcs":"1","regular_price":null,"disable_date":"2024-06-14","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Organza","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"14","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Jun 2024","salelable":""}],"s":"select pm.* from product_master pm where pm.type IN (1,2) and pm.product_price!=0 group by pm.product_id order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}