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 'Votive|Candle|Hurricane'
and p.ss_name not like '%Orrefors%'
and p.ss_productfield13 like 'RSI'
group by p.ss_sku order by c desc
Recommended for you:
With characteristic craftsmanship and good design, and an ongoing commitment to avant-garde expression, Kosta Boda has become one of the leading glasshouses in the world. The company's three glassworks in the villages of Kosta, Boda and Åfors each have exciting individual stories of their own, yet stand together under the common brand name Kosta Boda.
Eight designers are currently on retainer at Kosta Boda. They work with both utilitarian and art glass. The designers are Olle Brozén, Anna Ehrner, Kjell Engman, Ulrica Hydman-Vallien, Bertil Vallien, Ludvig Lofgren, Asa Jungnelius and Göran Wärff. Glass results from a great many meetings between people, artists, crafts people and lovers of glass.
The artists of Kosta Boda have a decisive role to play in all the creative stages of the process. The cooperation between the designers and the skilled craftspeople is very close; indeed, it is essential if the designers are to transfer their intentions to the glass.
Shannon is the largest independent retailer of Kosta Boda in the U.S.