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 'Emotion' and p.ss_productfield13 like 'Rogaska%' group by p.ss_sku order by c desc
Share with us your comments about Rogaska Crystal:
Steklarna Rogaska d.d. is one of the leading producers of crystal ware in the world and the Rogaska trademark is at the highest level in terms of price, quality and design innovation in its branch of industry.
We at Steklarna Rogaska are aware that we do not design everyday objects. We design balance between functionality and aesthetics. We dare influence and to a certain extent shape the feelings of the user with each item we make. We are aware of the power of beauty that crystal possesses and therefore we give it to people who can appreciate the nobility of the spirit, knowledge, culture and art.
Rogaska fosters and continues the tradition of old manual glassmaking skills as we do not want to see the extinction of this profession and activity. Thus we preserve the art of almost 350 years of making crystal ware in Slovenia. We preserve items that are often viewed as the showpieces of Slovene culture, knowledge and original ideas.
Steklarna Rogaska draws its rich knowledge of designing and making crystal ware from almost 350 years of tradition in the area of Trebusa, Pohorje and Kozjansko where the so-called forest glass huts could be found.
In the 18th and the 19th centuries, there were 14 to 17 glass foundries in the Stajerska region and the glassmaking industry was blooming in this area. Unfortunately, the use of coal as fuel for melting glass in the 19th century resulted in gradual extinction of foundries in the traditional glass huts.
In the beginning of the 20th century, the remains of the then glassmaking industry were merged and Viljem Abel, the owner of “Merges Glassmakers” built the glass factory at Sveti Kriz, the today’s Steklarna Rogaska, in 1926. It started operating in 1927 and was extremely successful. In the last three decades of the previous century, it achieved great progress and expansion.
With more than 350 years of tradition in superior crystal ware, Steklarna Rogaska creates and improves the ambient.