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-08-14 12:50:58","push_to_top_date":"2023-08-14 12:50: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":"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":"110814","author_id":"admin","product_sku":"TM-110777","product_hsn":"540710","product_name":"SILK SAREES BY REWAA AMRUT PATOLA R-885 TO R-893 SET & LOOSE & SINGLE","cname":"SILK SAREES BY REWAA AMRUT PATOLA R-885 TO R-893 SET & LOOSE & SINGLE","product_seo_url":"silk-sarees-by-rewaa-amrut-patola-r-885-to-r-893-set-loose-single","product_image":"images\/product\/2023\/08\/silk-sarees-by-rewaa-amrut-patola-r-885-to-r-893-set-loose-single-2023-08-05_06_54_07.jpeg","product_qty":"5","catalog_pcs":"1","catelog_set":"","product_price":"1695","product_mrp_price":"9","product_sale_price":"1695","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"12","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":"SILK SAREES BY REWAA AMRUT PATOLA R-885 TO R-893 SET & LOOSE & SINGLE","product_full_description":"","product_status":"Publish","product_meta_title":"SILK SAREES BY REWAA AMRUT PATOLA R-885 TO R-893 SET & LOOSE & SINGLE","product_meta_keyword":"SILK SAREES BY REWAA AMRUT PATOLA R-885 TO R-893 SET & LOOSE & SINGLE","product_meta_description":"SILK SAREES BY REWAA AMRUT PATOLA R-885 TO R-893 SET & LOOSE & SINGLE","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
BRAND NAME – *REWAA*<\/strong><\/p>\r\n\r\nCATALOG NAME – *AMRUT PATOLA*<\/strong><\/p>\r\n\r\nSERIES – R-885 TO R-893<\/strong><\/p>\r\n\r\nCATALOGUE DETAILS :-<\/strong><\/p>\r\n\r\n\ufe0e09 PCS CATALOGUE<\/strong><\/p>\r\n\r\n\ufe0eONE DESIGN NINE MATCHING EACH<\/strong><\/p>\r\n\r\nFABRIC : SUPERIOR P.V.SILK WITH FLOREEM VACUUM FINISH<\/strong><\/p>\r\n\r\nBLOUSE - SMOUTH PATOLA SILK PRINT WITH FOILPRINT<\/strong><\/p>\r\n\r\nPRICE – 1695\/- PER PCS<\/strong><\/p>\r\n\r\nGST 5% EXTRA<\/strong><\/p>\r\n\r\n*Set & Loose & Single*<\/strong><\/p>\r\n\r\nBOOK YOUR ORDER NOW<\/strong><\/p>\r\n","single_catalog":"0","product_date":"2023-08-05 06:54:07","push_to_top_date":"2023-08-05 06:54:07","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"110809","author_id":"admin","product_sku":"TM-110772","product_hsn":"","product_name":"LEHENGA CHOLI REWAA HASTKATHA RL-09 TO RL-17 SET & LOOSE & SINGLE","cname":"LEHENGA CHOLI REWAA HASTKATHA RL-09 TO RL-17 SET & LOOSE & SINGLE","product_seo_url":"lehenga-choli-rewaa-hastkatha-rl-09-to-rl-17-set-loose-single","product_image":"images\/product\/2023\/08\/lehenga-choli-rewaa-hastkatha-rl-09-to-rl-17-set-loose-single-2023-08-04_21_38_10.jpeg","product_qty":"20","catalog_pcs":"9","catelog_set":"","product_price":"7895","product_mrp_price":"7895","product_sale_price":"71055","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"40","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":"LEHENGA CHOLI REWAA HASTKATHA RL-09 TO RL-17 SET & LOOSE & SINGLE","product_full_description":"","product_status":"Publish","product_meta_title":"LEHENGA CHOLI REWAA HASTKATHA RL-09 TO RL-17 SET & LOOSE & SINGLE","product_meta_keyword":"LEHENGA CHOLI REWAA HASTKATHA RL-09 TO RL-17 SET & LOOSE & SINGLE","product_meta_description":"LEHENGA CHOLI REWAA HASTKATHA RL-09 TO RL-17 SET & LOOSE & SINGLE","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"BRAND NAME – *REWAA*<\/strong><\/p>\r\n\r\nCATALOG NAME – *HASTKATHA*<\/strong><\/p>\r\n\r\nSERIES – RL-09 TO RL-17<\/strong><\/p>\r\n\r\nLEHENGA FABRIC : SMOOTH RAJWADI SILK WITH SPARKLE N MIRROR WORK<\/strong><\/p>\r\n\r\nBLOUSE FABRIC - SMOOTH SILK WITH MIRROR sparkle WORK<\/strong><\/p>\r\n\r\nLEHENGA SIZE : READY 36. MARGIN 4 INCH AND 4:5 METER GHERA<\/strong><\/p>\r\n\r\nBLOUSE : STITCHED<\/strong><\/p>\r\n\r\nBLOUSE SIZE 38, MARGIN UPTO 40<\/strong><\/p>\r\n\r\nSPECIAL EDITION OF BEAUTIFUL MINI PURSE AND BELT<\/strong><\/p>\r\n","single_catalog":"0","product_date":"2023-08-04 21:38:10","push_to_top_date":"2023-08-04 21:38:10","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"5 TO 8","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='464' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}