The items in this collection are no longer available, try searching for something similar...

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 MATCH(p.ss_sku) AGAINST ('5300256040,5300256042,5300256044,5300256045,5300256050,5300256047,5300256046,5300256048,5300256033,5300256041,5300256032,5300256043' IN BOOLEAN MODE) group by p.ss_sku order by FIELD(ss_sku, '5300256040','5300256042','5300256044','5300256045','5300256050','5300256047','5300256046','5300256048','5300256033','5300256041','5300256032','5300256043')
Related Collections:

Wedgwood Vera Wang Vera Simplicity Cream Collection
Listing of the Simplicity Cream Collection, Cream presents gray cross-hatching and irregular lines recalling the earthy textures of hand woven textiles against a cream colored landscape... $69.00
Wedgwood Vera Wang Vera Simplicity Ombre Collection
Listing of a china collection featuring a watercolor wash of gradient gray migrating into the warm cream of the Ombre pattern... $69.00
Wedgwood Vera Wang Simplicity Common Accessories Collection
Listing of simple accessories, in solid colors that echo the cream and gray themes of all three dinnerware patterns, can be shared across the line for truly unique mix and match combinations...
   
^ Back to Top