4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del MTK Budapest

MTK Budapest

Entrenador: Dávid Horváth

Temporada 2007/2008
TEMPORADA 2007/2008
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 MTK Budapest Budapest 30 67 23 66
2 Debreceni VSC Debreceni 30 67 29 64
3 Györi ETO Györi ETO 30 64 35 58
4 Újpest FC Újpest FC 30 58 40 55
5 Fehérvár Fehérvár 30 48 32 54
6 Kaposvari Rakoczi Kaposvari 30 48 38 51
7 Zalaegerszegi TE Zalaegerszeg 30 55 39 46
8 Budapest Honved Budapest 30 45 36 43
9 Budapesti Vasas Budapesti 30 41 45 41
10 Nyíregyháza Spartacus FC Nyíregyház 30 34 37 40
11 Paksi SE Paksi SE 30 51 51 37
12 REAC REAC 30 42 60 30
13 Diósgyőr VTK Diósgyőr 30 43 63 28
14 BFC Siófok BFC Siófok 30 33 46 27
15 Tatabánya Tatabánya 30 34 93 10
16 Sopron Sopron 30 10 73 0
TEMPORADA 2006/2007
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 30 63 21 69
2 MTK Budapest Budapest 30 61 33 61
3 Zalaegerszegi TE Zalaegerszeg 30 54 38 55
4 Újpest FC Újpest FC 30 39 32 46
5 Budapesti Vasas Budapesti 30 43 41 45
6 Fehérvár Fehérvár 30 45 43 44
7 Budapest Honved Budapest 30 48 43 41
8 Kaposvari Rakoczi Kaposvari 30 40 36 41
9 Diósgyőr VTK Diósgyőr 30 40 52 38
10 Paksi SE Paksi SE 30 34 38 37
11 Sopron Sopron 30 33 46 37
12 Tatabánya Tatabánya 30 46 58 36
13 Györi ETO Györi ETO 30 37 43 35
14 REAC REAC 30 42 55 34
15 Pécsi MFC Pécsi MFC 30 31 41 33
16 Samsung Vác FC Samsung Vác 30 21 57 19
TEMPORADA 2005/2006
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 30 69 34 68
2 Újpest FC Újpest FC 30 74 37 65
3 Fehérvár Fehérvár 30 52 24 64
4 MTK Budapest Budapest 30 65 33 60
5 Ferencvárosi Ferencváros 30 43 38 41
6 Tatabánya Tatabánya 30 46 45 41
7 Kaposvari Rakoczi Kaposvari 30 35 41 37
8 Diósgyőr VTK Diósgyőr 30 33 44 37
9 Györi ETO Györi ETO 30 47 50 36
10 Sopron Sopron 30 39 39 35
11 Zalaegerszegi TE Zalaegerszeg 30 42 47 35
12 Pécsi MFC Pécsi MFC 30 37 41 33
13 Budapest Honved Budapest 30 33 52 33
14 REAC REAC 30 30 59 26
15 Budapesti Vasas Budapesti 30 32 47 25
16 Lombard Pápa TFC Lombard 30 30 76 22
TEMPORADA 2004/2005
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 30 57 25 62
2 Ferencvárosi Ferencváros 30 56 31 56
3 MTK Budapest Budapest 30 47 26 56
4 Újpest FC Újpest FC 30 60 34 55
5 Györi ETO Györi ETO 30 44 32 54
6 Zalaegerszegi TE Zalaegerszeg 30 48 45 44
7 Sopron Sopron 30 44 44 42
8 Fehérvár Fehérvár 30 44 36 40
9 Diósgyőr VTK Diósgyőr 30 39 45 37
10 Pécsi MFC Pécsi MFC 30 33 35 36
11 Budapest Honved Budapest 30 37 58 35
12 Kaposvari Rakoczi Kaposvari 30 34 47 34
13 Budapesti Vasas Budapesti 30 34 48 33
14 Lombard Pápa TFC Lombard 30 40 47 30
15 Nyíregyháza Spartacus FC Nyíregyház 30 38 63 26
16 Békéscsaba Békéscsaba 30 26 65 4
TEMPORADA 2003/2004
LIGA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 22 29 15 44
2 BFC Siófok BFC Siófok 22 24 11 41
3 Debreceni VSC Debreceni 22 34 17 39
4 MTK Budapest Budapest 22 35 21 38
5 Újpest FC Újpest FC 22 32 22 35
6 Sopron Sopron 22 35 28 31
7 Pécsi MFC Pécsi MFC 22 19 21 27
8 Fehérvár Fehérvár 22 27 37 23
9 Zalaegerszegi TE Zalaegerszeg 22 24 35 20
10 Györi ETO Györi ETO 22 23 38 20
11 Békéscsaba Békéscsaba 22 23 34 19
12 Szombathelyi Haladas Szombathelyi 22 12 38 17
TEMPORADA 2002/2003
LIGA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 22 41 17 48
2 MTK Budapest Budapest 22 42 21 47
3 Újpest FC Újpest FC 22 45 29 40
4 Debreceni VSC Debreceni 22 44 30 39
5 BFC Siófok BFC Siófok 22 28 27 32
6 Györi ETO Györi ETO 22 35 35 32
7 Zalaegerszegi TE Zalaegerszeg 22 37 36 30
8 Fehérvár Fehérvár 22 29 30 27
9 Sopron Sopron 22 33 36 23
10 Dunaferr Dunaferr 22 28 43 18
11 Budapest Honved Budapest 22 27 51 15
12 Békéscsaba Békéscsaba 22 25 59 14
TEMPORADA 2001/2002
LIGA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 MTK Budapest Budapest 33 56 34 64
2 Zalaegerszegi TE Zalaegerszeg 33 65 40 61
3 Ferencvárosi Ferencváros 33 58 34 59
4 Dunaferr Dunaferr 33 62 38 53
5 Fehérvár Fehérvár 33 45 47 46
6 Újpest FC Újpest FC 33 58 57 44
7 Sopron Sopron 33 47 51 40
8 Györi ETO Györi ETO 33 45 57 38
9 Budapest Honved Budapest 33 40 63 38
10 Debreceni VSC Debreceni 33 34 45 36
11 Szombathelyi Haladas Szombathelyi 33 41 62 35
12 Budapesti Vasas Budapesti 33 42 65 27
TEMPORADA 2000/2001
LIGA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Dunaújváros Dunaújváro 14 37 20 29
2 Tatabánya Tatabánya 14 29 18 29
3 Ferencvárosi Ferencváros 14 23 21 21
4 Sopron Sopron 14 21 23 20
5 Györi ETO Györi ETO 14 21 23 18
6 Budapest Honved Budapest 14 18 20 15
7 Szombathelyi Haladas Szombathelyi 14 14 24 13
8 Nyíregyháza Spartacus FC Nyíregyház 14 10 24 9
9 MTK Budapest Budapest 14 32 13 27
10 Újpest FC Újpest FC 14 33 19 25
11 Budapesti Vasas Budapesti 14 24 11 25
12 Debreceni VSC Debreceni 14 27 20 23
13 Fehérvár Fehérvár 14 21 22 21
14 Zalaegerszegi TE Zalaegerszeg 14 12 22 16
15 Pécsi MFC Pécsi MFC 14 13 24 9
16 Nagykanizsa Nagykanizsa 14 12 43 8
TEMPORADA 1999/2000
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
TEMPORADA 1997/1998
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Újpest FC Újpest FC 34 62 26 73
2 Ferencvárosi Ferencváros 34 63 43 67
3 Budapesti Vasas Budapesti 34 66 41 64
4 Györi ETO Györi ETO 34 47 31 63
5 MTK Budapest Budapest 34 60 35 58
6 Samsung Vác FC Samsung Vác 34 45 47 51
7 Zalaegerszegi TE Zalaegerszeg 34 58 42 50
8 Gazszer Gazszer 34 55 45 49
9 Debreceni VSC Debreceni 34 46 48 48
10 Budapest BVSC Budapest 34 49 43 46
11 Diósgyőr VTK Diósgyőr 34 46 41 44
12 BFC Siófok BFC Siófok 34 38 43 41
13 Szombathelyi Haladas Szombathelyi 34 38 47 36
14 Budapest Honved Budapest 34 41 57 36
15 Tiszakécske Tiszakécske 34 36 75 32
16 Fehérvár Fehérvár 34 43 58 31
17 Békéscsaba Békéscsaba 34 28 61 31
18 Stadler Stadler 34 29 67 22
TEMPORADA 1996/1997
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 MTK Budapest Budapest 34 87 25 85
2 Újpest FC Újpest FC 34 75 35 76
3 Ferencvárosi Ferencváros 34 69 37 74
4 Budapesti Vasas Budapesti 34 50 33 64
5 Debreceni VSC Debreceni 34 55 38 52
6 Budapest BVSC Budapest 34 43 36 49
7 Budapest Honved Budapest 34 42 44 45
8 Fehérvár Fehérvár 34 45 44 42
9 Györi ETO Györi ETO 34 44 51 42
10 Szombathelyi Haladas Szombathelyi 34 39 42 40
11 Samsung Vác FC Samsung Vác 34 40 48 40
12 BFC Siófok BFC Siófok 34 36 53 40
13 Zalaegerszegi TE Zalaegerszeg 34 34 51 40
14 Békéscsaba Békéscsaba 34 37 62 36
15 III. Kerületi TVE III. 34 45 55 35
16 Stadler Stadler 34 27 50 28
17 Pécsi MFC Pécsi MFC 34 31 68 26
18 Csepel FC Csepel FC 34 43 70 25
TEMPORADA 1995/1996
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 30 56 25 66
2 Budapest BVSC Budapest 30 50 29 61
3 Újpest FC Újpest FC 30 43 31 48
4 Debreceni VSC Debreceni 30 49 40 48
5 MTK Budapest Budapest 30 58 43 46
6 Budapest Honved Budapest 30 49 35 46
7 Budapesti Vasas Budapesti 30 44 40 46
8 Csepel FC Csepel FC 30 46 45 42
9 Stadler Stadler 30 35 41 36
10 Zalaegerszegi TE Zalaegerszeg 30 42 48 34
11 Samsung Vác FC Samsung Vác 30 39 46 33
12 Szombathelyi Haladas Szombathelyi 30 30 48 32
13 Fehérvár Fehérvár 30 38 54 31
14 Békéscsaba Békéscsaba 30 33 46 29
15 Györi ETO Györi ETO 30 34 54 27
16 Pécsi MFC Pécsi MFC 30 32 53 26
TEMPORADA 1989/1990
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Újpest FC Újpest FC 30 43 20 58
2 MTK Budapest Budapest 30 48 26 58
3 Ferencvárosi Ferencváros 30 48 34 48
4 Pécsi MFC Pécsi MFC 30 37 23 48
5 Tatabánya Tatabánya 30 24 28 43
6 Veszprém Veszprém 30 27 24 41
7 BFC Siófok BFC Siófok 30 31 34 39
8 Budapesti Vasas Budapesti 30 35 42 39
9 Fehérvár Fehérvár 30 26 30 38
10 Békéscsaba Békéscsaba 30 26 34 38
11 Samsung Vác FC Samsung Vác 30 30 31 36
12 Györi ETO Györi ETO 30 34 30 35
13 Budapest Honved Budapest 30 31 39 35
14 Debreceni VSC Debreceni 30 20 30 35
15 Szombathelyi Haladas Szombathelyi 30 33 46 33
16 Csepel FC Csepel FC 30 27 49 25
TEMPORADA 1988/1989
LIGA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Fehérvár Fehérvár 30 57 32 56
2 Ferencvárosi Ferencváros 30 49 29 55
3 Budapest Honved Budapest 30 44 28 55
4 Györi ETO Györi ETO 30 44 31 53
5 MTK Budapest Budapest 30 41 34 50
6 Tatabánya Tatabánya 30 39 35 45
7 Békéscsaba Békéscsaba 30 40 36 42
8 Samsung Vác FC Samsung Vác 30 33 34 40
9 Újpest FC Újpest FC 30 37 35 39
10 Pécsi MFC Pécsi MFC 30 35 37 37
11 Veszprém Veszprém 30 23 35 35
12 BFC Siófok BFC Siófok 30 34 41 34
13 Budapesti Vasas Budapesti 30 35 58 33
14 Zalaegerszegi TE Zalaegerszeg 30 38 45 30
15 Szombathelyi Haladas Szombathelyi 30 31 44 30
16 Dunaújváros Dunaújváro 30 26 52 20

  USO DE MEMORIA  
6,964,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7226
Total Execution Time  0.7237
  CADENA URL  
/historico/Mtk/2008
  GET DATOS  
$_GET['/historico/Mtk/2008']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0254  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 = 42353
0.0132  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 = 12666
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10020 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=95 AND type_rel = 3
0.0131  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 95 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0136  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 (1305161,1268453,1213703,1180004,1177461) ORDER BY n.cover_points DESC, update_date DESC
0.0176  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 = '10020' ORDER BY l.year DESC,cat.coefficient DESC
0.0173  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 = '10020' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137  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 = 21224 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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 = 42353 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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 = 665 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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 = 12666 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0181  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=10020 AND l.year in (2007,2008,2009) 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 (42353,40656,21226,12666,666) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 666 AND teamId = 10020
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 40656 AND teamId = 10020
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 42353 AND teamId = 10020
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 21226 AND teamId = 10020
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 12666 AND teamId = 10020
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 `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 = 665 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '10020' 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 = '10020' 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 = '10020' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0136  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 events2008 e ON e.player_id = p.id AND e.league_id = 665 WHERE rp.league_id = 665 AND rp.teamId = 10020 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.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 events2008 e ON e.player_id = p.id AND e.league_id = 665 WHERE rp.league_id = 665 AND rp.teamId = 10020 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 events2008 e ON e.player_id = p.id AND e.league_id = 665 WHERE rp.league_id = 665 AND rp.teamId = 10020 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 = 10020 AND l.year <= 2008 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 `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 = 665 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 `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 = 666 AND t.round = 30 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 `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 = 667 AND t.round = 30 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 = 668 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 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 = 10472 AND t.round = 10 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 `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 = 669 AND t.round = 22 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 = 13991 AND t.round = 10 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 `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 = 670 AND t.round = 22 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 `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 = 14001 AND t.round = 5 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 `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 = 671 AND t.round = 33 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 `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 = 14007 AND t.round = 22 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 = 672 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 `tables2000` 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 = 673 AND t.round = 34 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 `tables1998` 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 = 13983 AND t.round = 34 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 `tables1997` 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 = 13985 AND t.round = 34 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 `tables1996` 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 = 13986 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 `tables1990` 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 = 26393 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables1989` 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 = 26390 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC