AUTHENTIC
DESIGNER PRODUCTS
₹ 28,050
₹ 33,000
(15% off)
SPECIFICATIONS
- Pattern Printed
- Wash Care Dry Clean
- Fit Fitted At Bust & Waist
- Fabric Organza
- Number Of Piece(s) 3 (Lehenga, Blouse & Dupatta)
- Country Of Origin India
Product SKU: IV-ESS-00019
Estimated Delivery In: 4 Weeks
Description
This beautiful set includes a blouse and a skirt, both designed with the elegant ivory and orange floral print. The blouse features a boat neck, hand-embroidered with pearls and white glass beads, and it's finished with pearls on the hem, adding intricate detail to the design. The lehenga is designed with an attached cancan and double lining, providing a voluminous and graceful look. The set is elegantly completed with a hand-embroidered ivory organza dupatta.
Disclaimer
- For return, refund and exchange refer to our policies. All custom made products are not returnable.
AUTHENTIC
DESIGNER PRODUCTS
SELECT P.productID,P.productName,P.seoUri,P.productSKU,P.brandName,P.USDproductPrice,P.USDspecialPrice,DD.brandName AS designerBrandName,P.isDTR,P.visibilityID,P.featuredID,P.productImg,P.instagramImg,P.productPrice,P.specialPrice,P.customField,GROUP_CONCAT(DISTINCT(PI.imageName) ORDER BY PI.imageName ASC) AS multiImg,SUM(PS.productQuantity) AS stockCount
FROM fx_product AS P LEFT JOIN fx_product_category AS PC ON P.productID=PC.productID
LEFT JOIN fx_productimages AS PI ON P.productID=PI.productID
INNER JOIN fx_product_specification AS PS ON P.productID=PS.productID
INNER JOIN fx_designer_details AS DD ON P.designerID=DD.designerID AND DD.status='1'
WHERE P.status='1' AND P.productStatus='0' AND P.productID !='5401' AND PC.categoryID IN (SELECT PC.categoryID FROM fx_product_category AS PC LEFT JOIN fx_category AS C ON PC.categoryID=C.categoryID WHERE productID ='5401') GROUP BY P.productID HAVING stockCount>0 ORDER BY RAND() LIMIT 4
SELECT P.productID,P.productName,P.seoUri,P.productSKU,P.brandName,P.USDproductPrice,P.USDspecialPrice,DD.brandName AS designerBrandName,P.isDTR,P.visibilityID,P.featuredID,P.productImg,P.instagramImg,P.productPrice,P.specialPrice,P.customField,GROUP_CONCAT(DISTINCT(PI.imageName) ORDER BY PI.imageName ASC) AS multiImg,SUM(PS.productQuantity) AS stockCount
FROM fx_product AS P LEFT JOIN fx_product_category AS PC ON P.productID=PC.productID
LEFT JOIN fx_productimages AS PI ON P.productID=PI.productID
INNER JOIN fx_product_specification AS PS ON P.productID=PS.productID
INNER JOIN fx_designer_details AS DD ON P.designerID=DD.designerID AND DD.status='1'
WHERE P.status='1' AND P.productStatus='0' AND P.productID !='5401' AND PC.categoryID IN (SELECT PC.categoryID FROM fx_product_category AS PC LEFT JOIN fx_category AS C ON PC.categoryID=C.categoryID WHERE productID ='5401') GROUP BY P.productID HAVING stockCount>0 ORDER BY RAND() LIMIT 4
Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")
.jpg)
