{"status":"ok","count":3,"catalog":[{"product":{"product_id":"2272","author_id":"","product_sku":"SD-2272","product_hsn":"","product_name":"Designer Exclusive Salwar Kameez Dupatta At Wholesale Price By Kesari","cname":"12046","product_seo_url":"designer-exclusive-salwar-kameez-dupatta-at-wholesale-price-by-kesari","product_image":"images\/product\/2018\/08\/rggg.jpg","product_qty":"1","catalog_pcs":"5","catelog_set":"Full ","product_price":"1360","product_mrp_price":"1360","product_sale_price":"6800","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"","product_gst":"5","product_weight":"0","product_stitch":"Unstitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"","product_full_description":"","product_status":"publish","product_meta_title":"Designer Exclusive Salwar Kameez Dupatta At Wholesale Price By Kesari","product_meta_keyword":"Designer Exclusive Salwar Kameez Dupatta At Wholesale Price By Kesari","product_meta_description":"Designer Exclusive Salwar Kameez Dupatta At Wholesale Price By Kesari","disable_date":"2018-08-17 08:51:52","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"Designer Latest Salwar Suit . Exclusive with Stone & Embroidery work gives a Fashionable Look, High sensed style and luxury makes you ready for envious glazes and very rich & Royal in the Party, Function, Event etc.\r
Fabric: Georgette With Embroidery With Nazneen Work Dupatta\r
Work: Fancy Embroidery work \r
Size: 28 to 42 inches\r
\r
ETHNIC MELA \r
We have a large team of female fashion designers who can customise and provide the stitching as per your need or you can do this locally. Please feel free to contact us if you have any questions\r
Stitching Services : If you need stitching it will cost you Extra . Do contact us if you need stitching services.\r
FOR DAILY UPDATES ON WHATSAPP PLEASE SAVE OUR BROADCAST NUMBER +918588818719","single_catalog":"0","product_date":"2018-08-17 08:51:52","push_to_top_date":"2018-08-17 08:51:52","delivery_date":"2018-08-24","fabric":"","availability":"Ready to Ship","permalink":"https:\/\/textilemela.com\/portfolio\/designer-exclusive-salwar-kameez-dupatta-at-wholesale-price-by-kesari","note":"","shipping_days":"","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"2063","author_id":"","product_sku":"SD-2063","product_hsn":"","product_name":"Designer Silk Salwar Kameez With 6 Pcs By Kesari","cname":"12030","product_seo_url":"designer-silk-salwar-kameez-with-6-pcs-by-kesari","product_image":"images\/product\/2018\/08\/1008.jpg","product_qty":"1","catalog_pcs":"6","catelog_set":"Full ","product_price":"1410","product_mrp_price":"1410","product_sale_price":"8460","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"","product_gst":"5","product_weight":"0","product_stitch":"Semi Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"","product_full_description":"","product_status":"publish","product_meta_title":"Designer Silk Salwar Kameez With 6 Pcs By Kesari","product_meta_keyword":"Designer Silk Salwar Kameez With 6 Pcs By Kesari","product_meta_description":"Designer Silk Salwar Kameez With 6 Pcs By Kesari","disable_date":"2018-08-12 12:28:58","upcoming":"0","product_type":"On Booking","video_link":"","other_detail":"Designer Latest Salwar Kameez . Exclusive with Hand Work +Embroidery Work gives a Fashionable Look, High sensed style and luxury makes you ready for envious glazes and very rich & Royal in the Party, Function, Event etc.\r
Work: Hand Work +Embroidery Work\r
Size: 28 to 42 inches\r
\r
ETHNIC MELA \r
We have a large team of female fashion designers who can customise and provide the stitching as per your need or you can do this locally. Please feel free to contact us if you have any questions\r
Stitching Services : If you need stitching it will cost you Extra . Do contact us if you need stitching services.\r
FOR DAILY UPDATES ON WHATSAPP PLEASE SAVE OUR BROADCAST NUMBER +918588818719","single_catalog":"0","product_date":"2018-08-12 12:28:58","push_to_top_date":"2018-08-12 12:28:58","delivery_date":"2018-08-17","fabric":"","availability":"On Booking","permalink":"https:\/\/textilemela.com\/portfolio\/designer-silk-salwar-kameez-with-6-pcs-by-kesari","note":"","shipping_days":"","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"1122","author_id":"","product_sku":"SD-1122","product_hsn":"","product_name":"Straight Suits With 4 Pcs By Kesari 12012","cname":"","product_seo_url":"straight-suits-with-4-pcs-by-kesari-12012","product_image":"images\/product\/2018\/08\/1-1.jpg","product_qty":"1","catalog_pcs":"4","catelog_set":"Full ","product_price":"1250","product_mrp_price":"1250","product_sale_price":"5000","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"","product_gst":"5","product_weight":"0","product_stitch":"","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"","product_full_description":"","product_status":"publish","product_meta_title":"Straight Suits With 4 Pcs By Kesari 12012","product_meta_keyword":"Straight Suits With 4 Pcs By Kesari 12012","product_meta_description":"Straight Suits With 4 Pcs By Kesari 12012","disable_date":"2018-08-10 09:32:41","upcoming":"0","product_type":"","video_link":"","other_detail":"","single_catalog":"0","product_date":"2018-08-10 09:32:41","push_to_top_date":"2018-08-10 09:32:41","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"https:\/\/textilemela.com\/portfolio\/straight-suits-with-4-pcs-by-kesari-12012","note":"","shipping_days":"","filter":"0","code_userid":"","is_single":"0"}}],"ggg":"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='25' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}