\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-02 14:38:38","push_to_top_date":"2024-05-02 14:38:38","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"118130","author_id":"admin","product_sku":"TM-118052","product_hsn":"540710","product_name":"Omtex Vivanta SILK DIGITAL PRINT EMBROIDERY PATCH WORK SUIT","cname":"DAISY SILK DIGITAL PRINT EMBROIDERY PATCH WORK WITH HAND WORK","product_seo_url":"omtex-vivanta-silk-digital-print-embroidery-patch-work-suit","product_image":"images\/product\/2024\/05\/omtex-vivanta-silk-digital-print-embroidery-patch-work-suit-2024-05-02_14_30_34.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"2295","product_mrp_price":"2295","product_sale_price":"9180","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"4","product_stitch":"Unstitched","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":"DAISY SILK DIGITAL PRINT EMBROIDERY PATCH WORK WITH HAND WORK SUIT","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Omtex Vivanta SILK DIGITAL PRINT EMBROIDERY PATCH WORK SUIT sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" TOP DAISY SILK DIGITAL PRINT EMBROIDERY PATCH WORK WITH HAND WORK<\/p>\r\n\r\n BOTTOM CANVAS SATIN WITH PATCH WORK<\/p>\r\n\r\n DUPATTA PINE SILK DIGITAL PRINT WITH<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-02 14:30:34","push_to_top_date":"2024-05-02 14:30:34","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"118127","author_id":"admin","product_sku":"TM-118049","product_hsn":"540710","product_name":" Kimora MAASOOMIYAT PURE MUSLIN, RESHAM EMBROIDERY ORGANZA EMBROIDERY SUIT","cname":"PURE MUSLIN, RESHAM TONAL EMBROIDERY WITH ORGANZA SCALLOPED EMBROIDERY APPLIQU\u00c9D ON HEMLINE AND SLEEVES SUIT","product_seo_url":"kimora-maasoomiyat-pure-muslin-resham-embroidery-organza-embroidery-suit","product_image":"images\/product\/2024\/05\/kimora-maasoomiyat-pure-muslin-resham-embroidery-organza-embroidery-suit-2024-05-02_14_20_47.jpg","product_qty":"5","catalog_pcs":"6","catelog_set":"","product_price":"2050","product_mrp_price":"2050","product_sale_price":"12300","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":"YES","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"PURE MUSLIN, RESHAM TONAL EMBROIDERY WITH ORGANZA SCALLOPED EMBROIDERY APPLIQU\u00c9D ON HEMLINE AND SLEEVES SUIT","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":" Kimora MAASOOMIYAT PURE MUSLIN, RESHAM EMBROIDERY ORGANZA EMBROIDERY SUIT sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"1_jcN19_u7G5Ky5gr9TNaRmDnIocWxR1B","other_detail":" TOP PURE MUSLIN, RESHAM TONAL EMBROIDERY WITH ORGANZA SCALLOPED EMBROIDERY APPLIQUÉD ON HEMLINE AND SLEEVES<\/p>\r\n\r\n DUPATTA PURE CHINNON WITH DIGITAL PRINT AND HAND CRAFTED TASSELS<\/p>\r\n\r\n BOTTOM PURE MUSLIN HEAVY<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-02 14:20:47","push_to_top_date":"2024-05-02 14:20:47","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"118125","author_id":"admin","product_sku":"TM-118047","product_hsn":"540710","product_name":" Varsha Neo COTTON LINEN PRINTED EMBROIDERY MIRROR WORK SUIT","cname":"COTTON LINEN PRINTED WITH EMBROIDERY MIRROR HANDWORK DETAILS AND LACES SUIT","product_seo_url":"varsha-neo-cotton-linen-printed-embroidery-mirror-work-suit","product_image":"images\/product\/2024\/05\/varsha-neo-cotton-linen-printed-embroidery-mirror-work-suit-2024-05-02_14_11_15.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"1580","product_mrp_price":"1580","product_sale_price":"6320","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"4","product_stitch":"Unstitched","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":"COTTON LINEN PRINTED WITH EMBROIDERY MIRROR HANDWORK DETAILS AND LACES SUIT","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":" Varsha Neo COTTON LINEN PRINTED EMBROIDERY MIRROR WORK SUIT sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" TOP COTTON LINEN PRINTED WITH EMBROIDERY MIRROR HANDWORK DETAILS AND LACES.<\/p>\r\n\r\n DUPATTA NEO VISCOSE MUSLIN PRINTED WITH ADDED TASSELS. NEO<\/p>\r\n\r\n BOTTOM COTTON SOLID.<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-02 14:11:15","push_to_top_date":"2024-05-02 14:11:15","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"118116","author_id":"admin","product_sku":"TM-118038","product_hsn":"540710","product_name":"Ganga Navy 2529 COTTON SILK SOLID EMBROIDERY WORK SUIT ","cname":"COTTON SILK SOLID WITH EMBROIDERY AND READY LACE ON DAMAN","product_seo_url":"ganga-navy-2529-cotton-silk-solid-embroidery-work-suit","product_image":"images\/product\/2024\/05\/ganga-navy-2529-cotton-silk-solid-embroidery-work-suit-2024-05-02_13_50_38.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"1370","product_mrp_price":"1370","product_sale_price":"5480","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"4","product_stitch":"Unstitched","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":"COTTON SILK SOLID WITH EMBROIDERY AND READY LACE ON DAMAN","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Ganga Navy 2529 COTTON SILK SOLID EMBROIDERY WORK SUIT sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" TOP PREMIUM COTTON SILK SOLID WITH EMBROIDERY AND READY LACE ON DAMAN<\/p>\r\n\r\n BOTTOM PREMIUM COTTON SILK SOLID COLOUR<\/p>\r\n\r\n DUPATTA PURE CHIFFON PRINTED<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-02 13:50:38","push_to_top_date":"2024-05-02 13:50:38","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"118113","author_id":"admin","product_sku":"TM-118035","product_hsn":"540710","product_name":"Ganga Iskra PURE LINEN PRINTED EMBROIDERY COTTON LACE SUIT","cname":"PURE LINEN PRINTED WITH EMBROIDERY AND COTTON LACE FOR NECK AND DAMAN SUIT","product_seo_url":"ganga-iskra-pure-linen-printed-embroidery-cotton-lace-suit","product_image":"images\/product\/2024\/05\/ganga-iskra-pure-linen-printed-embroidery-cotton-lace-suit-2024-05-02_13_44_36.jpg","product_qty":"5","catalog_pcs":"6","catelog_set":"","product_price":"2480","product_mrp_price":"2480","product_sale_price":"14880","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":"YES","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"PURE LINEN PRINTED WITH EMBROIDERY AND COTTON LACE FOR NECK AND DAMAN SUIT","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Ganga Iskra PURE LINEN PRINTED EMBROIDERY COTTON LACE SUIT sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" TOP PREMIUM PURE LINEN PRINTED WITH EMBROIDERY AND COTTON LACE FOR NECK AND DAMAN<\/p>\r\n\r\n BOTTOM PREMIUM COTTON SOLID COLOUR<\/p>\r\n\r\n DUPATTA PURE CHIFFON PRINTED WITH FOUR SIDE COTTON LACE<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-02 13:44:36","push_to_top_date":"2024-05-02 13:44:36","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"118112","author_id":"admin","product_sku":"TM-118034","product_hsn":"540710","product_name":"Ganga Maribel Whitney 2614 COTTON PATTERN SOLID EMBROIDERY SUIT ","cname":"COTTON PATTERN SOLID WITH EMBROIDERY & COTTON LACE ON DAMAN SUIT","product_seo_url":"ganga-maribel-whitney-2614-cotton-pattern-solid-embroidery-suit","product_image":"images\/product\/2024\/05\/ganga-maribel-whitney-2614-cotton-pattern-solid-embroidery-suit-2024-05-02_13_38_29.jpg","product_qty":"5","catalog_pcs":"2","catelog_set":"","product_price":"1825","product_mrp_price":"1825","product_sale_price":"3650","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":"YES","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"COTTON PATTERN SOLID WITH EMBROIDERY & COTTON LACE ON DAMAN SUIT","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Ganga Maribel Whitney 2614 COTTON PATTERN SOLID EMBROIDERY SUIT sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" TOP PREMIUM COTTON PATTERN SOLID WITH EMBROIDERY & COTTON LACE ON DAMAN<\/p>\r\n\r\n BOTTOM PREMIUM COTTON SOLID COLOUR<\/p>\r\n\r\n DUPATTA PREMIUM PURE LINEN JACQUARD<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-02 13:38:29","push_to_top_date":"2024-05-02 13:38:29","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"118108","author_id":"admin","product_sku":"TM-118030","product_hsn":"540710","product_name":"Shri Balaji Emporium Joya Sanjha COTTON DIGITAL PRINT EMBROIDERED NECK LACE SUIT","cname":"FAB FILL COTTON DIGITAL PRINT EMBROIDERED NECK LACE ON SLEEVES AND ON TOP ","product_seo_url":"shri-balaji-emporium-joya-sanjha-cotton-digital-print-embroidered-neck-lace-suit","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-joya-sanjha-cotton-digital-print-embroidered-neck-lace-suit-2024-05-02_13_29_42.jpg","product_qty":"5","catalog_pcs":"6","catelog_set":"","product_price":"1695","product_mrp_price":"1695","product_sale_price":"10170","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":"YES","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"FAB FILL COTTON DIGITAL PRINT EMBROIDERED NECK LACE ON SLEEVES AND ON TOP","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium Joya Sanjha COTTON DIGITAL PRINT EMBROIDERED NECK LACE SUIT sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" TOP: FAB FILL COTTON DIGITAL PRINT EMBROIDERED NECK LACE ON SLEEVES AND ON TOP <\/p>\r\n\r\n BOTTOM: COTTON SOLID<\/p>\r\n\r\n DUPATTA : MASLIN DIGITAL PRINT WITH LACE FOUR SIDE<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-02 13:29:42","push_to_top_date":"2024-05-02 13:29:42","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"118062","author_id":"admin","product_sku":"TM-117984","product_hsn":"540710","product_name":"STYLISHTA 6125 TANISHA VOL02 Fancy Casual Wear Block Printed Suit Pant ","cname":" Fancy Casual Wear Block Printed Suit Pant floral print","product_seo_url":"stylishta-6125-tanisha-vol02-fancy-casual-wear-block-printed-suit-pant","product_image":"images\/product\/2024\/05\/stylishta-6125-tanisha-vol02-fancy-casual-wear-block-printed-suit-pant-2024-05-01_13_43_05.jpg","product_qty":"20","catalog_pcs":"8","catelog_set":"","product_price":"699","product_mrp_price":"699","product_sale_price":"5592","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"8","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":" Fancy Casual Wear Block Printed Suit Pant floral print","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"STYLISHTA 6125 TANISHA VOL02 Fancy Casual Wear Block Printed Suit Pant sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Fabric Details: - Cotton.
\r\nWork: - block print.
\r\n dyed.
\r\n floral print.
\r\nSize:-M (38)\/ L (40), XL (42), XXL (44).
\r\nWeight: - 1 kg.<\/p>\r\n\r\n please contact us if you have any queries <\/p>\r\n","single_catalog":"0","product_date":"2024-05-01 13:43:05","push_to_top_date":"2024-05-01 13:43:05","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118055","author_id":"admin","product_sku":"TM-117977","product_hsn":"540710","product_name":"HOOR TEX H 231 A To C Embroidered Faux Georgette Pakistani Suit","cname":"Indian Latest Designer Beautiful Embroiderd Faux Georgette Pakistani Suit with Heavy Embroiderd Dupatta","product_seo_url":"hoor-tex-h-231-a-to-c-embroidered-faux-georgette-pakistani-suit","product_image":"images\/product\/2024\/05\/hoor-tex-h-231-a-to-c-embroidered-faux-georgette-pakistani-suit-2024-05-01_12_57_32.jpg","product_qty":"5","catalog_pcs":"3","catelog_set":"","product_price":"1149","product_mrp_price":"1149","product_sale_price":"3447","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","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 Beautiful Embroiderd Faux Georgette Pakistani Suit with Heavy Embroiderd Dupatta","product_full_description":"","product_status":"Publish","product_meta_title":"HOOR TEX H 188 A To D Embroidered Faux Georgette Pakistani Suit","product_meta_keyword":"HOOR TEX H 231 A To C Embroidered Faux Georgette Pakistani Suit indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian, wedding, ","product_meta_description":"Indian Latest Designer Beautiful Embroiderd Faux Georgette Pakistani Suit with Heavy Embroiderd Dupatta","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"1mgyRIahuhwHTP7kzjUxHxOv_sBDbbs3d","other_detail":" H-231,A To C<\/p>\r\n\r\n Fabric details<\/p>\r\n\r\n Top : FOX GEORGETTE<\/p>\r\n\r\n Bottom : SANTOON
\r\n
\r\ninner : SANTOON<\/p>\r\n\r\n Dupatta : Heavy Net<\/p>\r\n\r\n Please contact us if you have any questions.<\/p>\r\n","single_catalog":"0","product_date":"2024-05-01 12:57:32","push_to_top_date":"2024-05-01 12:57:32","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":"118052","author_id":"admin","product_sku":"TM-117974","product_hsn":"540710","product_name":"HOOR TEX H 188 A To D Embroidered Faux Georgette Pakistani Suit","cname":"Indian Latest Designer Beautiful Embroiderd Faux Georgette Pakistani Suit with Heavy Embroiderd Dupatta","product_seo_url":"hoor-tex-h-188-a-to-d-embroidered-faux-georgette-pakistani-suit","product_image":"images\/product\/2024\/05\/hoor-tex-h-188-a-to-d-embroidered-faux-georgette-pakistani-suit-2024-05-01_12_40_58.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"1249","product_mrp_price":"1249","product_sale_price":"4996","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"4","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 Beautiful Embroiderd Faux Georgette Pakistani Suit with Heavy Embroiderd Dupatta","product_full_description":"","product_status":"Publish","product_meta_title":"HOOR TEX H 188 A To D Embroidered Faux Georgette Pakistani Suit","product_meta_keyword":"HOOR TEX H 188 A To D Embroidered Faux Georgette Pakistani Suit indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian, wedding, ","product_meta_description":"Indian Latest Designer Beautiful Embroiderd Faux Georgette Pakistani Suit with Heavy Embroiderd Dupatta","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"1jZdo2b3dHOdY0hJFxgOi3VDt9ZNuYu3Z","other_detail":" H-188 A To D<\/p>\r\n\r\n Fabric details<\/p>\r\n\r\n Top : FOX GEORGETTE<\/p>\r\n\r\n Bottom : SANTOON
\r\n
\r\ninner : SANTOON<\/p>\r\n\r\n Dupatta : Heavy Net<\/p>\r\n\r\n Please contact us if you have any questions.<\/p>\r\n","single_catalog":"0","product_date":"2024-05-01 12:40:58","push_to_top_date":"2024-05-01 12:40: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":"118050","author_id":"admin","product_sku":"TM-117972","product_hsn":"540710","product_name":"SHREEMATEE 6120 KIASHA Heavy Rayon Straight Pakistani Suit Party Wear ","cname":"Heavy Rayon with Guaranteed Foil Print","product_seo_url":"shreematee-6120-kiasha-heavy-rayon-straight-pakistani-suit-party-wear","product_image":"images\/product\/2024\/05\/banwari-fashion-6119-nykaa-v-heavy-rayon-straight-pakistani-suit-party-wear-2024-05-01_12_14_27.jpg","product_qty":"25","catalog_pcs":"6","catelog_set":"","product_price":"799","product_mrp_price":"799","product_sale_price":"4794","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"4","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":"Heavy Rayon with Guaranteed Foil Print","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"BANWARI FASHION 6119 NYKAA V Heavy Rayon Straight Pakistani Suit Party Wear sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"1HKcr7DmeNzBtRMuS_NIecKjtYp6RLUHa","other_detail":" TOP :- Heavy 14kg Rayon with Guaranteed Foil Print<\/p>\r\n\r\n PENT:- Heavy 14kg Rayon with Guaranteed Foil Print<\/p>\r\n\r\n DUPATTA :- Heavy 14kg Rayon with Guaranteed Foil Print
\r\n
\r\nSize :- M, L, XL, XXL, 3XL<\/p>\r\n\r\n Weight 600gm<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-01 12:14:27","push_to_top_date":"2024-05-01 12:14: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":"118044","author_id":"admin","product_sku":"TM-117966","product_hsn":"540710","product_name":"Shri Balaji Emporium 6116 Subhadra Trendy Straight Women Cotton Kurta Pant ","cname":"Women Kurta Pant Cotton Bland Printed ","product_seo_url":"shri-balaji-emporium-6116-subhadra-trendy-straight-women-cotton-kurta-pant","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-6116-subhadra-trendy-straight-women-cotton-kurta-pant-2024-05-01_11_20_41.jpg","product_qty":"20","catalog_pcs":"2","catelog_set":"","product_price":"555","product_mrp_price":"555","product_sale_price":"1110","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"2","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"no","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Women Kurta Pant Cotton Bland Printed ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 6116 Subhadra Trendy Straight Women Cotton Kurta Pant sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Product typ - Women Kurta With Pant<\/p>\r\n\r\n Size - M To XXL<\/p>\r\n\r\n Fabric - Cotton Bland<\/p>\r\n\r\n Pattern - Printed<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-01 11:20:41","push_to_top_date":"2024-05-01 11:20:41","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118043","author_id":"admin","product_sku":"TM-117965","product_hsn":"540710","product_name":"HOOR TEX H 238 Faux Georgette Pakistani Suit","cname":"Indian Latest Designer Beautiful Embroiderd Faux Georgette Pakistani Suit with Georgette Dupatta","product_seo_url":"hoor-tex-h-238-faux-georgette-pakistani-suit","product_image":"images\/product\/2024\/05\/hoor-tex-h-238-faux-georgette-pakistani-suit-2024-05-01_11_14_52.jpg","product_qty":"5","catalog_pcs":"3","catelog_set":"","product_price":"1149","product_mrp_price":"1149","product_sale_price":"3447","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","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 Beautiful Embroiderd Faux Georgette Pakistani Suit with Georgette Dupatta","product_full_description":"","product_status":"Publish","product_meta_title":"HOOR TEX H 238 Faux Georgette Pakistani Suit","product_meta_keyword":"HOOR TEX H 238 Faux Georgette Pakistani Suit indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian, wedding, green wine, pink ","product_meta_description":"Indian Latest Designer Beautiful Embroiderd Faux Georgette Pakistani Suit with Georgette Dupatta","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"1vHOJ9z5dRmpvKGxG4J6b8-9CuyOoBjGl","other_detail":" H-238,A To D<\/p>\r\n\r\n Fabric details<\/p>\r\n\r\n Top : FOX GEORGETTE<\/p>\r\n\r\n Bottom : SANTOON
\r\n
\r\ninner : SANTOON<\/p>\r\n\r\n Dupatta : Georgette<\/p>\r\n\r\n Please contact us if you have any questions.<\/p>\r\n\r\n <\/p>\r\n","single_catalog":"0","product_date":"2024-05-01 11:14:52","push_to_top_date":"2024-05-01 11:14:52","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"4 to 7 Days","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118036","author_id":"admin","product_sku":"TM-117958","product_hsn":"540710 ","product_name":"Shri Balaji Emporium 6104 Latest Designer Wedding Wear Palazzo Sharara Suit ","cname":"pakistani palazzo sharara suit partywear weddig wear ","product_seo_url":"shri-balaji-emporium-6104-latest-designer-wedding-wear-palazzo-sharara-suit","product_image":"images\/product\/2024\/04\/shri-balaji-emporium-6104-latest-designer-wedding-wear-palazzo-sharara-suit-2024-04-30_18_06_47.jpg","product_qty":"20","catalog_pcs":"4","catelog_set":"","product_price":"4199","product_mrp_price":"4199","product_sale_price":"16796","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":"yes","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"pakistani palazzo sharara suit partywear weddig wear ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 6104 Latest Designer Wedding Wear Palazzo Sharara Suit sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","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\r\n\t\t\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-04-30 18:06:47","push_to_top_date":"2024-04-30 18:06:47","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117976","author_id":"admin","product_sku":"TM-117898","product_hsn":"540710","product_name":"Shri Balaji Emporium 5805 Pure Viscose Musline silk Pakistani Suit ","cname":"pure bamberg viscose Musline silk with digital print","product_seo_url":"shri-balaji-emporium-5805-pure-viscose-musline-silk-pakistani-suit","product_image":"images\/product\/2024\/04\/shri-balaji-emporium-5805-pure-viscose-musline-silk-pakistani-suit-2024-04-29_14_37_01.jpg","product_qty":"5","catalog_pcs":"6","catelog_set":"","product_price":"1295","product_mrp_price":"1295","product_sale_price":"7770","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":"yes","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"pure bamberg viscose Musline silk with digital print","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 5805 Pure Viscose Musline silk Pakistani Suit sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"1VJ-HjrNGkKTk3PUuROWMxftErWbIbxNm","other_detail":" Fabric Details
\r\n
\r\n*Top: pure bamberg viscose Musline silk with digital print<\/p>\r\n\r\n Bottom: pure airjet viscose rayon<\/p>\r\n\r\n Dupatta: pure bemberg musline with degital print<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-04-29 14:37:01","push_to_top_date":"2024-04-29 14:37:01","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117975","author_id":"admin","product_sku":"TM-117897","product_hsn":"540710","product_name":"Your choice 5806 SIYA Semi Pure Chinon Pakistani Partywear Suit Collection ","cname":"Latest Pure Chinon Pakistani Partywear Suit Collection ","product_seo_url":"your-choice-5806-siya-semi-pure-chinon-pakistani-partywear-suit-collection","product_image":"images\/product\/2024\/04\/your-choice-5806-siya-semi-pure-chinon-pakistani-partywear-suit-collection-2024-04-29_14_16_56.jpg","product_qty":"5","catalog_pcs":"2","catelog_set":"","product_price":"2795","product_mrp_price":"2795","product_sale_price":"5590","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":"yes","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Latest Pure Chinon Pakistani Partywear Suit Collection ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Your choice 5806 SIYA Semi Pure Chinon Pakistani Partywear Suit Collection sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Fabrics- ","single_catalog":"0","product_date":"2024-04-29 14:16:56","push_to_top_date":"2024-04-29 14:16:56","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117970","author_id":"admin","product_sku":"TM-117892","product_hsn":"540710","product_name":"SHREEMATEE 5809 Soft Silk with Embroidery Work Suit Salwar ","cname":"Bitalian Soft Silk with Embroidery Work & Real mirror work Suit Salwar ","product_seo_url":"shreematee-5809-soft-silk-with-embroidery-work-suit-salwar","product_image":"images\/product\/2024\/04\/shreematee-5809-soft-silk-with-embroidery-work-suit-salwar-2024-04-29_13_27_46.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"1494","product_mrp_price":"1495","product_sale_price":"5976","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"4","product_stitch":"Unstitched","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":"Bitalian Soft Silk with Embroidery Work & Real mirror work Suit Salwar ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"SHREEMATEE 5809 Soft Silk with Embroidery Work Suit Salwar sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" TOP:- Bitalian Soft Silk with Embroidery Work & Real mirror work. BOTTOM :- Bitalian Soft Silk.
\r\nDUPATTA :- Net with 4 Side Lace Border.
\r\nWEIGHT :- 1 Kg+.<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-04-29 13:27:46","push_to_top_date":"2024-04-29 13:27:46","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117963","author_id":"admin","product_sku":"TM-117885","product_hsn":"540710","product_name":"Shri Balaji Emporium 6081 GUNJAN RAYON EMBROIDERY PAKISTANI SUIT COLLECTION ","cname":" elegance with Lucknowi embroidered suits RAYON EMBROIDERY PAKISTANI SUIT COLLECTION ","product_seo_url":"shri-balaji-emporium-6081-gunjan-rayon-embroidery-pakistani-suit-collection","product_image":"images\/product\/2024\/04\/shri-balaji-emporium-6081-gunjan-rayon-embroidery-pakistani-suit-collection-2024-04-29_11_19_09.jpg","product_qty":"35","catalog_pcs":"6","catelog_set":"","product_price":"1425","product_mrp_price":"1425","product_sale_price":"8550","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"6","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":" elegance with Lucknowi embroidered suits RAYON EMBROIDERY PAKISTANI SUIT COLLECTION ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 6081 GUNJAN RAYON EMBROIDERY PAKISTANI SUIT COLLECTION sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"1ebR4PuAlYr0Onf3X5Nk13lY2oVnnl-Of","other_detail":" Fabric - rayon
\r\n m to xxl
\r\nBig size -\/- 3xl 4xl 5xl<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-04-29 11:19:09","push_to_top_date":"2024-04-29 11:19:09","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117936","author_id":"admin","product_sku":"TM-117858","product_hsn":"540710","product_name":"MESMORA 6059 Floral Printed Regular Pure Cotton Kurta","cname":"Floral Printed Regular Pure Cotton Kurta with Pant & With Dupatta","product_seo_url":"mesmora-6059-floral-printed-regular-pure-cotton-kurta","product_image":"images\/product\/2024\/04\/mesmora-6059-floral-printed-regular-pure-cotton-kurta-2024-04-27_13_03_21.jpg","product_qty":"25","catalog_pcs":"17","catelog_set":"","product_price":"1499","product_mrp_price":"1499","product_sale_price":"25483","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"17","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":"Floral Printed Regular Pure Cotton Kurta with Pant & With Dupatta ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"MESMORA 6059 Floral Printed Regular Pure Cotton Kurta sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Available in 5 sizes
\r\nS - 34
\r\nM - 38
\r\nL - 40
\r\nXL - 42
\r\nXXL - 44<\/p>\r\n\r\n Floral Printed Regular Pure Cotton Kurta with Pant & With Dupatta<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\t| please contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n\r\n <\/p>\r\n","single_catalog":"0","product_date":"2024-04-27 13:03:21","push_to_top_date":"2024-04-27 13:03:21","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='14' and rm.type='subcat' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 24, 20"} | | | | | | | | | | | | | | |