AUTHENTIC
DESIGNER PRODUCTS
₹ 2,250
₹ 2,500
(10% off)
SPECIFICATIONS
- Fit As Per Size
- Number Of Piece(s) 2 (Earrings)
- Material Brass
- Country Of Origin India
Product SKU: IV-NNM-00009
Estimated Delivery In: 2 Weeks
Description
Crafted from high-quality brass with gold plating and a protective top coating, these earrings gleam with a lustrous gold color. The large pea design adds elegance to any outfit, making them a versatile accessory for casual and formal occasions. Style them with a crisp white blouse and jeans for a polished look.
Diameter- 16 mm
Disclaimer
- Fit: Free Size
- Brass items feature 24K gold flash plating with tarnish protection. However, they're moisture-sensitive; avoid liquids and store in airtight packaging for optimal care.
- 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 !='3532' 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 ='3532') 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 !='3532' 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 ='3532') 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)
