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 'Chantilly Lace' and p.ss_productfield13 like 'Wedgwood' group by p.ss_sku order by c desc
Share with us your comments about Wedgwood:
Vera Wang has created a unique aspirational world filled with sensuality and youthful sophistication. Exquisite details, intricate draping and a nonchalant sense of style characterize the Vera Wang aesthetic.
Vera Wang, a native New Yorker, understands women who embrace fashion. As a child, she accompanied her mother as she shopped Parisian and American couture. Her collections include ready-to-wear, eveningwear, intimate apparel, fur, footwear, eyewear, fragrance, china and crystal, silver and gifts, fine papers, fine jewelry and her first book, Vera Wang On Weddings.
The red carpet is unquestionably one of Vera Wang's most important runways. She has become the authority on bridal and ready-to-wear elegance, her name synonymous with a modern sophisticated approach to classic style.
Crystal Classics is a Vera Wang by Wedgwood Platinum Retailer, the highest level bestowed by the company.