AUTHENTIC
DESIGNER PRODUCTS
₹ 6,120
₹ 6,800
(10% off)
SPECIFICATIONS
- Pattern Solid
- Wash Care First Wash - Dry Clean & Then Handwash
- Fit Comfort Fit
- Fabric Mulmul
- Number Of Piece(s) 1 (Dress)
- Country Of Origin India
Product SKU: IV-OMN-00004
Estimated Delivery In: 2 Weeks
Description
This impeccably designed dress in luscious mulmul fabric is a lavish indulgence for the fashion-savvy woman. This dress boasts a distinct dark teal hue and flirty frills at the hemline, blending joyful effervescence and impeccable design with ease. Experience pure sophistication every time you slip into OMAANA.
Disclaimer
- This is a bespoke wear, exclusively customized for our customers. You can connect to our customer care team in case you want to order more than one quantity.
- For return, refund and exchange refer to our policies. All Made-For-You custom-made products are not returnable.
- Made-For-You hyper-personalized styling services are currently available at Delhi NCR & Mumbai pin codes only. However, you can provide your measurement by clicking on the Custom-Size button on the website to get Customized Products.
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 !='921' 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 ='921') 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 !='921' 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 ='921') GROUP BY P.productID HAVING stockCount>0 ORDER BY RAND() LIMIT 4
Error writing file '/tmp/#sql-temptable-b46bb-32d122b-27d5a5.MAD' (Errcode: 28 "No space left on device")
.jpg)
