info@textilemela.com<\/a><\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2023-08-10 15:54:50","push_to_top_date":"2023-08-10 15:54:50","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":"110902","author_id":"admin","product_sku":"TM-110865","product_hsn":"5407","product_name":"SAFA PK 602 HEAVY GEORGETTE PAKISTANI SALWAR SUIT","cname":"BALA393","product_seo_url":"safa-pk-602-heavy-georgette-pakistani-salwar-suit","product_image":"images\/product\/2023\/08\/safa-pk-602-heavy-georgette-pakistani-salwar-suit-2023-08-08_12_28_58.jpeg","product_qty":"5","catalog_pcs":"1","catelog_set":"","product_price":"1800","product_mrp_price":"2600","product_sale_price":"1800","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":"SAFA PK 602 A TO D HEAVY GEORGETTE PAKISTANI SALWAR SUIT","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":"0000-00-00 00:00: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: GEORGETTE || BOTTOM<\/strong>: SANTOON || <\/li>\r\n\t
- DUPATTA<\/strong>:NAZMEEN WITH LACE EMBROIDERY & LATKANS<\/li>\r\n\t
- WORK:<\/strong> EMBROIDERY, HANDWORK<\/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> WhatsApp us on 6355271708 & mail us on info@textilemela.com<\/a><\/li>\r\n<\/ul>\r\n\r\n
\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2023-08-08 12:28:58","push_to_top_date":"2023-08-08 12:28:58","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":"109234","author_id":"admin","product_sku":"TM-109212","product_hsn":"5407","product_name":"SAFA PRESENTS 311 COLOURS PAKISTANI WEAR ORGANZA SUITS COLLECTION AT WHOLESALE PRICE 7798","cname":"BALA7798","product_seo_url":"safa-presents-311-colours-pakistani-wear-organza-suits-collection-at-wholesale-price-7798","product_image":"images\/product\/2023\/01\/safa-presents-311-colours-pakistani-wear-organza-suits-collection-at-wholesale-price-7798-2023-01-20_14_12_15.jpeg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"1234","product_mrp_price":"1299","product_sale_price":"4936","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"3","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 Salwar Kameez 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":"SAFA PRESENTS 311 COLOURS PAKISTANI WEAR ORGANZA SUITS COLLECTION AT WHOLESALE PRICE 7798","product_meta_keyword":"SALWAR SUITS, DESIGNER SUITS, ORGANZA SUITS, PAKISTANI SUITS, INDIAN PAKISTANI SUITS, DESIGNER PAKISTANI SUITS","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"\r\n\t- FABRIC:<\/strong> TOP: Organza Tisue || BOTTOM: Dull Santoon || DUPATTA: Butterfly Net<\/li>\r\n\t
- WORK:<\/strong> Thread embroidery, Diamond work, Sequence work<\/li>\r\n\t
- LENGTH:<\/strong> TOP: As Shown in The Picture<\/li>\r\n\t
- STYLE:<\/strong> This is Semi Stitched Beautiful Wedding Casual 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
- Do note:<\/strong> Accessories shown in the picture are for presentation purposes only. Slight Variation in actual colour v\/s image colour is possible because of photography lights. If any query, do WhatsApp us on +919558826602 & mail us on info@textilemela.com<\/a><\/li>\r\n\t
- 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":"2023-01-20 14:12:15","push_to_top_date":"2023-01-20 14:12:15","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":"108466","author_id":"admin","product_sku":"TM-108447","product_hsn":"5407","product_name":"SAFA PRESENTS 306 COLOURS INDIAN PAKISTANI SUITS COLLECTION AT WHOLESALE PRICE 7116","cname":"BALA7116","product_seo_url":"safa-presents-306-colours-indian-pakistani-suits-collection-at-wholesale-price-7116","product_image":"images\/product\/2022\/12\/safa-presents-306-colours-indian-pakistani-suits-collection-at-wholesale-price-7116-2022-12-06_14_51_19.jpeg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"1499","product_mrp_price":"0","product_sale_price":"5996","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"3","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 Salwar Kameez 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":"SAFA PRESENTS 306 COLOURS INDIAN PAKISTANI SUITS COLLECTION AT WHOLESALE PRICE 7116","product_meta_keyword":"SALWAR SUITS, DESIGNER SUITS, GEORGETTE SUITS, INDIAN PAKISTANI SUITS, PARTY WEAR SUITS, WEDDING SUITS, WHOLESALE SUITS, PAKISTANI SUITS","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
\r\n\t- FABRIC:<\/strong> TOP: Georgette || BOTTOM: Santoon || DUPATTA: Georgette || INNER: Santoon<\/li>\r\n\t
- WORK:<\/strong> Thread embroidery, digital print<\/li>\r\n\t
- LENGTH:<\/strong> TOP: As Shown in The Picture<\/li>\r\n\t
- STYLE:<\/strong> This is Semi Stitched Beautiful Wedding Casual 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
- Do note:<\/strong> Accessories shown in the picture are for presentation purposes only. Slight Variation in actual colour v\/s image colour is possible because of photography lights. If any query, do WhatsApp us on +919558826602 & mail us on info@textilemela.com<\/a><\/li>\r\n\t
- 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-12-06 14:51:19","push_to_top_date":"2022-12-06 14:51:19","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='423' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}