You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '._id=stock_xref_e.g..id AND stock_xref_e.g..e.g. = '' AND stock.category_id = s' at line 1
SELECT * FROM `artist`, `stock_xref_e.g.`, `stock_xref_category`, `stock` WHERE stock.e.g._id=stock_xref_e.g..id AND stock_xref_e.g..e.g. = '' 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 = 'dargouge' AND artist.firstname = 'e.g..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