SELECT foto.players as keyword FROM foto WHERE foto.eventID= GROUP BY foto.players ORDER BY count(foto.fotoID) desc LIMIT 10 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY foto.players ORDER BY count(foto.fotoID) desc LIMIT 10' at line 1