AUTHENTIC
DESIGNER PRODUCTS
SPECIFICATIONS
- Fit Free Size
- Number Of Piece(s) 1 (Charms)
- Material 14K Gold
- Country Of Origin India
Product SKU: IV-FRK-00020
Estimated Delivery In: 5 Weeks
Description
The revered emblem 'Om' holds deep significance in Hinduism, representing the sacred sound. Created with a unique font derived from our Aayat motif, it's made of 14kt yellow gold and adorned with white diamonds. This two-sided charm, painted in vibrant orange, embodies strength and positive energy. ( FKCH616AEN )
Disclaimer
- BIS 100% Hallmarked Jewellery
- All Farah Khan Jewellery pieces are unique and made to order. The weight, size and carat weight of each piece can vary slightly from one creation to another.
- Always store jewellery in separate pouches so they don't rub against each other. Exposure to chemicals can damage or discolor precious metals. Even everyday substances like hairspray, lotion, perfume, or other cosmetics can contain chemicals that will permanently damage the surface of your pearls and other gems. Precious gemstones are delicate and should be protected against the impact on hard or abrasive surfaces.
- For return, refund and exchange please 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 !='1244' 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 ='1244') 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 !='1244' 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 ='1244') GROUP BY P.productID HAVING stockCount>0 ORDER BY RAND() LIMIT 4
Error writing file '/tmp/#sql-temptable-b46bb-32c7fe1-2c757c.MAD' (Errcode: 28 "No space left on device")
.jpg)
