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 'puffed heart' and p.ss_productfield13 like 'Baccarat' group by p.ss_sku order by c desc
Share with us your comments about Baccarat:
Baccarat Crystal has, from the beginning, affixed its signature on strong works illustrating all the facets of artistic craftsmanship and covering a vast repertoire of inspiration.
In 1764 King Louis XV of France gave Bishop Montmorency-Laval of Metz permission to found a glassworks in the village of Baccarat located in Lorraine in eastern France.
The creations of great artists inspired by the magic of crystal are all magnificent stones brought together into building the Art de Vivre collection.
This is how Baccarat perpetuates the great French tradition of a cosmopolitan art of living. Envisioned by Philippe Starck, the Baccarat House in Paris, home to the brand's headquarters, is a meeting place for its most beautiful creations and one of its most beautiful manifestations.
Crystal Classics is the only Baccarat authorized online-only retailer. Since Crystal Classics opened it's online store in 1996, we have been the only store that Baccarat has authorized as an online-only boutique. Other stores might have online presence, but only Crystal Classics is the online-only specialized boutique authorized to sell and service Baccarat products. We take great pride in that privilege bestowed upon our online boutique by a bespoke crystal brand like Baccarat.