{"status":"ok","count":1,"catalog":[{"product":{"product_id":"108490","author_id":"admin","product_sku":"TM-108471","product_hsn":"6208","product_name":"SHUBHKALA PRESENTS FLORAL VOL-3 131 - 135 SERIES INDIAN WOMEN DESIGNER FLORAL PRINTED ART SILK FANCY LEHENGA CHOLI FESTIVE WEDDING GHAGAR CHOLI GIRLISH WEAR COLLECTION 7149","cname":"BALA 7149","product_seo_url":"shubhkala-presents-floral-vol-3-131-135-series-indian-women-designer-floral-printed-art-silk-fancy-lehenga-choli-festive-wedding-ghagar-choli-girlish-wear-collection-7149","product_image":"images\/product\/2022\/12\/shubhkala-presents-floral-vol-3-131-135-series-indian-women-designer-floral-printed-art-silk-fancy-lehenga-choli-festive-wedding-ghagar-choli-girlish-wear-collection-7149-2022-12-08_12_21_43.jpeg","product_qty":"5","catalog_pcs":"5","catelog_set":"","product_price":"1600","product_mrp_price":"1999","product_sale_price":"8000","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"4","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":"Indian Latest Designer Festive Lehenga Choli Collection. 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.","product_full_description":"","product_status":"Publish","product_meta_title":"SHUBHKALA PRESENTS FLORAL VOL-3 131 - 135 SERIES INDIAN WOMEN DESIGNER FLORAL PRINTED ART SILK FANCY LEHENGA CHOLI FESTIVE WEDDING GHAGAR CHOLI GIRLISH WEAR COLLECTION 7149","product_meta_keyword":"bridal lehenga choli , party wear lehenga choli , lehenga choli , ghagra choli , party , wedding wear women , indian designer , net , velvet lehenga choli , bridal women ","product_meta_description":"","disable_date":"2025-07-18 00:00:00","upcoming":"1","product_type":"Ready to Ship","video_link":"","other_detail":"<ul>\r\n\t<li><strong>STYLE<\/strong>: This is Semi Stitched Lehenga with Unstitched Choli and Dupatta in Stylish Pattern.<\/li>\r\n\t<li><strong>FABRIC<\/strong>: Lehenga: Pure Rera Silk || Choli: Pure Rera Silk&nbsp; || Dupatta: Assam Silk<\/li>\r\n\t<li><strong>WORK<\/strong>: A stunning Lehenga with digital printed&nbsp;Work.<\/li>\r\n\t<li><strong>FEATURE<\/strong>: Flair: 4 mtr approx. | Lehenga length: 42 inches approx. || Dupatta Length: 2.40 Mtr approx. || Choli Length &ndash; 1 Meter approx. || Sleeve length :10&Prime; approx.<\/li>\r\n\t<li><strong>WHY BUY FROM US<\/strong>&nbsp;&ndash; All our collections are 100% original &amp; as shown in the picture.<\/li>\r\n\t<li><strong>DO NOTE<\/strong>: Accessories shown in the image are for presentation purposes only. (Slight variation in actual colour vs. image is possible.) If any query, do WhatsApp us on +918076953198 &amp; mail us on <a href=\"mailto:info@textilemela.com\">info@textilemela.com<\/a><\/li>\r\n<\/ul>\r\n\r\n<p><strong>IMPORTANT: In case, the actual weight is more so we will contact you for additional charges before shipping<\/strong><\/p>\r\n","single_catalog":"0","product_date":"2022-12-08 12:21:43","push_to_top_date":"2022-12-08 12:21:43","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3-10 DAYS","filter":"0","code_userid":"","is_single":"1"}}],"ggg":"select pm.* from relation_master as  rm  left join product_master as pm on pm.product_id=rm.product_id where 1=1 and pm.product_price!=0  and rm.type_id='76' and rm.type='subcat'  order by pm.push_to_top_date desc,pm.product_id desc  LIMIT 24, 20"}