SELECT tables.team_id,tables.group_id,tables.position,tables.Points,tables.matchesPlayed,tables.win,tables.draw,tables.lose, tables.goalsFor,tables.goalsAgainst,tables.goalDifference,teams.name,tables.location, league_groups.name as group_name FROM tables LEFT JOIN teams ON teams.id=tables.team_id LEFT JOIN league_groups ON league_groups.id=tables.group_id WHERE tables.league='835' AND tables.season='485' AND tables.updated='1789129802' ORDER BY FIELD(league_groups.name,'Group A','Group B','Group C','Group D','Group E','Group F','Group G','Group H','Group I','Group J','Group K','Group L','Ranking of third-placed teams','Group Stage'),tables.Position ASC,tables.position ASC
Pos
Team
Pld
W
D
L
+
-
+/-
Points
table_update_data