Table 'ArtOnLine.stock_xref_john' doesn't exist
SELECT * FROM `artist`, `stock_xref_john`, `stock_xref_category`, `stock` WHERE stock.john_id=stock_xref_john.id AND stock_xref_john.john = '' AND stock.category_id = stock_xref_category.id AND stock_xref_category.type = 'P' AND ( stock.status_id = '4' OR stock.status_id = '5' OR stock.status_id = '11' ) AND stock.artist_id = artist.id AND artist.surname = 'mathison' AND artist.firstname = 'john.php' AND ( stock.status_id = '4' OR stock.status_id = '5' OR stock.status_id = '11' ) AND stock.live = 'Y' AND stock.inc_on_website = 'Y' ORDER BY stock.id ASC