4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del USC Eugendorf
TEMPORADA 2023/2024
CUARTA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 Kuchl Kuchl 23 76 10 64
2 Seekirchen Seekirchen 23 60 21 55
3 UFC Hallein UFC Hallein 23 57 32 46
4 Grödig Grödig 23 37 24 37
5 USC Eugendorf Eugendorf 23 37 33 34
6 Puch Puch 23 43 39 32
7 Bürmoos Bürmoos 23 34 34 32
8 Siezenheim Siezenheim 23 29 33 32
9 Bramberg Bramberg 23 31 29 29
10 Thalgau Thalgau 23 45 49 27
11 Union Henndorf Union 23 32 49 27
12 Golling Golling 23 26 35 25
13 Salzburger AK Salzburger 23 24 37 25
14 Straßwalchen Straßwalche 23 28 53 25
15 USK Anif USK Anif 23 24 46 20
16 Adnet Adnet 23 14 73 8
TEMPORADA 2022/2023
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 Thalgau Thalgau 26 60 30 58
2 Bürmoos Bürmoos 26 55 24 55
3 Straßwalchen Straßwalche 26 49 37 48
4 USC Eugendorf Eugendorf 26 55 32 42
5 Bramberg Bramberg 26 57 36 42
6 Adnet Adnet 26 41 30 39
7 Siezenheim Siezenheim 26 43 36 39
8 Puch Puch 26 42 41 38
9 TSV Neumarkt Neumarkt 26 47 56 35
10 Hallwang Hallwang 26 43 52 30
11 SV Schwarzach Schwarzach 26 31 46 30
12 Altenmarkt Altenmarkt 26 36 66 20
13 ASV Salzburg Salzburg 26 30 61 17
14 Bergheim Bergheim 26 35 77 17
TEMPORADA 2021/2022
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 Golling Golling 26 75 37 54
2 UFC Hallein UFC Hallein 26 70 32 51
3 USC Eugendorf Eugendorf 26 61 25 50
4 Thalgau Thalgau 26 58 49 46
5 Bürmoos Bürmoos 26 59 45 44
6 Adnet Adnet 26 40 28 44
7 Siezenheim Siezenheim 26 49 50 40
8 Hallwang Hallwang 26 48 42 38
9 TSV Neumarkt Neumarkt 26 48 47 38
10 Bramberg Bramberg 26 39 49 34
11 Straßwalchen Straßwalche 26 55 52 31
12 Bergheim Bergheim 26 46 80 23
13 Altenmarkt Altenmarkt 26 36 68 20
14 Puch Puch 26 20 100 2
TEMPORADA 2020/2021
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
TEMPORADA 2019/2020
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 USC Eugendorf Eugendorf 15 40 15 35
2 Adnet Adnet 15 38 18 33
3 Zell am See Zell am See 15 32 14 30
4 TSV Neumarkt Neumarkt 15 34 15 28
5 Golling Golling 15 41 35 26
6 Straßwalchen Straßwalche 15 32 43 25
7 Bergheim Bergheim 15 28 22 22
8 Bramberg Bramberg 15 27 24 20
9 Bürmoos Bürmoos 15 32 22 19
10 Altenmarkt Altenmarkt 15 28 32 17
11 UFC Hallein UFC Hallein 15 20 27 15
12 Thalgau Thalgau 15 23 46 11
13 Hallwang Hallwang 15 15 40 9
14 Puch Puch 15 12 49 5
TEMPORADA 2018/2019
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Salzburger AK Salzburger 30 93 25 75
2 Austria Salzburg Austria 30 92 31 70
3 Kuchl Kuchl 30 66 37 61
4 TSV Neumarkt Neumarkt 30 77 48 57
5 Bürmoos Bürmoos 30 55 45 47
6 USC Eugendorf Eugendorf 30 61 47 46
7 Zell am See Zell am See 30 63 53 43
8 Golling Golling 30 59 69 38
9 Straßwalchen Straßwalche 30 48 46 37
10 Altenmarkt Altenmarkt 30 52 61 37
11 Thalgau Thalgau 30 64 75 34
12 Puch Puch 30 54 89 30
13 Bramberg Bramberg 30 59 82 29
14 Adnet Adnet 30 32 82 26
15 UFC Hallein UFC Hallein 30 41 85 25
16 SK Strobl SK Strobl 30 38 79 18
TEMPORADA 2017/2018
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Bischofshofen Bischofshofe 30 63 28 69
2 TSV Neumarkt Neumarkt 30 64 34 61
3 USC Eugendorf Eugendorf 30 69 50 55
4 Bürmoos Bürmoos 30 46 36 49
5 Zell am See Zell am See 30 63 46 47
6 Salzburger AK Salzburger 30 59 48 45
7 Austria Salzburg Austria 30 57 50 41
8 Bramberg Bramberg 30 39 44 41
9 Straßwalchen Straßwalche 30 58 55 39
10 SK Strobl SK Strobl 30 56 57 37
11 Kuchl Kuchl 30 49 57 36
12 Golling Golling 30 53 64 32
13 UFC Hallein UFC Hallein 30 37 60 30
14 Altenmarkt Altenmarkt 30 40 64 30
15 Hallwang Hallwang 30 39 68 30
16 Bergheim Bergheim 30 39 70 27
TEMPORADA 2016/2017
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 USK Anif USK Anif 30 99 28 80
2 Grödig Grödig 30 70 20 70
3 SC Rheindorf Altach II Rheindorf 30 48 48 48
4 St. Johann St. Johann 30 48 42 45
5 Schwaz Schwaz 30 46 39 44
6 FC Wacker Innsbruck II Wacker 30 48 46 43
7 Kufstein Kufstein 30 53 51 41
8 Dornbirn Dornbirn 30 33 43 39
9 Hohenems Hohenems 30 49 50 38
10 Seekirchen Seekirchen 30 51 57 38
11 Hard Hard 30 46 54 37
12 Pinzgau Saalfelden Pinzgau 30 33 47 34
13 Wörgl Wörgl 30 40 61 33
14 USC Eugendorf Eugendorf 30 40 66 30
15 Austria Salzburg Austria 30 43 62 23
16 Salzburger AK Salzburger 30 34 67 22
TEMPORADA 2015/2016
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 WSG Tirol WSG Tirol 30 81 18 75
2 USK Anif USK Anif 30 76 46 57
3 St. Johann St. Johann 30 59 32 55
4 Dornbirn Dornbirn 30 58 39 50
5 Schwaz Schwaz 30 44 40 46
6 USC Eugendorf Eugendorf 30 56 63 43
7 FC Wacker Innsbruck II Wacker 30 54 45 42
8 Pinzgau Saalfelden Pinzgau 30 51 59 39
9 Seekirchen Seekirchen 30 50 58 39
10 SC Rheindorf Altach II Rheindorf 30 33 48 38
11 Kufstein Kufstein 30 43 45 37
12 Hard Hard 30 35 42 36
13 TSV Neumarkt Neumarkt 30 43 61 36
14 SW Bregenz SW Bregenz 30 42 63 33
15 Kitzbühel Kitzbühel 30 53 59 32
16 Reichenau Reichenau 30 28 88 13
TEMPORADA 2014/2015
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Austria Salzburg Austria 30 71 23 73
2 WSG Tirol WSG Tirol 30 81 22 69
3 St. Johann St. Johann 30 51 35 47
4 USC Eugendorf Eugendorf 30 53 48 47
5 Kitzbühel Kitzbühel 30 46 40 43
6 TSV Neumarkt Neumarkt 30 51 58 43
7 Dornbirn Dornbirn 30 46 43 41
8 Kufstein Kufstein 30 56 59 41
9 Seekirchen Seekirchen 30 40 46 40
10 Schwaz Schwaz 30 42 37 39
11 FC Wacker Innsbruck II Wacker 30 58 61 38
12 Pinzgau Saalfelden Pinzgau 30 47 49 37
13 Hard Hard 30 41 50 32
14 SC Rheindorf Altach II Rheindorf 30 33 70 31
15 Bizau Bizau 30 27 68 29
16 FC Höchst FC Höchst 30 20 54 19
TEMPORADA 2013/2014
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Austria Salzburg Austria 30 96 15 79
2 WSG Tirol WSG Tirol 30 88 36 70
3 TSV Neumarkt Neumarkt 30 67 41 53
4 St. Johann St. Johann 30 59 57 47
5 SC Rheindorf Altach II Rheindorf 30 51 51 46
6 Schwaz Schwaz 30 45 42 45
7 FC Wacker Innsbruck II Wacker 30 51 61 40
8 Kufstein Kufstein 30 49 58 36
9 Dornbirn Dornbirn 30 50 51 34
10 Seekirchen Seekirchen 30 44 48 34
11 Hard Hard 30 38 65 34
12 FC Höchst FC Höchst 30 35 51 33
13 USC Eugendorf Eugendorf 30 44 69 33
14 USK Anif USK Anif 30 43 56 31
15 SW Bregenz SW Bregenz 30 50 75 29
16 Wals-Grünau Wals-Grünau 30 36 70 27
TEMPORADA 2012/2013
CUARTA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 USC Eugendorf Eugendorf 30 82 31 68
2 Hallein Hallein 30 57 34 61
3 Salzburger AK Salzburger 30 56 37 54
4 Altenmarkt Altenmarkt 30 54 35 51
5 Puch Puch 30 56 47 48
6 Straßwalchen Straßwalche 30 66 50 47
7 Bramberg Bramberg 30 54 63 42
8 Grödig II Grödig II 30 56 50 39
9 Kuchl Kuchl 30 54 51 39
10 Zell am See Zell am See 30 59 61 38
11 Hallwang Hallwang 30 34 39 37
12 Union Henndorf Union 30 43 60 35
13 Berndorf Berndorf 30 42 59 33
14 Schwarzach Schwarzach 30 38 62 29
15 SC Leogang SC Leogang 30 41 78 26
16 Golling Golling 30 31 66 25
TEMPORADA 2011/2012
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 Wals-Grünau Wals-Grünau 30 67 25 64
2 Salzburger AK Salzburger 30 59 25 62
3 Hallwang Hallwang 30 66 36 62
4 Grödig II Grödig II 30 69 35 60
5 USC Eugendorf Eugendorf 30 68 41 59
6 Kuchl Kuchl 30 55 49 44
7 Hallein Hallein 30 59 53 42
8 Straßwalchen Straßwalche 30 54 56 38
9 Puch Puch 30 54 56 37
10 Union Henndorf Union 30 54 61 33
11 SC Leogang SC Leogang 30 52 77 31
12 Altenmarkt Altenmarkt 30 40 65 31
13 Zell am See Zell am See 30 45 76 31
14 Golling Golling 30 53 72 29
15 Anthering Anthering 30 31 62 27
16 ASK PSV Salzburg Salzburg 30 38 75 24
TEMPORADA 2010/2011
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Pinzgau Saalfelden Pinzgau 30 74 24 75
2 Puch Puch 30 75 43 61
3 USC Eugendorf Eugendorf 30 81 43 60
4 Straßwalchen Straßwalche 30 70 45 59
5 Hallwang Hallwang 30 69 45 57
6 Kuchl Kuchl 30 61 50 49
7 Hallein Hallein 30 62 52 47
8 Salzburger AK Salzburger 30 61 48 41
9 Wals-Grünau Wals-Grünau 30 48 53 40
10 Union Henndorf Union 30 53 62 36
11 ASK PSV Salzburg Salzburg 30 54 66 32
12 Zell am See Zell am See 30 54 77 26
13 Anthering Anthering 30 52 84 26
14 SC Leogang SC Leogang 30 44 77 26
15 Piesendorf Piesendorf 30 44 80 25
16 UFC Maria Alm Maria 30 38 91 22
TEMPORADA 2009/2010
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Austria Salzburg Austria 26 68 24 60
2 Hallwang Hallwang 26 50 26 55
3 USC Eugendorf Eugendorf 26 60 30 51
4 Pinzgau Saalfelden Pinzgau 26 56 29 50
5 Hallein Hallein 26 61 52 45
6 Salzburger AK Salzburger 26 54 36 40
7 Zell am See Zell am See 26 59 50 39
8 Straßwalchen Straßwalche 26 46 59 32
9 Piesendorf Piesendorf 26 39 58 26
10 Anthering Anthering 26 30 52 26
11 Puch Puch 26 32 51 25
12 Maria Saal Maria Saal 26 43 71 25
13 ASK PSV Salzburg Salzburg 26 29 61 23
14 Union Henndorf Union 26 44 72 19
TEMPORADA 2008/2009
CUARTA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 TSV Neumarkt Neumarkt 26 62 26 57
2 USC Eugendorf Eugendorf 26 48 37 48
3 Hallwang Hallwang 26 65 33 47
4 Pinzgau Saalfelden Pinzgau 26 54 32 47
5 Puch Puch 26 51 39 41
6 Hallein Hallein 26 43 46 39
7 Salzburger AK Salzburger 26 43 42 38
8 Straßwalchen Straßwalche 26 39 52 32
9 Zell am See Zell am See 26 37 50 28
10 Union Henndorf Union 26 36 50 28
11 ASK PSV Salzburg Salzburg 26 32 50 27
12 Anthering Anthering 25 30 38 24
13 Piesendorf Piesendorf 26 34 55 22
14 Bischofshofen Bischofshofe 25 30 54 21

  USO DE MEMORIA  
6,677,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1102
Total Execution Time  0.1115
  CADENA URL  
/historico/Usc-Eugendorf
  GET DATOS  
$_GET['/historico/Usc-Eugendorf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0027  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 = 'Usc-Eugendorf' 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=12428 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=12428 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=12428 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=12428 AND type_rel = 2
0.0021  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 = '12428' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '12428' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73018 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=12428 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 (73018,71432) 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 = 73018 AND teamId = 12428
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12428
0.0019  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '12428' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12428' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '12428' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 73018 WHERE rp.league_id = 73018 AND rp.teamId = 12428 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.0027  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 = 73018 WHERE rp.league_id = 73018 AND rp.teamId = 12428 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 73018 WHERE rp.league_id = 73018 AND rp.teamId = 12428 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 12428 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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 = 68330 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `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 = 63696 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables2021` 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 = 57781 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 50449 AND t.round = 15 ORDER BY team.conference ASC,t.position 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 `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 = 44306 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 38911 AND t.round = 30 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 = 33373 AND t.round = 30 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 `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 = 15760 AND t.round = 30 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 `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 = 4156 AND t.round = 30 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 `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 = 2768 AND t.round = 30 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 `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 = 27175 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 27212 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 27206 AND t.round = 30 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 `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 = 27237 AND t.round = 26 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 `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 = 27255 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC