TODAY'S MOST POPULAR ITEMS

Waterford Tracy 6 1/2" Footed Bowl $39.00 Waterford Huntley Footed Vase $39.00 Waterford Heritage Seahorse Paperweight $39.00 Waterford Huntley 6" Footed Bowl $39.00 Swarovski 2016 Annual Edition Ornament, Snowflake, 25th Anniversary Celebration $79.00 Waterford Loralee Tealight Votives, Pair $39.00 Cashs Crystal Sterling Silver Teardrop Pave Solitaire Pendant Necklace $37.00 Cashs Crystal Cooper Lager Beer Glasses, Buy One Get One Free $75.00 Nambe Metal Tri-Corner Small Bowl $19.00 Waterford Huntley Toasting Flutes, Pair $79.00 Cashs Annestown White Wine Glass, Pair $39.00 Cashs Crystal Holy Cross $59.00 Cashs Crystal Hawthorne Fairy Ring Holder $19.00 Waterford Irish Shamrock Paperweight $39.00 Nambe Metal Amore Heart Bowl $19.00 Cashs Crystal Cooper 6" Bowl $19.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