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(*) 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 MATCH(p.ss_sku) AGAINST ('M1182E,M1181E,M1180E,M1168E,M1167E,M1166E,M1165E,M1162E,M1161E,M1155E,M1140E,M1125E,M1122E,M1121E,M1120E,M1115E,M1111E,M1009E,25687E,0' IN BOOLEAN MODE) group by p.ss_sku order by c desc
Share with us your comments about Galway:
Galway Irish Crystal has long been one of the world's best known and loved brands of traditionally crafted Irish lead crystal.
Nestled in the heart of the West of Ireland, on the shores of Galway Bay, Galway Irish Crystal is steeped in the rich and diverse heritage of this unique hinterland.
Galway's Master Craftsmen are continuously inspired by the sheer beauty of the surrounding countryside - Connemara, Galway Bay and Lough Corrib - and influenced by the wealth of history and folklore which is synonymous with Galway, the famous City of the Tribes..
© Crystal Classics. All Rights Reserved Worldwide