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

Kyoto Sanga

Entrenador: Gwi-Jae Jo

TEMPORADA 2023/2024
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Cerezo Osaka Cerezo Osaka 10 15 9 19
2 Machida Zelvia Machida 10 13 10 19
3 Sanfrecce Hiroshima Sanfrecce 9 14 5 17
4 Vissel Kobe Vissel Kobe 10 14 7 17
5 Nagoya Grampus Nagoya 9 9 8 16
6 Yokohama F. Marinos Yokohama 9 14 11 15
7 FC Tokyo FC Tokyo 10 17 15 15
8 Gamba Osaka Gamba Osaka 9 8 7 15
9 Júbilo Iwata Júbilo 10 15 13 13
10 Kashiwa Reysol Kashiwa 8 7 6 13
11 Kashima Antlers Kashima 9 10 10 13
12 Albirex Niigata Albirex 10 9 12 12
13 Urawa Reds Urawa Reds 9 12 12 11
14 Avispa Fukuoka Avispa 9 8 9 11
15 Tokyo Verdy Tokyo Verdy 9 12 13 9
16 Kyoto Sanga Kyoto Sanga 10 8 13 9
17 Kawasaki Frontale Kawasaki 9 10 11 8
18 Shonan Bellmare Shonan 10 14 20 7
19 Sagan Tosu Sagan Tosu 9 11 18 7
20 Consadole Sapporo Consadole 10 9 20 7
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
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Yokohama F. Marinos Yokohama 34 70 35 68
2 Kawasaki Frontale Kawasaki 34 65 42 66
3 Sanfrecce Hiroshima Sanfrecce 34 52 41 55
4 Kashima Antlers Kashima 34 47 42 52
5 Cerezo Osaka Cerezo Osaka 34 46 40 51
6 FC Tokyo FC Tokyo 34 46 43 49
7 Kashiwa Reysol Kashiwa 34 43 44 47
8 Nagoya Grampus Nagoya 34 30 35 46
9 Urawa Reds Urawa Reds 34 48 39 45
10 Consadole Sapporo Consadole 34 45 55 45
11 Sagan Tosu Sagan Tosu 34 45 44 42
12 Shonan Bellmare Shonan 34 31 39 41
13 Vissel Kobe Vissel Kobe 34 35 41 40
14 Avispa Fukuoka Avispa 34 29 38 38
15 Gamba Osaka Gamba Osaka 34 33 44 37
16 Kyoto Sanga Kyoto Sanga 34 30 38 36
17 Shimizu S-Pulse Shimizu 34 44 54 33
18 Júbilo Iwata Júbilo 34 32 57 30
TEMPORADA 2020/2021
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Júbilo Iwata Júbilo 42 75 42 91
2 Kyoto Sanga Kyoto Sanga 42 59 31 84
3 Ventforet Kofu Ventforet 42 65 38 80
4 V-Varen Nagasaki V-Varen 42 69 44 78
5 Machida Zelvia Machida 42 64 38 72
6 Albirex Niigata Albirex 42 61 40 68
7 Montedio Yamagata Montedio 42 61 49 68
8 JEF United JEF United 42 48 36 66
9 Ryūkyū Ryūkyū 42 57 47 65
10 Mito Hollyhock Mito 42 59 50 59
11 Fagiano Okayama Fagiano 42 40 36 59
12 Tokyo Verdy Tokyo Verdy 42 62 66 58
13 Blaublitz Akita Blaublitz 42 41 53 47
14 Tochigi Tochigi 42 37 51 45
15 Renofa Yamaguchi Renofa 42 37 51 43
16 Omiya Ardija Omiya Ardija 42 51 56 42
17 Zweigen Kanazawa Zweigen 42 39 60 41
18 Thespa Gunma Thespa Gunma 42 35 56 41
19 Sagamihara Sagamihara 42 33 54 38
20 Ehime Ehime 42 38 67 35
21 Giravanz Kitakyushu Giravanz 42 35 66 35
22 Matsumoto Yamaga Matsumoto 42 36 71 34
TEMPORADA 2019/2020
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Tokushima Vortis Tokushima 42 67 33 84
2 Avispa Fukuoka Avispa 42 51 29 84
3 V-Varen Nagasaki V-Varen 42 66 39 80
4 Ventforet Kofu Ventforet 42 50 41 65
5 Giravanz Kitakyushu Giravanz 42 59 51 65
6 Júbilo Iwata Júbilo 42 58 47 63
7 Montedio Yamagata Montedio 42 59 42 62
8 Kyoto Sanga Kyoto Sanga 42 47 45 59
9 Mito Hollyhock Mito 42 68 62 58
10 Tochigi Tochigi 42 41 39 58
11 Albirex Niigata Albirex 42 55 55 57
12 Tokyo Verdy Tokyo Verdy 42 48 48 54
13 Matsumoto Yamaga Matsumoto 42 44 52 54
14 JEF United JEF United 42 47 51 53
15 Omiya Ardija Omiya Ardija 42 43 52 53
16 Ryūkyū Ryūkyū 42 58 61 50
17 Fagiano Okayama Fagiano 42 39 49 50
18 Zweigen Kanazawa Zweigen 42 57 67 49
19 Machida Zelvia Machida 42 41 52 49
20 Thespa Gunma Thespa Gunma 42 40 62 49
21 Ehime Ehime 42 38 68 34
22 Renofa Yamaguchi Renofa 42 43 74 33
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
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
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Consadole Sapporo Consadole 48 66 45 91
2 Tokyo Verdy Tokyo Verdy 48 90 57 89
3 Kyoto Sanga Kyoto Sanga 48 80 59 86
4 Vegalta Sendai Vegalta 48 72 54 83
5 Cerezo Osaka Cerezo Osaka 48 72 55 80
6 Shonan Bellmare Shonan 48 72 55 77
7 Avispa Fukuoka Avispa 48 77 61 73
8 Sagan Tosu Sagan Tosu 48 63 66 72
9 Montedio Yamagata Montedio 48 46 56 58
10 Ehime Ehime 48 39 66 45
11 Thespa Gunma Thespa Gunma 48 42 71 42
12 Mito Hollyhock Mito 48 32 70 34
13 Tokushima Vortis Tokushima 48 31 67 33
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
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,299,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  2.0830
Total Execution Time  2.0843
  CADENA URL  
/historico/Kyoto-Sanga
  GET DATOS  
$_GET['/historico/Kyoto-Sanga']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.2456  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 = 74986
0.1753  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 = '1479' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0170  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 = 74986 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.1478  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=1479 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0097  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,74986,71686) 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.1595  SELECT count(id) as num_players from rel_players WHERE league_id = 74986 AND teamId = 1479
0.1625  SELECT count(id) as num_players from rel_players WHERE league_id = 75185 AND teamId = 1479
0.0929  SELECT count(id) as num_players from rel_players WHERE league_id = 71686 AND teamId = 1479
0.0303  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 = 74986 AND t.round = 10 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.1886  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 = 74986 WHERE rp.league_id = 74986 AND rp.teamId = 1479 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.1723  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 = 74986 WHERE rp.league_id = 74986 AND rp.teamId = 1479 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0738  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 = 74986 WHERE rp.league_id = 74986 AND rp.teamId = 1479 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.1009  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 = 1479 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0295  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 = 74986 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0365  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.0322  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 = 61092 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.0201  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 = 55275 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.0273  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.0196  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.0325  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.0304  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.0309  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.0311  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.0268  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.0247  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.0246  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.0292  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.0110  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 = 13518 AND t.round = 52 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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.0186  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.0069  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 = 74986 ORDER BY nameShow LIMIT 100