PHP/MYSQL Join auf 3 Tabellen

[Ralf]

Nur der Vollständigkeit halber:

$sql = "SELECT phpbb3_users.username AS username, maptool_image.name AS mi_name, maptool_image.url AS mi_url, maptool_image.creator AS mi_creator, maptool_image.created AS mi_created, maptool_image.deleted AS mi_deleted, maptool_games.game_id AS mg_game, maptool_games.game_name AS mg_name ".
"FROM maptool_image LEFT JOIN maptool_games ".
"ON maptool_image.game = maptool_games.game_id ".
"LEFT JOIN phpbb3_users ".
"ON phpbb3_users.user_id = maptool_image.creator ".
"WHERE maptool_image.deleted=1 ".
"ORDER BY maptool_games.game_name,maptool_image.name ASC";