SQL Error

SQLSTATE[42000]: Syntax error or access violation: 1064 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 'AS nome FROM prodotti p JOIN aa_translation t1 ON p.nome=t1.id WHERE p.id='51...' at line 1 SELECT p.id, t1. AS nome FROM prodotti p JOIN aa_translation t1 ON p.nome=t1.id WHERE p.id='518' ORDER BY p.ordine ASC Execute() called at /var/www/vhosts/efremsrl.com/httpdocs/public/server/addproduct.php at line 9

Fatal error: Call to a member function FetchRow() on boolean in /var/www/vhosts/efremsrl.com/httpdocs/public/server/addproduct.php on line 10