1 2 3 4 5 6 7 8
TODAY'S MOST POPULAR ITEMS
See More
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
FREE SHIPPINGNO SALES TAXWORLDWIDE DELIVERYPAYPAL
Contiguous U.S. Orders Over $39. Sales Tax on Ohio orders.

Baccarat Belleek Cashs Crystal Kosta Boda Lalique Lenox Marquis by Waterford Nambe Orrefors Riedel Rogaska Royal Albert Royal Dulton Schott Zwiesel Swarovski Waterford Wedgwood

^ Back to Top