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_sku NOT like '5064411' and p.ss_name REGEXP 'Stardust' and p.ss_name not like '%Pen%' and p.ss_name not like '%Necklace%' and p.ss_productfield13 like 'Swarovski' group by p.ss_sku order by c desc
Share with us your comments about Swarovski:
Crystal Classics is an official Swarovski retailer. winner of the Daniel Swarovski Award given to the best Swarovski retailer!
Pioneers were always way ahead of their time. In their minds they conceived the inconceivable. In their fantasies they created the impossible. When he invented an automatic cutting machine at the end of the 19th Century, Daniel Swarovski opened the door to a world of fantasy. The magic word was crystal. A raw material, which even the most ancient cultures ascribed beneficial, valuable, indeed miraculous properties. Born to a glass cutter in North Bohemia, today a part of the Czech Republic, young Daniel Swarovski completed a two-year apprenticeship in his father's small factory. Here, he gained expertise in cutting glass. During this time, in 1892, he invented a machine that revolutionized the process of crystal cutting. He filed for patents soon after.
In 1895, he founded the company Swarovski. He realized that he needed more water, power and a factory building in order for his plans to manifest. In addition, he needed to move away from competitiors to keep his inventions a secret. So, he chose to settle in Wattens, Tyrol, Austria. In 1976, the first Silver Crystal Mouse was the first ever figurine created using chandelier parts. Representative of the Olympic Winter Games taking place in Innsbruck at the time, it also marked a historical step forward in the world of crystal. A Replica Mouse is available today.
Crystal Classics is accepting Swarovski discount vouchers and will match the prices on Swarovski offers from other sites.
For health reasons we can not accept returns or exchanges on earrings.