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 'Sculpture'
and p.ss_productfield13 like 'AE'
group by p.ss_sku order by c desc limit 126
Recommended for you:
AERIN is a global luxury lifestyle brand inspired by the signature style of its founder, Aerin Lauder. Based on the premise that living beautifully should be effortless, the brand develops curated collections in the worlds of beauty, fashion accessories, and home decor. With a passion for art, travel, fashion, and design, Aerin's own lifestyle serves as a focal point of inspirations for the brand. Classic, but always with a modern point of view, every piece is created to make life more beautiful, with a sense of ease and refinement.