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 'Belleek'
&& DATE_SUB(CURDATE(),interval 365 day) <= FROM_UNIXTIME(p.ss_created)
group by p.ss_sku order by ss_created desc
Recommended for you:
Belleek Pottery has been hand-crafting fine porcelain in County Fermanagh, Ireland, continuously since 1857.
Known for its beautiful translucence, each piece is light but is also very durable, with fine design detail and hand-painted shamrocks, flowers or gold trim.
16 individuals craft and care for each piece before it receives the famous Belleek trade mark, ensuring it's authenticity, is gift boxed and packed for the journey to America.
Belleek's reputation has been built on product excellence. Company founder, John Caldwell Bloomfield declared that any piece with even the slightest flaw must be destroyed. Over 155 years later, this is still strictly adhered to. The result is perfection.