AUTHENTIC
DESIGNER PRODUCTS
₹ 6,120
₹ 6,800
(10% off)
SPECIFICATIONS
- Pattern Solid
- Wash Care Dry Clean Only
- Fit Relaxed Fit
- Fabric Cotton
- Number Of Piece(s) 1 (Romper)
- Country Of Origin India
Product SKU: IV-DTL-00048
Estimated Delivery In: 3 Weeks
Description
This chic romper with 3/4 sleeves and utility pockets is crafted from lightweight linen crepe fabric in spotless white colour. With its elasticated waistband, this romper blends comfort and convenience. Style this romper with statement earrings and heels for a dressy event.
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 custom made products are not returnable. Note: No return is available on this product.
- Made-To-Measure 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 !='2766' 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 ='2766') 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 !='2766' 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 ='2766') GROUP BY P.productID HAVING stockCount>0 ORDER BY RAND() LIMIT 4
Error writing file '/tmp/#sql-temptable-b46bb-32c2fed-293a02.MAD' (Errcode: 28 "No space left on device")
.jpg)
