4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2016/2017
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Budapest Honved Budapest 33 55 30 65
2 Fehérvár Fehérvár 33 65 28 62
3 Budapesti Vasas Budapesti 33 50 40 52
4 Ferencvárosi Ferencváros 33 54 44 52
5 Paksi SE Paksi SE 33 41 37 45
6 Szombathelyi Haladas Szombathelyi 33 42 46 43
7 Újpest FC Újpest FC 33 47 51 42
8 Debreceni VSC Debreceni 33 42 46 41
9 Mezőkövesd-Zsory Mezőkövesd 33 39 54 40
10 Diósgyőr VTK Diósgyőr 33 39 58 37
11 MTK Budapest Budapest 33 26 36 37
12 Gyirmot Gyirmot 33 21 51 24
TEMPORADA 2015/2016
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 33 69 23 76
2 Fehérvár Fehérvár 33 42 29 55
3 Debreceni VSC Debreceni 33 48 34 53
4 MTK Budapest Budapest 33 39 37 51
5 Szombathelyi Haladas Szombathelyi 33 33 37 50
6 Újpest FC Újpest FC 33 42 37 46
7 Paksi SE Paksi SE 33 41 40 43
8 Budapest Honved Budapest 33 40 39 43
9 Diósgyőr VTK Diósgyőr 33 37 47 38
10 Budapesti Vasas Budapesti 33 32 54 32
11 Puskás Akadémia Puskás 33 35 51 31
12 Békéscsaba Békéscsaba 33 25 55 27
TEMPORADA 2014/2015
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Fehérvár Fehérvár 30 64 14 71
2 Ferencvárosi Ferencváros 30 49 19 64
3 MTK Budapest Budapest 30 39 25 57
4 Debreceni VSC Debreceni 30 44 19 54
5 Paksi SE Paksi SE 30 44 27 51
6 Újpest FC Újpest FC 30 40 28 51
7 Diósgyőr VTK Diósgyőr 30 43 36 48
8 Györi ETO Györi ETO 30 41 44 38
9 Kecskemét Kecskemét 30 30 39 38
10 Puskás Akadémia Puskás 30 35 40 35
11 Pécsi MFC Pécsi MFC 30 32 51 31
12 Nyíregyháza Spartacus FC Nyíregyház 30 33 49 30
13 Budapest Honved Budapest 30 26 36 28
14 Szombathelyi Haladas Szombathelyi 30 26 53 25
15 Dunaújváros Dunaújváro 30 26 49 23
16 Lombard Pápa TFC Lombard 30 14 57 19
TEMPORADA 2013/2014
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 30 66 33 62
2 Györi ETO Györi ETO 30 58 32 62
3 Ferencvárosi Ferencváros 30 47 33 57
4 Fehérvár Fehérvár 30 52 31 53
5 Diósgyőr VTK Diósgyőr 30 45 38 47
6 Szombathelyi Haladas Szombathelyi 30 37 31 46
7 Pécsi MFC Pécsi MFC 30 41 38 45
8 MTK Budapest Budapest 30 42 36 40
9 Budapest Honved Budapest 30 37 39 36
10 Kecskemét Kecskemét 30 36 51 36
11 Paksi SE Paksi SE 30 39 42 34
12 Lombard Pápa TFC Lombard 30 32 50 33
13 Újpest FC Újpest FC 30 46 51 32
14 Puskás Akadémia Puskás 30 36 51 31
15 Mezőkövesd-Zsory Mezőkövesd 30 27 52 24
16 Kaposvari Rakoczi Kaposvari 30 21 54 19
TEMPORADA 2012/2013
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Györi ETO Györi ETO 30 57 33 64
2 Fehérvár Fehérvár 30 52 24 54
3 Budapest Honved Budapest 30 50 36 52
4 MTK Budapest Budapest 30 43 30 51
5 Ferencvárosi Ferencváros 30 51 36 49
6 Debreceni VSC Debreceni 30 47 36 46
7 Szombathelyi Haladas Szombathelyi 30 36 27 44
8 Kecskemét Kecskemét 30 42 42 44
9 Újpest FC Újpest FC 30 40 42 41
10 Diósgyőr VTK Diósgyőr 30 31 39 38
11 Kaposvari Rakoczi Kaposvari 30 35 38 37
12 Pécsi MFC Pécsi MFC 30 33 44 37
13 Paksi SE Paksi SE 30 40 38 35
14 Lombard Pápa TFC Lombard 30 26 46 28
15 BFC Siófok BFC Siófok 30 31 61 25
16 Eger Eger 30 25 67 15
TEMPORADA 2011/2012
SEGUNDA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 MTK Budapest Budapest 30 67 20 69
2 Kozarmisleny Kozarmisleny 30 50 30 55
3 Gyirmot Gyirmot 30 50 43 52
4 FC Ajka FC Ajka 30 48 34 50
5 Tatabánya Tatabánya 30 50 34 49
6 Veszprém Veszprém 30 44 37 47
7 Szigetszentmiklosi Szigetszentm 30 52 38 45
8 Videoton II Videoton II 30 38 35 41
9 Bajai Bajai 30 46 50 37
10 Ferencváros II Ferencváros 30 46 54 36
11 BKV Előre BKV Előre 30 32 45 35
12 Paksi SE II Paksi SE II 30 27 41 31
13 Győri ETO II Győri 30 37 49 30
14 Soproni Vasutas SE Soproni 30 28 52 30
15 Dunaújváros Dunaújváro 30 25 58 28
16 Budaörsi Budaörsi 30 37 57 25
TEMPORADA 2010/2011
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Fehérvár Fehérvár 30 59 29 61
2 Paksi SE Paksi SE 30 54 38 56
3 Ferencvárosi Ferencváros 30 50 43 50
4 Zalaegerszegi TE Zalaegerszeg 30 51 47 48
5 Debreceni VSC Debreceni 30 53 43 46
6 Újpest FC Újpest FC 30 50 38 45
7 Kaposvari Rakoczi Kaposvari 30 41 42 43
8 Szombathelyi Haladas Szombathelyi 30 42 36 41
9 Györi ETO Györi ETO 30 40 35 41
10 Budapest Honved Budapest 30 36 39 40
11 Budapesti Vasas Budapesti 30 34 46 40
12 Kecskemét Kecskemét 30 51 56 36
13 Lombard Pápa TFC Lombard 30 39 52 35
14 BFC Siófok BFC Siófok 30 29 41 34
15 MTK Budapest Budapest 30 35 49 30
16 Szolnoki MÁV Szolnoki 30 26 56 21
TEMPORADA 2009/2010
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 30 63 37 62
2 Fehérvár Fehérvár 30 59 31 61
3 Györi ETO Györi ETO 30 38 18 57
4 Újpest FC Újpest FC 30 49 39 55
5 Zalaegerszegi TE Zalaegerszeg 30 59 45 53
6 MTK Budapest Budapest 30 52 41 43
7 Ferencvárosi Ferencváros 30 35 35 41
8 Szombathelyi Haladas Szombathelyi 30 46 49 39
9 Budapest Honved Budapest 30 38 35 38
10 Kecskemét Kecskemét 30 50 56 37
11 Lombard Pápa TFC Lombard 30 39 50 35
12 Kaposvari Rakoczi Kaposvari 30 38 50 32
13 Paksi SE Paksi SE 30 31 44 31
14 Budapesti Vasas Budapesti 30 39 61 31
15 Nyíregyháza Spartacus FC Nyíregyház 30 41 60 27
16 Diósgyőr VTK Diósgyőr 30 31 57 17
TEMPORADA 2008/2009
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 30 70 29 68
2 Újpest FC Újpest FC 30 61 38 59
3 Szombathelyi Haladas Szombathelyi 30 44 29 53
4 Zalaegerszegi TE Zalaegerszeg 30 52 44 52
5 Kecskemét Kecskemét 30 55 44 48
6 Fehérvár Fehérvár 30 42 34 48
7 MTK Budapest Budapest 30 43 41 45
8 Györi ETO Györi ETO 30 57 41 43
9 Kaposvari Rakoczi Kaposvari 30 51 46 40
10 Budapesti Vasas Budapesti 30 42 52 38
11 Paksi SE Paksi SE 30 38 51 35
12 Diósgyőr VTK Diósgyőr 30 29 45 33
13 Nyíregyháza Spartacus FC Nyíregyház 30 32 41 32
14 Budapest Honved Budapest 30 31 46 32
15 BFC Siófok BFC Siófok 30 30 56 26
16 REAC REAC 30 33 73 15
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 2
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 10 15 15 59
2 Sopron Sopron 10 18 14 58
3 Újpest FC Újpest FC 10 16 7 56
4 Debreceni VSC Debreceni 10 17 15 56
5 BFC Siófok BFC Siófok 10 10 13 50
6 MTK Budapest Budapest 10 7 19 44
TEMPORADA 2002/2003
LIGA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 MTK Budapest Budapest 10 17 13 19
2 Ferencvárosi Ferencváros 10 9 7 16
3 BFC Siófok BFC Siófok 10 18 17 15
4 Debreceni VSC Debreceni 10 13 8 14
5 Újpest FC Újpest FC 10 9 12 12
6 Györi ETO Györi ETO 10 6 15 4
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 2
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 22 36 14 44
2 Dunaújváros Dunaújváro 22 40 35 41
3 Györi ETO Györi ETO 22 34 32 38
4 Budapesti Vasas Budapesti 22 42 33 36
5 Újpest FC Újpest FC 22 40 37 35
6 Budapest Honved Budapest 22 33 31 33
7 MTK Budapest Budapest 22 31 22 29
8 Fehérvár Fehérvár 22 37 34 29
9 Zalaegerszegi TE Zalaegerszeg 22 33 36 28
10 Sopron Sopron 22 26 30 27
11 Debreceni VSC Debreceni 22 31 44 21
12 Tatabánya Tatabánya 22 20 55 6

  USO DE MEMORIA  
7,393,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1758
Total Execution Time  0.1770
  CADENA URL  
/historico/Mtk/2017
  GET DATOS  
$_GET['/historico/Mtk/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (51)  
0.0034  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 = 'Mtk' AND l.year = 2017 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.0019  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=10020 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=10020 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=10020 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=10020 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=10020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=10020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0028  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 = 31916
0.0024  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 = 33326
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10020 AND type_rel = 2
0.0036  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.0031  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' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0030  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.0023  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 = 35218 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 = 33326 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 29300 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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 (2016,2017,2018) 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 (40058,39020,38427,33326,29300) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 29300 AND teamId = 10020
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 39020 AND teamId = 10020
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 33326 AND teamId = 10020
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 40058 AND teamId = 10020
0.0100  SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 10020
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 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 = 29300 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10020' and rp.type = 4
0.0019  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.0060  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 events2017 e ON e.player_id = p.id AND e.league_id = 29300 WHERE rp.league_id = 29300 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.0043  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 events2017 e ON e.player_id = p.id AND e.league_id = 29300 WHERE rp.league_id = 29300 AND rp.teamId = 10020 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 events2017 e ON e.player_id = p.id AND e.league_id = 29300 WHERE rp.league_id = 29300 AND rp.teamId = 10020 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 29300 AND t.round = 33 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 `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 = 15703 AND t.round = 33 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 = 3867 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 `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 = 2483 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 `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 = 2036 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 `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 = 14531 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 = 1092 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 = 872 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 `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.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 `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.0030  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.0029  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.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 `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.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 `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.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 `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.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 `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.0021  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.0021  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.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 `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.0019  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 = 29300 ORDER BY nameShow LIMIT 100