TODAY'S MOST POPULAR ITEMS

Swarovski Annual Edition 2017 Crystal Ornament $79.00 Waterford Normandy 10" Bowl $90.00 Waterford Huntley Stemless White Wine Glasses, Pair $59.00 Waterford 2017 Annual Snow Crystal Pierced Ornament $65.00 Waterford Heritage Seahorse Sculpture $39.00 Cashs Crystal Annestown Lager Beer Glasses, 1+1 Free $75.00 Waterford Huntley Stemless Red Wine Glasses, Pair $69.00 Waterford Huntley Vodka Shooters, Shot Glasses, Set of Four $79.00 Waterford 2017 Annual Snowstar Ornament $65.00 Swarovski 2017 Little Star Ornament $49.00 Waterford 2018 Times Square Ball Ornament $100.00 Waterford Tracy 6 1/2" Footed Bowl $39.00 Orrefors Annual 2017 Ornament, Snowman $50.00 Waterford 2017 Twas the Night Before Christmas Ornament $55.00 Waterford Huntley Footed Whiskey Tasting Glasses, Pair $64.50 Cashs Crystal Celtic Ring DOF Single Malt Whiskey Glass, Pair $39.00

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,ss_productdescription,count(*) as c from ss_products p LEFT JOIN ss_orders o ON o.sku = p.ss_sku where p.ss_productfield4 not like '' and p.ss_productfield6 not like '' and p.ss_productfield12 not like 'PGC' and p.ss_productfield12 not like 'STA' and p.ss_productfield12 not like 'DSC' and p.ss_productfield12 not like 'INFO' and p.ss_name not like '%Wooden Base%' and DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= o.date AND p.ss_productfield3!='Y' && p.ss_price > 0 group by p.ss_name order by c desc limit 16