SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_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 (455) ) 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_posts.post_date DESC, wp_posts.ID DESC LIMIT 0, 11200
nerikomi
Select Maker
Barbara Gittings
Judy McKenzie
Select Category
Bottles
Bowls
Lidded Pots & Boxes
Select Material
Porcelain
Sorry, No Products Found
-
Barbara GittingsSmall Head Bowl #98 BG550Y24£325.00 £293.06 outside the UK
PRODUCT CODE:BG550Y24
Add to basketBarbara GittingsLarge Coracle #1 BG550Y22£550.00 £495.94 outside the UKPRODUCT CODE:BG550Y22
Add to basketBarbara GittingsBig Bowl #19 BG550Y25£550.00 £495.94 outside the UKPRODUCT CODE:BG550Y25
Add to basketJudy McKenziePink Floral Bottle JM570Y1£793.00 £715.06 outside the UKPRODUCT CODE:JM570Y1
Add to basketJudy McKenzieLidded Jar JM570Y2£854.00 £770.06 outside the UKPRODUCT CODE:JM570Y2
Add to basketJOIN OUR MAILING LIST