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

select o.ss_date, p.ss_created, p.ss_name, o.ss_sku, p.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.ss_sku) as c from ss_Products p LEFT JOIN ss_MostPopular o ON o.ss_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 'Limited|House|trilogy|fred' and p.ss_productfield13 like 'Waterford' group by p.ss_sku order by c desc



Largest collection of handmade Limited Edition Masterpieces. Handmade in Waterford City, Ireland. Home to the House of Waterford Crystal, where skilled Waterford Crystal nd artisans carry on centuries-old traditions of mouth blowing, hand cutting, finishing, sculpting, and engraving. The newest works from the Waterford Studio include these inspired and limited edition pieces. These beautifully hand crafted pieces are individual works of art, appreciated by collectors around the world. Shannon is the largest independent retailer of Waterford Crystal.
^ Back to Top