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

Avispa Fukuoka

Entrenador: Shigetoshi Hasebe

Temporada 2023/2024
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 10 16 7 18
4 Vissel Kobe Vissel Kobe 10 14 7 17
5 Kashima Antlers Kashima 10 12 11 16
6 Nagoya Grampus Nagoya 10 10 10 16
7 Yokohama F. Marinos Yokohama 9 14 11 15
8 FC Tokyo FC Tokyo 10 17 15 15
9 Gamba Osaka Gamba Osaka 10 9 9 15
10 Urawa Reds Urawa Reds 10 14 13 14
11 Kashiwa Reysol Kashiwa 9 8 7 14
12 Júbilo Iwata Júbilo 10 15 13 13
13 Avispa Fukuoka Avispa 10 8 9 12
14 Albirex Niigata Albirex 10 9 12 12
15 Tokyo Verdy Tokyo Verdy 10 12 13 10
16 Kawasaki Frontale Kawasaki 10 12 13 9
17 Kyoto Sanga Kyoto Sanga 10 8 13 9
18 Sagan Tosu Sagan Tosu 10 12 19 8
19 Shonan Bellmare Shonan 10 14 20 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
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
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
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
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
LIGA JAPONESA J1
Equipo PJ GF GC Puntos
1 Kashiwa Reysol Kashiwa 34 65 42 72
2 Nagoya Grampus Nagoya 34 67 36 71
3 Gamba Osaka Gamba Osaka 34 78 51 70
4 Vegalta Sendai Vegalta 34 39 25 56
5 Yokohama F. Marinos Yokohama 34 46 40 56
6 Kashima Antlers Kashima 34 53 40 50
7 Sanfrecce Hiroshima Sanfrecce 34 52 49 50
8 Júbilo Iwata Júbilo 34 53 45 47
9 Vissel Kobe Vissel Kobe 34 44 45 46
10 Shimizu S-Pulse Shimizu 34 42 51 45
11 Kawasaki Frontale Kawasaki 34 52 53 44
12 Cerezo Osaka Cerezo Osaka 34 67 53 43
13 Omiya Ardija Omiya Ardija 34 38 48 42
14 Albirex Niigata Albirex 34 38 46 39
15 Urawa Reds Urawa Reds 34 36 43 36
16 Ventforet Kofu Ventforet 34 42 63 33
17 Avispa Fukuoka Avispa 34 34 75 22
18 Montedio Yamagata Montedio 34 23 64 21
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
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

  USO DE MEMORIA  
8,242,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.8949
Total Execution Time  0.8960
  CADENA URL  
/historico/Avispa-Fukuoka
  GET DATOS  
$_GET['/historico/Avispa-Fukuoka']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0158  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 = 'Avispa-Fukuoka' 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.0145  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=403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293  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.0155  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 = 75185
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=403 AND type_rel = 2
0.0151  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 403 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0156  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 (560568,567951,700497,772263,816492) ORDER BY n.cover_points DESC, update_date DESC
0.0188  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 = '403' ORDER BY l.year DESC,cat.coefficient DESC
0.0162  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 = '403' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0155  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 = '403' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = 75185 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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.0151  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=403 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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,71432) 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.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 74986 AND teamId = 403
0.0176  SELECT count(id) as num_players from rel_players WHERE league_id = 75185 AND teamId = 403
0.0183  SELECT count(id) as num_players from rel_players WHERE league_id = 71686 AND teamId = 403
0.0188  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 403
0.0165  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 = 11 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0153  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 = '403' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '403' and rp.type = 4
0.0147  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 = '403' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0157  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 = 403 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.0155  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 = 403 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167  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 = 403 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 = 403 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0163  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 = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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.0160  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 = 66261 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.0155  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.0155  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.0151  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.0151  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.0150  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.0151  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.0150  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.0151  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.0151  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.0151  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.0150  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 = 1350 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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.0152  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.0153  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.0158  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.0149  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