4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Feldkirchen
TEMPORADA 2015/2016
CUARTA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Ferlach Ferlach 30 81 41 68
2 ATSV Wolfsberg ATSV 30 77 30 65
3 SAK Klagenfurt Klagenfurt 30 65 38 52
4 Treibach Treibach 30 53 46 46
5 Lendorf Lendorf 30 50 54 45
6 ASKÖ Gmünd ASKÖ Gmünd 30 46 44 44
7 Feldkirchen Feldkirchen 30 49 55 44
8 Völkermarkt Völkermarkt 30 40 38 43
9 Bleiburg Bleiburg 30 41 43 41
10 Köttmannsdorf Köttmannsdo 30 36 36 40
11 Spittal Spittal 30 52 53 38
12 Rapid Lienz Rapid Lienz 30 36 48 35
13 Maria Saal Maria Saal 30 41 56 32
14 Kühnsdorf Kühnsdorf 30 30 47 29
15 SC Globasnitz Globasnitz 30 38 75 27
16 St. Michael St. Michael 30 26 57 16
TEMPORADA 2014/2015
CUARTA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Annabichler Austria Annabichler 30 77 34 69
2 Völkermarkt Völkermarkt 30 61 28 65
3 Köttmannsdorf Köttmannsdo 30 63 33 61
4 Ferlach Ferlach 30 65 43 51
5 ASKÖ Gmünd ASKÖ Gmünd 30 56 48 49
6 Treibach Treibach 30 58 53 44
7 Feldkirchen Feldkirchen 30 60 43 41
8 Maria Saal Maria Saal 30 50 51 41
9 St. Michael St. Michael 30 45 48 41
10 Lendorf Lendorf 30 62 57 37
11 Bleiburg Bleiburg 30 40 50 36
12 Kühnsdorf Kühnsdorf 30 48 52 35
13 Spittal Spittal 30 46 62 31
14 Blau Weiss Sachsenburg Blau Weiss. 30 55 72 27
15 St. Veit Glan Veit Glan 30 45 71 26
16 SV Villach SV Villach 30 28 114 14
TEMPORADA 2013/2014
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 ATSV Wolfsberg ATSV 30 58 20 65
2 Feldkirchen Feldkirchen 30 66 32 58
3 Lendorf Lendorf 30 58 39 56
4 Völkermarkt Völkermarkt 30 50 31 53
5 Bleiburg Bleiburg 30 60 38 50
6 Treibach Treibach 30 51 40 48
7 Annabichler Austria Annabichler 30 54 48 46
8 Köttmannsdorf Köttmannsdo 30 46 42 44
9 Maria Saal Maria Saal 30 57 57 42
10 ASKÖ Gmünd ASKÖ Gmünd 30 43 48 41
11 Ferlach Ferlach 30 48 47 40
12 St. Veit Glan Veit Glan 30 38 64 33
13 Spittal Spittal 30 61 72 31
14 Drautal Drautal 30 36 50 27
15 Steinfeld Steinfeld 30 44 91 19
16 Landskron Landskron 30 39 90 19
TEMPORADA 2012/2013
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 LASK LASK 28 75 15 68
2 SV Pasching SV Pasching 28 64 19 66
3 SAK Klagenfurt Klagenfurt 28 54 48 47
4 Kalsdorf Kalsdorf 28 62 48 43
5 SV Villach SV Villach 28 46 40 43
6 Union St. Florian Union 28 34 37 37
7 Allerheiligen Allerheilige 28 46 52 36
8 Austria Klagenfurt Austria 28 40 48 35
9 Gratkorn Gratkorn 28 50 53 34
10 SV Wallern SV Wallern 28 24 31 34
11 Vöcklamarkt Vöcklamarkt 28 38 46 33
12 Sturm Graz II Sturm Graz 28 36 47 32
13 Kapfenberger SV KM II Kapfenberger 28 27 50 27
14 Feldkirchen Feldkirchen 28 36 69 23
15 Leoben Leoben 28 32 61 19
16 Grazer AK Grazer AK 0 0 0 0
TEMPORADA 2011/2012
CUARTA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Feldkirchen Feldkirchen 30 62 32 60
2 St. Veit Glan Veit Glan 30 57 35 59
3 Drautal Drautal 30 50 31 59
4 Lendorf Lendorf 30 65 47 55
5 Spittal Spittal 30 61 36 50
6 ATSV Wolfsberg ATSV 30 60 48 44
7 Treibach Treibach 30 57 54 43
8 Völkermarkt Völkermarkt 30 43 36 41
9 Rapid Lienz Rapid Lienz 30 41 44 40
10 WAC Sankt Andrä II Sankt Andrä 30 39 43 37
11 SV Raiba Ruden Raiba Ruden 30 57 72 36
12 Maria Saal Maria Saal 30 42 58 36
13 Ferlach Ferlach 30 47 60 33
14 Bleiburg Bleiburg 30 38 52 31
15 Hermagor Hermagor 30 33 63 21
16 Eberndorfer AC Eberndorfer 30 33 74 15
TEMPORADA 2010/2011
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 LASK Juniors LASK Juniors 30 55 37 58
2 Blau-Weiß Linz Blau-Weiß 30 55 27 57
3 Grazer AK Grazer AK 30 59 37 54
4 Allerheiligen Allerheilige 30 45 29 52
5 Union St. Florian Union 30 43 37 45
6 SV Pasching SV Pasching 30 38 33 45
7 Austria Klagenfurt Austria 30 42 37 43
8 SV Gleinstätten Gleinstätte 30 49 49 41
9 Vöcklamarkt Vöcklamarkt 30 45 45 38
10 SAK Klagenfurt Klagenfurt 30 38 40 38
11 Leoben Leoben 30 47 51 37
12 Sturm Graz II Sturm Graz 30 48 61 34
13 Wels Wels 30 21 42 33
14 Feldkirchen Feldkirchen 30 36 55 27
15 Weiz Weiz 30 34 53 26
16 Voitsberg Voitsberg 30 30 52 21
TEMPORADA 2009/2010
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Feldkirchen Feldkirchen 30 49 29 58
2 Lendorf Lendorf 30 54 32 56
3 Treibach Treibach 30 53 27 55
4 Bleiburg Bleiburg 30 69 40 51
5 SV Villach SV Villach 30 54 39 51
6 ATSV Wolfsberg ATSV 30 43 48 49
7 Rapid Lienz Rapid Lienz 30 48 42 47
8 Austria Kärnten II Austria 30 47 44 44
9 Völkermarkt Völkermarkt 30 53 48 43
10 WAC Sankt Andrä II Sankt Andrä 30 53 49 43
11 UFC Maria Alm Maria 30 29 26 40
12 Welzenegg Welzenegg 30 28 49 32
13 Spittal Spittal 30 52 64 30
14 St. Michael St. Michael 30 33 57 29
15 Penk Penk 30 33 56 25
16 Sittersdorf Sittersdorf 30 39 87 17
TEMPORADA 2008/2009
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 TSV Hartberg Hartberg 30 63 25 64
2 Grazer AK Grazer AK 30 68 32 64
3 Sturm Graz II Sturm Graz 30 52 32 56
4 Voitsberg Voitsberg 30 65 37 54
5 WAC Sankt Andrä Sankt Andrä 30 41 30 54
6 Wels Wels 30 62 51 47
7 Blau-Weiß Linz Blau-Weiß 30 50 35 43
8 Union St. Florian Union 30 49 41 40
9 SAK Klagenfurt Klagenfurt 30 46 46 38
10 Allerheiligen Allerheilige 30 38 38 38
11 Weiz Weiz 30 48 52 34
12 St. Veit Glan Veit Glan 30 43 62 30
13 Bad Aussee Bad Aussee 30 29 66 28
14 Feldkirchen Feldkirchen 30 39 66 27
15 FC Kärnten FC Kärnten 30 22 70 23
16 Spittal Spittal 30 31 63 19
TEMPORADA 2007/2008
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Vöcklabruck Vöcklabruck 30 70 23 68
2 Feldkirchen Feldkirchen 30 66 45 52
3 Grazer AK Grazer AK 30 57 37 52
4 WAC Sankt Andrä Sankt Andrä 30 41 26 52
5 Sturm Graz II Sturm Graz 30 52 40 52
6 Allerheiligen Allerheilige 30 40 35 52
7 TSV Hartberg Hartberg 30 45 38 44
8 Wels Wels 30 57 46 43
9 SAK Klagenfurt Klagenfurt 30 44 43 41
10 Union St. Florian Union 30 44 45 38
11 Austria Kärnten II Austria 30 40 52 38
12 Weiz Weiz 30 45 47 35
13 Spittal Spittal 30 34 42 30
14 Gmunden Gmunden 30 33 69 26
15 Grieskirchen Grieskirchen 30 30 55 22
16 Bleiburg Bleiburg 30 19 74 10
TEMPORADA 2006/2007
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Bad Aussee Bad Aussee 30 62 31 57
2 Wels Wels 30 58 34 56
3 Feldkirchen Feldkirchen 30 51 35 53
4 WAC Sankt Andrä Sankt Andrä 30 43 30 51
5 Vöcklabruck Vöcklabruck 30 41 28 47
6 Spittal Spittal 30 37 43 45
7 SAK Klagenfurt Klagenfurt 30 45 46 44
8 Allerheiligen Allerheilige 30 40 32 43
9 Sturm Graz II Sturm Graz 30 42 45 37
10 Union St. Florian Union 30 35 50 35
11 Grieskirchen Grieskirchen 30 33 38 34
12 FC Kärnten II Kärnten 30 35 46 34
13 Voitsberg Voitsberg 30 44 48 33
14 Blau-Weiß Linz Blau-Weiß 30 33 38 33
15 Köflach Köflach 30 29 59 30
16 Union Perg Union Perg 30 28 53 26
TEMPORADA 2005/2006
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 TSV Hartberg Hartberg 30 54 28 63
2 Spittal Spittal 30 48 35 54
3 Feldkirchen Feldkirchen 30 43 38 53
4 Voitsberg Voitsberg 30 44 38 48
5 WAC Sankt Andrä Sankt Andrä 30 49 33 45
6 Union St. Florian Union 30 45 33 44
7 Köflach Köflach 30 46 42 43
8 Wels Wels 30 41 40 40
9 SAK Klagenfurt Klagenfurt 30 39 55 39
10 Bad Aussee Bad Aussee 30 38 34 37
11 Sturm Graz II Sturm Graz 30 52 46 35
12 Blau-Weiß Linz Blau-Weiß 30 32 42 34
13 FC Superfund II Superfund 30 36 42 31
14 Vöcklabruck Vöcklabruck 30 37 49 31
15 Union Perg Union Perg 30 27 43 31
16 Bleiburg Bleiburg 30 30 63 24
TEMPORADA 2004/2005
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 SC Schwanenstadt Schwanenstad 30 43 26 62
2 TSV Hartberg Hartberg 30 55 33 50
3 Spittal Spittal 30 56 43 48
4 FC Superfund II Superfund 30 57 41 47
5 Köflach Köflach 30 42 32 47
6 Sturm Graz II Sturm Graz 30 49 46 44
7 Union St. Florian Union 30 36 30 43
8 Bleiburg Bleiburg 30 37 52 40
9 Feldkirchen Feldkirchen 30 46 55 38
10 Blau-Weiß Linz Blau-Weiß 30 33 32 37
11 WAC Sankt Andrä Sankt Andrä 30 36 41 37
12 Voitsberg Voitsberg 30 39 42 35
13 Wels Wels 30 34 42 35
14 Union Perg Union Perg 30 31 45 34
15 FC Kärnten II Kärnten 30 30 41 31
16 Kalsdorf Kalsdorf 30 32 55 21
TEMPORADA 2002/2003
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Wacker Innsbruck Wacker 30 101 17 80
2 SCR Altach SCR Altach 30 108 40 68
3 SV Hall SV Hall 30 52 39 56
4 Kufstein Kufstein 30 71 45 52
5 SK Schärding Schärding 30 69 52 45
6 RB Juniors Salzburg Juniors 30 64 56 45
7 Reichenau Reichenau 30 48 48 44
8 Puch Puch 30 53 42 41
9 Seekirchen Seekirchen 30 53 63 35
10 Feldkirchen Feldkirchen 30 52 59 34
11 ASK PSV Salzburg Salzburg 30 41 55 34
12 Salzburger AK Salzburger 30 22 46 30
13 Rot-Weiß Rankweil Rot-Weiß 30 41 69 29
14 Hohenems Hohenems 30 47 83 28
15 Kundl Kundl 30 43 93 23
16 SK Rum SK Rum 30 34 92 21
TEMPORADA 2000/2001
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 FC Lustenau FC Lustenau 30 103 32 72
2 SCR Altach SCR Altach 30 90 28 65
3 Kufstein Kufstein 30 67 34 62
4 RB Juniors Salzburg Juniors 30 68 38 54
5 Kundl Kundl 30 60 42 51
6 Feldkirchen Feldkirchen 30 55 53 49
7 Hard Hard 30 76 42 47
8 Puch Puch 30 52 39 43
9 Reichenau Reichenau 30 46 63 38
10 Schwarzach Schwarzach 30 38 51 37
11 Hohenems Hohenems 30 44 60 37
12 Salzburger AK Salzburger 30 43 44 33
13 Nenzing Nenzing 30 33 59 32
14 Kirchbichl Kirchbichl 30 29 64 24
15 Tirol Innsbruck II Tirol 30 37 80 21
16 Jenbach Jenbach 30 14 126 5

  USO DE MEMORIA  
6,536,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6257
Total Execution Time  0.6269
  CADENA URL  
/historico/Feldkirchen/2016
  GET DATOS  
$_GET['/historico/Feldkirchen/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0136  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 = 'Feldkirchen' AND l.year = 2016 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=18110 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=18110 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0287  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 = 15764
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18110 AND type_rel = 2
0.0135  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 = '18110' ORDER BY l.year DESC,cat.coefficient DESC
0.0141  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 = '18110' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0138  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 = '18110' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150  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 = '18110' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0136  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 = 15764 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  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=18110 AND l.year in (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0133  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 (38903,30386) 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.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 38903 AND teamId = 18110
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 30386 AND teamId = 18110
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 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 = 15764 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129  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 = '18110' 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 = '18110' and rp.type = 4
0.0126  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 = '18110' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2016 e ON e.player_id = p.id AND e.league_id = 15764 WHERE rp.league_id = 15764 AND rp.teamId = 18110 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.0134  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 events2016 e ON e.player_id = p.id AND e.league_id = 15764 WHERE rp.league_id = 15764 AND rp.teamId = 18110 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 events2016 e ON e.player_id = p.id AND e.league_id = 15764 WHERE rp.league_id = 15764 AND rp.teamId = 18110 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 18110 AND l.year <= 2016 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 `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 = 15764 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 `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 = 3935 AND t.round = 30 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 `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 = 27162 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 `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 = 24526 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 `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 = 27189 AND t.round = 30 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 `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 = 24532 AND t.round = 30 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 `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 = 27226 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 24538 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 24541 AND t.round = 30 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 `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 = 27600 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 `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 = 27592 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 `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 = 27576 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 `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 = 44524 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 `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 = 27567 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 15764 ORDER BY nameShow LIMIT 100