Waterford Crystal Desk Items - Crystal Classics
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 like '%Waterford%' and p.ss_name like '%Pen%' and p.ss_productfield13 like 'HH' group by p.ss_sku order by c desc
Related Collections:

Marquis Writing Instruments Collection
Listing of elegant Marquis Pens by Waterford...
Wooden Base Collection
Listing of wooden bases made of fine Mahogany wood, ideal for many desk items...
Waterford Crystal Sports Collectible Collection
Listing of national champions... numbered, limited edition pieces...
Engrave and Personalize Your Crystal Gift
High quality engraving service is available on all crystal pieces we offer...
^ Back to Top