{"status":"ok","count":2,"catalog":[{"product":{"product_id":"106350","author_id":"admin","product_sku":"TM-106340","product_hsn":"6208","product_name":"DRESSETIVE PRESENTS 1201-1208 SERIES EXCLUSIVE WEDDING LEHENGA CHOLI STITCHED COLLECTION AT WHOLESALE PRICE N538","cname":"BALAN538","product_seo_url":"dressetive-presents-1201-1208-series-exclusive-wedding-lehenga-choli-stitched-collection-at-wholesale-price-n538","product_image":"images\/product\/2022\/08\/dressetive-presents-1201-1208-series-exclusive-wedding-lehenga-choli-stitched-collection-at-wholesale-price-n538-2022-08-31_18_47_20.jpeg","product_qty":"6","catalog_pcs":"8","catelog_set":"","product_price":"2653","product_mrp_price":"2735","product_sale_price":"21224","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"16","product_stitch":"Full 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":"Indian Latest Designer 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":"DRESSETIVE PRESENTS 1201-1208 SERIES EXCLUSIVE WEDDING LEHENGA CHOLI STITCHED COLLECTION AT WHOLESALE PRICE N538","product_meta_keyword":"LEHENGA CHOLI, DESIGNER LEHENGA CHOLI, GHAGHRA CHOLI, WEDDING LEHENGA, WHOLESALE LEHENGA, BRIDAL LEHENGA CHOLI","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"1","product_type":"Ready to Ship","video_link":"","other_detail":"<ul>\r\n\t<li><strong>STYLE<\/strong>: This is Stitched Lehenga with stitched Choli and Dupatta in Stylish Pattern.<\/li>\r\n\t<li><strong>FABRIC<\/strong>: Lehenga: Chinon\u00a0|| Choli: Art silk || Dupatta: Chinon<\/li>\r\n\t<li><strong>WORK<\/strong>: Thread Work, Mirror 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 \u2013 1 Meter approx. || Sleeve length :10\u2033 approx.<\/li>\r\n\t<li><strong>WHY BUY FROM US<\/strong>\u00a0\u2013 All our collections are 100% original & 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 +91 8154943468 & mail us on\u00a0<a href=\"mailto:info@textilemela.com\">info@textilemela.com<\/a><\/li>\r\n\t<li><strong>IMPORTANT: In case, the actual weight is more so we will contact you for additional charges before shipping.<\/strong><\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2022-08-31 18:47:20","push_to_top_date":"2022-08-31 18:47:20","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"106347","author_id":"admin","product_sku":"TM-106337","product_hsn":"6208","product_name":"DRESSETIVE PRESENTS 1201-1208 SERIES EXCLUSIVE WEDDING LEHENGA CHOLI SEMI STITCH COLLECTION AT WHOLESALE PRICE N538","cname":"BALAN538","product_seo_url":"dressetive-presents-1201-1208-series-exclusive-wedding-lehenga-choli-semi-stitch-collection-at-wholesale-price-n538","product_image":"images\/product\/2022\/08\/dressetive-presents-1201-1208-series-exclusive-wedding-lehenga-choli-semi-stitch-collection-at-wholesale-price-n538-2022-08-31_18_42_32.jpeg","product_qty":"5","catalog_pcs":"8","catelog_set":"","product_price":"2168","product_mrp_price":"2235","product_sale_price":"17344","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"16","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":"Indian Latest Designer 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":"DRESSETIVE PRESENTS 1201-1208 SERIES EXCLUSIVE WEDDING LEHENGA CHOLI SEMI STITCH COLLECTION AT WHOLESALE PRICE N538","product_meta_keyword":"LEHENGA CHOLI, DESIGNER LEHENGA CHOLI, GHAGHRA CHOLI, WEDDING LEHENGA, WHOLESALE LEHENGA, BRIDAL LEHENGA CHOLI","product_meta_description":"","disable_date":"0000-00-00 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: Chinon&nbsp;|| Choli: Art silk || Dupatta: Chinon<\/li>\r\n\t<li><strong>WORK<\/strong>: Thread Work, Mirror 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 +91 8154943468 &amp; mail us on <a href=\"mailto:info@textilemela.com\">info@textilemela.com<\/a><\/li>\r\n\t<li><strong>IMPORTANT: In case, the actual weight is more so we will contact you for additional charges before shipping.<\/strong><\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2022-08-31 18:42:32","push_to_top_date":"2022-08-31 18:42:32","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"","filter":"0","code_userid":"","is_single":"1"}}],"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='342'  order by pm.push_to_top_date desc,pm.product_id desc  LIMIT 20, 20"}