{"status":"ok","count":20,"catalog":[{"product_id":"4140509","product_name":"Ziaaz Designs 422 Pakistani Festive Wear Style Heavy Designer Salwar Suit Collection","brand_name_name":"Ziaaz Designs","cname":"422","product_seo_url":"ziaaz-designs-422-pakistani-festive-wear-style-heavy-designer-salwar-suit-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/ziaaz-designs-422-pakistani-festive-wear-style-heavy-designer-salwar-suit-collection-2024-04-19_15_45_28.jpeg","product_qty":"5","sale_price":"1350","product_price":"1350","catalog_pcs":"1","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","size":"not","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":"10","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140502","product_name":"Ziaaz Designs 487 Fancy Designer Georgette Embroidered Salwar Kameez Dealers","brand_name_name":"Ziaaz Designs","cname":"487","product_seo_url":"ziaaz-designs-487-fancy-designer-georgette-embroidered-salwar-kameez-dealers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/ziaaz-designs-487-fancy-designer-georgette-embroidered-salwar-kameez-dealers-2024-04-19_15_08_19.jpeg","product_qty":"5","sale_price":"1470","product_price":"1470","catalog_pcs":"1","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","size":"not","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":"8","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140496","product_name":"Mahamani Rashmika 1001 To 1012 Latest Festive Wear Gotha Silk Saree Catalog Exporter","brand_name_name":"Shubh Shree Creation","cname":"Rashmika 1001 to 1012","product_seo_url":"mahamani-rashmika-1001-to-1012-latest-festive-wear-gotha-silk-saree-catalog-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/mahamani-rashmika-1001-to-1012-latest-festive-wear-gotha-silk-saree-catalog-exporter-2024-04-19_14_08_59.jpeg","product_qty":"5","sale_price":"10740","product_price":"895","catalog_pcs":"12","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"12Kg","fabric_name123":"Tussar Silk","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"12","size_name":"","category_name":"Saree Single,Saree","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140489","product_name":"Johra Tex 139 Colors Party Wear Style Exclusive Salwar Kameez Exporter","brand_name_name":"Johra Tex","cname":"JT 139 Colors","product_seo_url":"johra-tex-139-colors-party-wear-style-exclusive-salwar-kameez-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/johra-tex-139-colors-party-wear-style-exclusive-salwar-kameez-exporter-2024-04-19_13_12_59.jpeg","product_qty":"5","sale_price":"3996","product_price":"999","catalog_pcs":"4","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"4Kg","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,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140487","product_name":"Fepic C 1763 B Fancy Designer Style Tubby Silk Salwar Suit Buy Online","brand_name_name":"Fepic","cname":"C 1763 B","product_seo_url":"fepic-c-1763-b-fancy-designer-style-tubby-silk-salwar-suit-buy-online","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/fepic-c-1763-b-fancy-designer-style-tubby-silk-salwar-suit-buy-online-2024-04-19_13_07_09.jpeg","product_qty":"5","sale_price":"1429","product_price":"1429","catalog_pcs":"1","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","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":"6","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140486","product_name":"Fepic C 1763 Festive Wear Style Latest Designer Unstitch Salwar Kameez Exporter","brand_name_name":"Fepic","cname":"C 1763","product_seo_url":"fepic-c-1763-festive-wear-style-latest-designer-unstitch-salwar-kameez-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/fepic-c-1763-festive-wear-style-latest-designer-unstitch-salwar-kameez-exporter-2024-04-19_13_07_08.jpeg","product_qty":"5","sale_price":"1429","product_price":"1429","catalog_pcs":"1","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","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":"10","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140484","product_name":"Fepic C 1763 Colors Exclusive Heavy Designer Style Party Wear Salwar Suit Collection","brand_name_name":"Fepic","cname":"C 1763 Colors","product_seo_url":"fepic-c-1763-colors-exclusive-heavy-designer-style-party-wear-salwar-suit-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/fepic-c-1763-colors-exclusive-heavy-designer-style-party-wear-salwar-suit-collection-2024-04-19_13_03_53.jpeg","product_qty":"5","sale_price":"2858","product_price":"1429","catalog_pcs":"2","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"2Kg","fabric_name123":"Silk ","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"19","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140480","product_name":"Serine S 211 Latest New Designer Festive Wear Salwar Kameez Buy Online","brand_name_name":"Megha Exports","cname":"S 211","product_seo_url":"serine-s-211-latest-new-designer-festive-wear-salwar-kameez-buy-online","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/serine-s-211-latest-new-designer-festive-wear-salwar-kameez-buy-online-2024-04-19_12_48_13.jpeg","product_qty":"5","sale_price":"1249","product_price":"1249","catalog_pcs":"1","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","size":"not","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":"9","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140478","product_name":"Ziaaz Designs 533 Exclusive Heavy Embroidered Designer Cotton Salwar Kameez Exporter","brand_name_name":"Ziaaz Designs","cname":"533","product_seo_url":"ziaaz-designs-533-exclusive-heavy-embroidered-designer-cotton-salwar-kameez-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/ziaaz-designs-533-exclusive-heavy-embroidered-designer-cotton-salwar-kameez-exporter-2024-04-19_12_40_03.jpeg","product_qty":"5","sale_price":"1180","product_price":"1180","catalog_pcs":"1","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cambric Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"10","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140475","product_name":"Deepsy 3284 D Exclusive Designer Pakistani Party Wear Dress Online Suppliers","brand_name_name":"Deepsy NC","cname":"3284 D","product_seo_url":"deepsy-3284-d-exclusive-designer-pakistani-party-wear-dress-online-suppliers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/deepsy-3284-d-exclusive-designer-pakistani-party-wear-dress-online-suppliers-2024-04-19_12_31_42.jpeg","product_qty":"5","sale_price":"1199","product_price":"1199","catalog_pcs":"1","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Rayon","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"7","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140474","product_name":"Deepsy 3284 C Party Wear Style Embroidered Salwar Suit Exporter","brand_name_name":"Deepsy NC","cname":"3284 C","product_seo_url":"deepsy-3284-c-party-wear-style-embroidered-salwar-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/deepsy-3284-c-party-wear-style-embroidered-salwar-suit-exporter-2024-04-19_12_31_41.jpeg","product_qty":"5","sale_price":"1199","product_price":"1199","catalog_pcs":"1","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Rayon","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"10","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140473","product_name":"Deepsy 3284 B Festive Wear style Latest Salwar Kameez Buy Online","brand_name_name":"Deepsy NC","cname":"3284 B","product_seo_url":"deepsy-3284-b-festive-wear-style-latest-salwar-kameez-buy-online","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/deepsy-3284-b-festive-wear-style-latest-salwar-kameez-buy-online-2024-04-19_12_31_40.jpeg","product_qty":"5","sale_price":"1199","product_price":"1199","catalog_pcs":"1","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Rayon","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"9","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140472","product_name":"Deepsy 3284 A Pakistani Style Fancy Designer Unstitched Suit Suppliers","brand_name_name":"Deepsy NC","cname":"3284 A","product_seo_url":"deepsy-3284-a-pakistani-style-fancy-designer-unstitched-suit-suppliers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/deepsy-3284-a-pakistani-style-fancy-designer-unstitched-suit-suppliers-2024-04-19_12_31_40.jpeg","product_qty":"5","sale_price":"1199","product_price":"1199","catalog_pcs":"1","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Rayon","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"6","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140470","product_name":"Deepsy Maria B 3284 Colors Pakistani Fancy Designer Salwar Suit Wholesalers","brand_name_name":"Deepsy Suits","cname":"Maria B 3284 Colors","product_seo_url":"deepsy-maria-b-3284-colors-pakistani-fancy-designer-salwar-suit-wholesalers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/deepsy-maria-b-3284-colors-pakistani-fancy-designer-salwar-suit-wholesalers-2024-04-19_12_25_13.jpeg","product_qty":"5","sale_price":"4796","product_price":"1199","catalog_pcs":"4","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"4Kg","fabric_name123":"Rayon","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"19","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140468","product_name":"Naqsh NDS 15010 Designer Top Bottom Dupatta Sett Pakistani Collection","brand_name_name":"Kapdavilla","cname":"NDS 15010 ","product_seo_url":"naqsh-nds-15010-designer-top-bottom-dupatta-sett-pakistani-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/naqsh-nds-15010-designer-top-bottom-dupatta-sett-pakistani-collection-2024-04-19_12_15_09.jpeg","product_qty":"10","sale_price":"1525","product_price":"1525","catalog_pcs":"1","regular_price":null,"disable_date":"2024-04-19","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":"18","size_name":"XL | XXL","category_name":"Readymade,Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140466","product_name":"Ziaaz Designs 489 D Fancy Latest Pakistani Designer Dress Online Dealers","brand_name_name":"Ziaaz Designs","cname":"489 D","product_seo_url":"ziaaz-designs-489-d-fancy-latest-pakistani-designer-dress-online-dealers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/ziaaz-designs-489-d-fancy-latest-pakistani-designer-dress-online-dealers-2024-04-19_12_04_40.jpeg","product_qty":"5","sale_price":"1580","product_price":"1580","catalog_pcs":"1","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","size":"not","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":"17","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140465","product_name":"Ziaaz Designs 489 A Festive Wear Style Embroidered Salwar Suit Exporter","brand_name_name":"Ziaaz Designs","cname":"489 A","product_seo_url":"ziaaz-designs-489-a-festive-wear-style-embroidered-salwar-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/ziaaz-designs-489-a-festive-wear-style-embroidered-salwar-suit-exporter-2024-04-19_12_04_39.jpeg","product_qty":"5","sale_price":"1580","product_price":"1580","catalog_pcs":"1","regular_price":null,"disable_date":"2024-04-19","moq":"0","avail":"ask","size":"not","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":"11","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"19th Apr 2024","salelable":""},{"product_id":"4140457","product_name":"Shubh Shree Saanvi 2 1001 To 101 Festive Wear Style Designer Chiffon Printed Saree Dealers","brand_name_name":"Shubh Shree Creation","cname":"Saanvi 2 ","product_seo_url":"shubh-shree-saanvi-2-1001-to-101-festive-wear-style-designer-chiffon-printed-saree-dealers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/shubh-shree-saanvi-2-1001-to-101-festive-wear-style-designer-chiffon-printed-saree-dealers-2024-04-18_17_48_57.jpeg","product_qty":"5","sale_price":"8950","product_price":"895","catalog_pcs":"10","regular_price":null,"disable_date":"2024-04-18","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Chiffon","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"27","size_name":"","category_name":"Saree,Saree Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"18th Apr 2024","salelable":""},{"product_id":"4140454","product_name":"Bunawat Konark Cotton 10499 To 10504 Daily Wear Style Designer Cotton Saree Wholesalers","brand_name_name":"Sangam Saree","cname":"Konark Cotton","product_seo_url":"bunawat-konark-cotton-10499-to-10504-daily-wear-style-designer-cotton-saree-wholesalers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/bunawat-konark-cotton-10499-to-10504-daily-wear-style-designer-cotton-saree-wholesalers-2024-04-18_17_38_40.jpeg","product_qty":"5","sale_price":"7494","product_price":"1249","catalog_pcs":"6","regular_price":null,"disable_date":"2024-04-18","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"6Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"24","size_name":"","category_name":"Saree,Saree Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"18th Apr 2024","salelable":""},{"product_id":"4140442","product_name":"Fepic IR 21012 C Exclusive Heavy Style Organza Embroidered Dress Collection","brand_name_name":"Fepic","cname":"IR 21012 C","product_seo_url":"fepic-ir-21012-c-exclusive-heavy-style-organza-embroidered-dress-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/04\/fepic-ir-21012-c-exclusive-heavy-style-organza-embroidered-dress-collection-2024-04-18_16_21_17.jpeg","product_qty":"5","sale_price":"1025","product_price":"1025","catalog_pcs":"1","regular_price":null,"disable_date":"2024-04-18","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":"11","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"18th Apr 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"}