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 'DeGeneres Christmas|DeGeneres holiday' group by p.ss_sku order by c desc
Share with us your comments about Crystal Classics and our service:
About Crystal Classics
Crystal Classics is the largest independent retailer of Waterford Crystal and an authorized retailer of all the finest quality brands we sell. We sell only new, first quality merchandise acquired directly from the brand manufacturers. Exceptional customer service is our highest priority and paramount to our mission to help customers find the World's Finest Crystal.
Our Baccarat Crystal and Lalique Crystal collections feature their renowned annual christmas ornaments, sculptures, stemware, as well as vases and bowls. Our collections are one of the most complete anywhere for our world renowned vendors. Crystal Classics also specializes in crystal lamps, and crystal chandeliers, featuring Baccarat, Lalique and Waterford chandeliers. Crystal Classics is the largest independent retailer of Waterford Crystal, Marquis by Waterford, Wedgwood, Royal Doulton, Royal Albert and Rogaska Crystal. We are Daniel Swarovski award winner and a leading retailer of Swarovski crystal collectibles, Swarovski Christmas ornaments and Swarovski jewelry.
Crystal Classics is proud to carry Cashs Crystal and Cashs Jewelry. Crystal Classics is a top retailer of Orrefors and Kosta Boda as well as Lenox, kate spade, Iittala, Ralph Lauren and Moser Crystal. Crystal Classics carries quality metal, leather, wood and crystal items from Nambe, Ralph Lauren and Michael Aram. We are one of the largest retailers of Belleek China, carrying collectibles, tableware, ornaments and lamps from Ireland.
Crystal Classics specializes in wine glasses and barware, tailored by famous makers like Riedel, Schott Zwiesel, Waterford, Baccarat, and Cashs to each of the varietals you enjoy the most. If you search by wine varietal, our search will list wine glass suggestions for most of the wines available.
We offer secure shopping, free ground shipping on orders over $89 and tax free sales outside the State of Ohio. Crystal Classics is an independent small business focused on providing exceptional excellent customer service. We have knowledgeable Customer Service representatives ready to assist you via phone or email. Your shopping experience and satisfaction are very important to us. We welcome and appreciate your questions, comments and suggestions.
Crystal Classics Print Catalog