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 like '%Galway%' group by p.ss_sku order by c desc
Recommended for you:
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..