4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rain / Lech
TEMPORADA 2023/2024
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 TSV Schwaben Augsburg Schwaben 31 71 32 61
2 Landsberg Landsberg 31 78 47 60
3 SV Erlbach SV Erlbach 31 44 25 60
4 Heimstetten Heimstetten 31 54 34 59
5 FC Deisenhofen Deisenhofen 31 60 31 56
6 TSV Nördlingen Nördlingen 31 59 42 55
7 1860 München II 1860 31 56 45 49
8 Kottern Kottern 31 57 48 46
9 Kirchanschöring Kirchanschö 31 36 43 43
10 FC Pipinsried Pipinsried 30 36 33 40
11 Sonthofen Sonthofen 30 45 44 40
12 Rain / Lech Rain / Lech 30 37 49 38
13 Dachau Dachau 31 50 63 37
14 Ismaning Ismaning 31 39 62 36
15 FC Gundelfingen Gundelfingen 31 35 51 32
16 Türkspor Augsburg Türkspor 30 27 41 29
17 VfR Garching Garching 30 29 74 18
18 Kirchheimer SC Kirchheimer 30 37 86 13
TEMPORADA 2022/2023
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Unterhaching Unterhaching 38 86 33 86
2 Würzburger Kickers Würzburger 38 103 36 80
3 Bayern München II Bayern 38 94 54 71
4 Nürnberg II Nürnberg 38 81 55 61
5 Viktoria Aschaffenburg Viktoria 38 63 47 61
6 Schweinfurt Schweinfurt 38 77 64 59
7 SV Wacker Burghausen Wacker 38 57 45 56
8 Greuther Fürth II Greuther 38 51 53 55
9 Illertissen Illertissen 38 60 65 55
10 FC Augsburg II Augsburg 38 78 69 54
11 Aubstadt Aubstadt 38 65 59 54
12 Buchbach Buchbach 38 62 68 53
13 Vilzing Vilzing 38 52 68 51
14 Türkgücü München Türkgücü 38 48 51 50
15 SpVgg Ansbach SpVgg 38 57 66 50
16 Eichstätt Eichstätt 38 64 70 43
17 Rain / Lech Rain / Lech 38 40 78 36
18 Hankofen-Hailing Hankofen-Hai 38 47 90 36
19 Heimstetten Heimstetten 38 43 94 25
20 FC Pipinsried Pipinsried 38 37 100 25
TEMPORADA 2021/2022
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Bayreuth SpVgg Bayreuth 38 103 39 93
2 Bayern München II Bayern 38 113 50 86
3 SV Wacker Burghausen Wacker 38 84 54 64
4 Unterhaching Unterhaching 38 73 59 64
5 Schweinfurt Schweinfurt 38 96 56 62
6 Aubstadt Aubstadt 38 74 43 61
7 Illertissen Illertissen 38 57 45 59
8 Viktoria Aschaffenburg Viktoria 38 54 53 51
9 FC Augsburg II Augsburg 38 68 70 50
10 Eichstätt Eichstätt 38 49 62 50
11 Nürnberg II Nürnberg 38 55 56 49
12 Buchbach Buchbach 38 50 46 48
13 FC Pipinsried Pipinsried 38 52 72 48
14 Heimstetten Heimstetten 38 56 68 47
15 Rain / Lech Rain / Lech 38 43 66 45
16 Eltersdorf Eltersdorf 38 55 84 41
17 Greuther Fürth II Greuther 38 50 67 40
18 Memmingen Memmingen 38 44 72 38
19 Schalding-Heining Schalding-He 38 34 85 29
20 Rosenheim Rosenheim 38 39 102 27
TEMPORADA 2019/2020
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Türkgücü München Türkgücü 23 51 20 54
2 Schweinfurt Schweinfurt 23 49 28 45
3 Nürnberg II Nürnberg 23 51 27 43
4 Bayreuth SpVgg Bayreuth 23 48 27 41
5 Viktoria Aschaffenburg Viktoria 23 45 29 38
6 Eichstätt Eichstätt 23 41 23 37
7 Greuther Fürth II Greuther 23 29 25 35
8 Buchbach Buchbach 23 29 31 34
9 Aubstadt Aubstadt 22 37 34 33
10 FC Augsburg II Augsburg 23 38 34 29
11 SV Wacker Burghausen Wacker 23 28 33 26
12 Illertissen Illertissen 23 33 48 25
13 Rain / Lech Rain / Lech 22 24 40 24
14 Heimstetten Heimstetten 23 37 52 23
15 Schalding-Heining Schalding-He 22 26 47 23
16 Rosenheim Rosenheim 23 29 56 21
17 Memmingen Memmingen 22 22 36 19
18 VfR Garching Garching 21 23 50 16
TEMPORADA 2018/2019
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Türkgücü München Türkgücü 32 59 30 68
2 Rain / Lech Rain / Lech 32 60 42 58
3 Jahn Regensburg II Jahn 32 69 48 53
4 Pullach Pullach 32 52 48 53
5 Vilzing Vilzing 32 47 36 51
6 Dachau Dachau 32 47 45 49
7 Kottern Kottern 32 46 47 46
8 1860 München II 1860 32 58 48 45
9 Schwabmünchen Schwabmünch 32 57 52 45
10 TSV Nördlingen Nördlingen 32 53 55 45
11 Kirchanschöring Kirchanschö 32 51 47 44
12 TSV Schwaben Augsburg Schwaben 32 41 44 43
13 Hankofen-Hailing Hankofen-Hai 32 47 50 39
14 Sonthofen Sonthofen 32 54 64 38
15 Ismaning Ismaning 32 45 51 37
16 Unterföhring Unterföhrin 32 41 59 28
17 TuS Holzkirchen Holzkirchen 32 30 91 9
TEMPORADA 2017/2018
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Heimstetten Heimstetten 36 93 51 72
2 Pullach Pullach 36 75 48 65
3 Rain / Lech Rain / Lech 36 70 44 62
4 Kottern Kottern 36 59 48 60
5 TSV Schwaben Augsburg Schwaben 36 64 50 54
6 Schwabmünchen Schwabmünch 36 52 52 53
7 Vilzing Vilzing 36 65 54 52
8 ASV Neumarkt Neumarkt 36 51 48 50
9 Dachau Dachau 36 64 52 49
10 Sonthofen Sonthofen 36 59 50 49
11 Ismaning Ismaning 36 70 70 47
12 TuS Holzkirchen Holzkirchen 36 57 69 47
13 Hankofen-Hailing Hankofen-Hai 36 53 66 46
14 1860 München II 1860 36 47 47 43
15 Chiemgau Traunstein Chiemgau 36 49 63 41
16 Kirchanschöring Kirchanschö 36 44 51 40
17 Landsberg Landsberg 36 52 72 39
18 Wolfratshausen Wolfratshaus 36 57 85 39
19 TSV Kornburg Kornburg 36 36 97 28
TEMPORADA 2016/2017
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Pullach Pullach 34 73 32 73
2 Unterföhring Unterföhrin 34 62 42 69
3 FC Pipinsried Pipinsried 34 55 38 63
4 Schwabmünchen Schwabmünch 34 54 43 60
5 Dachau Dachau 34 56 49 60
6 Heimstetten Heimstetten 34 68 52 52
7 Vilzing Vilzing 34 47 48 52
8 Kirchanschöring Kirchanschö 34 40 39 48
9 Sonthofen Sonthofen 34 55 44 47
10 Rain / Lech Rain / Lech 34 64 58 46
11 Ismaning Ismaning 34 52 52 42
12 Kottern Kottern 34 64 72 39
13 Hankofen-Hailing Hankofen-Hai 34 36 57 35
14 Landsberg Landsberg 34 46 65 34
15 Wolfratshausen Wolfratshaus 34 44 66 34
16 Jahn Regensburg II Jahn 34 53 56 33
17 Bogen Bogen 34 34 62 31
18 FC Gundelfingen Gundelfingen 34 39 67 27
TEMPORADA 2015/2016
REGIONALLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Jahn Regensburg Jahn 34 61 36 64
2 SV Wacker Burghausen Wacker 34 58 33 63
3 Nürnberg II Nürnberg 34 57 37 63
4 Unterhaching Unterhaching 34 59 32 56
5 Illertissen Illertissen 34 53 49 53
6 Bayern München II Bayern 34 54 38 52
7 Bayreuth SpVgg Bayreuth 34 52 57 49
8 Buchbach Buchbach 34 43 46 48
9 Greuther Fürth II Greuther 34 53 56 47
10 1860 München II 1860 34 48 38 46
11 Ingolstadt 04 II Ingolstadt 34 55 54 46
12 Memmingen Memmingen 34 52 60 42
13 Schalding-Heining Schalding-He 34 40 62 40
14 Schweinfurt Schweinfurt 34 44 52 38
15 Viktoria Aschaffenburg Viktoria 34 49 63 35
16 FC Augsburg II Augsburg 34 52 63 33
17 Amberg Amberg 34 36 57 29
18 Rain / Lech Rain / Lech 34 44 77 27
TEMPORADA 2014/2015
OBERLIGA GRUPO 10
Equipo PJ GF GC Puntos
1 Rain / Lech Rain / Lech 36 100 29 83
2 Pullach Pullach 36 72 33 75
3 FC Pipinsried Pipinsried 36 81 43 72
4 Bogen Bogen 36 43 35 57
5 Vilzing Vilzing 36 49 55 53
6 Wolfratshausen Wolfratshaus 36 60 57 52
7 Hankofen-Hailing Hankofen-Hai 36 49 51 52
8 Unterföhring Unterföhrin 36 68 41 51
9 Landsberg Landsberg 36 66 56 51
10 Sonthofen Sonthofen 36 47 46 48
11 Rosenheim Rosenheim 36 47 60 48
12 Eichstätt Eichstätt 36 47 50 45
13 Dachau Dachau 36 55 62 45
14 Schwabmünchen Schwabmünch 36 43 51 44
15 Bad Kötzting Kötzting 36 48 65 43
16 Landshut Landshut 36 49 69 40
17 Raisting Raisting 36 41 61 36
18 DJK Rosenheim Rosenheim 36 56 79 35
19 Unterhaching II Unterhaching 36 41 119 17
TEMPORADA 2013/2014
REGIONALLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Bayern München II Bayern 36 94 33 79
2 Illertissen Illertissen 36 79 33 75
3 1860 München II 1860 36 68 41 72
4 FC Augsburg II Augsburg 36 63 34 69
5 Buchbach Buchbach 36 63 55 61
6 Ingolstadt 04 II Ingolstadt 36 65 50 57
7 Seligenporten Seligenporte 36 55 60 54
8 Nürnberg II Nürnberg 36 57 46 53
9 Greuther Fürth II Greuther 36 68 57 52
10 Eintracht Bamberg Eintracht 36 63 65 51
11 Würzburger Kickers Würzburger 36 61 55 49
12 Schalding-Heining Schalding-He 36 52 71 42
13 Memmingen Memmingen 36 51 56 41
14 Heimstetten Heimstetten 36 50 82 38
15 Rosenheim Rosenheim 36 45 59 37
16 Schweinfurt Schweinfurt 36 46 71 36
17 Bayern Hof Bayern Hof 36 42 68 36
18 Viktoria Aschaffenburg Viktoria 36 45 86 23
19 Rain / Lech Rain / Lech 36 45 90 20
TEMPORADA 2012/2013
REGIONALLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 1860 München II 1860 38 69 35 80
2 Bayern München II Bayern 38 71 31 73
3 Illertissen Illertissen 38 74 44 72
4 Nürnberg II Nürnberg 38 64 40 65
5 Heimstetten Heimstetten 38 61 53 61
6 Buchbach Buchbach 38 73 57 60
7 Rosenheim Rosenheim 38 43 44 58
8 Ingolstadt 04 II Ingolstadt 38 69 57 55
9 Memmingen Memmingen 38 45 39 55
10 Würzburger Kickers Würzburger 38 63 76 52
11 Rain / Lech Rain / Lech 38 51 59 49
12 Greuther Fürth II Greuther 38 49 56 48
13 Eintracht Bamberg Eintracht 38 48 64 47
14 Seligenporten Seligenporte 38 53 72 45
15 Viktoria Aschaffenburg Viktoria 38 45 71 42
16 FC Augsburg II Augsburg 38 57 66 41
17 Bayern Hof Bayern Hof 38 39 56 40
18 Eltersdorf Eltersdorf 38 50 70 39
19 Ismaning Ismaning 38 38 48 36
20 VfL Frohnlach Frohnlach 38 40 64 35
TEMPORADA 2011/2012
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Rosenheim Rosenheim 34 72 34 70
2 Bayern Hof Bayern Hof 34 55 27 64
3 Eltersdorf Eltersdorf 34 70 50 58
4 Buchbach Buchbach 34 65 49 56
5 Rain / Lech Rain / Lech 34 50 44 55
6 Seligenporten Seligenporte 34 51 44 52
7 VfL Frohnlach Frohnlach 34 62 46 51
8 Eintracht Bamberg Eintracht 34 62 57 51
9 Ismaning Ismaning 34 52 47 47
10 Grossbardorf Grossbardorf 34 49 65 46
11 Erlangen-Bruck Erlangen-Bru 34 37 49 44
12 Würzburger FV Würzburger 34 55 66 43
13 Schweinfurt Schweinfurt 34 58 70 41
14 DJK Rosenheim Rosenheim 34 53 59 39
15 Heimstetten Heimstetten 34 56 67 38
16 TSV Aindling Aindling 34 41 58 32
17 Gersthofen Gersthofen 34 49 82 27
18 Unterhaching II Unterhaching 34 35 58 26
TEMPORADA 2010/2011
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Ismaning Ismaning 34 72 48 66
2 Ingolstadt 04 II Ingolstadt 34 75 48 63
3 Rosenheim Rosenheim 34 58 39 53
4 Buchbach Buchbach 34 58 51 53
5 Würzburger FV Würzburger 34 57 52 52
6 Seligenporten Seligenporte 34 59 56 52
7 Unterhaching II Unterhaching 34 53 44 51
8 Eintracht Bamberg Eintracht 34 54 61 51
9 Schweinfurt Schweinfurt 34 48 50 50
10 Grossbardorf Grossbardorf 34 53 54 45
11 Erlangen-Bruck Erlangen-Bru 34 59 70 45
12 Rain / Lech Rain / Lech 34 52 47 44
13 TSV Aindling Aindling 34 40 39 43
14 Heimstetten Heimstetten 34 53 53 43
15 Bayern Hof Bayern Hof 34 50 56 41
16 Bayreuth SpVgg Bayreuth 34 45 63 41
17 Schalding-Heining Schalding-He 34 47 66 32
18 Freier TuS Freier TuS 34 38 74 23
TEMPORADA 2009/2010
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Memmingen Memmingen 36 57 23 74
2 Ismaning Ismaning 36 70 47 63
3 Unterhaching II Unterhaching 36 65 48 62
4 TSV Aindling Aindling 36 60 46 59
5 Rain / Lech Rain / Lech 36 54 45 59
6 Ingolstadt 04 II Ingolstadt 36 61 53 58
7 Seligenporten Seligenporte 36 61 53 58
8 Erlangen-Bruck Erlangen-Bru 36 56 43 56
9 Bayreuth SpVgg Bayreuth 36 44 34 54
10 Bayern Hof Bayern Hof 36 45 44 52
11 Buchbach Buchbach 36 71 62 49
12 Rosenheim Rosenheim 36 53 47 49
13 Schalding-Heining Schalding-He 36 46 65 47
14 Grossbardorf Grossbardorf 36 49 50 44
15 SpVgg Ansbach SpVgg 36 42 57 42
16 VfL Frohnlach Frohnlach 36 43 59 40
17 Memmelsdorf Memmelsdorf 36 36 74 29
18 TSG Thannhausen Thannhausen 36 43 77 28
19 Bad Kötzting Kötzting 36 43 72 24
TEMPORADA 2008/2009
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Weiden Weiden 34 66 29 74
2 TSV Aindling Aindling 34 69 27 65
3 Memmingen Memmingen 34 48 34 59
4 Bayreuth SpVgg Bayreuth 34 48 38 55
5 Erlangen-Bruck Erlangen-Bru 34 60 44 53
6 Ingolstadt 04 II Ingolstadt 34 50 42 52
7 VfL Frohnlach Frohnlach 34 64 56 45
8 Buchbach Buchbach 34 47 44 45
9 TSG Thannhausen Thannhausen 34 53 55 43
10 Bayern Hof Bayern Hof 34 41 45 42
11 Ismaning Ismaning 34 61 60 41
12 SpVgg Ansbach SpVgg 34 37 49 40
13 Bad Kötzting Kötzting 34 42 65 39
14 Würzburger FV Würzburger 34 45 52 38
15 Seligenporten Seligenporte 34 41 55 38
16 Rain / Lech Rain / Lech 34 47 67 38
17 Schweinfurt Schweinfurt 34 39 66 36
18 Würzburger Kickers Würzburger 34 52 82 30

  USO DE MEMORIA  
7,133,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1251
Total Execution Time  0.1264
  CADENA URL  
/historico/Rain-Lech
  GET DATOS  
$_GET['/historico/Rain-Lech']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0028  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Rain-Lech' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9732 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9732 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9732 AND type_rel = 2
0.0024  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '9732' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '9732' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0028  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=9732 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72394,68045,67320) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 68045 AND teamId = 9732
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72394 AND teamId = 9732
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 9732
0.0032  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 9732 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 9732 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 9732 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 9732 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0040  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72394 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68045 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 63156 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50101 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44076 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 38870 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 33324 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15528 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 9463 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2508 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2008 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 19820 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 19831 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 19842 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 19854 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC