info@textilemela.com<\/a><\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2023-08-10 16:19:54","push_to_top_date":"2023-08-10 16:19:54","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"110968","author_id":"admin","product_sku":"TM-110931","product_hsn":"540710","product_name":"Lehenga Choli Bagru hand block printed cotton designer top & skirt with mulmul duptta\u00a0","cname":"Lehenga Choli Bagru hand block printed cotton designer top & skirt with mulmul duptta\u00a0","product_seo_url":"lehenga-choli-bagru-hand-block-printed-cotton-designer-top-skirt-with-mulmul-duptta-","product_image":"images\/product\/2023\/08\/lehenga-choli-bagru-hand-block-printed-cotton-designer-top-skirt-with-mulmul-duptta--2023-08-10_06_44_52.jpeg","product_qty":"50","catalog_pcs":"1","catelog_set":"","product_price":"2199","product_mrp_price":"2499","product_sale_price":"2199","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"1.5","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":"Lehenga Choli Bagru hand block printed cotton designer top & skirt with mulmul duptta\u00a0","product_full_description":"","product_status":"Publish","product_meta_title":"Lehenga Choli Bagru hand block printed cotton designer top & skirt with mulmul duptta\u00a0","product_meta_keyword":"Lehenga Choli Bagru hand block printed cotton designer top & skirt with mulmul duptta\u00a0","product_meta_description":"Lehenga Choli Bagru hand block printed cotton designer top & skirt with mulmul duptta\u00a0","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"Lehenga Choli Bagru hand block printed cotton designer top & skirt with mulmul duptta <\/p>\r\n\r\n
100% Pure collton fabric <\/p>\r\n\r\n
Sizes: 38-46. 3xl is 46
\r\nSkirt length: 40 inch
\r\nSkirt circle: 5.5 mtr.
\r\nTop length: 16 inch
\r\nDupptta size -2.5 mtr..<\/p>\r\n","single_catalog":"0","product_date":"2023-08-10 06:44:52","push_to_top_date":"2023-08-10 06:44:52","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"5 to 9","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"110868","author_id":"admin","product_sku":"TM-110831","product_hsn":"5407","product_name":"Rewaa Hastkatha Designer Bridal Wedding, Navratri Lehenga Collection","cname":"Full Catalog Available At Wholesale Rate.","product_seo_url":"rewaa-hastkatha-designer-bridal-wedding-navratri-lehenga-collection","product_image":"images\/product\/2023\/08\/rewaa-hastkatha-designer-bridal-wedding-navratri-lehenga-collection-2023-08-07_11_44_04.jpeg","product_qty":"8","catalog_pcs":"9","catelog_set":"","product_price":"7995","product_mrp_price":"9395","product_sale_price":"71955","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"45","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 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":"Rewaa Hastkatha Designer Bridal Wedding, Navratri Lehenga Collection","product_meta_keyword":"INDIAN DESIGNER LEHENGA, WEDDING LEHENGA, FESTIVE LEHENGA, PARTYWEAR LEHENGA","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
LEHENGA FABRIC : SMOOTH RAJWADI SILK WITH SPARKLE N MIRROR WORK
\r\nBLOUSE FABRIC - SMOOTH SILK WITH MIRROR sparkle WORK
\r\nLEHENGA SIZE : READY 36. MARGIN 4 INCH AND 4:5 METER GHERA
\r\nBLOUSE : STITCHED
\r\nBLOUSE SIZE 38, MARGIN UPTO 40
\r\nSPECIAL EDITION OF BEAUTIFUL MINI PURSE AND BELT","single_catalog":"0","product_date":"2023-08-07 11:44:04","push_to_top_date":"2023-08-07 11:44:04","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"110866","author_id":"admin","product_sku":"TM-110829","product_hsn":"","product_name":"New Exclusive Festival Wear Navratri Collection Chaniya Choli Collection ","cname":"New Exclusive Festival Wear Navratri Collection Chaniya Choli Collection ","product_seo_url":"new-exclusive-festival-wear-navratri-collection-chaniya-choli-collection","product_image":"images\/product\/2023\/08\/-shubhkala-new-navratri-collection-raas-vol-7-2023-08-06_07_40_38.jpeg","product_qty":"5","catalog_pcs":"1","catelog_set":"","product_price":"31300","product_mrp_price":"31300","product_sale_price":"31300","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"18","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":"New Exclusive Festival Wear Navratri Collection Chaniya Choli Collection ","product_full_description":"","product_status":"Publish","product_meta_title":"New Exclusive Festival Wear Navratri Collection Chaniya Choli Collection ","product_meta_keyword":"New Exclusive Festival Wear Navratri Collection Chaniya Choli Collection ","product_meta_description":"New Exclusive Festival Wear Navratri Collection Chaniya Choli Collection ","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
New Exclusive Festival Wear Navratri Collection Chaniya Choli Collection <\/p>\r\n\r\n
Please refer the size chart<\/p>\r\n","single_catalog":"0","product_date":"2023-08-06 07:40:38","push_to_top_date":"2023-08-06 07:40:38","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"110860","author_id":"admin","product_sku":"TM-110823","product_hsn":"5407","product_name":"Shri Balaji Emporium D.no- C10576 Designer Partywear Lehenga ","cname":"Full Catalog Available At Wholesale Rate","product_seo_url":"shri-balaji-emporium-d-no-c10576-designer-partywear-lehenga","product_image":"images\/product\/2023\/08\/shri-balaji-emporium-d-no-c10576-designer-partywear-lehenga-2023-08-05_18_22_58.jpeg","product_qty":"15","catalog_pcs":"1","catelog_set":"","product_price":"2795","product_mrp_price":"3095","product_sale_price":"2795","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"2","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 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":"Shri Balaji Emporium D.no- C10576 Designer Partywear Lehenga ","product_meta_keyword":"INDIAN DESIGNER LEHENGA, TRADITIONAL LEHENGA, PARTYWEAR LEHENGA, WHOLESALE LEHENGA, FESTIVE-WEAR LEHENGA","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
TOP CLASSY HAND EMBELLISHED WITH PRINT WORK BLOUSE <\/p>\r\n\r\n
LEHENGA ORGANZA FABRIC WITH PRINT WORK <\/p>\r\n\r\n
DUPPATTA DESIGNER ORGANZA PRINT WORK DUPPATTA<\/p>\r\n\r\n
SIZE 38 (READY)
\r\n2-2 INCH MARGIN EXTENDED 42
\r\nSLEEVES INSIDE<\/p>\r\n\r\n
\r\n\t- DO NOTE:<\/strong> Accessories shown in the image are for presentation purposes only. Difference in Image colour v\/s Actual colour is possible because of photography lights. If any query, do WhatsApp us on +918154943468.<\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2023-08-05 18:22:58","push_to_top_date":"2023-08-05 18:22:58","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"110836","author_id":"admin","product_sku":"TM-110799","product_hsn":"6211","product_name":"Shri Balaji Emporium D.no-C 1955 Georgette Festival Wear Lehenga Choli","cname":"Full Catalog Available At Wholesale Rate","product_seo_url":"shri-balaji-emporium-d-no-c-1955-georgette-festival-wear-lehenga-choli","product_image":"images\/product\/2023\/08\/shri-balaji-emporium-d-no-c-1955-georgette-festival-wear-lehenga-choli-2023-08-05_13_20_59.jpeg","product_qty":"8","catalog_pcs":"3","catelog_set":"","product_price":"3295","product_mrp_price":"3795","product_sale_price":"9885","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"9","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 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":"Shri Balaji Emporium D.no-C 1955 Georgette Festival Wear Lehenga Choli","product_meta_keyword":"INDIAN DESIGNER LEHENGA, WEDDING LEHENGA, FESTIVE LEHENGA, PARTYWEAR LEHENGA, WHOLESALE LEHENGA","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
TOP- SEQUIN EMBROIDERY WORK WITH HAND WORK <\/p>\r\n\r\n
LEHENGA - PURE VISCOSE GEORGETTE FABRIC SEQUIN EMBRIDERY WITH HANDWORK <\/p>\r\n\r\n
DUPPATA- FANCY NET WITH FULL SEQUIN EMBROIDERY WITH HANDWORK <\/p>\r\n\r\n
SIZE- 38 (READY)
\r\n3-3 INCH MARGIN EXTENDED 44
\r\nSLEEVE INSIDE<\/p>\r\n\r\n
3 COLOURS AVAILABLE<\/p>\r\n\r\n
\r\n\t- DO NOTE:<\/strong> Accessories shown in the image are for presentation purposes only. Difference in Image colour v\/s Actual colour is possible because of photography lights. If any query, do WhatsApp us on +918154943468.<\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2023-08-05 13:20:59","push_to_top_date":"2023-08-05 13:20:59","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"110829","author_id":"admin","product_sku":"TM-110792","product_hsn":"5407","product_name":"Shri Balaji Emporium D.No- C 1989 Partywear Festive Wear Lehenga Choli Collection","cname":"Full Catalog Available At Wholesale Rate","product_seo_url":"shri-balaji-emporium-d-no-c-1989-partywear-festive-wear-lehenga-choli-collection","product_image":"images\/product\/2023\/08\/shri-balaji-emporium-d-no-c-1989-partywear-festive-wear-lehenga-choli-collection-2023-08-05_12_48_16.jpeg","product_qty":"5","catalog_pcs":"1","catelog_set":"","product_price":"2695","product_mrp_price":"2995","product_sale_price":"2695","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"2","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 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":"Shri Balaji Emporium D.No- C 1989 Partywear Festive Wear Lehenga Choli Collection","product_meta_keyword":"DESIGNER LEHENGA, FANCY CROP TOP, PARTYWEAR LEHENGA, FESTIVAL LEHENGA CHOLI, WHOLESALE LEHENGA CHOLI","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
TOP CHINNON FABRIC WITH DESIGNER BLOUSE WITH SEQUIN EMBROIDERY WORK <\/p>\r\n\r\n
LEHENGA CHINNON FABRIC WITH PRINTED AND LATHKHAN<\/p>\r\n\r\n
DUPPATTA CHINNON FABRIC WITH PRINTED + LATHKHAN<\/p>\r\n\r\n
\r\nSIZE 42 (READY)
\r\n1-1 INCH MARGINE EXTENDED TO 44
\r\nSLEEVES INSIDE <\/p>\r\n\r\n
\r\n\t- DO NOTE:<\/strong> Accessories shown in the image are for presentation purposes only. Difference in Image colour v\/s Actual colour is possible because of photography lights. If any query, do WhatsApp us on +918154943468.<\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2023-08-05 12:48:16","push_to_top_date":"2023-08-05 12:48:16","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"110616","author_id":"admin","product_sku":"TM-110587","product_hsn":"","product_name":"AAWIYA NAVRATRI SPECIAL TRADITIONAL CHANIYA CHOLI COLLECTION 2023","cname":"AAWIYA NAVRATRI SPECIAL TRADITIONAL CHANIYA CHOLI COLLECTION 2023","product_seo_url":"aawiya-navratri-special-traditional-chaniya-choli-collection-2023","product_image":"images\/product\/2023\/07\/aawiya-navratri-special-traditional-chaniya-choli-collection-2023-2023-07-30_08_36_17.jpeg","product_qty":"7","catalog_pcs":"6","catelog_set":"","product_price":"1949","product_mrp_price":"2249","product_sale_price":"11694","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"2","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":"AAWIYA NAVRATRI SPECIAL TRADITIONAL CHANIYA CHOLI COLLECTION 2023","product_full_description":"","product_status":"Publish","product_meta_title":"AAWIYA NAVRATRI SPECIAL TRADITIONAL CHANIYA CHOLI COLLECTION 2023","product_meta_keyword":"AAWIYA NAVRATRI SPECIAL TRADITIONAL CHANIYA CHOLI COLLECTION 2023","product_meta_description":"AAWIYA NAVRATRI SPECIAL TRADITIONAL CHANIYA CHOLI COLLECTION 2023","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
AAWIYA NAVRATRI SPECIAL TRADITIONAL CHANIYA CHOLI COLLECTION 2023 ","single_catalog":"0","product_date":"2023-07-30 08:36:17","push_to_top_date":"2023-07-30 08:36:17","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","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='98' and rm.type='subcat' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 24, 20"}