info@textilemela.com<\/a><\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2023-08-19 17:03:08","push_to_top_date":"2023-08-19 17:03:08","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":"111180","author_id":"admin","product_sku":"TM-111142","product_hsn":"5407","product_name":"HAZZEL MAHGUL 027 PAKISTANI STYLE SUIT","cname":"BALA606","product_seo_url":"hazzel-mahgul-027-pakistani-style-suit","product_image":"images\/product\/2023\/08\/hazzel-mahgul-027-pakistani-style-suit-2023-08-18_17_08_52.jpeg","product_qty":"5","catalog_pcs":"1","catelog_set":"","product_price":"649","product_mrp_price":"999","product_sale_price":"649","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"1","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 Pakistani Suit 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":"HAZZEL MAHGUL 027 PAKISTANI STYLE SUIT","product_meta_keyword":"SALWAR SUITS, DESIGNER SUITS, COTTON SUITS, INDIAN PAKISTANI SUITS, PAKISTANI SUITS, WHOLESALE SUITS","product_meta_description":"Elevate your style with our Pakistani suits featuring stunning heavy embroidery work. Embrace timeless elegance and cultural finesse in these exquisite ensembles. Perfect for every occasion.","disable_date":"2024-05-19 06:30:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"Pakistani Suit<\/strong><\/p>\r\n\r\n\r\n\t- FABRIC:<\/strong> TOP: PURE COTTON PRINTED AND EMBROIDERY PATCHES||<\/li>\r\n\t
- BOTTOM<\/strong>: COTTON SOLID ||<\/li>\r\n\t
- DUPATTA<\/strong>: COTTON PRINTED & MAL MAL<\/li>\r\n\t
- WORK:<\/strong> EMBROIDERED.<\/li>\r\n\t
- LENGTH:<\/strong> TOP: As Shown in The Picture<\/li>\r\n\t
- STYLE:<\/strong> This is Unstitched Beautiful Pakistani Dress with Top, Bottom & Dupatta,<\/li>\r\n\t
- WHY BUY FROM US:<\/strong> All our collections are 100% original & as shown in the picture.<\/li>\r\n\t
- FOR ANY QUIRY = <\/strong>do WhatsApp us on 6355271708 & mail us on info@textilemela.com<\/a><\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2023-08-18 17:08:52","push_to_top_date":"2023-08-18 17:08:52","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":"110830","author_id":"admin","product_sku":"TM-110793","product_hsn":"5407","product_name":"HAZZEL MARIA B COTTON DUPATTA PAKISTANI SALWAR SUITS","cname":"BALA269","product_seo_url":"hazzel-maria-b-cotton-dupatta-pakistani-salwar-suits","product_image":"images\/product\/2023\/08\/hazzel-maria-b-cotton-dupatta-pakistani-salwar-suits-2023-08-05_12_52_09.jpeg","product_qty":"10","catalog_pcs":"2","catelog_set":"","product_price":"625","product_mrp_price":"699","product_sale_price":"1250","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","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":"Indian Latest Designer Pakistani Suit 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":"HAZZEL MARIA B COTTON DUPATTA PAKISTANI SALWAR SUITS","product_meta_keyword":"SALWAR SUITS, DESIGNER SUITS, GEORGETTE SUITS, INDIAN PAKISTANI SUITS, PAKISTANI SUITS, WHOLESALE SUITS","product_meta_description":"Elevate your style with our Pakistani suits featuring stunning heavy embroidery work. Embrace timeless elegance and cultural finesse in these exquisite ensembles. Perfect for every occasion.","disable_date":"2024-05-19 06:30:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
Pakistani Suit<\/strong><\/p>\r\n\r\n\r\n\t- FABRIC:<\/strong> TOP: PURE COTTON || BOTTOM<\/strong>: COTTON SOLID || <\/li>\r\n\t
- DUPATTA<\/strong>: COTTON PRINTED<\/li>\r\n\t
- WORK:<\/strong> PRINTED <\/li>\r\n\t
- LENGTH:<\/strong> TOP: As Shown in The Picture<\/li>\r\n\t
- STYLE:<\/strong> This is Unstitched Beautiful Pakistani Dress with Top, Bottom & Dupatta,<\/li>\r\n\t
- WHY BUY FROM US:<\/strong> All our collections are 100% original & as shown in the picture.<\/li>\r\n\t
- FOR ANY QUIRY = <\/strong>do WhatsApp us on 6355271708 & mail us on info@textilemela.com<\/a><\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2023-08-05 12:52:09","push_to_top_date":"2023-08-05 12:52:09","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7 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='466' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}