SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN (SELECT * FROM wp_postmeta WHERE meta_key = '_sale_price' AND meta_value > 0) sale ON (wp_posts.ID = sale.post_id) LEFT JOIN (SELECT * FROM wp_postmeta WHERE meta_key = '_stock_status') stock ON (wp_posts.ID = stock.post_id) WHERE 1=1 AND ( wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (7) ) AND wp_term_relationships.term_taxonomy_id IN (594) ) AND ( wp_postmeta.meta_key = 'select_maker' ) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'wc-fraud-screen' OR wp_posts.post_status = 'wc-authorised'))) GROUP BY wp_posts.ID ORDER BY stock.meta_value ASC, sale.meta_value DESC, wp_postmeta.meta_value ASC LIMIT 0, 999
Barry Stedman
Select Maker
Barry Stedman
Select Category
Plates & Servers
Vessels
Select Material
Earthenware
Select Firing
Electric
Sorry, No Products Found
-
Barry Stedmanvessel with blue BS355Y265£244.00 £220.02 outside the UK
PRODUCT CODE:BS355Y265
Add to basketBarry Stedmanvessel with orange BS355Y268£317.00 £285.84 outside the UKPRODUCT CODE:BS355Y268
Add to basketBarry Stedmanvessel with green BS355Y269£293.00 £264.20 outside the UKPRODUCT CODE:BS355Y269
Add to basketBarry StedmanBS355Y273 Vessel£317.00 £285.84 outside the UKPRODUCT CODE:BS355Y273
Add to basketBarry StedmanBS355Y287 Vessel£195.00 £175.83 outside the UKPRODUCT CODE:BS355Y287
Add to basketBarry StedmanBS355Y281 Vessel£159.00 £143.37 outside the UKPRODUCT CODE:BS355Y281
Add to basketBarry StedmanBS355Y280 Vessel£159.00 £143.37 outside the UKPRODUCT CODE:BS355Y280
Add to basketBarry StedmanBS355Y286 Platter£281.00 £253.38 outside the UKPRODUCT CODE:BS355Y286
Add to basketBarry StedmanBS355Y276 Vessel£281.00 £253.38 outside the UKPRODUCT CODE:BS355Y276
Add to basketJOIN OUR MAILING LIST