{"status":"ok","count":20,"catalog":[{"product_id":"406904","product_name":"Fepic C 1361 Festive Wear Style Designer Pakistani Salwar Suit Wholesaler","brand_name_name":"Fepic","cname":"C 1361 ","product_seo_url":"fepic-c-1361-festive-wear-style-designer-pakistani-salwar-suit-wholesaler","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/fepic-c-1361-festive-wear-style-designer-pakistani-salwar-suit-wholesaler-2023-10-03_14_50_54.jpeg","product_qty":"5","sale_price":"1281","product_price":"1281","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","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":"3rd Oct 2023","salelable":""},{"product_id":"406902","product_name":"Fepic C 1361 Colors Pakistani Fancy New Designs Party Wear Suit Exporters","brand_name_name":"Fepic","cname":"C 1361 Colors","product_seo_url":"fepic-c-1361-colors-pakistani-fancy-new-designs-party-wear-suit-exporters","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/fepic-c-1361-colors-pakistani-fancy-new-designs-party-wear-suit-exporters-2023-10-03_14_46_28.jpeg","product_qty":"5","sale_price":"5124","product_price":"1281","catalog_pcs":"4","regular_price":null,"disable_date":"2023-10-03","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":"12","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"406893","product_name":"Ziaaz Designs 353 Pakistani Latest Designs Velvet Salwar Suit Exporter","brand_name_name":"Ziaaz Designs","cname":"353 ","product_seo_url":"ziaaz-designs-353-pakistani-latest-designs-velvet-salwar-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/ziaaz-designs-353-pakistani-latest-designs-velvet-salwar-suit-exporter-2023-10-03_13_35_23.jpg","product_qty":"5","sale_price":"1470","product_price":"1470","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Velvet","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":"3rd Oct 2023","salelable":""},{"product_id":"406892","product_name":"Shree Fabs R 1113 B Party Wear Style Latest Designer Suit Wholesaler","brand_name_name":"Shree Fabs NC","cname":"R 1113 B","product_seo_url":"shree-fabs-r-1113-b-party-wear-style-latest-designer-suit-wholesaler","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/shree-fabs-r-1113-b-party-wear-style-latest-designer-suit-wholesaler-2023-10-03_13_29_35.jpeg","product_qty":"5","sale_price":"1650","product_price":"1650","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","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":"10","size_name":"","category_name":"Kurti Single,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"406891","product_name":"Shree Fabs R 1113 A Exclusive Heavy Designer Style Pakistani Readymade Collection","brand_name_name":"Shree Fabs NC","cname":"R 1113 A","product_seo_url":"shree-fabs-r-1113-a-exclusive-heavy-designer-style-pakistani-readymade-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/shree-fabs-r-1113-a-exclusive-heavy-designer-style-pakistani-readymade-collection-2023-10-03_13_29_34.jpeg","product_qty":"9","sale_price":"1650","product_price":"1650","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","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":"10","size_name":"XL | XXL","category_name":"Kurti Single,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"406889","product_name":"Shree Fabs R 1113 Colors Pakistani Party Wear Style Latest Readymade Collection","brand_name_name":"Shree Fabs","cname":"R 1113 Colors","product_seo_url":"shree-fabs-r-1113-colors-pakistani-party-wear-style-latest-readymade-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/shree-fabs-r-1113-colors-pakistani-party-wear-style-latest-readymade-collection-2023-10-03_13_21_47.jpeg","product_qty":"6","sale_price":"3300","product_price":"1650","catalog_pcs":"2","regular_price":null,"disable_date":"2023-10-03","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"2Kg","fabric_name123":"Organza","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"17","size_name":"XL | XXL","category_name":"Salwar Kameez,Kurti Single,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"406887","product_name":"Rajpath Shadow Silk 153001 To 153006 Party Wear Style Latest Designs Silk Saree Exporter","brand_name_name":"Rajyog","cname":"Shadow Silk","product_seo_url":"rajpath-shadow-silk-153001-to-153006-party-wear-style-latest-designs-silk-saree-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/rajpath-shadow-silk-153001-to-153006-party-wear-style-latest-designs-silk-saree-exporter-2023-10-03_13_08_55.jpeg","product_qty":"5","sale_price":"11970","product_price":"1995","catalog_pcs":"6","regular_price":null,"disable_date":"2023-10-03","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"6Kg","fabric_name123":"Silk ","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"8","size_name":"","category_name":"Saree,Saree Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"406886","product_name":"Anjani Art 2559 Colors Wedding Wear Heavy Net Designer Lehenga Suppliers","brand_name_name":"Anjani Art","cname":"2559 Colors","product_seo_url":"anjani-art-2559-colors-wedding-wear-heavy-net-designer-lehenga-suppliers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/anjani-art-2559-colors-wedding-wear-heavy-net-designer-lehenga-suppliers-2023-10-03_13_03_18.jpg","product_qty":"5","sale_price":"31996","product_price":"7999","catalog_pcs":"4","regular_price":null,"disable_date":"2023-10-13","moq":"0","avail":"add","size":"not","product_type":"","per_product_weight":"16Kg","fabric_name123":"Heavy Net","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"10","size_name":"","category_name":"Lehenga,Lehenga Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"406885","product_name":"Dinsaa DS 149 C Party Wear Style Exclusive Designer Salwar Suit Collection","brand_name_name":"Dinsaa Suit","cname":"DS 149 B","product_seo_url":"dinsaa-ds-149-c-party-wear-style-exclusive-designer-salwar-suit-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/dinsaa-ds-149-c-party-wear-style-exclusive-designer-salwar-suit-collection-2023-10-03_12_57_38.jpeg","product_qty":"5","sale_price":"1199","product_price":"1199","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","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":"4","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"406884","product_name":"Dinsaa DS 149 B Pakistani Festive Wear Style Latest Designer Suit Exporter","brand_name_name":"Dinsaa Suit","cname":"DS 149 B","product_seo_url":"dinsaa-ds-149-b-pakistani-festive-wear-style-latest-designer-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/dinsaa-ds-149-b-pakistani-festive-wear-style-latest-designer-suit-exporter-2023-10-03_12_57_37.jpeg","product_qty":"5","sale_price":"1199","product_price":"1199","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","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":"3","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"406882","product_name":"Fepic C 1335 C Party Wear Style Exclusive Designer Pakistani Suit Collection","brand_name_name":"Fepic","cname":"C 1335 C","product_seo_url":"fepic-c-1335-c-party-wear-style-exclusive-designer-pakistani-suit-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/fepic-c-1335-c-party-wear-style-exclusive-designer-pakistani-suit-collection-2023-10-03_12_45_19.jpeg","product_qty":"5","sale_price":"1359","product_price":"1359","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","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":"4","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"406881","product_name":"Fepic C 1335 B Festive Wear Style Fancy Designer Salwar Suit Exporter","brand_name_name":"Fepic","cname":"C 1335 B","product_seo_url":"fepic-c-1335-b-festive-wear-style-fancy-designer-salwar-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/fepic-c-1335-b-festive-wear-style-fancy-designer-salwar-suit-exporter-2023-10-03_12_45_18.jpeg","product_qty":"5","sale_price":"1359","product_price":"1359","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","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":"7","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"406879","product_name":"Fepic C 1335 Colors Pakistani Latest New Designs Party Wear Suit Wholesaler","brand_name_name":"Fepic","cname":"C 1335 Colors","product_seo_url":"fepic-c-1335-colors-pakistani-latest-new-designs-party-wear-suit-wholesaler","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/fepic-c-1335-colors-pakistani-latest-new-designs-party-wear-suit-wholesaler-2023-10-03_12_41_27.jpeg","product_qty":"5","sale_price":"4077","product_price":"1359","catalog_pcs":"3","regular_price":null,"disable_date":"2023-10-03","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"3Kg","fabric_name123":"Organza","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"17","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"401382","product_name":"Dinsaa Ds 149 E Exclusive Organza Pakistani Suit New Designs","brand_name_name":"Dinsaa Suit","cname":"Ds 149 E","product_seo_url":"dinsaa-ds-149-e-exclusive-organza-pakistani-suit-new-designs","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/06\/dinsaa-ds-149-e-exclusive-organza-pakistani-suit-new-designs-2023-06-19_11_56_52.jpeg","product_qty":"5","sale_price":"1199","product_price":"1199","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","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":"62","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"396656","product_name":"Dinsaa DS 149 D Pakistani Salwar suit new Designer Wholasaler","brand_name_name":"Dinsaa Suit","cname":"DS 149 D","product_seo_url":"dinsaa-ds-149-d-pakistani-salwar-suit-new-designer-wholasaler","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/dinsaa-ds-149-d-pakistani-salwar-suit-new-designer-wholasaler-2023-10-03_12_52_39.jpeg","product_qty":"5","sale_price":"1199","product_price":"1199","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","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":"61","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"400797","product_name":"Fepic C 1335 Pakistani Party Wear Style Fancy suit Collection","brand_name_name":"Fepic","cname":"C 1335","product_seo_url":"fepic-c-1335-pakistani-party-wear-style-fancy-suit-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/06\/fepic-c-1335-pakistani-party-wear-style-fancy-suit-collection-2023-06-07_11_38_10.jpeg","product_qty":"5","sale_price":"1359","product_price":"1359","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","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":"61","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"406877","product_name":"Al Khushbu 4049 D Exclusive Fancy Designer Pakistani Suit Collection ","brand_name_name":"Al Khushbu","cname":"4049 D","product_seo_url":"al-khushbu-4049-d-exclusive-fancy-designer-pakistani-suit-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/al-khushbu-4049-d-exclusive-fancy-designer-pakistani-suit-collection-2023-10-03_12_34_31.jpeg","product_qty":"5","sale_price":"1349","product_price":"1349","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","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":"7","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"406876","product_name":"Al Khushbu 4049 C Pakistani Party Wear Style Designer Salwar Suit Exporter","brand_name_name":"Al Khushbu","cname":"4049 C","product_seo_url":"al-khushbu-4049-c-pakistani-party-wear-style-designer-salwar-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/al-khushbu-4049-c-pakistani-party-wear-style-designer-salwar-suit-exporter-2023-10-03_12_34_30.jpeg","product_qty":"5","sale_price":"1349","product_price":"1349","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","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":"7","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"406875","product_name":"Al Khushbu 4049 B Pakistani Designer Style Salwar Suit Online Supplier","brand_name_name":"Al Khushbu","cname":"4049 B","product_seo_url":"al-khushbu-4049-b-pakistani-designer-style-salwar-suit-online-supplier","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/al-khushbu-4049-b-pakistani-designer-style-salwar-suit-online-supplier-2023-10-03_12_34_29.jpeg","product_qty":"5","sale_price":"1349","product_price":"1349","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","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":"7","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","salelable":""},{"product_id":"406874","product_name":"Al Khushbu 4049 A Pakistani Style Designer Festive Wear Salwar Suit Exporter","brand_name_name":"Al Khushbu","cname":"4049 A","product_seo_url":"al-khushbu-4049-a-pakistani-style-designer-festive-wear-salwar-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/al-khushbu-4049-a-pakistani-style-designer-festive-wear-salwar-suit-exporter-2023-10-03_12_34_28.jpeg","product_qty":"5","sale_price":"1349","product_price":"1349","catalog_pcs":"1","regular_price":null,"disable_date":"2023-10-03","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":"6","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Oct 2023","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"}