SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
					 FROM wp_posts  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_postmeta.meta_key = '_price'
) 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+0 DESC
					 LIMIT 0, 1500

Select Maker
Billy Adams
Justine Allison
Jennifer Amon
Tim Andrews
Ben Arnup
Duncan Ayscough
Chris Barnes
Peter Beard
Helen Beard
Jan Beeny
Terry Bell-Hughes
Bev Bell-Hughes
David Binns
Peter Black
Matthew Blakely
Peter Bodenham
Charles Bound
Clive Bowen
Dylan Bowen
Daniel Boyle
Katie Braida
Lise Herud Braten
Ben Brierley
Sandy Brown
Adam Buick
Anne Butler
Ian Byers
Jane Cairns
Kyra Cane
Matthew Chambers
Daniel Chau
Mandy Cheng
Jonathan Chiswell-Jones
Carina Ciscato
Kim Colebrook
Clare Conrad
Sophie Cook
Prue Cooper
Timothy Copsey
Gilles Le Corre
Jane Cox
Lowri Davies
Jo Davies
Patia davis
John Dawson
Anthony Dix
Sara Dodd
Jack Doherty
Chloë Dowds
Karen Downing
Bridget Drakeford
Sarah Dunstan
Ant and Di Edmonds
Annabel Faraday
Sotis Filippides
Penny Fowler
Rachel Foxwell
Adam Frew
David Frith
Carolyn Genders
Barbara Gittings
Tanya Gomez
Moira Goodall
Jemma Gowland
Carl Gray
Diane Griffin
Jennifer Hall
Jane Hamlyn
Lisa Hammond
Björk Haraldsdóttir
Robyn Hardyman
Kerry Hastings
Richard Heeley
John Higgins
Akiko Hirai
Rachel Holian
Matt Horne
Ashley Howard
Simon Hulbert
Claire Ireland
Ikuko Iwamoto
Paul Jackson
Paul James
Jude Jelfs
John Jelfs
Sarah Jenkins
David Jones
Jill Fanshawe Kato
Lisa Katzenstein
Chris Keenan
Dan Kelly
John Kershaw
Hyejeong Kim
Jaeeun Kim
Sun Kim
Ruth King
Julian King-Salter
Katharina Klug
Alastair Knights
Gabriele Koch
Emma Lacey
Anna Lambert
Nigel Lambert
Jaejun Lee
Francis Lloyd-Jones
Anja Lubach
Sophie MacCarthy
Sally MacDonell
John MacKenzie
Juliet Macleod
Rhian Malin
Jim Malone
Agalis Manessi
Marcio Mattos
Hilary Mayo
Hannah McAndrew
Judy McKenzie
Lesley McShea
Martin McWilliam
Angela Mellor
Sean Miller
Sarah Monk
Sara Moorhouse
Ian Morrison
Eric Moss
Sue Mundy
Emily Myers
Sabine Nemet
Jeremy Nichols
Marcus O'Mahony
James Oughtibridge
Jitka Palmer
Sue Paraskeva
Stephen Parry
Martin Pearce
Ania Perkowska
Jane Perryman
Richard Phethean
Lea Phillips
Paul Philp
Mitch Pilkington
Laura Plant
Birgit Pohl
John Pollex
Adela Powell
Ostinelli and Priest
Christine-Ann Richards
Hajeong Lee Rogers
Amanda-Sue Rope
Suleyman Saba
Antonia Salmon
Micki Schloessingk
Tiffany Scull
Jane Seymour
Jill Shaddock
Ken and Valerie Shelton
Jane Sheppard
Patricia Shone
Anna Silverton
Penny Simpson
Carol Sinclair
Peter Smith
Daniel Smith
Jenny Southam
Chris Speyer
Barry Stedman
Jeremy Steward
Petra Steward
Moyra Stewart
Emily Stubbs
Geoffrey Swindell
Taja
Hiro Takahashi
Midori Takaki
Tricia Thom
Yo Thom
Fiona Thompson
Jessica Thorn
Owen Thorpe
Ali Tomlin
Carolyn Tripp
Ruthanne Tudball
Angela Verdon
Tina Vlassopulos
Carol Wainwright
Motoko Wakana
Elly Wall
Rose Wallace
Sarah Walton
Sasha Wardell
James and Tilla Waters
Paul Wearing
Sarah Went
Nicola Werner
Emily-Kriste Wilcox
Jon Williams
Graham Williamson
Peter Wills
Richard Wilson
Kate Windibank
Maria Wojdat
Yusun Won
Rachel Wood
Alistair Young
Select Category
Bottles
Bowls
Dishes
Functional
Jars
Jugs & Pourers
Lidded Pots & Boxes
Mugs & Drinking Vessels
Plates & Servers
Sculptural
Teapots
Tiles & Wall Art
Under £100
Vases
Vessels
Select Material
Bone China
Earthenware
Porcelain
Stoneware
Select Firing
Electric
Gas
Oil
Raku
Salt Glaze
Soda Fired
Wood
Sorry, No Products Found