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, p.ss_productfield10, p.ss_productfield11, p.ss_productfield12, p.ss_productfield13, p.ss_productfield14, p.ss_productfield15, p.ss_productfield16, p.ss_productfield17, p.ss_productfield18, p.ss_productfield19, ss_productdescription, ss_moreinfotext, ss_QuantityOnHand, count(o.sku) as c from ss_products p LEFT JOIN ss_orders o ON o.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 'sunflower' and p.ss_productfield13 like 'Belleek' group by p.ss_sku order by c desc
Share with us your comments about Belleek:
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.