{"status":"ok","count":9,"catalog":[{"product_id":"393714","product_name":"Swagat Swati 3601 To 3607 Designer Straight Suit Wholesaler New Collection","brand_name_name":"Swagat","cname":"Swati 3601 To 3607","product_seo_url":"swagat-swati-3601-to-3607-designer-straight-suit-wholesaler-new-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/02\/swagat-swati-3601-to-3607-designer-straight-suit-wholesaler-new-collection-2023-02-07_15_27_22.jpg","product_qty":"3","sale_price":"13265","product_price":"1895","catalog_pcs":"7","regular_price":null,"disable_date":"2023-04-04","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"12Kg","fabric_name123":"Georgette","wish":"<a href=\"javascript:void(0)\" onClick=\"wishlist(393714)\" class=\"tt-btn-wishlist iconheart\" id=\"id393714\"><i class='fa fa-heart-o' style='font-size:17px;color:#ed9c31;'><\/i><\/a>\n\t\t\t<a href=\"javascript:void(0)\" class=\"addto\"  data-tooltip=\"Like\" data-tposition=\"top\" data-tposition=\"left\" style=\"display:none;background: rgba(0,0,0,.7) !important; bottom: 0;width: 19.5%;z-index:2;color: white;\">\n\t\t\t<span class=\"tt-img\" id=\"like393714\" style=\"display: grid;\" onclick=\"product_like(393714)\"><i class=\"icon-f-91 icon\" style=\"font-size: 20px;\"><\/i><span>0<\/span><\/span><\/a>","productview":"274","size_name":"","category_name":"Salwar Kameez Single,Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"4th Mar 2023","salelable":""},{"product_id":"395030","product_name":"Narayani Zehra Vol 4 Designer Party Wear Straight Suit Catalog Exporter","brand_name_name":"Narayani Fashion","cname":"Zehra Vol 4","product_seo_url":"narayani-zehra-vol-4-designer-party-wear-straight-suit-catalog-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/03\/narayani-zehra-vol-4-designer-party-wear-straight-suit-catalog-exporter-2023-03-02_12_29_44.jpg","product_qty":"5","sale_price":"6900","product_price":"1725","catalog_pcs":"4","regular_price":null,"disable_date":"2023-03-10","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"5Kg","fabric_name123":"Butterfly Net","wish":"<a href=\"javascript:void(0)\" onClick=\"wishlist(395030)\" class=\"tt-btn-wishlist iconheart\" id=\"id395030\"><i class='fa fa-heart-o' style='font-size:17px;color:#ed9c31;'><\/i><\/a>\n\t\t\t<a href=\"javascript:void(0)\" class=\"addto\"  data-tooltip=\"Like\" data-tposition=\"top\" data-tposition=\"left\" style=\"display:none;background: rgba(0,0,0,.7) !important; bottom: 0;width: 19.5%;z-index:2;color: white;\">\n\t\t\t<span class=\"tt-img\" id=\"like395030\" style=\"display: grid;\" onclick=\"product_like(395030)\"><i class=\"icon-f-91 icon\" style=\"font-size: 20px;\"><\/i><span>0<\/span><\/span><\/a>","productview":"258","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"2nd Mar 2023","salelable":""},{"product_id":"371629","product_name":"Gulkayra Nazmin Straight Suit party Wear Collection at Best Rate","brand_name_name":"Gulkayra Designer","cname":"Nazmin","product_seo_url":"gulkayra-nazmin-straight-suit-party-wear-collection-at-best-rate","product_image":"https:\/\/kapdavilla.com\/images\/product\/2021\/04\/gulkayra-nazmin-straight-suit-party-wear-collection-at-best-rate-2021-04-14_15_32_23.jpeg","product_qty":"3","sale_price":"7475","product_price":"1495","catalog_pcs":"5","regular_price":null,"disable_date":"2022-01-22","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"5Kg","fabric_name123":"Georgette","wish":"<a href=\"javascript:void(0)\" onClick=\"wishlist(371629)\" class=\"tt-btn-wishlist iconheart\" id=\"id371629\"><i class='fa fa-heart-o' style='font-size:17px;color:#ed9c31;'><\/i><\/a>\n\t\t\t<a href=\"javascript:void(0)\" class=\"addto\"  data-tooltip=\"Like\" data-tposition=\"top\" data-tposition=\"left\" style=\"display:none;background: rgba(0,0,0,.7) !important; bottom: 0;width: 19.5%;z-index:2;color: white;\">\n\t\t\t<span class=\"tt-img\" id=\"like371629\" style=\"display: grid;\" onclick=\"product_like(371629)\"><i class=\"icon-f-91 icon\" style=\"font-size: 20px;\"><\/i><span>0<\/span><\/span><\/a>","productview":"544","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"13th Jan 2023","salelable":""},{"product_id":"391939","product_name":"Aanaya Vaani Vol 32 Exclusive Party Wear Georgette Suit Designs","brand_name_name":"Aanaya","cname":"Vaani Vol 32","product_seo_url":"aanaya-vaani-vol-32-exclusive-party-wear-georgette-suit-designs","product_image":"https:\/\/kapdavilla.com\/images\/product\/2023\/01\/aanaya-vaani-vol-32-exclusive-party-wear-georgette-suit-designs-2023-01-03_15_48_03.jpeg","product_qty":"3","sale_price":"4980","product_price":"1245","catalog_pcs":"4","regular_price":null,"disable_date":"2023-01-13","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"5Kg","fabric_name123":"Georgette","wish":"<a href=\"javascript:void(0)\" onClick=\"wishlist(391939)\" class=\"tt-btn-wishlist iconheart\" id=\"id391939\"><i class='fa fa-heart-o' style='font-size:17px;color:#ed9c31;'><\/i><\/a>\n\t\t\t<a href=\"javascript:void(0)\" class=\"addto\"  data-tooltip=\"Like\" data-tposition=\"top\" data-tposition=\"left\" style=\"display:none;background: rgba(0,0,0,.7) !important; bottom: 0;width: 19.5%;z-index:2;color: white;\">\n\t\t\t<span class=\"tt-img\" id=\"like391939\" style=\"display: grid;\" onclick=\"product_like(391939)\"><i class=\"icon-f-91 icon\" style=\"font-size: 20px;\"><\/i><span>0<\/span><\/span><\/a>","productview":"193","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Jan 2023","salelable":""},{"product_id":"372301","product_name":"Aliizeh Murad Vol 1 Party Wear Straight Suit Collection at Best Rate","brand_name_name":"Alizeh","cname":"Murad Vol 1","product_seo_url":"aliizeh-murad-vol-1-party-wear-straight-suit-collection-at-best-rate","product_image":"https:\/\/kapdavilla.com\/images\/product\/2021\/06\/aliizeh-murad-vol-1-party-wear-straight-suit-collection-at-best-rate-2021-06-11_12_02_49.jpg","product_qty":"3","sale_price":"7480","product_price":"1870","catalog_pcs":"4","regular_price":null,"disable_date":"2022-12-25","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"4Kg","fabric_name123":"Georgette","wish":"<a href=\"javascript:void(0)\" onClick=\"wishlist(372301)\" class=\"tt-btn-wishlist iconheart\" id=\"id372301\"><i class='fa fa-heart-o' style='font-size:17px;color:#ed9c31;'><\/i><\/a>\n\t\t\t<a href=\"javascript:void(0)\" class=\"addto\"  data-tooltip=\"Like\" data-tposition=\"top\" data-tposition=\"left\" style=\"display:none;background: rgba(0,0,0,.7) !important; bottom: 0;width: 19.5%;z-index:2;color: white;\">\n\t\t\t<span class=\"tt-img\" id=\"like372301\" style=\"display: grid;\" onclick=\"product_like(372301)\"><i class=\"icon-f-91 icon\" style=\"font-size: 20px;\"><\/i><span>0<\/span><\/span><\/a>","productview":"381","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"15th Dec 2022","salelable":""},{"product_id":"391330","product_name":"Mrudangi Kashish 2014 Colors Party Wear Straight Suit Catalog Wholesaler","brand_name_name":"Mrudangi","cname":"Kashish 2014 Colors","product_seo_url":"mrudangi-kashish-2014-colors-party-wear-straight-suit-catalog-wholesaler","product_image":"https:\/\/kapdavilla.com\/images\/product\/2022\/12\/mrudangi-kashish-2014-colors-party-wear-straight-suit-catalog-wholesaler-2022-12-13_15_01_41.jpeg","product_qty":"3","sale_price":"9475","product_price":"1895","catalog_pcs":"5","regular_price":null,"disable_date":"2022-12-23","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"5Kg","fabric_name123":"Georgette","wish":"<a href=\"javascript:void(0)\" onClick=\"wishlist(391330)\" class=\"tt-btn-wishlist iconheart\" id=\"id391330\"><i class='fa fa-heart-o' style='font-size:17px;color:#ed9c31;'><\/i><\/a>\n\t\t\t<a href=\"javascript:void(0)\" class=\"addto\"  data-tooltip=\"Like\" data-tposition=\"top\" data-tposition=\"left\" style=\"display:none;background: rgba(0,0,0,.7) !important; bottom: 0;width: 19.5%;z-index:2;color: white;\">\n\t\t\t<span class=\"tt-img\" id=\"like391330\" style=\"display: grid;\" onclick=\"product_like(391330)\"><i class=\"icon-f-91 icon\" style=\"font-size: 20px;\"><\/i><span>0<\/span><\/span><\/a>","productview":"306","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"13th Dec 2022","salelable":""},{"product_id":"375290","product_name":"Radha Trends Sundri Plazzo Style Latest Salwar Suit Catalog Wholesale Dealer","brand_name_name":"Radha trendz","cname":"Sundri","product_seo_url":"radha-trends-sundri-plazzo-style-latest-salwar-suit-catalog-wholesale-dealer","product_image":"https:\/\/kapdavilla.com\/images\/product\/2021\/09\/radha-trends-sundri-plazzo-style-latest-salwar-suit-catalog-wholesale-dealer-2021-09-11_20_24_46.jpeg","product_qty":"3","sale_price":"8106","product_price":"1351","catalog_pcs":"6","regular_price":null,"disable_date":"2022-05-09","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"6Kg","fabric_name123":"Georgette","wish":"<a href=\"javascript:void(0)\" onClick=\"wishlist(375290)\" class=\"tt-btn-wishlist iconheart\" id=\"id375290\"><i class='fa fa-heart-o' style='font-size:17px;color:#ed9c31;'><\/i><\/a>\n\t\t\t<a href=\"javascript:void(0)\" class=\"addto\"  data-tooltip=\"Like\" data-tposition=\"top\" data-tposition=\"left\" style=\"display:none;background: rgba(0,0,0,.7) !important; bottom: 0;width: 19.5%;z-index:2;color: white;\">\n\t\t\t<span class=\"tt-img\" id=\"like375290\" style=\"display: grid;\" onclick=\"product_like(375290)\"><i class=\"icon-f-91 icon\" style=\"font-size: 20px;\"><\/i><span>0<\/span><\/span><\/a>","productview":"421","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"12th Oct 2022","salelable":""},{"product_id":"385993","product_name":"Gulkayra Sabnam Exclusive Party Wear Straight Suit catalog Supplier in Surat","brand_name_name":"Gulkayra Designer","cname":"Sabnam","product_seo_url":"gulkayra-sabnam-exclusive-party-wear-straight-suit-catalog-supplier-in-surat","product_image":"https:\/\/kapdavilla.com\/images\/product\/2022\/08\/gulkayra-sabnam-exclusive-party-wear-straight-suit-catalog-supplier-in-surat-2022-08-02_15_42_23.jpeg","product_qty":"3","sale_price":"7475","product_price":"1495","catalog_pcs":"5","regular_price":null,"disable_date":"2022-10-17","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"5Kg","fabric_name123":"Georgette","wish":"<a href=\"javascript:void(0)\" onClick=\"wishlist(385993)\" class=\"tt-btn-wishlist iconheart\" id=\"id385993\"><i class='fa fa-heart-o' style='font-size:17px;color:#ed9c31;'><\/i><\/a>\n\t\t\t<a href=\"javascript:void(0)\" class=\"addto\"  data-tooltip=\"Like\" data-tposition=\"top\" data-tposition=\"left\" style=\"display:none;background: rgba(0,0,0,.7) !important; bottom: 0;width: 19.5%;z-index:2;color: white;\">\n\t\t\t<span class=\"tt-img\" id=\"like385993\" style=\"display: grid;\" onclick=\"product_like(385993)\"><i class=\"icon-f-91 icon\" style=\"font-size: 20px;\"><\/i><span>0<\/span><\/span><\/a>","productview":"425","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"7th Oct 2022","salelable":""},{"product_id":"387623","product_name":"Aanaya Twisha Vol 24  Party Wear Designer Suit Catalog Dealer","brand_name_name":"Aanaya","cname":"Twisha Vol 24","product_seo_url":"aanaya-twisha-vol-24-party-wear-designer-suit-catalog-dealer","product_image":"https:\/\/kapdavilla.com\/images\/product\/2022\/09\/aanaya-twisha-vol-24-party-wear-designer-suit-catalog-dealer-2022-09-16_17_01_15.jpeg","product_qty":"3","sale_price":"5980","product_price":"1495","catalog_pcs":"4","regular_price":null,"disable_date":"2022-09-26","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"4Kg","fabric_name123":"Net","wish":"<a href=\"javascript:void(0)\" onClick=\"wishlist(387623)\" class=\"tt-btn-wishlist iconheart\" id=\"id387623\"><i class='fa fa-heart-o' style='font-size:17px;color:#ed9c31;'><\/i><\/a>\n\t\t\t<a href=\"javascript:void(0)\" class=\"addto\"  data-tooltip=\"Like\" data-tposition=\"top\" data-tposition=\"left\" style=\"display:none;background: rgba(0,0,0,.7) !important; bottom: 0;width: 19.5%;z-index:2;color: white;\">\n\t\t\t<span class=\"tt-img\" id=\"like387623\" style=\"display: grid;\" onclick=\"product_like(387623)\"><i class=\"icon-f-91 icon\" style=\"font-size: 20px;\"><\/i><span>0<\/span><\/span><\/a>","productview":"140","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"16th Sep 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='526' and rm.type='subcat'  order by pm.push_to_top_date desc,pm.product_id desc  LIMIT 20, 40"}