info@textilemela.co<\/a><\/p>\r\n","single_catalog":"0","product_date":"2024-05-13 15:05:30","push_to_top_date":"2024-05-13 15:05:30","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7 DAYS","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"118477","author_id":"admin","product_sku":"TM-118399","product_hsn":"540710","product_name":"shri balaji emporium 5646 casual wear designer salawar suit","cname":"daily wear casual wear festival wear office wear designer salawar suit","product_seo_url":"shri-balaji-emporium-5646-casual-wear-designer-salawar-suit","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-5646-casual-wear-designer-salawar-suit-2024-05-13_13_44_27.png","product_qty":"25","catalog_pcs":"7","catelog_set":"","product_price":"999","product_mrp_price":"999","product_sale_price":"6993","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"7","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"yes","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"daily wear casual wear festival wear office wear designer salawar suit","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"shri balaji emporium 5646 casual wear designer salawar suit","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"SERIES – 10001 TO 10007
\r\nSize - M To 3XL
\r\nFabric - Romal Viscose Silk
\r\nPattern - Embroidery And Hand Work With printed Dupatta<\/p>\r\n\r\n
please contact us if you have any queries<\/p>\r\n","single_catalog":"0","product_date":"2024-05-13 13:44:27","push_to_top_date":"2024-05-13 13:44:27","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118465","author_id":"admin","product_sku":"TM-118387","product_hsn":"540710","product_name":"Shri Balaji Emporium 6261C Beautiful Block Printed Cotton Mulmul Saree","cname":"New Summer Collection Beautiful Block Printed Cotton Mulmul 5.5m Saree with 1m Unstitched Blouse","product_seo_url":"shri-balaji-emporium-6261c-beautiful-block-printed-cotton-mulmul-saree","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-6261c-beautiful-block-printed-cotton-mulmul-saree-2024-05-13_11_36_47.jpg","product_qty":"5","catalog_pcs":"20","catelog_set":"","product_price":"799","product_mrp_price":"799","product_sale_price":"15980","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"20","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":"New Summer Collection Beautiful Block Printed Cotton Mulmul 5.5m Saree with 1m Unstitched Blouse","product_full_description":"","product_status":"Publish","product_meta_title":"Shri Balaji Emporium 6261C Beautiful Block Printed Cotton Mulmul Saree","product_meta_keyword":"Shri Balaji Emporium 6261C Beautiful Block Printed Cotton Mulmul Saree pink red yellow purple wine green blue black white sarees, saree, sareelove, fashion, sareelovers, onlineshopping, sareesofinstagram, ethnicwear, sareeblouse, silksarees sareefashion, silksaree, indianwear, sareeindia, handloom, silk, indianfashion, sareedraping, traditional, designersarees, sareecollection, india, sareelover, indianwedding, sareestyle, kurtis, kurti, wedding, lehenga, sareeblousedesigns indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian, wedding,","product_meta_description":"New Summer Collection Beautiful Block Printed Cotton Mulmul 5.5m Saree with 1m Unstitched Blouse","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
Newly Arrival Mulmul Saree<\/p>\r\n\r\n
Bagru Block Print Cotton mulmul Sarees with blouse<\/p>\r\n\r\n
Fabric:- Pure Mulmul (92*80)<\/p>\r\n\r\n
Saree:-5.5m+ Blouse:- 1m<\/p>\r\n\r\n
Please contact us if you have any questions.<\/p>\r\n","single_catalog":"0","product_date":"2024-05-13 11:36:47","push_to_top_date":"2024-05-13 11:36:47","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7 days","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118464","author_id":"admin","product_sku":"TM-118386","product_hsn":"540710","product_name":"Shri Balaji Emporium 6261B Beautiful Block Printed Cotton Mulmul Saree","cname":"New Summer Collection Beautiful Block Printed Cotton Mulmul 5.5m Saree with 1m Unstitched Blouse","product_seo_url":"shri-balaji-emporium-6261b-beautiful-block-printed-cotton-mulmul-saree","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-6261b-beautiful-block-printed-cotton-mulmul-saree-2024-05-13_11_34_08.jpg","product_qty":"5","catalog_pcs":"20","catelog_set":"","product_price":"799","product_mrp_price":"799","product_sale_price":"15980","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"20","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":"New Summer Collection Beautiful Block Printed Cotton Mulmul 5.5m Saree with 1m Unstitched Blouse","product_full_description":"","product_status":"Publish","product_meta_title":"Shri Balaji Emporium 6261B Beautiful Block Printed Cotton Mulmul Saree","product_meta_keyword":"Shri Balaji Emporium 6261B Beautiful Block Printed Cotton Mulmul Saree pink red yellow purple wine green blue black white sarees, saree, sareelove, fashion, sareelovers, onlineshopping, sareesofinstagram, ethnicwear, sareeblouse, silksarees sareefashion, silksaree, indianwear, sareeindia, handloom, silk, indianfashion, sareedraping, traditional, designersarees, sareecollection, india, sareelover, indianwedding, sareestyle, kurtis, kurti, wedding, lehenga, sareeblousedesigns indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian, wedding,","product_meta_description":"New Summer Collection Beautiful Block Printed Cotton Mulmul 5.5m Saree with 1m Unstitched Blouse","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
Newly Arrival Mulmul Saree<\/p>\r\n\r\n
Bagru Block Print Cotton mulmul Sarees with blouse<\/p>\r\n\r\n
Fabric:- Pure Mulmul (92*80)<\/p>\r\n\r\n
Saree:-5.5m+ Blouse:- 1m<\/p>\r\n\r\n
Please contact us if you have any questions.<\/p>\r\n","single_catalog":"0","product_date":"2024-05-13 11:34:08","push_to_top_date":"2024-05-13 11:34:08","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7 days","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118463","author_id":"admin","product_sku":"TM-118385","product_hsn":"540710","product_name":"Shri Balaji Emporium 6261A Beautiful Block Printed Cotton Mulmul Saree","cname":"New Summer Collection Beautiful Block Printed Cotton Mulmul 5.5m Saree with 1m Unstitched Blouse","product_seo_url":"shri-balaji-emporium-6261a-beautiful-block-printed-cotton-mulmul-saree","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-6261a-beautiful-block-printed-cotton-mulmul-saree-2024-05-13_11_30_01.jpg","product_qty":"5","catalog_pcs":"20","catelog_set":"","product_price":"799","product_mrp_price":"799","product_sale_price":"15980","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"20","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":"New Summer Collection Beautiful Block Printed Cotton Mulmul 5.5m Saree with 1m Unstitched Blouse","product_full_description":"","product_status":"Publish","product_meta_title":"Shri Balaji Emporium 6261A Beautiful Block Printed Cotton Mulmul Saree","product_meta_keyword":"Shri Balaji Emporium 6261A Beautiful Block Printed Cotton Mulmul Saree pink red yellow purple wine green blue black white sarees, saree, sareelove, fashion, sareelovers, onlineshopping, sareesofinstagram, ethnicwear, sareeblouse, silksarees sareefashion, silksaree, indianwear, sareeindia, handloom, silk, indianfashion, sareedraping, traditional, designersarees, sareecollection, india, sareelover, indianwedding, sareestyle, kurtis, kurti, wedding, lehenga, sareeblousedesigns indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian, wedding,","product_meta_description":"New Summer Collection Beautiful Block Printed Cotton Mulmul 5.5m Saree with 1m Unstitched Blouse","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
Newly Arrival Mulmul Saree<\/p>\r\n\r\n
Bagru Block Print Cotton mulmul Sarees with blouse<\/p>\r\n\r\n
Fabric:- Pure Mulmul (92*80)<\/p>\r\n\r\n
Saree:-5.5m+ Blouse:- 1m<\/p>\r\n\r\n
Please contact us if you have any questions.<\/p>\r\n","single_catalog":"0","product_date":"2024-05-13 11:30:01","push_to_top_date":"2024-05-13 11:30:01","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7 days","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118461","author_id":"admin","product_sku":"TM-118383","product_hsn":"540710","product_name":"Shri Balaji Emporium 6262B Hand Block Printed Stitched Cotton Kurtis with Pant ","cname":"New Summer Collection Hand Block Printed Stitched Pure Cotton Kurtis with Pant ","product_seo_url":"shri-balaji-emporium-6262b-hand-block-printed-stitched-cotton-kurtis-with-pant","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-6262b-hand-block-printed-stitched-cotton-kurtis-with-pant-2024-05-13_11_13_09.jpg","product_qty":"30","catalog_pcs":"10","catelog_set":"","product_price":"999","product_mrp_price":"999","product_sale_price":"9990","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"10","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":"New Summer Collection Hand Block Printed Stitched Pure Cotton Kurtis with Pant ","product_full_description":"","product_status":"Publish","product_meta_title":"Shri Balaji Emporium 6262B Hand Block Printed Stitched Cotton Kurtis with Pant ","product_meta_keyword":"Shri Balaji Emporium 6262B Hand Block Printed Stitched Cotton Kurtis with Pant pink red yellow purple wine green blue black white indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian, ","product_meta_description":"New Summer Collection Hand Block Printed Stitched Pure Cotton Kurtis with Pant ","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
Presenting New Collection..... <\/p>\r\n\r\n
Exclusive Hand block printed Stitched Cotton Kurtis with Pant<\/p>\r\n\r\n
Fabric :- Cotton ( 60 × 60 )<\/p>\r\n\r\n
In bagru dye\/indigo\/sanganeri prints etc<\/p>\r\n\r\n
Quality :- Premium<\/p>\r\n\r\n
Sizes ......S. M L Xl. Xxl 3xl<\/p>\r\n\r\n
Chest :- 36 38 40. 42. 44.46
\r\nWaist :-. 34 36. 38 40. 42 44<\/p>\r\n\r\n
Kurti Length :- 43 inches<\/p>\r\n\r\n
Sleeves length :- 17
\r\nPant Length :- 38<\/p>\r\n\r\n
Please feel free to contact us if you need Singles. In some catalogues, we can give single on additional cost if available in stock.<\/p>\r\n\r\n
<\/p>\r\n","single_catalog":"0","product_date":"2024-05-13 11:13:09","push_to_top_date":"2024-05-13 11:13:09","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7 days","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"118460","author_id":"admin","product_sku":"TM-118382","product_hsn":"540710","product_name":"Shri Balaji Emporium 6262A Hand Block Printed Stitched Cotton Kurtis with Pant ","cname":"New Summer Collection Hand Block Printed Stitched Pure Cotton Kurtis with Pant ","product_seo_url":"shri-balaji-emporium-6262a-hand-block-printed-stitched-cotton-kurtis-with-pant","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-6262a-hand-block-printed-stitched-cotton-kurtis-with-pant-2024-05-13_11_11_05.jpg","product_qty":"30","catalog_pcs":"15","catelog_set":"","product_price":"999","product_mrp_price":"999","product_sale_price":"14985","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"15","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":"New Summer Collection Hand Block Printed Stitched Pure Cotton Kurtis with Pant ","product_full_description":"","product_status":"Publish","product_meta_title":"Shri Balaji Emporium 6262A Hand Block Printed Stitched Cotton Kurtis with Pant ","product_meta_keyword":"Shri Balaji Emporium 6262A Hand Block Printed Stitched Cotton Kurtis with Pant pink red yellow purple wine green blue black white indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian, ","product_meta_description":"New Summer Collection Hand Block Printed Stitched Pure Cotton Kurtis with Pant ","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
Presenting New Collection..... <\/p>\r\n\r\n
Exclusive Hand block printed Stitched Cotton Kurtis with Pant<\/p>\r\n\r\n
Fabric :- Cotton ( 60 × 60 )<\/p>\r\n\r\n
In bagru dye\/indigo\/sanganeri prints etc<\/p>\r\n\r\n
Quality :- Premium<\/p>\r\n\r\n
Sizes ......S. M L Xl. Xxl 3xl<\/p>\r\n\r\n
Chest :- 36 38 40. 42. 44.46
\r\nWaist :-. 34 36. 38 40. 42 44<\/p>\r\n\r\n
Kurti Length :- 43 inches<\/p>\r\n\r\n
Sleeves length :- 17
\r\nPant Length :- 38<\/p>\r\n\r\n
Please feel free to contact us if you need Singles. In some catalogues, we can give single on additional cost if available in stock.<\/p>\r\n\r\n
<\/p>\r\n","single_catalog":"0","product_date":"2024-05-13 11:11:05","push_to_top_date":"2024-05-13 11:11:05","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7 days","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"118458","author_id":"admin","product_sku":"TM-118380","product_hsn":"540710","product_name":"SHRI BALAJI EMPORIUM 6318 ADITHI DAILY WEAR DESIGNER FANCY SAREE","cname":"DAILY WAER CASUAL WEAR DESIGNER FANCY SAREE","product_seo_url":"shri-balaji-emporium-6318-adithi-daily-wear-designer-fancy-saree","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-6318-adithi-daily-wear-designer-fancy-saree-2024-05-12_16_37_03.jpg","product_qty":"5","catalog_pcs":"6","catelog_set":"","product_price":"770","product_mrp_price":"770","product_sale_price":"4620","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"6","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":"DAILY WAER CASUAL WEAR DESIGNER FANCY SAREE","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"SHRI BALAJI EMPORIUM 6318 ADITHI DAILY WEAR DESIGNER FANCY SAREE","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"1X6KPrRZDpmr9yLx4aJKettY1VE4p88hn","other_detail":"
New Cataloge Launch<\/p>\r\n\r\n
Brand-shri balaji emporium<\/p>\r\n\r\n
CATLOGUE - ADITHI<\/p>\r\n\r\n
Fabric - Barasso With Fancy Diamond & Cut Work & Fancy Blouse<\/p>\r\n\r\n
ple4ase contact us if you have any queries<\/p>\r\n","single_catalog":"0","product_date":"2024-05-12 16:37:03","push_to_top_date":"2024-05-12 16:37:03","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7 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='456' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}