{"status":"ok","count":3,"catalog":[{"product":{"product_id":"5444","author_id":"","product_sku":"SD-5444","product_hsn":"","product_name":"Designer Lehenga By Lehenga","cname":"7521","product_seo_url":"designer-lehenga-by-lehenga","product_image":"images\/product\/2019\/03\/WhatsApp-Image-2019-01-05-at-10.34.51-AM-3.jpeg","product_qty":"1","catalog_pcs":"14","catelog_set":"","product_price":"2422","product_mrp_price":"2422","product_sale_price":"33908","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 Lehenga By Lehenga","product_meta_keyword":"Designer Lehenga By Lehenga","product_meta_description":"Designer Lehenga By Lehenga","disable_date":"2019-03-01 13:47:47","upcoming":"0","product_type":"On Booking","video_link":"","other_detail":"Designer Latest Semi stitched Lehenga Choli . Exclusive with 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:\r
Work: Stylish & Heavy Embroidery work with Latest Pattern \r
Size: 28 to 42 inches bust size \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":"2019-03-01 13:47:47","push_to_top_date":"2019-03-01 13:47:47","delivery_date":"1970-01-01","fabric":"","availability":"On Booking","permalink":"https:\/\/textilemela.com\/portfolio\/designer-lehenga-by-lehenga","note":"","shipping_days":"","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"1656","author_id":"","product_sku":"SD-1656","product_hsn":"","product_name":"Designer Party Wear Silk Lehenga Choli 16003","cname":"16003","product_seo_url":"designer-party-wear-silk-lehenga-choli-16003","product_image":"images\/product\/2018\/08\/1-3-1.jpeg","product_qty":"1","catalog_pcs":"7","catelog_set":"Single ","product_price":"1965","product_mrp_price":"1965","product_sale_price":"13755","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 Party Wear Silk Lehenga Choli 16003","product_meta_keyword":"Designer Party Wear Silk Lehenga Choli 16003","product_meta_description":"Designer Party Wear Silk Lehenga Choli 16003","disable_date":"2018-08-11 08:18:46","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"Can be Stitched as Anarkali or Lehenga.","single_catalog":"0","product_date":"2018-08-11 08:18:46","push_to_top_date":"2018-08-11 08:18:46","delivery_date":"2018-08-16","fabric":"","availability":"Ready to Ship","permalink":"https:\/\/textilemela.com\/portfolio\/designer-party-wear-silk-lehenga-choli-16003","note":"","shipping_days":"","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"1640","author_id":"","product_sku":"SD-1640","product_hsn":"","product_name":"Designer Wedding Silk Lehenga Choli Dupatta 16002","cname":"16002","product_seo_url":"designer-wedding-silk-lehenga-choli-dupatta-16002","product_image":"images\/product\/2018\/08\/1126-a_1-1.jpg","product_qty":"1","catalog_pcs":"8","catelog_set":"","product_price":"5650","product_mrp_price":"5650","product_sale_price":"45200","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 Wedding Silk Lehenga Choli Dupatta 16002","product_meta_keyword":"Designer Wedding Silk Lehenga Choli Dupatta 16002","product_meta_description":"Designer Wedding Silk Lehenga Choli Dupatta 16002","disable_date":"2018-08-11 08:12:31","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"Free Size","single_catalog":"0","product_date":"2018-08-11 08:12:31","push_to_top_date":"2018-08-11 08:12:31","delivery_date":"2018-08-14","fabric":"","availability":"Ready to Ship","permalink":"https:\/\/textilemela.com\/portfolio\/designer-wedding-silk-lehenga-choli-dupatta-16002","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='95' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}