Swarovski
Sort by:  Popular    Newest    Name    Price     Price

The items in this collection are no longer available, try searching for something similar...

select o.date, p.ss_created, p.ss_name, sku, ss_sku, p.ss_price, p.ss_searchkeywords, p.ss_productfield1, p.ss_productfield2, p.ss_productfield3, p.ss_productfield4, p.ss_productfield5, p.ss_productfield6, p.ss_productfield7, p.ss_productfield8, p.ss_productfield10, p.ss_productfield11, p.ss_productfield12, p.ss_productfield13, p.ss_productfield14, p.ss_productfield15, p.ss_productfield16, p.ss_productfield17, p.ss_productfield18, p.ss_productfield19, ss_productdescription, ss_moreinfotext, ss_QuantityOnHand, count(o.sku) as c from ss_products p LEFT JOIN ss_orders o ON o.sku = p.ss_sku where p.ss_productfield4 != '' and p.ss_productfield6 != '' and p.ss_productfield12 not REGEXP '(DSC|Web|INFO|AMZ)' and p.ss_productfield3 = 'unchecked' and p.ss_name REGEXP 'Pendant|earrings|necklace|bracelet|watch' and p.ss_productfield13 like 'Swarovski' && DATE_SUB(CURDATE(),interval 565 day) <= ss_created group by p.ss_sku order by ss_created desc
From timeless and classic designs to current trends, Swarovski jewelry has your style.Swarovski jewelry is available in two different finishes; Rhodium plated, which is a metal derivative of platinum, and as Gold plated. All electroplated pieces are backed by Swarovski's two year warranty, and the stones are the finest full lead crystal diamonds set in high quality jewelry settings.
Swarovski produces a new set of fashion jewelry every three months and at any time the current pieces could retire and be replaced with new designs.
^ Back to Top