count(o.ss_sku) as c
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 'Picture Frame|Frame'
group by p.ss_sku order by c desc
Share with us your comments about Shannon and our service:
Shannon 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. Shannon also specializes in crystal lamps, and crystal chandeliers, featuring Baccarat, Lalique and Waterford chandeliers. Shannon 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.
Shannon is proud to carry Cashs Crystal and Cashs Jewelry. Shannon is a top retailer of Orrefors and Kosta Boda as well as Lenox, kate spade, Iittala, Ralph Lauren and Moser Crystal. Shannon 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.
Shannon 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. Shannon 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.