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

select, 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 ('5300256034,5300256036,5300256037,5300256038,5300256039,5300256047,5300256046,5300256048,5300256033,5300256041,5300256032,5300256043' IN BOOLEAN MODE) group by p.ss_sku order by FIELD(ss_sku, '5300256034','5300256036','5300256037','5300256038','5300256039','5300256047','5300256046','5300256048','5300256033','5300256041','5300256032','5300256043')
Related Collections:

Wedgwood Vera Wang Vera Simplicity Gray Collection
Listing of the Simplicity Gray Collection, with cream detailing over a neutral gray background... $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