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='971' AND tables.season='482' AND tables.updated='1781289011' 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

TABLE
OVERALL
HOME
AWAY
GROUP:
Ykkonen
Pos
Team
Pld
W
D
L
+
-
+/-
Points
1
-
11
8
1
2
24
6
18
25
2
-
12
6
3
3
23
13
10
21
3
-
10
5
3
2
20
10
10
18
4
-
11
5
3
3
21
18
3
18
5
-
10
4
3
3
20
17
3
15
6
-
9
4
2
3
16
10
6
14
7
-
9
3
4
2
17
10
7
13
8
-
10
5
1
4
13
17
-4
13
9
-
10
3
2
5
20
24
-4
11
10
-
10
2
1
7
13
21
-8
7
11
-
10
1
3
6
9
19
-10
6
12
-
10
1
2
7
7
38
-31
5
table_update_data
Array ( [stat_view_dp] => 1 [user_league_order] => 69,367,413,741,425,987,839,379,318,35,418,485,442,443,509,432,466,1021,491,434,563,879,920,416,421,288,616,465,895,408,401,490,501,503,721,404,489,14,615,951,952,414,486,424,467,533,560,444,546,547,561,907,1038,975 [user_stats_order] => position,played,ppg,form,win,gf,ga,o15,o25,corns,cards [user_lower_limits] => position|20.00,played|20.00,ppg|1.00,form|20.00,win|20.00,fts|20.00,cs|20.00,gc|0.50,gf|0.30,ga|0.30,1Hgf|0.20,1Hga|0.20,1HScd|20.00,1HCon|20.00,2Hgf|0.20,2Hga|0.20,2HScd|20.00,2HCon|20.00,o15|20.00,o25|20.00,btts|20.00,1Hbtts|20.00,2Hbtts|20.00,w15|20.00,w25|20.00,wBTTS|20.00,corns|8.00,cornf|1.50,corna|1.50,cards|1.50,cardf|0.50,carda|0.50,s2f|20.00,scd1st|20.00,con1st|20.00 [user_upper_limits] => position|85.00,played|85.00,ppg|2.00,form|85.00,win|85.00,fts|85.00,cs|85.00,gc|2.00,gf|2.00,ga|2.00,1Hgf|2.00,1Hga|2.00,1HScd|85.00,1HCon|85.00,2Hgf|2.00,2Hga|2.00,2HScd|85.00,2HCon|85.00,o15|85.00,o25|85.00,btts|85.00,1Hbtts|85.00,2Hbtts|85.00,w15|85.00,w25|85.00,wBTTS|85.00,corns|11.00,cornf|5.00,corna|5.00,cards|5.00,cardf|3.00,carda|3.00,s2f|80.00,scd1st|80.00,con1st|80.00 [location_view] => all [position_view] => league [userTheme] => light [leftMenuSize] => lg )
EVENT LOGGER