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 MATCH(p.ss_sku) AGAINST ('6533643,6533622,6533621,6533612,6533613,6533662' IN BOOLEAN MODE) group by p.ss_sku order by c desc
Share with us your comments about Orrefors
As early as 1726, Lars Johan Silversparre received permission to build a furnace and a smithy at "the beautiful river that flows into Lake Orrenas". The iron works was given the name Orrefors, which means "the Orre waterfall".
Orrefors' international breakthrough came at the Paris Exhibition of 1925. From the Hotel de Ville, the Town Hall of Paris, the Swedish pavilion borrowed a magnificent glass goblet designed by Simon Gate that had been presented as a gift to the City of Paris from the City of Stockholm in 1922. The goblet became a sensation, and the prestigious Grand Prix award was given to Orrefors and its designers. The glassblowers and engravers received gold medals. Many of the imposing glas objects from Orrefors were created for special occasions, or to special order. The motifs in the engraved glass of that period may seem somewhat grandiloquent today, but the technique was consummately realized through skilled craftsmanship and the light, clear quality of the glass.
The ambition for all glass from Orrefors is the highest possible quality and exquisite design. This is the same objective that applied more than eighty years ago, when Johan Ekman traveled the long road through the forest, past the quiet farms behind their stonewalls...
Crystal Classics is the largest independent retailer of Orrefors Crystal in the U.S.