AUTHENTIC
DESIGNER PRODUCTS
Select Size
S
M
L
XL
Please select size.
SPECIFICATIONS
- Pattern Embroidered
- Wash Care Dry Clean Only
- Fit Regular Fit
- Fabric Chanderi
- Number Of Piece(s) 1 (Kaftaan)
- Country Of Origin India
Product SKU: IV-STK-00001
Estimated Delivery In: 3 Weeks
Description
Discover the epitome of style with this exquisite chanderi kaftaan, beautifully adorned with hand block prints and delicate hand embroidery. Crafted from premium chanderi fabric, this kaftaan exudes elegance and style. The svet white color adds a touch of sophistication, making it a perfect choice for any occasion.
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 !='1735' 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 ='1735') 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 !='1735' 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 ='1735') 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)
