Sort by:  Popular    Newest    Name    Price     Price     Filter by:  All    On Sale

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 'Crossroads' and p.ss_productfield13 like 'Waterford' group by p.ss_sku order by c desc
Waterford Crystal introduces Crossroads, a new range of casual/transitional tabletop that truly bridges the gap between everyday casual and formal place settings. There are four crystal stemware patterns, Flight, Impression, Onward and Pathway, featuring updated shapes and modern cutting. The transitional and neutral pallets of Stone and Steel invite personal and creative interpretation to make the table truly unique. They are dishwasher safe and break-resistant to meet the needs of modern life.
^ Back to Top