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

FC Tokyo

Entrenador: Peter Cklamovski

Temporada 2020/2021
TEMPORADA 2020/2021
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Kawasaki Frontale Kawasaki 38 81 28 92
2 Yokohama F. Marinos Yokohama 38 82 35 79
3 Vissel Kobe Vissel Kobe 38 62 36 73
4 Kashima Antlers Kashima 38 62 36 69
5 Nagoya Grampus Nagoya 38 44 30 66
6 Urawa Reds Urawa Reds 38 47 38 63
7 Sagan Tosu Sagan Tosu 38 43 35 59
8 Avispa Fukuoka Avispa 38 42 37 54
9 FC Tokyo FC Tokyo 38 49 53 53
10 Consadole Sapporo Consadole 38 48 50 51
11 Sanfrecce Hiroshima Sanfrecce 38 44 42 49
12 Cerezo Osaka Cerezo Osaka 38 47 51 48
13 Gamba Osaka Gamba Osaka 38 33 49 44
14 Shimizu S-Pulse Shimizu 38 37 54 42
15 Kashiwa Reysol Kashiwa 38 37 56 41
16 Shonan Bellmare Shonan 38 36 43 37
17 Tokushima Vortis Tokushima 38 34 55 36
18 Oita Trinita Oita Trinita 38 31 55 35
19 Vegalta Sendai Vegalta 38 31 62 28
20 Yokohama Yokohama 38 32 77 27
TEMPORADA 2019/2020
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Kawasaki Frontale Kawasaki 34 88 31 83
2 Gamba Osaka Gamba Osaka 34 46 42 65
3 Nagoya Grampus Nagoya 34 44 27 63
4 Cerezo Osaka Cerezo Osaka 34 46 37 60
5 Kashima Antlers Kashima 34 54 43 59
6 FC Tokyo FC Tokyo 34 47 42 57
7 Kashiwa Reysol Kashiwa 34 60 46 52
8 Sanfrecce Hiroshima Sanfrecce 34 46 37 48
9 Yokohama F. Marinos Yokohama 34 69 59 47
10 Urawa Reds Urawa Reds 34 43 56 46
11 Oita Trinita Oita Trinita 34 36 45 43
12 Sagan Tosu Sagan Tosu 33 37 41 36
13 Vissel Kobe Vissel Kobe 34 50 59 36
14 Consadole Sapporo Consadole 33 45 58 36
15 Yokohama Yokohama 34 38 60 33
16 Shimizu S-Pulse Shimizu 34 48 70 28
17 Vegalta Sendai Vegalta 34 36 61 28
18 Shonan Bellmare Shonan 34 29 48 27
TEMPORADA 2018/2019
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Yokohama F. Marinos Yokohama 34 68 38 70
2 FC Tokyo FC Tokyo 34 46 29 64
3 Kashima Antlers Kashima 34 54 30 63
4 Kawasaki Frontale Kawasaki 34 57 34 60
5 Cerezo Osaka Cerezo Osaka 34 39 25 59
6 Sanfrecce Hiroshima Sanfrecce 34 45 29 55
7 Gamba Osaka Gamba Osaka 34 54 48 47
8 Vissel Kobe Vissel Kobe 34 61 59 47
9 Oita Trinita Oita Trinita 34 35 35 47
10 Consadole Sapporo Consadole 34 54 49 46
11 Vegalta Sendai Vegalta 34 38 45 41
12 Shimizu S-Pulse Shimizu 34 45 69 39
13 Nagoya Grampus Nagoya 34 45 50 37
14 Urawa Reds Urawa Reds 34 34 50 37
15 Sagan Tosu Sagan Tosu 34 32 53 36
16 Shonan Bellmare Shonan 34 40 63 36
17 Matsumoto Yamaga Matsumoto 34 21 40 31
18 Júbilo Iwata Júbilo 34 29 51 31
TEMPORADA 2017/2018
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Kawasaki Frontale Kawasaki 34 57 27 69
2 Sanfrecce Hiroshima Sanfrecce 34 47 35 57
3 Kashima Antlers Kashima 34 50 39 56
4 Consadole Sapporo Consadole 34 48 48 55
5 Urawa Reds Urawa Reds 34 51 39 51
6 FC Tokyo FC Tokyo 34 39 34 50
7 Cerezo Osaka Cerezo Osaka 34 39 38 50
8 Shimizu S-Pulse Shimizu 34 56 48 49
9 Gamba Osaka Gamba Osaka 34 41 46 48
10 Vissel Kobe Vissel Kobe 34 45 52 45
11 Vegalta Sendai Vegalta 34 44 54 45
12 Yokohama F. Marinos Yokohama 34 56 56 41
13 Shonan Bellmare Shonan 34 38 43 41
14 Sagan Tosu Sagan Tosu 34 29 34 41
15 Nagoya Grampus Nagoya 34 52 59 41
16 Júbilo Iwata Júbilo 34 35 48 41
17 Kashiwa Reysol Kashiwa 34 47 54 39
18 V-Varen Nagasaki V-Varen 34 39 59 30
TEMPORADA 2016/2017
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Kawasaki Frontale Kawasaki 34 71 32 72
2 Kashima Antlers Kashima 34 53 31 72
3 Cerezo Osaka Cerezo Osaka 34 65 43 63
4 Kashiwa Reysol Kashiwa 34 49 33 62
5 Yokohama F. Marinos Yokohama 34 45 36 59
6 Júbilo Iwata Júbilo 34 50 30 58
7 Urawa Reds Urawa Reds 34 64 54 49
8 Sagan Tosu Sagan Tosu 34 41 44 47
9 Vissel Kobe Vissel Kobe 34 40 45 44
10 Gamba Osaka Gamba Osaka 34 48 41 43
11 Consadole Sapporo Consadole 34 39 47 43
12 Vegalta Sendai Vegalta 34 44 53 41
13 FC Tokyo FC Tokyo 34 37 42 40
14 Shimizu S-Pulse Shimizu 34 36 54 34
15 Sanfrecce Hiroshima Sanfrecce 34 32 49 33
16 Ventforet Kofu Ventforet 34 23 39 32
17 Albirex Niigata Albirex 34 28 60 28
18 Omiya Ardija Omiya Ardija 34 28 60 25
TEMPORADA 2015/2016
LIGA JAPONESA J1 - 2ª FASE
Equipo PJ GF GC Puntos
1 Urawa Reds Urawa Reds 17 35 12 41
2 Vissel Kobe Vissel Kobe 17 33 18 35
3 Kawasaki Frontale Kawasaki 17 35 24 34
4 Gamba Osaka Gamba Osaka 17 31 22 34
5 Kashiwa Reysol Kashiwa 17 32 23 30
6 Omiya Ardija Omiya Ardija 17 24 18 30
7 Yokohama F. Marinos Yokohama 17 32 19 29
8 Sagan Tosu Sagan Tosu 17 26 22 29
9 FC Tokyo FC Tokyo 17 23 21 29
10 Sanfrecce Hiroshima Sanfrecce 17 26 22 26
11 Kashima Antlers Kashima 17 24 24 20
12 Vegalta Sendai Vegalta 17 19 23 20
13 Ventforet Kofu Ventforet 17 14 27 16
14 Júbilo Iwata Júbilo 17 16 27 13
15 Nagoya Grampus Nagoya 17 14 29 13
16 Albirex Niigata Albirex 17 14 24 12
17 Shonan Bellmare Shonan 17 12 29 11
18 Avispa Fukuoka Avispa 17 15 41 8
TEMPORADA 2014/2015
LIGA JAPONESA J1 - 2ª FASE
Equipo PJ GF GC Puntos
1 Sanfrecce Hiroshima Sanfrecce 17 44 14 40
2 Kashima Antlers Kashima 17 30 16 37
3 Gamba Osaka Gamba Osaka 17 32 24 31
4 Urawa Reds Urawa Reds 17 30 23 31
5 Yokohama F. Marinos Yokohama 17 24 15 29
6 FC Tokyo FC Tokyo 17 21 15 28
7 Kawasaki Frontale Kawasaki 17 30 22 27
8 Kashiwa Reysol Kashiwa 17 24 18 27
9 Shonan Bellmare Shonan 17 20 20 26
10 Nagoya Grampus Nagoya 17 26 30 24
11 Albirex Niigata Albirex 17 21 25 20
12 Sagan Tosu Sagan Tosu 17 15 22 20
13 Vissel Kobe Vissel Kobe 17 27 30 19
14 Ventforet Kofu Ventforet 17 14 21 17
15 Matsumoto Yamaga Matsumoto 17 13 28 13
16 Vegalta Sendai Vegalta 17 17 28 12
17 Shimizu S-Pulse Shimizu 17 15 33 12
18 Montedio Yamagata Montedio 17 10 29 10
TEMPORADA 2013/2014
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Gamba Osaka Gamba Osaka 34 59 31 63
2 Urawa Reds Urawa Reds 34 52 32 62
3 Kashima Antlers Kashima 34 64 39 60
4 Kashiwa Reysol Kashiwa 34 48 40 60
5 Sagan Tosu Sagan Tosu 34 41 33 60
6 Kawasaki Frontale Kawasaki 34 56 43 55
7 Yokohama F. Marinos Yokohama 34 37 29 51
8 Sanfrecce Hiroshima Sanfrecce 34 44 37 50
9 FC Tokyo FC Tokyo 34 47 33 48
10 Nagoya Grampus Nagoya 34 47 48 48
11 Vissel Kobe Vissel Kobe 34 49 50 45
12 Albirex Niigata Albirex 34 30 36 44
13 Ventforet Kofu Ventforet 34 27 31 41
14 Vegalta Sendai Vegalta 34 35 50 38
15 Shimizu S-Pulse Shimizu 34 42 60 36
16 Omiya Ardija Omiya Ardija 34 44 60 35
17 Cerezo Osaka Cerezo Osaka 34 36 48 31
18 Tokushima Vortis Tokushima 34 16 74 14
TEMPORADA 2012/2013
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Sanfrecce Hiroshima Sanfrecce 34 51 29 63
2 Yokohama F. Marinos Yokohama 34 49 31 62
3 Kawasaki Frontale Kawasaki 34 65 51 60
4 Cerezo Osaka Cerezo Osaka 34 53 32 59
5 Kashima Antlers Kashima 34 60 52 59
6 Urawa Reds Urawa Reds 34 66 57 56
7 Albirex Niigata Albirex 34 49 42 56
8 FC Tokyo FC Tokyo 34 61 47 54
9 Shimizu S-Pulse Shimizu 34 48 57 50
10 Kashiwa Reysol Kashiwa 34 56 59 48
11 Nagoya Grampus Nagoya 34 47 48 47
12 Sagan Tosu Sagan Tosu 34 54 63 46
13 Vegalta Sendai Vegalta 34 41 38 45
14 Omiya Ardija Omiya Ardija 34 45 48 45
15 Ventforet Kofu Ventforet 34 30 41 37
16 Shonan Bellmare Shonan 34 34 62 25
17 Júbilo Iwata Júbilo 34 40 56 23
18 Oita Trinita Oita Trinita 34 31 67 14
TEMPORADA 2011/2012
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Sanfrecce Hiroshima Sanfrecce 34 63 34 64
2 Vegalta Sendai Vegalta 34 59 43 57
3 Urawa Reds Urawa Reds 34 47 42 55
4 Yokohama F. Marinos Yokohama 34 44 33 53
5 Sagan Tosu Sagan Tosu 34 48 39 53
6 Kashiwa Reysol Kashiwa 34 57 52 52
7 Nagoya Grampus Nagoya 34 46 47 52
8 Kawasaki Frontale Kawasaki 34 51 50 50
9 Shimizu S-Pulse Shimizu 34 39 40 49
10 FC Tokyo FC Tokyo 34 47 44 48
11 Kashima Antlers Kashima 34 50 43 46
12 Júbilo Iwata Júbilo 34 57 53 46
13 Omiya Ardija Omiya Ardija 34 38 45 44
14 Cerezo Osaka Cerezo Osaka 34 47 53 42
15 Albirex Niigata Albirex 34 29 34 40
16 Vissel Kobe Vissel Kobe 34 41 50 39
17 Gamba Osaka Gamba Osaka 34 67 65 38
18 Consadole Sapporo Consadole 34 25 88 14
TEMPORADA 2010/2011
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 FC Tokyo FC Tokyo 38 67 22 77
2 Sagan Tosu Sagan Tosu 38 68 34 69
3 Consadole Sapporo Consadole 38 49 32 68
4 Tokushima Vortis Tokushima 38 51 38 65
5 Tokyo Verdy Tokyo Verdy 38 69 45 59
6 JEF United JEF United 38 46 39 58
7 Kyoto Sanga Kyoto Sanga 38 50 45 58
8 Giravanz Kitakyushu Giravanz 38 45 46 58
9 Thespa Gunma Thespa Gunma 38 51 51 57
10 Tochigi Tochigi 38 44 39 56
11 Roasso Kumamoto Roasso 38 33 44 51
12 Oita Trinita Oita Trinita 38 42 45 50
13 Fagiano Okayama Fagiano 38 43 58 48
14 Shonan Bellmare Shonan 38 46 48 46
15 Ehime Ehime 38 44 54 44
16 Kataller Toyama Kataller 38 36 53 43
17 Mito Hollyhock Mito 38 40 49 42
18 Yokohama Yokohama 38 40 54 41
19 Gainare Tottori Gainare 38 36 60 31
20 Gifu Gifu 38 39 83 24
TEMPORADA 2009/2010
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Nagoya Grampus Nagoya 34 54 37 72
2 Gamba Osaka Gamba Osaka 34 65 44 62
3 Cerezo Osaka Cerezo Osaka 34 58 32 61
4 Kashima Antlers Kashima 34 51 31 60
5 Kawasaki Frontale Kawasaki 34 61 47 54
6 Shimizu S-Pulse Shimizu 34 60 49 54
7 Sanfrecce Hiroshima Sanfrecce 34 45 38 51
8 Yokohama F. Marinos Yokohama 34 43 39 51
9 Albirex Niigata Albirex 34 48 45 49
10 Urawa Reds Urawa Reds 34 48 41 48
11 Júbilo Iwata Júbilo 34 38 49 44
12 Omiya Ardija Omiya Ardija 34 39 45 42
13 Montedio Yamagata Montedio 34 29 42 42
14 Vegalta Sendai Vegalta 34 40 46 39
15 Vissel Kobe Vissel Kobe 34 37 45 38
16 FC Tokyo FC Tokyo 34 36 41 36
17 Kyoto Sanga Kyoto Sanga 34 30 60 19
18 Shonan Bellmare Shonan 34 31 82 16
TEMPORADA 2008/2009
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Kashima Antlers Kashima 34 51 30 66
2 Kawasaki Frontale Kawasaki 34 64 40 64
3 Gamba Osaka Gamba Osaka 34 62 44 60
4 Sanfrecce Hiroshima Sanfrecce 34 53 44 56
5 FC Tokyo FC Tokyo 34 47 39 53
6 Urawa Reds Urawa Reds 34 43 43 52
7 Shimizu S-Pulse Shimizu 34 44 41 51
8 Albirex Niigata Albirex 34 42 31 50
9 Nagoya Grampus Nagoya 34 46 42 50
10 Yokohama F. Marinos Yokohama 34 43 37 46
11 Júbilo Iwata Júbilo 34 50 60 41
12 Kyoto Sanga Kyoto Sanga 34 35 47 41
13 Omiya Ardija Omiya Ardija 34 40 47 39
14 Vissel Kobe Vissel Kobe 34 40 48 39
15 Montedio Yamagata Montedio 34 32 40 39
16 Kashiwa Reysol Kashiwa 34 41 57 34
17 Oita Trinita Oita Trinita 34 26 45 30
18 JEF United JEF United 34 32 56 27
TEMPORADA 2007/2008
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Kashima Antlers Kashima 33 55 30 60
2 Nagoya Grampus Nagoya 33 48 35 58
3 Kawasaki Frontale Kawasaki 33 63 42 57
4 Oita Trinita Oita Trinita 33 33 24 55
5 FC Tokyo FC Tokyo 33 48 42 55
6 Urawa Reds Urawa Reds 33 49 36 53
7 Shimizu S-Pulse Shimizu 33 47 41 52
8 Gamba Osaka Gamba Osaka 33 44 46 50
9 Vissel Kobe Vissel Kobe 33 39 36 47
10 Yokohama F. Marinos Yokohama 33 37 31 45
11 Kashiwa Reysol Kashiwa 33 46 45 43
12 Kyoto Sanga Kyoto Sanga 33 36 43 41
13 Omiya Ardija Omiya Ardija 33 35 45 40
14 Albirex Niigata Albirex 33 29 44 39
15 Júbilo Iwata Júbilo 33 40 47 37
16 Tokyo Verdy Tokyo Verdy 33 38 48 37
17 JEF United JEF United 33 32 51 35
18 Consadole Sapporo Consadole 33 36 69 18
TEMPORADA 2006/2007
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Kashima Antlers Kashima 34 60 36 72
2 Urawa Reds Urawa Reds 34 55 28 70
3 Gamba Osaka Gamba Osaka 34 71 37 67
4 Shimizu S-Pulse Shimizu 34 53 36 61
5 Kawasaki Frontale Kawasaki 34 66 48 54
6 Albirex Niigata Albirex 34 48 47 51
7 Yokohama F. Marinos Yokohama 34 54 35 50
8 Kashiwa Reysol Kashiwa 34 43 36 50
9 Júbilo Iwata Júbilo 34 54 55 49
10 Vissel Kobe Vissel Kobe 34 58 48 47
11 Nagoya Grampus Nagoya 34 43 45 45
12 FC Tokyo FC Tokyo 34 49 58 45
13 JEF United JEF United 34 51 56 42
14 Oita Trinita Oita Trinita 34 42 60 41
15 Omiya Ardija Omiya Ardija 34 24 40 35
16 Sanfrecce Hiroshima Sanfrecce 34 44 71 32
17 Ventforet Kofu Ventforet 34 33 65 27
18 Yokohama Yokohama 34 19 66 16
TEMPORADA 2005/2006
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Urawa Reds Urawa Reds 34 67 28 72
2 Kawasaki Frontale Kawasaki 34 84 55 67
3 Gamba Osaka Gamba Osaka 34 80 48 66
4 Shimizu S-Pulse Shimizu 34 60 41 60
5 Júbilo Iwata Júbilo 34 68 51 58
6 Kashima Antlers Kashima 34 62 53 58
7 Nagoya Grampus Nagoya 34 51 49 48
8 Oita Trinita Oita Trinita 34 47 45 47
9 Yokohama F. Marinos Yokohama 34 49 43 45
10 Sanfrecce Hiroshima Sanfrecce 34 50 56 45
11 JEF United JEF United 34 57 58 44
12 Omiya Ardija Omiya Ardija 34 43 55 44
13 FC Tokyo FC Tokyo 34 56 65 43
14 Albirex Niigata Albirex 34 46 65 42
15 Ventforet Kofu Ventforet 34 42 64 42
16 Avispa Fukuoka Avispa 34 32 56 27
17 Cerezo Osaka Cerezo Osaka 34 44 70 27
18 Kyoto Sanga Kyoto Sanga 34 38 74 22
TEMPORADA 2004/2005
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Gamba Osaka Gamba Osaka 34 82 58 60
2 Urawa Reds Urawa Reds 34 65 37 59
3 Kashima Antlers Kashima 34 61 39 59
4 JEF United JEF United 34 56 42 59
5 Cerezo Osaka Cerezo Osaka 34 48 40 59
6 Júbilo Iwata Júbilo 34 51 41 51
7 Sanfrecce Hiroshima Sanfrecce 34 50 42 50
8 Kawasaki Frontale Kawasaki 34 54 47 50
9 Yokohama F. Marinos Yokohama 34 41 40 48
10 FC Tokyo FC Tokyo 34 43 40 47
11 Oita Trinita Oita Trinita 34 44 43 43
12 Albirex Niigata Albirex 34 47 62 42
13 Omiya Ardija Omiya Ardija 34 39 50 41
14 Nagoya Grampus Nagoya 34 43 49 39
15 Shimizu S-Pulse Shimizu 34 40 49 39
16 Kashiwa Reysol Kashiwa 34 39 54 35
17 Tokyo Verdy Tokyo Verdy 34 40 73 30
18 Vissel Kobe Vissel Kobe 34 30 67 21
TEMPORADA 2003/2004
LIGA JAPONESA J1 - 1ª FASE
Equipo PJ GF GC Puntos
1 Yokohama F. Marinos Yokohama 15 26 13 36
2 Júbilo Iwata Júbilo 15 31 16 34
3 Urawa Reds Urawa Reds 15 30 24 25
4 Gamba Osaka Gamba Osaka 15 31 23 24
5 Kashima Antlers Kashima 15 18 14 24
6 FC Tokyo FC Tokyo 15 19 19 23
7 JEF United JEF United 15 28 23 22
8 Nagoya Grampus Nagoya 15 24 22 20
9 Tokyo Verdy Tokyo Verdy 15 21 23 19
10 Oita Trinita Oita Trinita 15 21 27 17
11 Shimizu S-Pulse Shimizu 15 20 27 16
12 Vissel Kobe Vissel Kobe 15 21 25 15
13 Sanfrecce Hiroshima Sanfrecce 15 15 19 15
14 Albirex Niigata Albirex 15 16 25 14
15 Kashiwa Reysol Kashiwa 15 14 22 12
16 Cerezo Osaka Cerezo Osaka 15 17 30 10

  USO DE MEMORIA  
8,012,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1970
Total Execution Time  0.1990
  CADENA URL  
/historico/Fc-Tokyo/2021
  GET DATOS  
$_GET['/historico/Fc-Tokyo/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0057  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 = 'Fc-Tokyo' AND l.year = 2021 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=1110 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=1110 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=1110 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=1110 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=1110 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 = 61133
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1110 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1110 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (1372,3296,40930,93531,96505) ORDER BY n.cover_points DESC, update_date DESC
0.0034  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 = '1110' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0038  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 = '1110' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 61133 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 61091 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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=1110 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (67535,66542,66261,58994,53469,49506) 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.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 66261 AND teamId = 1110
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 66542 AND teamId = 1110
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 67535 AND teamId = 1110
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 58994 AND teamId = 1110
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 53469 AND teamId = 1110
0.0099  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 1110
0.0044  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 61091 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0042  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 events2021 e ON e.player_id = p.id AND e.league_id = 61091 WHERE rp.league_id = 61091 AND rp.teamId = 1110 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.0033  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 events2021 e ON e.player_id = p.id AND e.league_id = 61091 WHERE rp.league_id = 61091 AND rp.teamId = 1110 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 events2021 e ON e.player_id = p.id AND e.league_id = 61091 WHERE rp.league_id = 61091 AND rp.teamId = 1110 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 1110 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 61091 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 55273 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 48456 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 42417 AND t.round = 34 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 `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 = 37772 AND t.round = 34 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 `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 = 20266 AND t.round = 17 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 = 20311 AND t.round = 17 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 `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 = 10155 AND t.round = 17 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 `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 = 10156 AND t.round = 17 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 `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 = 3569 AND t.round = 34 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 `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 = 2286 AND t.round = 34 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 `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 = 1562 AND t.round = 34 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 `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 = 1351 AND t.round = 38 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 `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 = 1066 AND t.round = 34 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 `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 = 888 AND t.round = 34 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 `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 = 267 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 425 AND t.round = 34 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 `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 = 426 AND t.round = 34 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 `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 = 712 AND t.round = 34 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 = 10827 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC