4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Grödig
TEMPORADA 2023/2024
CUARTA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 Kuchl Kuchl 21 65 9 58
2 Seekirchen Seekirchen 22 57 19 52
3 UFC Hallein UFC Hallein 22 55 30 45
4 Grödig Grödig 22 35 22 36
5 USC Eugendorf Eugendorf 22 37 29 34
6 Siezenheim Siezenheim 21 28 31 31
7 Puch Puch 22 39 38 29
8 Bürmoos Bürmoos 22 30 34 29
9 Thalgau Thalgau 21 42 42 27
10 Union Henndorf Union 22 32 43 27
11 Bramberg Bramberg 21 25 29 25
12 Straßwalchen Straßwalche 22 26 51 24
13 Golling Golling 21 24 33 23
14 Salzburger AK Salzburger 22 22 36 22
15 USK Anif USK Anif 22 23 42 20
16 Adnet Adnet 21 14 66 7
TEMPORADA 2022/2023
TERCERA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 Golling Golling 8 13 14 26
2 Salzburger AK Salzburger 8 13 11 23
3 Grödig Grödig 8 15 11 22
4 USK Anif USK Anif 8 12 16 22
5 UFC Hallein UFC Hallein 8 13 14 12
TEMPORADA 2021/2022
TERCERA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 Seekirchen Seekirchen 14 24 14 40
2 Kuchl Kuchl 14 28 23 36
3 Bischofshofen Bischofshofe 14 21 16 35
4 Pinzgau Saalfelden Pinzgau 14 28 24 34
5 Salzburger AK Salzburger 14 26 21 29
6 Grödig Grödig 14 22 20 29
7 USK Anif USK Anif 14 21 25 25
8 Wals-Grünau Wals-Grünau 14 8 35 10
TEMPORADA 2020/2021
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Austria Salzburg Austria 14 21 15 28
2 Kuchl Kuchl 11 25 12 25
3 Seekirchen Seekirchen 14 24 23 23
4 Bischofshofen Bischofshofe 13 17 11 22
5 Grödig Grödig 13 23 24 18
6 USK Anif USK Anif 13 19 12 17
7 Pinzgau Saalfelden Pinzgau 13 18 19 16
8 St. Johann St. Johann 14 17 22 14
9 Salzburger AK Salzburger 12 15 26 12
10 Wals-Grünau Wals-Grünau 13 15 30 8
TEMPORADA 2019/2020
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Salzburger AK Salzburger 18 73 21 52
2 Pinzgau Saalfelden Pinzgau 18 46 13 42
3 Seekirchen Seekirchen 18 35 30 29
4 USK Anif USK Anif 18 40 37 27
5 Wals-Grünau Wals-Grünau 18 33 35 24
6 St. Johann St. Johann 18 28 39 24
7 Grödig Grödig 18 35 31 23
8 Austria Salzburg Austria 18 27 31 18
9 Kuchl Kuchl 18 25 41 13
10 Bischofshofen Bischofshofe 18 12 76 1
TEMPORADA 2018/2019
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Dornbirn Dornbirn 30 70 23 72
2 Kitzbühel Kitzbühel 30 59 28 65
3 USK Anif USK Anif 30 98 37 61
4 Kufstein Kufstein 30 55 31 55
5 Seekirchen Seekirchen 30 57 45 51
6 St. Johann St. Johann 30 66 43 50
7 Schwaz Schwaz 30 47 42 47
8 Wörgl Wörgl 30 60 59 43
9 Reichenau Reichenau 30 50 45 42
10 Grödig Grödig 30 38 46 38
11 Hohenems Hohenems 30 52 70 30
12 Wals-Grünau Wals-Grünau 30 34 55 30
13 SC Rheindorf Altach II Rheindorf 30 31 49 28
14 Pinzgau Saalfelden Pinzgau 30 38 73 25
15 Langenegg Langenegg 30 35 89 22
16 Bischofshofen Bischofshofe 30 31 86 19
TEMPORADA 2017/2018
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 USK Anif USK Anif 30 92 24 67
2 Grödig Grödig 30 73 27 61
3 Schwaz Schwaz 30 49 33 53
4 SC Rheindorf Altach II Rheindorf 30 63 45 49
5 Kitzbühel Kitzbühel 30 58 39 47
6 Dornbirn Dornbirn 30 40 42 43
7 Wals-Grünau Wals-Grünau 30 58 53 42
8 FC Wacker Innsbruck II Wacker 30 48 50 41
9 Hohenems Hohenems 30 51 61 41
10 Kufstein Kufstein 30 56 53 38
11 St. Johann St. Johann 30 48 55 36
12 Seekirchen Seekirchen 30 46 54 36
13 Wörgl Wörgl 30 45 59 34
14 Hard Hard 30 37 62 29
15 Pinzgau Saalfelden Pinzgau 30 35 74 24
16 Alberschwende Alberschwend 30 28 96 13
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
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 71 33 74
2 Rapid Wien Rapid Wien 36 66 42 65
3 Austria Wien Austria Wien 36 65 48 59
4 Admira Admira 36 45 51 50
5 Sturm Graz Sturm Graz 36 40 40 48
6 Wolfsberger AC Wolfsberger 36 33 36 43
7 SV Ried SV Ried 36 36 52 42
8 SCR Altach SCR Altach 36 39 49 40
9 Mattersburg Mattersburg 36 40 70 39
10 Grödig Grödig 36 42 56 35
TEMPORADA 2014/2015
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 99 42 73
2 Rapid Wien Rapid Wien 36 68 38 67
3 SCR Altach SCR Altach 36 50 49 59
4 Sturm Graz Sturm Graz 36 57 41 58
5 Wolfsberger AC Wolfsberger 36 44 50 52
6 SV Ried SV Ried 36 49 51 44
7 Austria Wien Austria Wien 36 45 51 43
8 Grödig Grödig 36 46 65 37
9 Admira Admira 36 32 61 34
10 Wiener Neustadt Wiener 36 37 79 29
TEMPORADA 2013/2014
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 110 35 80
2 Rapid Wien Rapid Wien 36 63 40 62
3 Grödig Grödig 36 68 71 54
4 Austria Wien Austria Wien 36 58 44 53
5 Sturm Graz Sturm Graz 36 55 55 48
6 SV Ried SV Ried 36 55 66 43
7 Admira Admira 36 51 67 42
8 Wolfsberger AC Wolfsberger 36 50 63 41
9 Wiener Neustadt Wiener 36 43 84 39
10 Wacker Innsbruck Wacker 36 42 70 29
TEMPORADA 2012/2013
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Grödig Grödig 36 71 30 75
2 SCR Altach SCR Altach 36 57 39 65
3 Austria Lustenau Austria 36 60 39 61
4 SKN St. Polten Polten 36 65 60 54
5 Kapfenberger SV Kapfenberger 36 56 50 53
6 Horn Horn 36 50 55 46
7 First Vienna First Vienna 36 48 64 46
8 FC Lustenau FC Lustenau 36 44 66 38
9 TSV Hartberg Hartberg 36 35 54 33
10 Blau-Weiß Linz Blau-Weiß 36 38 67 26
TEMPORADA 2011/2012
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 WAC Sankt Andrä Sankt Andrä 36 71 49 68
2 SCR Altach SCR Altach 36 62 39 62
3 LASK LASK 36 55 40 61
4 Austria Lustenau Austria 36 59 47 58
5 SKN St. Polten Polten 36 45 45 51
6 Blau-Weiß Linz Blau-Weiß 36 49 52 49
7 Grödig Grödig 36 46 52 42
8 First Vienna First Vienna 36 44 56 37
9 FC Lustenau FC Lustenau 36 51 66 37
10 TSV Hartberg Hartberg 36 38 74 27
TEMPORADA 2010/2011
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Admira Admira 36 85 45 75
2 SCR Altach SCR Altach 36 76 37 74
3 Austria Lustenau Austria 36 55 51 54
4 WAC Sankt Andrä Sankt Andrä 36 56 50 52
5 SKN St. Polten Polten 36 55 55 51
6 Grödig Grödig 36 51 60 46
7 FC Lustenau FC Lustenau 36 51 60 42
8 TSV Hartberg Hartberg 36 44 60 39
9 First Vienna First Vienna 36 47 67 34
10 Gratkorn Gratkorn 36 47 82 33
TEMPORADA 2009/2010
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Grödig Grödig 30 100 23 76
2 WSG Tirol WSG Tirol 30 78 39 61
3 USK Anif USK Anif 30 82 47 59
4 FC Wacker Innsbruck II Wacker 30 64 46 53
5 Kufstein Kufstein 30 69 51 51
6 Seekirchen Seekirchen 30 70 54 51
7 SW Bregenz SW Bregenz 30 76 44 50
8 Hard Hard 30 82 53 49
9 St. Johann St. Johann 30 66 64 42
10 TSV Neumarkt Neumarkt 30 48 57 40
11 Reichenau / Union Reichenau 30 73 75 36
12 SC Rheindorf Altach II Rheindorf 30 43 62 36
13 Schwaz Schwaz 30 37 64 33
14 Blau-Weiß Feldkirch Blau-Weiß 30 50 78 28
15 Axams / Götzens Axams 30 54 98 14
16 Hohenems Hohenems 30 19 156 1
TEMPORADA 2008/2009
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Wiener Neustadt Wiener 33 65 26 69
2 Wacker Innsbruck Wacker 33 65 44 62
3 Admira Admira 33 55 36 60
4 Austria Lustenau Austria 33 52 47 48
5 SKN St. Polten Polten 33 51 46 47
6 Austria Wien II Austria Wien 33 44 43 45
7 RB Juniors Salzburg Juniors 33 41 56 43
8 Gratkorn Gratkorn 33 39 55 40
9 FC Lustenau FC Lustenau 33 34 37 38
10 Grödig Grödig 33 37 52 35
11 Leoben Leoben 33 30 55 32
12 Vöcklabruck Vöcklabruck 33 40 56 30
TEMPORADA 2007/2008
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Grödig Grödig 30 72 25 68
2 Kufstein Kufstein 30 73 49 54
3 Hard Hard 30 53 38 54
4 SV Hall SV Hall 30 47 41 49
5 WSG Tirol WSG Tirol 30 54 42 47
6 Blau-Weiß Feldkirch Blau-Weiß 30 56 42 44
7 Seekirchen Seekirchen 30 51 43 43
8 Axams / Götzens Axams 30 54 47 42
9 USK Anif USK Anif 30 45 45 40
10 Dornbirn Dornbirn 30 48 50 40
11 FC Höchst FC Höchst 30 54 52 39
12 SW Bregenz SW Bregenz 30 61 66 37
13 Reichenau / Union Reichenau 30 49 62 37
14 Rot-Weiß Rankweil Rot-Weiß 30 36 53 36
15 Kundl Kundl 30 45 64 28
16 Innsbrucker AC Innsbrucker 30 39 118 8
TEMPORADA 2006/2007
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 RB Juniors Salzburg Juniors 30 97 34 73
2 Hard Hard 30 59 28 60
3 WSG Tirol WSG Tirol 30 58 30 56
4 Kufstein Kufstein 30 48 27 51
5 Blau-Weiß Feldkirch Blau-Weiß 30 74 47 49
6 Grödig Grödig 30 43 41 46
7 Dornbirn Dornbirn 30 43 45 42
8 SV Hall SV Hall 30 54 48 40
9 Axams / Götzens Axams 30 48 46 37
10 FC Höchst FC Höchst 30 50 55 37
11 Reichenau Reichenau 30 51 59 36
12 Seekirchen Seekirchen 30 42 68 32
13 Innsbrucker AC Innsbrucker 30 57 88 32
14 Rot-Weiß Rankweil Rot-Weiß 30 41 58 29
15 Hohenems Hohenems 30 32 72 24
16 Austria Lustenau II Austria 30 43 94 24

  USO DE MEMORIA  
6,625,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.7292
Total Execution Time  0.7311
  CADENA URL  
/historico/Grodig
  GET DATOS  
$_GET['/historico/Grodig']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0139  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 = 'Grodig' 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.0125  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=11782 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=11782 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=11782 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73018
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11782 AND type_rel = 2
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=584 AND type_rel = 3
0.0141  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 584 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0138  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (809215,467932,467907,348427) ORDER BY n.cover_points DESC, update_date DESC
0.0160  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 = '11782' ORDER BY l.year DESC,cat.coefficient DESC
0.0169  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 = '11782' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0180  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 = '11782' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0133  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.0139  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=11782 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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,71437,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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 71437 AND teamId = 11782
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 73018 AND teamId = 11782
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 11782
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 73018 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '11782' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11782' and rp.type = 4
0.0127  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 = '11782' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  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 = 11782 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.0164  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 = 11782 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 11782 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 11782 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 73018 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 68177 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 71437 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 66983 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 57020 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 50648 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 44210 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 38884 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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.0136  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 = 15404 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 3813 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 8928 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 8927 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 8926 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 24534 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 8924 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 `tables2008` 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 = 24540 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 `tables2007` 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 = 27595 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC