AUTHENTIC
DESIGNER PRODUCTS
₹ 3,471
₹ 4,312
(20% off)
SPECIFICATIONS
- Pattern Printed
- Wash Care Handwash In Cold Water With A Mild Detergent
- Fit Relaxed Fit
- Fabric Viscose Blend
- Number Of Piece(s) 2 (Co-ord Set)
- Country Of Origin India
Product SKU: IV-NTN-00013
Estimated Delivery In: 2 Weeks
Description
Crafted in a viscose blend, this set features a geometric print shirt and wide-leg pants, both in tones of grey. The shirt is designed with cuff sleeves, and the bottoms have an elasticated waist, making this set comfortable and stylish. Pair this set with white sneakers and a sling bag for a casual 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 !='3010' 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 ='3010') 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 !='3010' 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 ='3010') GROUP BY P.productID HAVING stockCount>0 ORDER BY RAND() LIMIT 4
Error writing file '/tmp/#sql-temptable-b46bb-32c709a-2aa951.MAD' (Errcode: 28 "No space left on device")
.jpg)
