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 'and games.gid = assigned_games.gid' at line 1select distinct season from games,assigned_games where assigned_games.main_ref_id= and games.gid = assigned_games.gid