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

Yokohama

Entrenador: Shuhei Yomoda

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 V-Varen Nagasaki V-Varen 12 25 11 27
2 Shimizu S-Pulse Shimizu 11 19 13 25
3 Fagiano Okayama Fagiano 11 14 7 22
4 Yokohama Yokohama 11 16 8 18
5 Ventforet Kofu Ventforet 12 20 15 18
6 Blaublitz Akita Blaublitz 11 12 8 18
7 Ehime Ehime 12 18 16 18
8 JEF United JEF United 12 25 15 17
9 Vegalta Sendai Vegalta 12 12 11 17
10 Iwaki FC Iwaki FC 11 20 10 16
11 Montedio Yamagata Montedio 11 12 12 16
12 Renofa Yamaguchi Renofa 11 14 9 15
13 Oita Trinita Oita Trinita 11 10 11 13
14 Roasso Kumamoto Roasso 11 15 23 12
15 Kagoshima United Kagoshima 11 12 20 12
16 Tochigi Tochigi 11 10 24 12
17 Mito Hollyhock Mito 12 10 13 11
18 Fujieda MYFC Fujieda MYFC 12 7 19 11
19 Tokushima Vortis Tokushima 11 9 21 8
20 Thespa Gunma Thespa Gunma 12 7 21 6
TEMPORADA 2022/2023
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Vissel Kobe Vissel Kobe 34 60 29 71
2 Yokohama F. Marinos Yokohama 34 63 40 64
3 Sanfrecce Hiroshima Sanfrecce 34 42 28 58
4 Urawa Reds Urawa Reds 34 42 27 57
5 Kashima Antlers Kashima 34 43 34 52
6 Nagoya Grampus Nagoya 34 41 36 52
7 Avispa Fukuoka Avispa 34 37 43 51
8 Kawasaki Frontale Kawasaki 34 51 45 50
9 Cerezo Osaka Cerezo Osaka 34 39 34 49
10 Albirex Niigata Albirex 34 36 40 45
11 FC Tokyo FC Tokyo 34 42 46 43
12 Consadole Sapporo Consadole 34 56 61 40
13 Kyoto Sanga Kyoto Sanga 34 40 45 40
14 Sagan Tosu Sagan Tosu 34 43 47 38
15 Shonan Bellmare Shonan 34 40 56 34
16 Gamba Osaka Gamba Osaka 34 38 61 34
17 Kashiwa Reysol Kashiwa 34 33 47 33
18 Yokohama Yokohama 34 31 58 29
TEMPORADA 2021/2022
SEGUNDA JAPONESA J2 GRUPO 1
Equipo PJ GF GC Puntos
1 Albirex Niigata Albirex 42 73 35 84
2 Yokohama Yokohama 42 66 49 80
3 Fagiano Okayama Fagiano 42 61 42 72
4 Roasso Kumamoto Roasso 42 58 48 67
5 Oita Trinita Oita Trinita 42 62 52 66
6 Montedio Yamagata Montedio 42 62 40 64
7 Vegalta Sendai Vegalta 42 67 59 63
8 Tokushima Vortis Tokushima 42 48 35 62
9 Tokyo Verdy Tokyo Verdy 42 62 55 61
10 JEF United JEF United 42 44 42 61
11 V-Varen Nagasaki V-Varen 42 50 54 56
12 Blaublitz Akita Blaublitz 42 39 46 56
13 Mito Hollyhock Mito 42 47 46 54
14 Zweigen Kanazawa Zweigen 42 56 69 52
15 Machida Zelvia Machida 42 51 50 51
16 Renofa Yamaguchi Renofa 42 51 54 50
17 Tochigi Tochigi 42 32 40 49
18 Ventforet Kofu Ventforet 42 47 54 48
19 Omiya Ardija Omiya Ardija 42 48 64 43
20 Thespa Gunma Thespa Gunma 42 36 57 42
21 Ryūkyū Ryūkyū 42 41 65 37
22 Grulla Morioka Grulla 42 35 80 34
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
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Kashiwa Reysol Kashiwa 42 85 33 84
2 Yokohama Yokohama 42 66 40 79
3 Omiya Ardija Omiya Ardija 42 62 40 75
4 Tokushima Vortis Tokushima 42 67 45 73
5 Ventforet Kofu Ventforet 42 64 40 71
6 Montedio Yamagata Montedio 42 59 40 70
7 Mito Hollyhock Mito 42 56 37 70
8 Kyoto Sanga Kyoto Sanga 42 59 56 68
9 Fagiano Okayama Fagiano 42 49 47 65
10 Albirex Niigata Albirex 42 71 52 62
11 Zweigen Kanazawa Zweigen 42 58 46 61
12 V-Varen Nagasaki V-Varen 42 57 61 56
13 Tokyo Verdy Tokyo Verdy 42 59 59 55
14 Ryūkyū Ryūkyū 42 57 80 49
15 Renofa Yamaguchi Renofa 42 54 70 47
16 Avispa Fukuoka Avispa 42 39 62 44
17 JEF United JEF United 42 46 64 43
18 Machida Zelvia Machida 42 36 59 43
19 Ehime Ehime 42 46 62 42
20 Tochigi Tochigi 42 33 53 40
21 Kagoshima United Kagoshima 42 41 73 40
22 Gifu Gifu 42 33 78 30
TEMPORADA 2017/2018
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Matsumoto Yamaga Matsumoto 42 54 34 77
2 Oita Trinita Oita Trinita 42 76 51 76
3 Yokohama Yokohama 42 63 44 76
4 Machida Zelvia Machida 42 62 44 76
5 Omiya Ardija Omiya Ardija 42 65 48 71
6 Tokyo Verdy Tokyo Verdy 42 56 41 71
7 Avispa Fukuoka Avispa 42 58 42 70
8 Renofa Yamaguchi Renofa 42 63 64 61
9 Ventforet Kofu Ventforet 42 56 46 59
10 Mito Hollyhock Mito 42 48 46 57
11 Tokushima Vortis Tokushima 42 48 42 56
12 Montedio Yamagata Montedio 42 49 51 56
13 Zweigen Kanazawa Zweigen 42 52 48 55
14 JEF United JEF United 42 72 72 55
15 Fagiano Okayama Fagiano 42 39 43 53
16 Albirex Niigata Albirex 42 48 56 53
17 Tochigi Tochigi 42 38 48 50
18 Ehime Ehime 42 34 52 48
19 Kyoto Sanga Kyoto Sanga 42 40 58 43
20 Gifu Gifu 42 44 62 42
21 Roasso Kumamoto Roasso 42 50 79 34
22 Kamatamare Sanuki Kamatamare 42 28 72 31
TEMPORADA 2016/2017
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Shonan Bellmare Shonan 42 58 36 83
2 V-Varen Nagasaki V-Varen 42 59 41 80
3 Nagoya Grampus Nagoya 42 85 65 75
4 Avispa Fukuoka Avispa 42 54 36 74
5 Tokyo Verdy Tokyo Verdy 42 64 49 70
6 JEF United JEF United 42 70 58 68
7 Tokushima Vortis Tokushima 42 71 45 67
8 Matsumoto Yamaga Matsumoto 42 61 45 66
9 Oita Trinita Oita Trinita 42 58 50 64
10 Yokohama Yokohama 42 60 49 63
11 Montedio Yamagata Montedio 42 45 47 59
12 Kyoto Sanga Kyoto Sanga 42 55 47 57
13 Fagiano Okayama Fagiano 42 44 49 55
14 Mito Hollyhock Mito 42 45 48 54
15 Ehime Ehime 42 54 68 51
16 Machida Zelvia Machida 42 53 53 50
17 Zweigen Kanazawa Zweigen 42 49 67 49
18 Gifu Gifu 42 56 68 46
19 Kamatamare Sanuki Kamatamare 42 41 61 38
20 Renofa Yamaguchi Renofa 42 48 69 38
21 Roasso Kumamoto Roasso 42 36 59 37
22 Thespa Gunma Thespa Gunma 42 32 88 20
TEMPORADA 2015/2016
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Consadole Sapporo Consadole 42 65 33 85
2 Shimizu S-Pulse Shimizu 42 85 37 84
3 Matsumoto Yamaga Matsumoto 42 62 32 84
4 Cerezo Osaka Cerezo Osaka 42 62 46 78
5 Kyoto Sanga Kyoto Sanga 42 50 37 69
6 Fagiano Okayama Fagiano 42 58 44 65
7 Machida Zelvia Machida 42 53 44 65
8 Yokohama Yokohama 42 50 51 59
9 Tokushima Vortis Tokushima 42 46 42 57
10 Ehime Ehime 42 41 40 56
11 JEF United JEF United 42 52 53 53
12 Renofa Yamaguchi Renofa 42 55 63 53
13 Mito Hollyhock Mito 42 45 49 48
14 Montedio Yamagata Montedio 42 43 49 47
15 V-Varen Nagasaki V-Varen 42 39 51 47
16 Roasso Kumamoto Roasso 42 38 53 46
17 Thespa Gunma Thespa Gunma 42 52 66 45
18 Tokyo Verdy Tokyo Verdy 42 43 61 43
19 Kamatamare Sanuki Kamatamare 42 43 62 43
20 Gifu Gifu 42 47 71 43
21 Zweigen Kanazawa Zweigen 42 36 60 39
22 Giravanz Kitakyushu Giravanz 42 43 64 38
TEMPORADA 2014/2015
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Omiya Ardija Omiya Ardija 42 72 37 86
2 Júbilo Iwata Júbilo 42 72 43 82
3 Avispa Fukuoka Avispa 42 63 37 82
4 Cerezo Osaka Cerezo Osaka 42 57 40 67
5 Ehime Ehime 42 47 39 65
6 V-Varen Nagasaki V-Varen 42 42 33 60
7 Giravanz Kitakyushu Giravanz 42 59 58 59
8 Tokyo Verdy Tokyo Verdy 42 42 41 58
9 JEF United JEF United 42 50 45 57
10 Consadole Sapporo Consadole 42 47 43 57
11 Fagiano Okayama Fagiano 42 40 35 54
12 Zweigen Kanazawa Zweigen 42 46 43 54
13 Roasso Kumamoto Roasso 42 42 45 53
14 Tokushima Vortis Tokushima 42 35 44 53
15 Yokohama Yokohama 42 33 58 52
16 Kamatamare Sanuki Kamatamare 42 30 33 51
17 Kyoto Sanga Kyoto Sanga 42 45 51 50
18 Thespa Gunma Thespa Gunma 42 34 55 48
19 Mito Hollyhock Mito 42 40 47 46
20 Gifu Gifu 42 37 71 43
21 Oita Trinita Oita Trinita 42 41 51 38
22 Tochigi Tochigi 42 39 64 35
TEMPORADA 2013/2014
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Shonan Bellmare Shonan 42 86 25 101
2 Matsumoto Yamaga Matsumoto 42 65 35 83
3 JEF United JEF United 42 55 44 68
4 Júbilo Iwata Júbilo 42 67 55 67
5 Giravanz Kitakyushu Giravanz 42 50 50 65
6 Montedio Yamagata Montedio 42 57 44 64
7 Oita Trinita Oita Trinita 42 52 55 63
8 Fagiano Okayama Fagiano 42 52 48 61
9 Kyoto Sanga Kyoto Sanga 42 57 52 60
10 Consadole Sapporo Consadole 42 48 44 59
11 Yokohama Yokohama 42 49 47 55
12 Tochigi Tochigi 42 52 58 55
13 Roasso Kumamoto Roasso 42 45 53 54
14 V-Varen Nagasaki V-Varen 42 45 42 52
15 Mito Hollyhock Mito 42 46 46 50
16 Avispa Fukuoka Avispa 42 52 60 50
17 Gifu Gifu 42 54 61 49
18 Thespa Gunma Thespa Gunma 42 45 54 49
19 Ehime Ehime 42 54 58 48
20 Tokyo Verdy Tokyo Verdy 42 31 48 42
21 Kamatamare Sanuki Kamatamare 42 34 71 33
22 Kataller Toyama Kataller 42 28 74 23
TEMPORADA 2012/2013
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Gamba Osaka Gamba Osaka 42 99 46 87
2 Vissel Kobe Vissel Kobe 42 78 41 83
3 Kyoto Sanga Kyoto Sanga 42 68 46 70
4 Tokushima Vortis Tokushima 42 56 51 67
5 JEF United JEF United 42 68 49 66
6 V-Varen Nagasaki V-Varen 42 48 40 66
7 Matsumoto Yamaga Matsumoto 42 54 54 66
8 Consadole Sapporo Consadole 42 60 49 64
9 Tochigi Tochigi 42 61 55 63
10 Montedio Yamagata Montedio 42 74 61 59
11 Yokohama Yokohama 42 49 46 58
12 Fagiano Okayama Fagiano 42 52 48 56
13 Tokyo Verdy Tokyo Verdy 42 52 58 56
14 Avispa Fukuoka Avispa 42 47 54 56
15 Mito Hollyhock Mito 42 50 58 55
16 Giravanz Kitakyushu Giravanz 42 50 60 49
17 Ehime Ehime 42 43 52 47
18 Kataller Toyama Kataller 42 45 59 44
19 Roasso Kumamoto Roasso 42 40 70 43
20 Thespa Gunma Thespa Gunma 42 43 61 40
21 Gifu Gifu 42 37 80 37
22 Gainare Tottori Gainare 42 38 74 31
TEMPORADA 2011/2012
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Ventforet Kofu Ventforet 42 63 35 86
2 Shonan Bellmare Shonan 42 66 43 75
3 Kyoto Sanga Kyoto Sanga 42 61 45 74
4 Yokohama Yokohama 42 62 45 73
5 JEF United JEF United 42 61 33 72
6 Oita Trinita Oita Trinita 42 59 40 71
7 Tokyo Verdy Tokyo Verdy 42 65 46 66
8 Fagiano Okayama Fagiano 42 41 34 65
9 Giravanz Kitakyushu Giravanz 42 53 47 64
10 Montedio Yamagata Montedio 42 51 49 61
11 Tochigi Tochigi 42 50 49 60
12 Matsumoto Yamaga Matsumoto 42 46 43 59
13 Mito Hollyhock Mito 42 47 49 56
14 Roasso Kumamoto Roasso 42 40 48 55
15 Tokushima Vortis Tokushima 42 45 49 51
16 Ehime Ehime 42 47 46 50
17 Thespa Gunma Thespa Gunma 42 31 45 47
18 Avispa Fukuoka Avispa 42 53 68 41
19 Kataller Toyama Kataller 42 38 59 38
20 Gainare Tottori Gainare 42 33 78 38
21 Gifu Gifu 42 27 55 35
22 Machida Zelvia Machida 42 34 67 32
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
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Kashiwa Reysol Kashiwa 36 71 24 80
2 Ventforet Kofu Ventforet 36 71 40 70
3 Avispa Fukuoka Avispa 36 63 34 69
4 JEF United JEF United 36 58 37 61
5 Tokyo Verdy Tokyo Verdy 36 47 34 58
6 Yokohama Yokohama 36 54 47 54
7 Roasso Kumamoto Roasso 36 39 43 54
8 Tokushima Vortis Tokushima 36 51 47 51
9 Sagan Tosu Sagan Tosu 36 42 41 51
10 Tochigi Tochigi 36 46 42 50
11 Ehime Ehime 36 34 34 48
12 Thespa Gunma Thespa Gunma 36 36 48 48
13 Consadole Sapporo Consadole 36 37 38 46
14 Gifu Gifu 36 32 45 45
15 Oita Trinita Oita Trinita 36 39 49 41
16 Mito Hollyhock Mito 36 29 45 38
17 Fagiano Okayama Fagiano 36 27 51 32
18 Kataller Toyama Kataller 36 39 71 28
19 Giravanz Kitakyushu Giravanz 36 20 65 15
TEMPORADA 2008/2009
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Vegalta Sendai Vegalta 51 87 39 106
2 Cerezo Osaka Cerezo Osaka 51 100 53 104
3 Shonan Bellmare Shonan 51 84 52 98
4 Ventforet Kofu Ventforet 51 76 46 97
5 Sagan Tosu Sagan Tosu 51 71 51 88
6 Consadole Sapporo Consadole 51 74 61 79
7 Tokyo Verdy Tokyo Verdy 51 68 61 74
8 Mito Hollyhock Mito 51 70 79 73
9 Tokushima Vortis Tokushima 51 67 52 72
10 Thespa Gunma Thespa Gunma 51 64 76 65
11 Avispa Fukuoka Avispa 51 52 71 65
12 Gifu Gifu 51 62 72 62
13 Kataller Toyama Kataller 51 48 58 61
14 Roasso Kumamoto Roasso 51 66 82 58
15 Ehime Ehime 51 54 80 47
16 Yokohama Yokohama 51 43 70 44
17 Tochigi Tochigi 51 38 77 37
18 Fagiano Okayama Fagiano 51 40 84 36
TEMPORADA 2007/2008
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Sanfrecce Hiroshima Sanfrecce 42 99 35 100
2 Montedio Yamagata Montedio 42 66 40 78
3 Vegalta Sendai Vegalta 42 62 47 70
4 Cerezo Osaka Cerezo Osaka 42 81 60 69
5 Shonan Bellmare Shonan 42 68 48 65
6 Sagan Tosu Sagan Tosu 42 50 51 64
7 Ventforet Kofu Ventforet 42 56 47 59
8 Avispa Fukuoka Avispa 42 55 66 58
9 Thespa Gunma Thespa Gunma 42 45 52 53
10 Yokohama Yokohama 42 51 56 50
11 Mito Hollyhock Mito 42 52 70 47
12 Roasso Kumamoto Roasso 42 46 72 43
13 Gifu Gifu 42 41 69 42
14 Ehime Ehime 42 39 66 37
15 Tokushima Vortis Tokushima 42 40 72 29
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
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Yokohama Yokohama 47 59 32 90
2 Vissel Kobe Vissel Kobe 47 77 51 86
3 Kashiwa Reysol Kashiwa 47 81 60 85
4 Sagan Tosu Sagan Tosu 47 62 49 76
5 Vegalta Sendai Vegalta 47 73 42 74
6 Consadole Sapporo Consadole 47 77 65 72
7 Tokyo Verdy Tokyo Verdy 47 68 74 70
8 Montedio Yamagata Montedio 47 63 56 62
9 Ehime Ehime 47 51 61 53
10 Mito Hollyhock Mito 47 47 64 51
11 Shonan Bellmare Shonan 47 61 84 49
12 Thespa Gunma Thespa Gunma 47 53 85 41
13 Tokushima Vortis Tokushima 48 43 92 35
TEMPORADA 2004/2005
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Kyoto Sanga Kyoto Sanga 44 89 40 97
2 Avispa Fukuoka Avispa 44 72 43 78
3 Ventforet Kofu Ventforet 44 78 64 69
4 Vegalta Sendai Vegalta 44 66 47 68
5 Montedio Yamagata Montedio 44 54 45 64
6 Consadole Sapporo Consadole 44 54 57 63
7 Shonan Bellmare Shonan 44 46 59 54
8 Sagan Tosu Sagan Tosu 44 58 58 52
9 Tokushima Vortis Tokushima 44 60 76 52
10 Mito Hollyhock Mito 44 41 57 52
11 Yokohama Yokohama 44 48 64 45
12 Thespa Gunma Thespa Gunma 44 26 82 23

  USO DE MEMORIA  
8,264,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1987
Total Execution Time  0.2000
  CADENA URL  
/historico/Yokohama
  GET DATOS  
$_GET['/historico/Yokohama']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0035  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 = 'Yokohama' AND l.year = 2024 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.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=16519 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=16519 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=16519 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16519 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 16519 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (969,22005,82200,98305,160320) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '16519' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '16519' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 74984 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=16519 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0038  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 (75185,74984,71686,70787) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 70787 AND teamId = 16519
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 74984 AND teamId = 16519
0.0042  SELECT count(id) as num_players from rel_players WHERE league_id = 75185 AND teamId = 16519
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71686 AND teamId = 16519
0.0045  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 74984 AND t.round = 12 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0038  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 = '16519' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16519' and rp.type = 4
0.0020  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 = '16519' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0052  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 events2024 e ON e.player_id = p.id AND e.league_id = 74984 WHERE rp.league_id = 74984 AND rp.teamId = 16519 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.0031  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 events2024 e ON e.player_id = p.id AND e.league_id = 74984 WHERE rp.league_id = 74984 AND rp.teamId = 16519 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 events2024 e ON e.player_id = p.id AND e.league_id = 74984 WHERE rp.league_id = 74984 AND rp.teamId = 16519 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 16519 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0027  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 `tables2024` 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 = 74984 AND t.round = 12 ORDER BY team.conference ASC,t.position 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 `tables2023` 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 = 70787 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.0038  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 `tables2022` 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 = 66265 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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.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 `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 = 48768 AND t.round = 42 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 `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 = 42451 AND t.round = 42 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 = 37765 AND t.round = 42 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 = 20246 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 10157 AND t.round = 42 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 `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 = 3562 AND t.round = 42 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 `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 = 2299 AND t.round = 42 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 `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 = 1641 AND t.round = 42 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 `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.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 `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 = 13521 AND t.round = 38 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 `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 = 13520 AND t.round = 51 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 13519 AND t.round = 45 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 `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.0027  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 = 13517 AND t.round = 51 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 13516 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 74984 ORDER BY nameShow LIMIT 100