{"status":"ok","count":20,"catalog":[{"product_id":"413232","product_name":"Fepic C 1688 C Pakistani Dress Material Online Surat","brand_name_name":"Fepic","cname":"C 1688 C","product_seo_url":"fepic-c-1688-c-pakistani-dress-material-online-surat","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/fepic-c-1688-c-pakistani-dress-material-online-surat-2024-02-24_19_48_12.jpeg","product_qty":"5","sale_price":"1449","product_price":"1449","catalog_pcs":"1","regular_price":null,"disable_date":"2024-02-24","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":"22","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"3","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"413231","product_name":"Fepic C 1688 B Online Pakistani Suit From Direct Dealer","brand_name_name":"Fepic","cname":"C 1688 B","product_seo_url":"fepic-c-1688-b-online-pakistani-suit-from-direct-dealer","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/fepic-c-1688-b-online-pakistani-suit-from-direct-dealer-2024-02-24_19_48_11.jpeg","product_qty":"5","sale_price":"1449","product_price":"1449","catalog_pcs":"1","regular_price":null,"disable_date":"2024-02-24","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":"29","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"1","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"413230","product_name":"Fepic C 1688 A Pakistani Salwar Kameez Best Price","brand_name_name":"Fepic","cname":"C 1688 A","product_seo_url":"fepic-c-1688-a-pakistani-salwar-kameez-best-price","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/fepic-c-1688-a-pakistani-salwar-kameez-best-price-2024-02-24_19_48_10.jpeg","product_qty":"5","sale_price":"1449","product_price":"1449","catalog_pcs":"1","regular_price":null,"disable_date":"2024-02-24","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":"25","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"4","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"413229","product_name":"Fepic C 1688 Colors Pakistani Salwar Kameez Catalog Dealer","brand_name_name":"Fepic","cname":"C 1688 Colors","product_seo_url":"fepic-c-1688-colors-pakistani-salwar-kameez-catalog-dealer","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/fepic-c-1688-colors-pakistani-salwar-kameez-catalog-dealer-2024-02-24_19_43_33.jpeg","product_qty":"5","sale_price":"5796","product_price":"1449","catalog_pcs":"4","regular_price":null,"disable_date":"2024-02-24","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":"68","size_name":"","category_name":"Salwar Kameez Single,Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"413228","product_name":"Fepic C 1733 C Exclusive Pakistani Suit Wholesaler","brand_name_name":"Fepic","cname":"C 1733 C","product_seo_url":"fepic-c-1733-c-exclusive-pakistani-suit-wholesaler","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/fepic-c-1733-c-exclusive-pakistani-suit-wholesaler-2024-02-24_19_36_37.jpeg","product_qty":"5","sale_price":"1399","product_price":"1399","catalog_pcs":"1","regular_price":null,"disable_date":"2024-02-24","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":"36","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"413227","product_name":"Fepic C 1733 B Designer Pakistani Suit Wholesaler","brand_name_name":"Fepic","cname":"C 1733 B","product_seo_url":"fepic-c-1733-b-designer-pakistani-suit-wholesaler","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/fepic-c-1733-b-designer-pakistani-suit-wholesaler-2024-02-24_19_36_36.jpeg","product_qty":"5","sale_price":"1399","product_price":"1399","catalog_pcs":"1","regular_price":null,"disable_date":"2024-02-24","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":"28","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"413226","product_name":"Fepic C 1733 A Pakistani Suit Wholesaler Surat","brand_name_name":"Fepic","cname":"C 1733 A","product_seo_url":"fepic-c-1733-a-pakistani-suit-wholesaler-surat","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/fepic-c-1733-a-pakistani-suit-wholesaler-surat-2024-02-24_19_36_36.jpeg","product_qty":"5","sale_price":"1399","product_price":"1399","catalog_pcs":"1","regular_price":null,"disable_date":"2024-02-24","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":"27","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"413225","product_name":"Fepic C 1733 Colors Pakistani Suit Dealer Surat","brand_name_name":"Fepic","cname":"C 1733 Colors","product_seo_url":"fepic-c-1733-colors-pakistani-suit-dealer-surat","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/fepic-c-1733-colors-pakistani-suit-dealer-surat-2024-02-24_19_36_35.jpeg","product_qty":"5","sale_price":"4197","product_price":"1399","catalog_pcs":"3","regular_price":null,"disable_date":"2024-02-24","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"3Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"57","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"413224","product_name":"Anamsa 407 Magenta Pakistani Suit Online Wholesale","brand_name_name":"Anamsa","cname":"407","product_seo_url":"anamsa-407-magenta-pakistani-suit-online-wholesale","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/anamsa-407-magenta-pakistani-suit-online-wholesale-2024-02-24_19_24_15.jpeg","product_qty":"5","sale_price":"1200","product_price":"1200","catalog_pcs":"1","regular_price":null,"disable_date":"2024-02-24","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":"35","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"408720","product_name":"Fepic C 1662 Colors Pakistani Festive Wear Style Designer Salwar Suit Wholesalers","brand_name_name":"Fepic","cname":"C 1662 Colors","product_seo_url":"fepic-c-1662-colors-pakistani-festive-wear-style-designer-salwar-suit-wholesalers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/10\/fepic-c-1662-colors-pakistani-festive-wear-style-designer-salwar-suit-wholesalers-2023-10-28_12_20_55.jpeg","product_qty":"5","sale_price":"4173","product_price":"1391","catalog_pcs":"3","regular_price":null,"disable_date":"2024-03-05","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":"80","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"413222","product_name":"Deespy D 108 Designer Embroidered Pakistani Dress Latest Designs","brand_name_name":"Deepsy","cname":"D-108","product_seo_url":"deespy-d-108-designer-embroidered-pakistani-dress-latest-designs","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/deespy-d-108-designer-embroidered-pakistani-dress-latest-designs-2024-02-24_16_50_54.jpg","product_qty":"5","sale_price":"1199","product_price":"1199","catalog_pcs":"1","regular_price":null,"disable_date":"2024-02-24","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":"24","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"413221","product_name":"Right Women Aarushi Vol 3 81911 To 81918 Festive Wear Saree Online Collection","brand_name_name":"Right Women Designer","cname":"Aarushi Vol 3","product_seo_url":"right-women-aarushi-vol-3-81911-to-81918-festive-wear-saree-online-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/right-women-aarushi-vol-3-81911-to-81918-festive-wear-saree-online-collection-2024-02-24_16_32_58.jpg","product_qty":"5","sale_price":"6360","product_price":"795","catalog_pcs":"8","regular_price":null,"disable_date":"2024-03-05","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"5Kg","fabric_name123":"Vichitra","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"60","size_name":"","category_name":"Saree,Saree Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"411842","product_name":"Anantesh Queen Vol 1 8001 To 8007 Designer Wedding Wear Lehenga New Arrivals","brand_name_name":"Anantesh Lifestyle","cname":"Queen Vol 1","product_seo_url":"anantesh-queen-vol-1-8001-to-8007-designer-wedding-wear-lehenga-new-arrivals","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/01\/anantesh-queen-vol-1-8001-to-8007-designer-wedding-wear-lehenga-new-arrivals-2024-01-17_12_08_53.jpg","product_qty":"5","sale_price":"34125","product_price":"4875","catalog_pcs":"7","regular_price":null,"disable_date":"2024-03-05","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"21Kg","fabric_name123":"Georgette,Net,Organza","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"114","size_name":"","category_name":"Lehenga,Lehenga Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"413220","product_name":"Bunawat Gauri Priya 1001 To 1006 Kanjivaram Silk Saree Wholesalers","brand_name_name":"Sangam Saree","cname":"Gauri Priya","product_seo_url":"bunawat-gauri-priya-1001-to-1006-kanjivaram-silk-saree-wholesalers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/bunawat-gauri-priya-1001-to-1006-kanjivaram-silk-saree-wholesalers-2024-02-24_16_24_42.jpg","product_qty":"5","sale_price":"8700","product_price":"1450","catalog_pcs":"6","regular_price":null,"disable_date":"2024-03-05","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"5Kg","fabric_name123":"Kanjivaram Silk","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"49","size_name":"","category_name":"Saree,Saree Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"413216","product_name":"Ganga Katie 909 Premium Designs Jacquard Silk Suit New Designs","brand_name_name":"Ganga Fashion","cname":"Katie 909","product_seo_url":"ganga-katie-909-premium-designs-jacquard-silk-suit-new-designs","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/ganga-katie-909-premium-designs-jacquard-silk-suit-new-designs-2024-02-24_16_04_44.jpeg","product_qty":"5","sale_price":"2100","product_price":"2100","catalog_pcs":"1","regular_price":null,"disable_date":"2024-03-05","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":"96","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"413179","product_name":"Amoha Trends C 362 Designer Indo Western Partywear Outfit","brand_name_name":"Amoha Trends","cname":"C-362","product_seo_url":"amoha-trends-c-362-designer-indo-western-partywear-outfit","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/amoha-trends-c-362-designer-indo-western-partywear-outfit-2024-02-24_11_50_22.jpg","product_qty":"20","sale_price":"2395","product_price":"2395","catalog_pcs":"1","regular_price":null,"disable_date":"2024-03-05","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"2Kg","fabric_name123":"Chinon","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"33","size_name":"L | XL","category_name":"Indo Western,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"24th Feb 2024","salelable":""},{"product_id":"413173","product_name":"Ganga Quincy 1861 Jacquard Designs Dress Festive Collection","brand_name_name":"Ganga Fashion","cname":"Quincy 1861","product_seo_url":"ganga-quincy-1861-jacquard-designs-dress-festive-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/ganga-quincy-1861-jacquard-designs-dress-festive-collection-2024-02-23_17_49_48.jpeg","product_qty":"5","sale_price":"2100","product_price":"2100","catalog_pcs":"1","regular_price":null,"disable_date":"2024-03-04","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Jacquard,Silk ","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"64","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"23rd Feb 2024","salelable":""},{"product_id":"413126","product_name":"Bunawat Floral Cotton Vol 1 1001 To 1006 Premium Designs Cotton Saree Festive Collection","brand_name_name":"Sangam Saree","cname":"Floral Cotton Vol 1","product_seo_url":"bunawat-floral-cotton-vol-1-1001-to-1006-premium-designs-cotton-saree-festive-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2024\/02\/bunawat-floral-cotton-vol-1-1001-to-1006-premium-designs-cotton-saree-festive-collection-2024-02-22_17_13_57.jpeg","product_qty":"5","sale_price":"7494","product_price":"1249","catalog_pcs":"6","regular_price":null,"disable_date":"2024-03-03","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"5Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"35","size_name":"","category_name":"Saree,Saree Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"22nd Feb 2024","salelable":""},{"product_id":"406460","product_name":"Crafted Needle CN 806 By Fepic Readymade Designer Style Pakistani Suit Exporter ","brand_name_name":"Fepic","cname":"CN 806","product_seo_url":"crafted-needle-cn-806-by-fepic-readymade-designer-style-pakistani-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/09\/crafted-needle-cn-806-by-fepic-readymade-designer-style-pakistani-suit-exporter-2023-09-26_14_58_37.jpeg","product_qty":"6","sale_price":"4920","product_price":"1640","catalog_pcs":"3","regular_price":null,"disable_date":"2024-03-03","moq":"0","avail":"ask","size":"yes","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":"133","size_name":"XL | XXL","category_name":"Salwar Kameez Single,Kurti Single,Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"22nd Feb 2024","salelable":""},{"product_id":"410960","product_name":"Aashirwad Gulkand Veeda Readymade Designer Wedding Suit Latest Collection","brand_name_name":"Ashirwad Creation","cname":"Veeda","product_seo_url":"aashirwad-gulkand-veeda-readymade-designer-wedding-suit-latest-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/12\/aashirwad-gulkand-veeda-readymade-designer-wedding-suit-latest-collection-2023-12-26_12_07_45.jpeg","product_qty":"10","sale_price":"5200","product_price":"2600","catalog_pcs":"2","regular_price":null,"disable_date":"2024-03-03","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"3Kg","fabric_name123":"Silk ,Chinon","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"137","size_name":"Free Size","category_name":"Salwar Kameez,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"22nd Feb 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"}