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_productfield12 REGEXP 'ZOM' and p.ss_productfield13 like 'RB' and ss_QuantityOnHand>='1' group by p.ss_sku order by c desc
Share with us your comments about Reed & Barton:
Family owned, Reed & Barton Corporation is one of the oldest silversmiths in the United States, its roots dating back to 1824. Over the years, Reed & Barton has evolved into a diversified tabletop company composed of several divisions. The Reed & Barton Silversmiths division continues to produce a wide range of fine sterling silver, silverplated, and stainless steel tableware and gifts, including flatware, serveware, and holloware, as well as picture frames, Christmas ornaments, baby gifts, and musicals. The Reed & Barton Handcrafted Chests division is the world's largest maker of wooden jewelry boxes and flatware chests.
Reed & Barton also acts as the exclusive U.S. distributor for Belleek Fine Parian China, Ireland's oldest pottery, and Aynsley Fine English Bone China, a renowned, 200-year-old company that has supplied tableware to England's royalty. Also,with the founding of Miller Rogaska Crystal, the company's mission was to offer excellent quality and design at an exceptional value.
After decades of strong marketing efforts, Reed & Barton had developed a reputation for quality craftsmanship and fine design work, especially in sterling, wood and crystal.
© Cashs of Ireland. All Rights Reserved Worldwide