TOP
\r\n: PURE ORGANZA
\r\nDIGITAL PRINT WITH HEAVY CODING WORK
\r\nBOTTOM+INNER: DULL SHANTUNG
\r\nDUPATTA
\r\n: PURE ORGANZA JACQUARD<\/p>\r\n\r\n
Please contact us if you have any questions.<\/p>\r\n","single_catalog":"0","product_date":"2024-04-09 13:15:04","push_to_top_date":"2024-04-09 13:15:04","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"4 to 7 Days","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"117347","author_id":"admin","product_sku":"TM-117272","product_hsn":"540710","product_name":"TAPI EKTA PURE MUSLIN SILK JACQUARD SUIT WITH HEAVY EMBROIDERY WORK ","cname":"Indian Latest Designer Beautiful Pure Muslin Silk Jacquard Suit With Heavy Embroidery Work & Swarovski Diamond ","product_seo_url":"tapi-ekta-pure-muslin-silk-jacquard-suit-with-heavy-embroidery-work","product_image":"images\/product\/2024\/04\/tapi-ekta-pure-muslin-silk-jacquard-suit-with-heavy-embroidery-work-2024-04-09_13_05_08.jpg","product_qty":"2","catalog_pcs":"6","catelog_set":"","product_price":"825","product_mrp_price":"825","product_sale_price":"4950","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":"Indian Latest Designer Beautiful Pure Muslin Silk Jacquard Suit With Heavy Embroidery Work & Swarovski Diamond ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"TAPI EKTA PURE MUSLIN SILK JACQUARD SUIT WITH HEAVY EMBROIDERY WORK pink red, yellow, purple, wine, green, blue, indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian,","product_meta_description":"","disable_date":"1970-01-01 05:30:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
TOP: PURE MUSLIN SILK JACQUARD WITH HEAVY EMBROIDERY WORK & SWAROVSKI DIAMOND<\/p>\r\n\r\n
BOTTOM: PURE REYON<\/p>\r\n\r\n
DUPATTA: PURE CHINON WITH HEAVY EMBROIDERY WORK & CUT-WORK BORDER<\/p>\r\n\r\n
Please contact us if you have any questions.<\/p>\r\n","single_catalog":"0","product_date":"2024-04-09 13:05:08","push_to_top_date":"2024-04-09 13:05:08","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"4 to 7 Days","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"117346","author_id":"admin","product_sku":"TM-117271","product_hsn":"540710","product_name":"TAPI PADMA PURE JAM COTTON SUIT WITH HEAVY EMBROIDERY WORK & JARKAN WORK ","cname":"Indian Latest Designer Beautiful Pure Jam Cotton Suit With Heavy Embroidery Work & Jarquan Work Half Pure With Heavy Embroidery Work ","product_seo_url":"tapi-padma-pure-jam-cotton-suit-with-heavy-embroidery-work-jarkan-work","product_image":"images\/product\/2024\/04\/tapi-padma-pure-jam-cotton-suit-with-heavy-embroidery-work-jarkan-work-2024-04-09_13_00_16.jpg","product_qty":"2","catalog_pcs":"6","catelog_set":"","product_price":"825","product_mrp_price":"825","product_sale_price":"4950","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":"Indian Latest Designer Beautiful Pure Jam Cotton Suit With Heavy Embroidery Work & Jarquan Work Half Pure With Heavy Embroidery Work ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"TAPI PADMA PURE JAM COTTON SUIT WITH HEAVY EMBROIDERY WORK & JARKAN WORK pink red, yellow, purple, wine, green, blue, indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian, ","product_meta_description":"","disable_date":"1970-01-01 05:30:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
TOP: PURE JAM COTTON WITH HEAVY EMBROIDERY WORK & JARKAN WORK HALF PURE WITH HEAVY EMBROIDERY WORK<\/p>\r\n\r\n
BOTTOM : SEMILON<\/p>\r\n\r\n
DUPATTA: PURE JAM COTTON WITH HEAVY EMBROIDERY WORK & JARKAN WORK<\/p>\r\n\r\n
Please contact us if you have any questions.<\/p>\r\n","single_catalog":"0","product_date":"2024-04-09 13:00:16","push_to_top_date":"2024-04-09 13:00:16","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 8 days","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"117342","author_id":"admin","product_sku":"TM-117267","product_hsn":"540710","product_name":"TAPI RANI PURE CREPE SUIT WITH HEAVY EMBROIDERY WORK ","cname":"Indian Latest Designer Beautiful Pure Crepe Suit With Heavy Embroidery Work & Zarkan Work ","product_seo_url":"tapi-rani-pure-crepe-suit-with-heavy-embroidery-work","product_image":"images\/product\/2024\/04\/tapi-rani-pure-crepe-suit-with-heavy-embroidery-work-2024-04-09_12_38_26.jpg","product_qty":"2","catalog_pcs":"6","catelog_set":"","product_price":"830","product_mrp_price":"830","product_sale_price":"4980","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":"Indian Latest Designer Beautiful Pure Crepe Suit With Heavy Embroidery Work & Zarkan Work ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"TAPI RANI PURE CREPE SUIT WITH HEAVY EMBROIDERY WORK , pink red, yellow, purple, wine, green, blue, indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian,","product_meta_description":"","disable_date":"1970-01-01 05:30:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
TOP: PURE CREPE WITH HEAVY EMBROIDERY WORK & ZARKAN WORK<\/p>\r\n\r\n
BOTTOM : DULL SHANTUNG<\/p>\r\n\r\n
DUPATTA : CHINON HEAVY SEQUENCE WORK WITH LACE<\/p>\r\n\r\n
Please contact us if you have any questions.<\/p>\r\n","single_catalog":"0","product_date":"2024-04-09 12:38:26","push_to_top_date":"2024-04-09 12:38:26","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"4 to 7 Days","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"111681","author_id":"admin","product_sku":"TM-111641","product_hsn":"540710","product_name":"Tapi Suits Present Samira Catalog Pure Viscose Cotton heavy Embroidery Salwar Suit 3 Pic Set Festival Special ","cname":"Tapi Suits Present Samira Catalog Pure Viscose Cotton heavy Embroidery Salwar Suit 3 Pic Set Festival Special ","product_seo_url":"tapi-suits-present-samira-catalog-pure-viscose-cotton-heavy-embroidery-salwar-suit-3-pic-set-festival-special","product_image":"images\/product\/2023\/09\/tapi-suits-present-samira-catalog-pure-viscose-cotton-heavy-embroidery-salwar-suit-3-pic-set-festival-special-2023-09-05_16_24_58.jpeg","product_qty":"2","catalog_pcs":"6","catelog_set":"","product_price":"930","product_mrp_price":"930","product_sale_price":"5580","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":"Tapi Suits Present Samira Catalog Pure Viscose Cotton heavy Embroidery Salwar Suit 3 Pic Set Festival Special ","product_full_description":"","product_status":"Publish","product_meta_title":"Tapi Suits Present Samira Catalog Pure Viscose Cotton heavy Embroidery Salwar Suit 3 Pic Set Festival Special ","product_meta_keyword":"Tapi Suits Present Samira Catalog Pure Viscose Cotton heavy Embroidery Salwar Suit 3 Pic Set Festival Special ","product_meta_description":"Tapi Suits Present Samira Catalog Pure Viscose Cotton heavy Embroidery Salwar Suit 3 Pic Set Festival Special ","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"1EWE8r5WJbBbXdyVlKxwaREsolA9RaEql","other_detail":"
Tapi Suits Present Samira Catalog Pure Viscose Cotton heavy Embroidery Salwar Suit 3 Pic Set Festival Special <\/p>\r\n\r\n
TAPI SUITS PRESENT
\r\n=<>=<>=<>=<>=<>=<\/p>\r\n\r\n
\r\nCatalog :New launched<\/p>\r\n\r\n
Catalog Name:- SAMIRA<\/p>\r\n\r\n
Fabric Details <\/p>\r\n\r\n
\u25aaTop:-pure viscose cotton with heavy embroidery work & ston work <\/p>\r\n\r\n
\u25aaBottom:- pure reyon <\/p>\r\n\r\n
\u25aaDupatta:- pure silk multi colour jacquard <\/p>\r\n\r\n
\u25aaTotal PICS :- 6<\/p>\r\n\r\n
Rate - 930\/-<\/p>\r\n","single_catalog":"0","product_date":"2023-09-05 16:24:58","push_to_top_date":"2023-09-05 16:24:58","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"Tapi Suits Present Samira Catalog Pure Viscose Cotton heavy Embroidery Salwar Suit 3 Pic Set Festival Special ","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"111679","author_id":"admin","product_sku":"TM-111639","product_hsn":"540710","product_name":"Tapi Suits Present Rashi Catalog pure viscose cotton with heavy coding work Festival Special","cname":"Tapi Suits Present Rashi Catalog pure viscose cotton with heavy coding work Festival Special","product_seo_url":"tapi-suits-present-rashi-catalog-pure-viscose-cotton-with-heavy-coding-work-festival-special","product_image":"images\/product\/2023\/09\/tapi-suits-present-rashi-catalog-pure-viscose-cotton-with-heavy-coding-work-festival-special-2023-09-05_16_12_59.jpeg","product_qty":"5","catalog_pcs":"6","catelog_set":"","product_price":"930","product_mrp_price":"930","product_sale_price":"5580","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":"Tapi Suits Present Rashi Catalog pure viscose cotton with heavy coding work Festival Special","product_full_description":"","product_status":"Publish","product_meta_title":"Tapi Suits Present Rashi Catalog pure viscose cotton with heavy coding work Festival Special","product_meta_keyword":"Tapi Suits Present Rashi Catalog pure viscose cotton with heavy coding work Festival Special","product_meta_description":"Tapi Suits Present Rashi Catalog pure viscose cotton with heavy coding work Festival Special","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
Tapi Suits Present Rashi Catalog pure viscose cotton with heavy coding work Festival Special<\/p>\r\n\r\n
TAPI SUITS PRESENT
\r\n=<>=<>=<>=<>=<>=<\/p>\r\n\r\n
\r\nCatalog :New launched<\/p>\r\n\r\n
Catalog Name:- RASHI<\/p>\r\n\r\n
Fabric Details <\/p>\r\n\r\n
\u25aaTop:-pure viscose cotton with heavy coding work <\/p>\r\n\r\n
\u25aaBottom:- pure reyon <\/p>\r\n\r\n
\u25aaDupatta:- pure chinon digital print with heavy coding border cut work & 4 side jhumka <\/p>\r\n\r\n
\u25aaTotal PICS :- 6<\/p>\r\n\r\n
Rate -930\/-<\/p>\r\n","single_catalog":"0","product_date":"2023-09-05 16:12:59","push_to_top_date":"2023-09-05 16:12:59","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 8 ","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"111677","author_id":"admin","product_sku":"TM-111637","product_hsn":"540710","product_name":"Tapi Suits Present Ladli Catalog pure zomato silk with inner & heavy embroidery work with heavy jarkan work ","cname":"Tapi Suits Present Ladli Catalog pure zomato silk with inner & heavy embroidery work with heavy jarkan work ","product_seo_url":"tapi-suits-present-ladli-catalog-pure-zomato-silk-with-inner-heavy-embroidery-work-with-heavy-jarkan-work","product_image":"images\/product\/2023\/09\/tapi-suits-present-ladli-catalog-pure-zomato-silk-with-inner-heavy-embroidery-work-with-heavy-jarkan-work-2023-09-05_15_53_28.jpeg","product_qty":"2","catalog_pcs":"6","catelog_set":"","product_price":"820","product_mrp_price":"820","product_sale_price":"4920","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":"Tapi Suits Present Ladli Catalog pure zomato silk with inner & heavy embroidery work with heavy jarkan work ","product_full_description":"","product_status":"Publish","product_meta_title":"Tapi Suits Present Ladli Catalog pure zomato silk with inner & heavy embroidery work with heavy jarkan work ","product_meta_keyword":"Tapi Suits Present Ladli Catalog pure zomato silk with inner & heavy embroidery work with heavy jarkan work ","product_meta_description":"Tapi Suits Present Ladli Catalog pure zomato silk with inner & heavy embroidery work with heavy jarkan work ","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"1Wpu8t9mmMtCsw45uSkNshkWAQVXUtfQ7","other_detail":"
Tapi Suits Present Ladli Catalog pure zomato silk with inner & heavy embroidery work with heavy jarkan work <\/p>\r\n\r\n
New Catalog :launched<\/p>\r\n\r\n
Catalog Name:-LADLI <\/p>\r\n\r\n
Fabric Details <\/p>\r\n\r\n
\u25aaTop:- pure zomato silk with inner & heavy embroidery work with heavy jarkan work <\/p>\r\n\r\n
\u25aaBottom:- heavy crepe <\/p>\r\n\r\n
\u25aaDupatta:-pure zomato silk with heavy embroidery & border cut work <\/p>\r\n\r\n
\u25aaTotal PICS :- 6<\/p>\r\n\r\n
Rate - 820\/-<\/p>\r\n","single_catalog":"0","product_date":"2023-09-05 15:53:28","push_to_top_date":"2023-09-05 15:53:28","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 8 ","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='499' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}