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.
Cashs of Ireland is an authorized Baccarat retailer.