{"status":"ok","count":7,"catalog":[{"product_id":"389776","product_name":"mayur creation mehafil vol 2 series 101 to 104 premium sllk ready made salwar kameez with inner wholesale market surat ","brand_name_name":"Mayur Creation","cname":"mehafil vol r with inner ","product_seo_url":"mayur-creation-mehafil-vol-2-series-101-to-104-premium-sllk-ready-made-salwar-kameez-with-inner-wholesale-market-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/02\/mayur-creation-mehafil-vol-2-series-101-to-104-premium-sllk-ready-made-salwar-kameez-with-inner-wholesale-market-surat-2022-02-12_14_16_34.jpg","product_qty":"5","sale_price":"4380","product_price":"1095","product_mrp_price":"1155","catalog_pcs":"4","regular_price":null,"disable_date":"2022-02-14 00:00:00","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"4Kg","fabric_name123":"Muslin","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"131","size_name":"M | L | XL | XXL | XXXL","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"12th Feb 2022","salelable":""},{"product_id":"389743","product_name":"moroccon mayur creation premium kaftan collection wholesale price surat","brand_name_name":"Mayur Creation","cname":"moroccon","product_seo_url":"moroccon-mayur-creation-premium-kaftan-collection-wholesale-price-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/02\/moroccon-mayur-creation-premium-kaftan-collection-wholesale-price-surat-2022-02-11_13_09_57.jpg","product_qty":"1","sale_price":"6330","product_price":"1055","product_mrp_price":"1095","catalog_pcs":"6","regular_price":null,"disable_date":"2022-02-12 00:00:00","moq":"0","avail":"ask","size":"yes","product_type":"Ready to Ship","per_product_weight":"6Kg","fabric_name123":"Modal","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"151","size_name":"XL","category_name":"Kurti","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"11th Feb 2022","salelable":""},{"product_id":"389742","product_name":"mayur creation moroccon premium kaftna collection wholesale price","brand_name_name":"Mayur Creation","cname":"moroccon","product_seo_url":"mayur-creation-moroccon-premium-kaftna-collection-wholesale-price","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/02\/mayur-creation-moroccon-premium-kaftna-collection-wholesale-price-2022-02-11_13_08_04.jpg","product_qty":"3","sale_price":"4470","product_price":"745","product_mrp_price":"795","catalog_pcs":"6","regular_price":null,"disable_date":"2022-02-12 00:00:00","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"4Kg","fabric_name123":"Modal","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"128","size_name":"L | XL | XXL","category_name":"Kurti","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"11th Feb 2022","salelable":""},{"product_id":"389612","product_name":"mayur riwayat 101-105 series exclusive designer kurti catalogue manufacturer surat","brand_name_name":"Mayur Creation","cname":"riwayat","product_seo_url":"mayur-riwayat-101-105-series-exclusive-designer-kurti-catalogue-manufacturer-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/02\/mayur-riwayat-101-105-series-exclusive-designer-kurti-catalogue-manufacturer-surat-2022-02-07_11_41_31.jpg","product_qty":"0","sale_price":"5475","product_price":"1095","product_mrp_price":"1145","catalog_pcs":"5","regular_price":null,"disable_date":"2022-02-09 00:00:00","moq":"0","avail":"outofstock","size":"yes","product_type":"Ask Availibility","per_product_weight":"5Kg","fabric_name123":"Modal","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"126","size_name":"L","category_name":"Kurti","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"7th Feb 2022","salelable":""},{"product_id":"388929","product_name":"mayur creation batik special vol 18 punjabi designer suits wholesaler surat","brand_name_name":"Mayur Creation","cname":"batik special vol 18","product_seo_url":"mayur-creation-batik-special-vol-18-punjabi-designer-suits-wholesaler-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/12\/mayur-creation-batik-special-vol-18-punjabi-designer-suits-wholesaler-surat-2021-12-27_19_47_02.jpg","product_qty":"2","sale_price":"5175","product_price":"345","product_mrp_price":"395","catalog_pcs":"15","regular_price":null,"disable_date":"2021-12-29 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"12Kg","fabric_name123":"Pure Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"142","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"27th Dec 2021","salelable":""},{"product_id":"388810","product_name":"mayur-fabrics zarnaa 5301-5308 series exclusive designer salwar suits catalogue collection 2021","brand_name_name":"Mayur Creation","cname":"zarnaa","product_seo_url":"mayur-fabrics-zarnaa-5301-5308-series-exclusive-designer-salwar-suits-catalogue-collection-2021","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/12\/mayur-fabrics-zarnaa-5301-5308-series-exclusive-designer-salwar-suits-catalogue-collection-2021-2021-12-21_19_41_06.jpg","product_qty":"2","sale_price":"8760","product_price":"1095","product_mrp_price":"1145","catalog_pcs":"8","regular_price":null,"disable_date":"2021-12-23 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"201","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"21st Dec 2021","salelable":""},{"product_id":"388652","product_name":"mayur creation bandhani special vol 13 pure cotton casual salwar kameez surat","brand_name_name":"Mayur Creation","cname":"bandhani special vol 13","product_seo_url":"mayur-creation-bandhani-special-vol-13-pure-cotton-casual-salwar-kameez-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/12\/mayur-creation-bandhani-special-vol-13-pure-cotton-casual-salwar-kameez-surat-2021-12-10_12_47_43.jpg","product_qty":"2","sale_price":"4140","product_price":"345","product_mrp_price":"370","catalog_pcs":"12","regular_price":null,"disable_date":"2021-12-14 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"160","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"10th Dec 2021","salelable":""}],"oo":"select pm.* from brand_relation_master as brm left join product_master as pm on pm.product_id=brm.product_id where 1=1 and pm.product_price!=0 and brm.brand_id='915' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}