4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 60 30 68
2 Rapid Wien Rapid Wien 36 52 30 62
3 Admira Admira 36 59 52 55
4 Austria Wien Austria Wien 36 52 44 54
5 Sturm Graz Sturm Graz 36 47 41 51
6 SV Ried SV Ried 36 44 38 48
7 Wacker Innsbruck Wacker 36 36 45 45
8 Mattersburg Mattersburg 36 41 43 38
9 Wiener Neustadt Wiener 36 26 51 33
10 Kapfenberger SV Kapfenberger 36 21 64 23
TEMPORADA 2010/2011
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Sturm Graz Sturm Graz 36 66 33 66
2 Salzburg Salzburg 36 53 31 63
3 Austria Wien Austria Wien 36 64 37 61
4 SV Ried SV Ried 36 51 38 58
5 Rapid Wien Rapid Wien 36 52 41 53
6 Wacker Innsbruck Wacker 36 43 42 50
7 Wiener Neustadt Wiener 36 44 52 50
8 Kapfenberger SV Kapfenberger 36 42 61 38
9 Mattersburg Mattersburg 36 29 56 31
10 LASK LASK 36 22 75 19
TEMPORADA 2009/2010
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 68 27 76
2 Austria Wien Austria Wien 36 60 34 75
3 Rapid Wien Rapid Wien 36 80 38 73
4 Sturm Graz Sturm Graz 36 50 36 58
5 Wiener Neustadt Wiener 36 54 58 47
6 Mattersburg Mattersburg 36 45 71 41
7 LASK LASK 36 59 70 40
8 SV Ried SV Ried 36 39 47 38
9 Kapfenberger SV Kapfenberger 36 44 67 33
10 Austria Karnten Austria 36 29 80 15
TEMPORADA 2008/2009
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 86 50 74
2 Rapid Wien Rapid Wien 36 89 43 70
3 Austria Wien Austria Wien 36 59 46 62
4 Sturm Graz Sturm Graz 36 68 45 60
5 SV Ried SV Ried 36 58 38 60
6 Austria Karnten Austria 36 47 57 41
7 LASK LASK 36 35 67 37
8 Kapfenberger SV Kapfenberger 36 48 81 36
9 Mattersburg Mattersburg 36 42 71 33
10 SCR Altach SCR Altach 36 56 90 30
TEMPORADA 2007/2008
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Kapfenberger SV Kapfenberger 33 79 45 66
2 Gratkorn Gratkorn 33 51 35 55
3 Austria Lustenau Austria 33 59 45 54
4 FC Lustenau FC Lustenau 33 50 39 53
5 Austria Wien II Austria Wien 33 45 44 50
6 RB Juniors Salzburg Juniors 33 51 52 46
7 SC Schwanenstadt Schwanenstad 33 48 51 45
8 Leoben Leoben 33 44 46 41
9 Schwadorf Schwadorf 33 48 53 41
10 FC Kärnten FC Kärnten 33 37 51 40
11 Parndorf Parndorf 33 45 61 37
12 Bad Aussee Bad Aussee 33 35 70 20
TEMPORADA 2006/2007
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 LASK LASK 33 74 34 76
2 SC Schwanenstadt Schwanenstad 33 59 41 63
3 Leoben Leoben 33 55 36 55
4 Austria Lustenau Austria 33 57 50 50
5 Gratkorn Gratkorn 33 45 41 47
6 FC Lustenau FC Lustenau 33 54 51 47
7 FC Kärnten FC Kärnten 33 41 41 42
8 Austria Wien II Austria Wien 33 42 52 38
9 Parndorf Parndorf 33 41 47 35
10 Admira Admira 33 45 67 33
11 Kapfenberger SV Kapfenberger 33 41 60 32
12 TSV Hartberg Hartberg 33 31 65 26
TEMPORADA 2005/2006
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 SCR Altach SCR Altach 36 61 35 68
2 LASK LASK 36 51 30 66
3 Austria Lustenau Austria 36 54 32 62
4 Austria Wien II Austria Wien 36 58 40 58
5 Gratkorn Gratkorn 36 47 40 54
6 Leoben Leoben 36 59 49 51
7 FC Kärnten FC Kärnten 36 57 50 51
8 Kapfenberger SV Kapfenberger 36 51 69 39
9 SC Schwanenstadt Schwanenstad 36 33 57 33
10 Kufstein Kufstein 36 23 92 16
TEMPORADA 2004/2005
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 SV Ried SV Ried 36 79 38 77
2 Kapfenberger SV Kapfenberger 36 64 37 71
3 FC Kärnten FC Kärnten 36 68 41 58
4 Austria Lustenau Austria 36 55 43 56
5 Leoben Leoben 36 43 49 47
6 SCR Altach SCR Altach 36 37 45 41
7 LASK LASK 36 38 64 39
8 Untersiebenbrunn Untersiebenb 36 45 66 34
9 Gratkorn Gratkorn 36 43 58 32
10 Wörgl Wörgl 36 32 63 32
TEMPORADA 2003/2004
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Wacker Innsbruck Wacker 36 65 44 72
2 Austria Lustenau Austria 36 55 36 65
3 Kapfenberger SV Kapfenberger 36 68 55 60
4 Untersiebenbrunn Untersiebenb 36 61 48 60
5 SV Ried SV Ried 36 60 43 56
6 Leoben Leoben 36 44 44 46
7 LASK LASK 36 46 55 44
8 Wörgl Wörgl 36 48 66 37
9 FC Lustenau FC Lustenau 36 40 58 31
10 BSV Juniors BSV Juniors 36 31 69 24
TEMPORADA 2002/2003
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Mattersburg Mattersburg 36 58 33 70
2 Leoben Leoben 36 69 57 57
3 Austria Lustenau Austria 36 41 40 53
4 Untersiebenbrunn Untersiebenb 36 59 58 52
5 LASK LASK 36 47 47 49
6 Kapfenberger SV Kapfenberger 36 50 49 48
7 FC Lustenau FC Lustenau 36 53 53 46
8 Wörgl Wörgl 36 44 58 45
9 Bad Bleiberg Bleiberg 36 49 60 44
10 Wiener SC Wiener SC 36 56 71 42
TEMPORADA 2001/2002
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Kapfenberger SV Kapfenberger 30 79 29 66
2 Blau-Weiß Linz Blau-Weiß 30 62 34 61
3 TSV Hartberg Hartberg 30 54 26 59
4 Gratkorn Gratkorn 30 48 27 55
5 Spittal Spittal 30 49 30 53
6 SC Schwanenstadt Schwanenstad 30 47 35 49
7 Zeltweg Zeltweg 30 44 47 48
8 Voitsberg Voitsberg 30 42 41 41
9 Köflach Köflach 30 33 41 39
10 Eintracht Wels Eintracht 30 31 36 38
11 Union St. Florian Union 30 53 58 37
12 FC Kärnten II Kärnten 30 40 45 35
13 Bleiburg Bleiburg 30 26 34 33
14 Sankt Veit Sankt Veit 30 28 57 18
15 ATSV Wolfsberg ATSV 30 23 57 18
16 Donau Linz Donau Linz 30 27 89 8
TEMPORADA 2000/2001
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 SV Pasching SV Pasching 30 61 27 56
2 Kapfenberger SV Kapfenberger 30 50 34 51
3 TSV Hartberg Hartberg 30 47 30 48
4 BSV Juniors BSV Juniors 30 52 39 48
5 Gratkorn Gratkorn 30 44 35 45
6 Donau Linz Donau Linz 30 33 30 45
7 Blau-Weiß Linz Blau-Weiß 30 48 41 42
8 Alpe Adria Alpe Adria 30 38 44 41
9 Zeltweg Zeltweg 30 42 39 40
10 Spittal Spittal 30 47 51 39
11 Wels Wels 30 40 51 38
12 Voitsberg Voitsberg 30 40 48 37
13 Wolfsberger AC Wolfsberger 30 37 49 34
14 Union St. Florian Union 30 34 56 32
15 Lendorf Lendorf 30 24 45 31
16 SAK Klagenfurt Klagenfurt 30 29 47 26
TEMPORADA 1984/1985
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 SVL Flavia Solva Flavia Solva 30 66 23 60
2 Salzburger AK Salzburger 30 57 18 60
3 Kremser SC Kremser SC 30 52 31 59
4 Vorwarts Steyr Vorwarts 30 37 32 46
5 Sankt Veit Sankt Veit 30 42 35 43
6 Kufstein Kufstein 30 34 33 43
7 SW Bregenz SW Bregenz 30 33 39 43
8 Voitsberg Voitsberg 30 53 40 42
9 Thörl Thörl 30 37 36 42
10 WSG Tirol WSG Tirol 30 37 41 41
11 FC Salzburg FC Salzburg 30 40 48 41
12 Oberwart Oberwart 30 45 54 37
13 Simmeringer SC Simmeringer 30 29 44 34
14 Kapfenberger SV Kapfenberger 30 33 45 33
15 Badener Badener 30 30 58 22
16 Wolfsberger AC Wolfsberger 30 27 75 13
TEMPORADA 1966/1967
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 26 72 29 61
2 Wacker Innsbruck Wacker 26 58 24 59
3 Austria Wien Austria Wien 26 43 23 49
4 LASK LASK 26 39 25 43
5 Wiener SC Wiener SC 26 60 36 42
6 SW Bregenz SW Bregenz 27 26 37 39
7 First Vienna First Vienna 26 42 49 37
8 Admira Admira 26 36 25 36
9 Grazer AK Grazer AK 26 27 44 31
10 Austria Klagenfurt Austria 26 21 33 30
11 Sturm Graz Sturm Graz 26 32 47 25
12 Wacker Wien Wacker Wien 26 28 50 25
13 Wiener Neustadt Wiener 26 21 44 21
14 Kapfenberger SV Kapfenberger 27 20 59 16
TEMPORADA 1965/1966
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Admira Admira 26 51 17 43
2 Rapid Wien Rapid Wien 26 64 22 40
3 Austria Wien Austria Wien 26 58 28 35
4 Wiener SC Wiener SC 26 57 32 30
5 First Vienna First Vienna 26 52 43 30
6 Austria Klagenfurt Austria 26 39 33 29
7 LASK LASK 26 46 37 27
8 FC Wacker Innsbruck Wacker 26 32 31 25
9 Schwechat Schwechat 26 40 42 23
10 Grazer AK Grazer AK 26 35 46 23
11 Kapfenberger SV Kapfenberger 26 26 51 20
12 Wiener Neustadt Wiener 26 24 59 18
13 Salzburg Salzburg 26 25 66 12
14 Simmeringer SC Simmeringer 26 26 68 9
TEMPORADA 1964/1965
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 LASK LASK 26 49 29 50
2 Admira Admira 26 52 28 49
3 Rapid Wien Rapid Wien 26 42 21 49
4 Wiener SC Wiener SC 26 54 36 48
5 First Vienna First Vienna 26 51 36 42
6 Schwechat Schwechat 26 27 28 39
7 Austria Wien Austria Wien 26 29 28 37
8 Wacker Innsbruck Wacker 26 29 23 34
9 Wiener Neustadt Wiener 26 31 32 31
10 Sturm Graz Sturm Graz 26 29 40 26
11 Grazer AK Grazer AK 26 28 48 26
12 Kapfenberger SV Kapfenberger 26 25 45 25
13 Wiener AC Wiener AC 26 31 54 20
14 Wacker Wien Wacker Wien 26 27 56 19
TEMPORADA 1963/1964
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 26 69 27 62
2 Austria Wien Austria Wien 26 61 36 54
3 LASK LASK 26 46 36 48
4 Schwechat Schwechat 26 51 41 44
5 Wiener SC Wiener SC 26 48 53 44
6 Grazer AK Grazer AK 26 49 42 38
7 Admira Admira 26 52 49 38
8 First Vienna First Vienna 26 38 33 32
9 Wiener AC Wiener AC 26 33 38 31
10 Wiener Neustadt Wiener 26 33 47 30
11 Kapfenberger SV Kapfenberger 26 38 56 26
12 Simmeringer SC Simmeringer 26 46 64 25
13 Stickstoff Linz Stickstoff 26 42 56 22
14 Dornbirn Dornbirn 26 31 59 17
TEMPORADA 1961/1962
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Wien Austria Wien 26 65 23 61
2 LASK LASK 26 69 40 54
3 Admira Admira 26 56 34 52
4 Wiener SC Wiener SC 26 58 39 44
5 Rapid Wien Rapid Wien 26 58 32 43
6 Wiener AC Wiener AC 26 47 37 38
7 Grazer AK Grazer AK 26 43 42 37
8 Stickstoff Linz Stickstoff 26 47 50 36
9 Schwechat Schwechat 26 50 68 32
10 Simmeringer SC Simmeringer 26 37 62 31
11 First Vienna First Vienna 26 44 44 29
12 Kapfenberger SV Kapfenberger 26 29 53 21
13 Wiener Neustadt Wiener 26 30 57 17
14 Salzburger AK Salzburger 26 27 79 9
TEMPORADA 1958/1959
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Wiener SC Wiener SC 26 104 35 66
2 Rapid Wien Rapid Wien 26 102 29 65
3 First Vienna First Vienna 26 63 41 45
4 Austria Wien Austria Wien 26 63 47 43
5 Wiener AC Wiener AC 26 56 45 42
6 Simmeringer SC Simmeringer 26 63 58 36
7 Grazer AK Grazer AK 26 46 61 36
8 Wacker Wien Wacker Wien 26 57 61 33
9 Kremser SC Kremser SC 26 49 51 30
10 LASK LASK 26 46 68 30
11 Leoben Leoben 26 63 91 30
12 Admira Admira 26 55 63 27
13 Kapfenberger SV Kapfenberger 26 32 68 21
14 Olympia Wien Olympia Wien 26 25 106 10

  USO DE MEMORIA  
6,988,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.6022
Total Execution Time  0.6039
  CADENA URL  
/historico/Kapfenberger-Sv/2013
  GET DATOS  
$_GET['/historico/Kapfenberger-Sv/2013']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0252  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 = 8928
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3972 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3972 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  SELECT /*35 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 (260835,581429) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = '3972' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 8928 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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=3972 AND l.year in (2012,2013,2014) 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 (20742,8928,1364) 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 = 1364 AND teamId = 3972
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 8928 AND teamId = 3972
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 20742 AND teamId = 3972
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0138  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 events2013 e ON e.player_id = p.id AND e.league_id = 8928 WHERE rp.league_id = 8928 AND rp.teamId = 3972 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.0140  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 events2013 e ON e.player_id = p.id AND e.league_id = 8928 WHERE rp.league_id = 8928 AND rp.teamId = 3972 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 events2013 e ON e.player_id = p.id AND e.league_id = 8928 WHERE rp.league_id = 8928 AND rp.teamId = 3972 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 3972 AND l.year <= 2013 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 = 1364 AND t.round = 36 ORDER BY team.conference 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 `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 = 1093 AND t.round = 36 ORDER BY team.conference 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 `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 = 870 AND t.round = 36 ORDER BY team.conference 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 `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 = 321 AND t.round = 36 ORDER BY team.conference 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 `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 = 8921 AND t.round = 33 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 `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 = 8919 AND t.round = 33 ORDER BY team.conference 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 `tables2006` 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 = 8916 AND t.round = 36 ORDER BY team.conference 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 `tables2005` 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 = 8914 AND t.round = 36 ORDER BY team.conference 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 `tables2004` 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 = 8912 AND t.round = 36 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 `tables2003` 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 = 8911 AND t.round = 36 ORDER BY team.conference 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 `tables2002` 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 = 27565 AND t.round = 30 ORDER BY team.conference 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 `tables2001` 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 = 27556 AND t.round = 30 ORDER BY team.conference 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 `tables1985` 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 = 23111 AND t.round = 30 ORDER BY team.conference 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 `tables1967` 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 = 26094 AND t.round = 26 ORDER BY team.conference 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 `tables1966` 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 = 26097 AND t.round = 26 ORDER BY team.conference 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 `tables1965` 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 = 26100 AND t.round = 26 ORDER BY team.conference 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 `tables1964` 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 = 26102 AND t.round = 26 ORDER BY team.conference 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 `tables1962` 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 = 26112 AND t.round = 26 ORDER BY team.conference 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 `tables1959` 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 = 26119 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 8928 ORDER BY nameShow LIMIT 100