AUTHENTIC
DESIGNER PRODUCTS
₹ 3,597
₹ 4,469
(20% off)
Select Size
S
M
L
Please select size.
SPECIFICATIONS
- Pattern Printed
- Wash Care Handwash In Cold Water With A Mild Detergent
- Fit Relaxed Fit
- Fabric Double Gauze
- Number Of Piece(s) 2 (Co-ord Set)
- Country Of Origin India
Product SKU: IV-NTN-00021
Estimated Delivery In: 2 Weeks
Description
This cream and light orange co-ord set features an elastic band on the upper waist of the top, allowing you to adjust it according to your comfort. The relaxed fit pants enhance the ease and style. Pair this outfit with sneakers and a sling bag for a comfortable day with friends.
Disclaimer
- For return, refund and exchange refer to our policies.
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 !='3018' 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 ='3018') 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 !='3018' 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 ='3018') 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)
