SELECT p.*,
tp.player_jersey_no AS real_player_jersey_no,
tp.season_id AS season_id,
tp.group_id AS group_id,
tp.team_id AS team_id
FROM tbl_team_player AS tp,
tbl_player AS p
WHERE tp.season_id = 18
AND tp.player_id =
AND tp.player_id = p.player_id
GROUP BY p.player_id
ORDER BY p.player_id DESC
LIMIT 1 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 tp.player_id = p.player_id
GROUP BY p.player_id
ORDER ' at line 10
