Sort by:  Popular Newest Name Price Price Filter by:  All On Sale
Kosta Boda Crystal Magic Coupe
Kosta Boda Crystal Magic CoupeNew
Item # 7091751
$65.00

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_name REGEXP 'flute|champagne|coupe|saucer' and p.ss_name like '%Kosta%' group by p.ss_sku order by c desc


Related Collections:

Engrave and Personalize Your Crystal Gift
High quality engraving service is available on all crystal pieces we offer...
Custom Monogramming Service
Monogramming of your fine crystal gift is available in several elegant styles...
^ Back to Top