count(o.ss_sku) as c
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 'christmas|holiday|ornament'
and p.ss_productfield13 like 'Steuben'
group by p.ss_sku order by c desc
Recommended for you:
At Steuben, luxury is in the details. Flawless by design, Steuben is the epitome of the expression "crystal clear". Exquisitely sculpted, delicately balanced; even the ping of Steuben stemware meeting for a toast is like no other. Refinements such as these, both great and small, bring a level of personal pleasure to life that can only be met when you are surrounded by the best.