Hunting z

MySQL Error: 1064
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 '' at line 7
SQL-Query: SELECT count(me.user) anz FROM hz_games hzg JOIN hz_players me ON = WHERE hzg.state!="finished" AND me.type="z" AND me.user=
FILE: /var/www/scripts/hz_overview.php
Line: 49
Function: new_game_possible