![]() |
||
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(IF(date >= DATE_SUB(NOW(), INTERVAL 90 DAY), 1, null)) 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_sku NOT like '19108C'
and p.ss_productfield13 like 'MAC'
group by p.ss_sku order by c desc |
Share with us your comments about Cashs of Ireland and our service: About Cashs of Ireland Cashs of Ireland 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. Cashs of Ireland also specializes in crystal lamps, and crystal chandeliers, featuring Baccarat, Lalique and Waterford chandeliers. Cashs of Ireland 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. Cashs of Ireland is proud to carry Cashs Crystal and Cashs Jewelry. Cashs of Ireland is a top retailer of Orrefors and Kosta Boda as well as Lenox, kate spade, Iittala, Ralph Lauren and Moser Crystal. Cashs of Ireland 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. Cashs of Ireland 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. Cashs of Ireland 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. Cashs of Ireland Print Catalog
Shop our eCatalog or sign up for our Free Catalog! |