Rogaska Crystal, Avenue Crystal DOF Tumbler, Pair
Most Popular

The items in this collection are no longer available, try searching for something similar...

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 'Rogaska' && DATE_SUB(CURDATE(),interval 365 day) <= ss_created group by p.ss_sku order by ss_created desc limit 1
New Items
Rogaska Crystal, Superior 5
Last Chance to Buy

By Pattern:

Steklarna Rogaska d.d. is one of the leading producers of crystal ware in the world and the Steklarna 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.

^ Back to Top