Rogaska By Category:


Rogaska Crystal, Gem 12" Crystal Vase
select o.ss_date, p.ss_created, p.ss_name, o.ss_sku, p.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.ss_sku) as c from ss_Products p LEFT JOIN 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_productfield12 REGEXP 'ZOM' and p.ss_productfield13 like 'Rogaska' and ss_QuantityOnHand<='10' and ss_QuantityOnHand>='1' group by p.ss_sku order by c desc limit 1

select o.ss_date, p.ss_created, p.ss_name, o.ss_sku, p.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.ss_sku) as c from ss_Products p LEFT JOIN 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_productfield12 REGEXP 'ZOM' and p.ss_productfield13 like 'Rogaska' and ss_QuantityOnHand<='10' and ss_QuantityOnHand>='1' group by p.ss_sku order by c desc limit 1


Last Chance to Buy

Rogaska 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