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

CD Alhaurino

Entrenador: Hugo Díez

Temporada 2023/2024
TEMPORADA 2023/2024
DIVISIÓN HONOR SENIOR GRUPO 2
Equipo PJ GF GC Puntos
1 CP Mijas Las Lagunas Mijas 30 60 36 57
2 Atletico Porcuna Atletico 30 63 39 56
3 Martos CD Martos CD 30 40 20 54
4 UD San Pedro Pedro 30 44 25 53
5 CD Alhaurino Alhaurino 30 46 28 50
6 Alhaurín de la Torre Alhaurín 30 49 37 49
7 Churriana de la Vega Churriana 30 37 25 49
8 Loja Loja 30 40 39 44
9 CD Cantoria CD Cantoria 30 41 45 44
10 CD Casabermeja Casabermeja 30 46 33 43
11 Atarfe Industrial Atarfe 30 55 51 39
12 Benagalbón CD Benagalbón 30 28 40 35
13 Iliturgi 2016 Iliturgi 30 36 46 31
14 CD Huercal CD Huercal 30 32 69 28
15 Almuñecar City Almuñecar 30 29 66 25
16 Berja Berja 30 24 71 8
TEMPORADA 2022/2023
DIVISIÓN HONOR SENIOR GRUPO 2
Equipo PJ GF GC Puntos
1 CD Rincón CD Rincón 30 58 22 68
2 Poli Almería Poli 30 39 20 58
3 CP Mijas Las Lagunas Mijas 30 51 30 56
4 Alhaurín de la Torre Alhaurín 30 50 27 55
5 Almuñecar City Almuñecar 30 40 30 48
6 CD Alhaurino Alhaurino 30 47 37 47
7 UD San Pedro Pedro 30 36 29 45
8 Martos CD Martos CD 30 39 40 41
9 CD Casabermeja Casabermeja 30 40 39 40
10 Berja Berja 30 49 61 37
11 Atarfe Industrial Atarfe 30 37 40 36
12 CD Cantoria CD Cantoria 30 38 47 36
13 CD Villacarrillo Villacarrill 30 32 46 34
14 Cubillas FC Cubillas FC 30 28 42 24
15 Vilches Vilches 30 23 53 20
16 UD Pavía UD Pavía 30 14 58 13
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 J. Torremolinos Torremolinos 32 45 21 63
2 CD Huétor Tájar Huétor 32 56 30 58
3 Marbella FC Marbella FC 32 53 26 58
4 Almería B Almería B 32 59 31 57
5 At. Malagueño Malagueño 32 51 38 57
6 CF Motril CF Motril 32 59 37 56
7 UDC Torredonjimeno Torredonjime 32 55 35 55
8 UD Torre Del Mar Torre 32 52 40 49
9 Atletico Porcuna Atletico 32 42 47 42
10 El Palo FC El Palo FC 32 40 40 41
11 Huétor Vega Huétor Vega 32 33 38 39
12 CD Torreperogil Torreperogil 32 28 36 38
13 Real Jaén Real Jaén 32 31 43 36
14 Alhaurín de la Torre Alhaurín 32 28 49 34
15 UD San Pedro Pedro 32 26 48 28
16 CD Alhaurino Alhaurino 32 40 53 27
17 Intergym Melilla Intergym 32 13 99 4
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Mancha Real Mancha Real 20 35 12 36
2 Almería B Almería B 20 32 25 33
3 UDC Torredonjimeno Torredonjime 20 35 25 33
4 CD Torreperogil Torreperogil 20 16 17 28
5 CD Huétor Tájar Huétor 20 28 25 28
6 Huétor Vega Huétor Vega 20 25 27 25
7 Real Jaén Real Jaén 20 24 27 25
8 Poli Almería Poli 20 15 25 23
9 Loja Loja 20 15 32 21
10 Atletico Porcuna Atletico 20 22 23 21
11 Maracena Maracena 20 19 28 20
12 Vélez CF Vélez CF 18 22 15 37
13 Antequera CF Antequera 18 29 11 30
14 El Palo FC El Palo FC 18 18 17 28
15 J. Torremolinos Torremolinos 18 23 18 28
16 At. Malagueño Malagueño 18 28 19 28
17 Alhaurín de la Torre Alhaurín 18 17 27 20
18 CD Estepona CD Estepona 18 18 25 20
19 CF Motril CF Motril 18 21 26 20
20 Melilla CD Melilla CD 18 17 29 17
21 CD Alhaurino Alhaurino 18 22 28 17
TEMPORADA 2019/2020
DIVISIÓN HONOR SENIOR GRUPO 2
Equipo PJ GF GC Puntos
1 CD Alhaurino Alhaurino 26 52 18 59
2 J. Torremolinos Torremolinos 27 46 17 57
3 CD Estepona CD Estepona 27 42 19 55
4 CD Rincón CD Rincón 26 48 32 46
5 Celtic Pulianas Celtic 27 45 40 46
6 Athletic Coín Athletic 27 37 37 44
7 Begíjar CF Begíjar CF 26 34 25 42
8 UD San Pedro Pedro 27 26 31 38
9 Atarfe Industrial Atarfe 26 36 28 36
10 Arenas de Armilla Arenas 26 37 34 36
11 Berja Berja 27 37 28 35
12 CD Villacarrillo Villacarrill 27 41 37 33
13 Martos CD Martos CD 27 34 46 30
14 CD Cantoria CD Cantoria 27 29 49 30
15 Cubillas FC Cubillas FC 26 25 28 29
16 CD Churriana Churriana 26 24 44 27
17 CD Casabermeja Casabermeja 27 22 38 24
18 Guadix CF Guadix CF 26 19 44 22
19 CD Villanueva Villanueva 26 21 60 11
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Real Jaén Real Jaén 42 99 32 101
2 Linares Deportivo Linares 42 80 31 90
3 Antequera CF Antequera 42 90 35 82
4 El Palo FC El Palo FC 42 65 34 81
5 Vélez CF Vélez CF 42 56 40 68
6 CF Motril CF Motril 42 79 59 68
7 Loja Loja 42 68 64 62
8 Mancha Real Mancha Real 42 59 52 60
9 UDC Torredonjimeno Torredonjime 42 74 59 58
10 CD Torreperogil Torreperogil 42 43 52 58
11 CD Huétor Tájar Huétor 42 65 55 57
12 Huétor Vega Huétor Vega 42 56 65 57
13 Poli Almería Poli 42 53 57 57
14 Alhaurín de la Torre Alhaurín 42 72 70 56
15 CD Alhaurino Alhaurino 42 72 66 56
16 J. Torremolinos Torremolinos 42 57 65 53
17 CD Rincón CD Rincón 42 45 63 52
18 Martos CD Martos CD 42 41 70 44
19 Atarfe Industrial Atarfe 42 49 79 42
20 UD San Pedro Pedro 42 48 75 41
21 Guadix CF Guadix CF 42 44 95 35
22 River Melilla River 42 28 125 4
TEMPORADA 2017/2018
DIVISIÓN HONOR SENIOR GRUPO 2
Equipo PJ GF GC Puntos
1 CD Torreperogil Torreperogil 34 80 35 76
2 Alhaurín de la Torre Alhaurín 34 71 32 73
3 Poli Almería Poli 34 67 28 68
4 CD Alhaurino Alhaurino 34 67 32 68
5 Atletico Porcuna Atletico 34 52 34 67
6 Cd Adra Milenaria Adra 34 51 47 49
7 Malaka Malaka 34 45 49 49
8 Estudiantes de Almeria Estudiantes 34 66 57 46
9 CD Estepona CD Estepona 34 47 50 44
10 Berja Berja 33 52 51 43
11 Navas CD Navas CD 34 48 56 43
12 Arenas de Armilla Arenas 34 42 48 40
13 Athletic Coín Athletic 34 53 58 38
14 Atlético Monachil Atlético 33 46 75 37
15 Cullar Vega Cullar Vega 33 41 62 36
16 UD Pavía UD Pavía 34 33 66 29
17 Churriana de la Vega Churriana 33 36 76 24
18 Roquetas CF 2016 Roquetas 30 31 72 22
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 At. Malagueño Malagueño 38 107 34 90
2 Antequera CF Antequera 38 70 38 75
3 Almería B Almería B 38 61 36 71
4 CD Huétor Tájar Huétor 38 73 48 71
5 CF Motril CF Motril 38 71 43 70
6 Loja Loja 38 63 41 66
7 CD Rincón CD Rincón 38 49 52 57
8 El Palo FC El Palo FC 38 64 57 56
9 Martos CD Martos CD 38 57 54 53
10 Guadix CF Guadix CF 38 47 51 51
11 UD San Pedro Pedro 38 44 49 48
12 UDC Torredonjimeno Torredonjime 38 41 51 48
13 Maracena Maracena 38 50 54 46
14 Atarfe Industrial Atarfe 38 42 61 45
15 Vélez CF Vélez CF 38 44 64 44
16 Huétor Vega Huétor Vega 38 45 55 44
17 River Melilla River 38 47 67 40
18 CD Alhaurino Alhaurino 38 37 67 31
19 D.H. San Andrés D.H. Andrés 38 48 88 28
20 Alhaurín de la Torre Alhaurín 38 39 89 19
TEMPORADA 2015/2016
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 CD Alhaurino Alhaurino 34 84 37 74
2 UDC Torredonjimeno Torredonjime 34 74 33 72
3 D.H. San Andrés D.H. Andrés 34 83 49 67
4 Atletico Porcuna Atletico 34 70 37 64
5 CD Torreperogil Torreperogil 34 54 40 60
6 J. Torremolinos Torremolinos 33 69 36 58
7 Athletic Coín Athletic 33 56 38 51
8 CD Villacarrillo Villacarrill 34 48 41 51
9 CD Tiro Pichón Tiro Pichón 34 61 58 45
10 Athletic Fuengirola Athletic 34 71 79 44
11 Malaka Malaka 34 56 72 40
12 CD Mijas CD Mijas 33 44 57 38
13 CF Alameda CF Alameda 34 50 72 37
14 Cala Míjas CD Cala Míjas 34 34 51 36
15 CD Casabermeja Casabermeja 34 38 55 36
16 At. Benamiel Benamiel 34 52 65 32
17 Barrio NSR Barrio NSR 33 46 89 19
18 UD Fuengirola Los Boliches Fuengirola 34 19 100 12
TEMPORADA 2014/2015
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 CD Rincón CD Rincón 30 63 31 64
2 UDC Torredonjimeno Torredonjime 30 53 28 58
3 CD Alhaurino Alhaurino 30 58 35 57
4 J. Torremolinos Torremolinos 30 63 32 55
5 Atletico Porcuna Atletico 30 46 48 44
6 D.H. San Andrés D.H. Andrés 30 57 44 42
7 Cala Míjas CD Cala Míjas 30 46 51 42
8 CD Tiro Pichón Tiro Pichón 30 42 32 41
9 Athletic Coín Athletic 30 47 46 40
10 Athletic Fuengirola Athletic 30 54 56 39
11 Barrio NSR Barrio NSR 30 40 48 36
12 CF Alameda CF Alameda 30 37 55 33
13 At. Benamiel Benamiel 30 42 63 33
14 UD Fuengirola Los Boliches Fuengirola 30 35 54 30
15 Real Jaén B Real Jaén 30 24 65 23
16 CD Cártama CD Cártama 30 46 65 21
TEMPORADA 2013/2014
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 Alhaurín de la Torre Alhaurín 32 74 28 77
2 J. Torremolinos Torremolinos 32 73 29 66
3 CD Alhaurino Alhaurino 32 77 36 65
4 CF Alameda CF Alameda 32 68 51 60
5 CD Rincón CD Rincón 32 66 49 53
6 D.H. San Andrés D.H. Andrés 32 88 71 49
7 UDC Torredonjimeno Torredonjime 32 60 48 46
8 Athletic Coín Athletic 32 59 65 43
9 Athletic Fuengirola Athletic 32 53 61 42
10 Atletico Porcuna Atletico 32 44 53 38
11 CD Tiro Pichón Tiro Pichón 32 39 52 37
12 Real Jaén B Real Jaén 32 45 68 35
13 UD Fuengirola Los Boliches Fuengirola 32 47 71 35
14 At. Benamiel Benamiel 32 48 64 34
15 CD Casabermeja B Casabermeja 32 39 59 34
16 Peña Compadres Peña 32 45 81 27
17 CD Puerto de la Torre Puerto Torre 32 38 77 15
TEMPORADA 2012/2013
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 Antequera CF Antequera 32 70 29 68
2 Los Villares CF Villares 32 70 27 66
3 CD Alhaurino Alhaurino 32 63 29 61
4 D.H. San Andrés D.H. Andrés 32 78 50 57
5 Athletic Coín Athletic 32 67 49 52
6 UDC Torredonjimeno Torredonjime 32 47 34 51
7 Peña Compadres Peña 32 60 63 50
8 CF Alameda CF Alameda 32 46 48 45
9 Athletic Fuengirola Athletic 32 56 55 42
10 UD Fuengirola Los Boliches Fuengirola 32 50 55 41
11 Real Jaén B Real Jaén 32 39 56 40
12 CD Rincón CD Rincón 32 45 64 38
13 At. Benamiel Benamiel 32 43 56 36
14 CD Úbeda Viva Úbeda Viva 32 39 61 35
15 CD Churriana Churriana 32 42 52 34
16 CD Barrio NS Remedios Barrio 32 35 69 25
17 At. Pedregalejo Pedregalejo 32 35 88 18
18 Iliturgi CF Iliturgi CF 0 0 0 0
TEMPORADA 2011/2012
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 CD Villacarrillo Villacarrill 34 79 22 86
2 Linares Deportivo Linares 34 85 21 83
3 J. Torremolinos Torremolinos 34 72 31 82
4 D.H. San Andrés D.H. Andrés 34 84 38 77
5 CD Alhaurino Alhaurino 34 63 38 59
6 CD Churriana Churriana 34 45 47 48
7 Coín Atlético Coín 34 48 51 48
8 UD Fuengirola Los Boliches Fuengirola 34 52 51 46
9 CD Úbeda Viva Úbeda Viva 34 44 43 46
10 Carolinense Carolinense 34 33 53 42
11 At. Benamiel Benamiel 34 47 47 41
12 CD Rincón CD Rincón 34 41 68 37
13 CF Alameda CF Alameda 34 36 52 36
14 Real Jaén B Real Jaén 34 45 66 33
15 CD Barrio NS Remedios Barrio 34 40 62 32
16 Baeza CF Baeza CF 34 28 62 26
17 At. Marbellí Marbellí 34 36 71 22
18 Malaka Malaka 34 25 80 17
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 CD Comarca de Níjar Comarca 38 57 29 79
2 Alhaurín de la Torre Alhaurín 38 61 25 78
3 Loja Loja 38 60 35 74
4 At. Malagueño Malagueño 38 62 35 70
5 CD Ronda CD Ronda 38 68 37 68
6 Maracena Maracena 38 51 36 63
7 Antequera CF Antequera 38 72 47 62
8 Motril CF Motril CF 38 50 33 58
9 Martos CD Martos CD 38 38 39 53
10 Marbella FC Marbella FC 38 52 50 50
11 Mancha Real Mancha Real 38 49 42 49
12 CD Huétor Tájar Huétor 38 37 54 46
13 El Palo FC El Palo FC 38 57 65 46
14 Ciudad Vícar Ciudad 38 46 54 45
15 Vélez CF Vélez CF 38 56 57 44
16 UD Carboneras Carboneras 38 57 71 40
17 Casino Real CF Casino Real 38 44 65 40
18 Baza Baza 38 30 60 34
19 CD Alhaurino Alhaurino 38 38 58 30
20 Adra Adra 38 13 106 6
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Mancha Real Mancha Real 36 53 26 68
2 Motril CF Motril CF 36 54 24 66
3 El Palo FC El Palo FC 36 59 44 63
4 Almería B Almería B 36 62 37 61
5 CD Ronda CD Ronda 36 64 51 60
6 At. Malagueño Malagueño 36 56 44 59
7 CD Comarca de Níjar Comarca 36 52 34 57
8 Ciudad Vícar Ciudad 36 52 48 53
9 Loja Loja 36 42 40 49
10 Antequera CF Antequera 36 43 38 47
11 Vélez CF Vélez CF 36 50 52 47
12 CD Alhaurino Alhaurino 36 53 54 45
13 Adra Adra 36 47 59 45
14 CD Santa Fe CD Santa Fe 36 40 55 41
15 Carboneras Carboneras 36 43 63 38
16 CD Huétor Tájar Huétor 36 44 67 38
17 Baza Baza 36 36 54 37
18 Arenas de Armilla Arenas 36 33 63 35
19 Polideportivo Ejido B Polideportiv 19 21 22 24
20 CD Vera CD Vera 19 17 46 10
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Unión Estepona Unión 35 71 31 80
2 Almería B Almería B 35 80 35 75
3 Motril CF Motril CF 35 66 36 71
4 Baza Baza 35 53 29 61
5 At. Malagueño Malagueño 34 59 30 60
6 Polideportivo Ejido B Polideportiv 34 53 36 56
7 CD Comarca de Níjar Comarca 35 46 38 56
8 Vélez CF Vélez CF 34 52 45 51
9 Loja Loja 34 26 37 45
10 Ciudad Vícar Ciudad 34 52 47 44
11 CD Ronda CD Ronda 35 48 54 43
12 CD Alhaurino Alhaurino 35 52 56 42
13 Granada Atlético Granada 34 40 47 42
14 Arenas de Armilla Arenas 34 33 41 38
15 Adra Adra 34 37 59 36
16 CD Vera CD Vera 34 30 56 35
17 Granada 74 Granada 74 34 41 54 34
18 CD Santa Fe CD Santa Fe 35 38 63 34
19 Imperio Albolote Imperio 34 26 66 27
20 Casino Real CF Casino Real 34 26 69 26
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Ciudad de Roquetas Ciudad 36 79 36 75
2 Antequera CF Antequera 36 55 27 70
3 Arenas de Armilla Arenas 37 43 29 63
4 Vélez CF Vélez CF 36 58 37 62
5 Granada Atlético Granada 35 47 25 60
6 Polideportivo Ejido B Polideportiv 36 58 33 57
7 CD Alhaurino Alhaurino 37 49 46 57
8 Almería B Almería B 37 52 41 54
9 Mengibar Mengibar 36 61 39 53
10 CD Comarca de Níjar Comarca 36 47 47 53
11 Motril CF Motril CF 36 54 52 52
12 Granada 74 Granada 74 37 49 46 50
13 Ciudad Vícar Ciudad 36 43 39 50
14 Loja Loja 36 42 41 49
15 CD Vera CD Vera 36 67 61 47
16 Adra Adra 38 48 51 47
17 At. Malagueño Malagueño 38 45 45 46
18 UD Fuengirola Los Boliches Fuengirola 36 34 61 40
19 Torredonjimeno Torredonjime 36 38 95 28
20 Alhaurín de la Torre Alhaurín 36 41 71 26
21 Peña Real Madrid Peña Real M. 35 10 98 12
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Granada Atlético Granada 38 56 25 81
2 Ciudad de Roquetas Ciudad 38 62 31 79
3 Polideportivo Ejido B Polideportiv 38 53 26 70
4 Motril CF Motril CF 38 69 39 67
5 Arenas de Armilla Arenas 38 56 26 66
6 Adra Adra 38 60 41 65
7 Vélez CF Vélez CF 38 54 45 60
8 Antequera CF Antequera 38 47 41 59
9 UD Fuengirola Los Boliches Fuengirola 38 47 43 55
10 CD Alhaurino Alhaurino 38 54 58 51
11 Almería B Almería B 38 37 50 49
12 CD Vera CD Vera 38 50 49 46
13 CD Comarca de Níjar Comarca 38 39 52 45
14 Torredonjimeno Torredonjime 38 43 45 44
15 Alhaurín de la Torre Alhaurín 38 36 48 43
16 CD Huercal CD Huercal 38 41 51 41
17 Loja Loja 38 32 48 39
18 Carolinense Carolinense 38 36 56 35
19 Imperio Albolote Imperio 38 27 64 26
20 Maracena Maracena 38 22 83 21
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Granada Granada 38 80 26 78
2 Motril CF Motril CF 38 77 27 77
3 Granada Atlético Granada 38 65 23 76
4 Arenas de Armilla Arenas 38 56 26 76
5 Torredonjimeno Torredonjime 38 67 36 70
6 CD Roquetas CD Roquetas 38 71 38 65
7 CD Huercal CD Huercal 38 64 47 62
8 UD Fuengirola Los Boliches Fuengirola 38 73 49 57
9 Alhaurín de la Torre Alhaurín 38 46 56 51
10 Almería B Almería B 38 45 46 51
11 Imperio Albolote Imperio 38 41 47 51
12 CD Vera CD Vera 38 36 54 47
13 CD Alhaurino Alhaurino 38 44 36 46
14 Maracena Maracena 38 49 47 46
15 Loja Loja 38 41 47 44
16 Comarca Níjar Comarca 38 40 48 43
17 Carolinense Carolinense 38 53 58 42
18 CD Santa Fe CD Santa Fe 38 34 62 41
19 Úbeda CF Úbeda CF 38 19 87 19
20 CD Basto CD Basto 38 18 159 9
TEMPORADA 2004/2005
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Baza Baza 38 78 23 85
2 Torredonjimeno Torredonjime 38 69 27 80
3 CD Roquetas CD Roquetas 38 67 27 74
4 CD Alhaurino Alhaurino 38 61 23 74
5 Granada Granada 38 69 35 73
6 Comarca Níjar Comarca 38 59 33 72
7 UD Fuengirola Los Boliches Fuengirola 38 48 45 60
8 Guadix CF Guadix CF 38 35 35 49
9 Motril CF Motril CF 38 35 35 49
10 CD Santa Fe CD Santa Fe 38 35 51 44
11 Maracena Maracena 38 30 38 44
12 Úbeda CF Úbeda CF 38 39 46 44
13 Imperio Albolote Imperio 38 40 43 44
14 Carolinense Carolinense 38 38 44 43
15 Almería B Almería B 38 36 44 43
16 Mancha Real Mancha Real 38 30 44 42
17 CD Vera CD Vera 38 40 56 42
18 Loja Loja 38 26 39 40
19 Granada 74 Granada 74 38 38 73 36
20 Rusadir Rusadir 38 20 132 9

  USO DE MEMORIA  
7,952,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1630
Total Execution Time  0.1642
  CADENA URL  
/historico/Alhaurino
  GET DATOS  
$_GET['/historico/Alhaurino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0036  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 = 'Alhaurino' 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.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=170 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=170 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=170 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=170 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0047  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 = 72023
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=170 AND type_rel = 2
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 170 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0027  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 (74477,285076,392760,461286,477746) ORDER BY n.cover_points DESC, update_date DESC
0.0041  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 = '170' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72023 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037  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=170 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (73496,72023,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.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 73496 AND teamId = 170
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72023 AND teamId = 170
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 170
0.0020  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 = 72023 AND t.round = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '170' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '170' and rp.type = 4
0.0024  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 = '170' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '170' and rp.type = 4
0.0041  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 = 72023 WHERE rp.league_id = 72023 AND rp.teamId = 170 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 events2024 e ON e.player_id = p.id AND e.league_id = 72023 WHERE rp.league_id = 72023 AND rp.teamId = 170 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 = 72023 WHERE rp.league_id = 72023 AND rp.teamId = 170 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 170 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73496 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 68672 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 62393 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.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 = 58588 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 51037 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 44397 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 `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 = 39237 AND t.round = 34 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 `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 = 33359 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 `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 = 16714 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 `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 = 4079 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 2571 AND t.round = 34 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 `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 = 2075 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 `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 = 1469 AND t.round = 34 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 `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 = 1122 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 839 AND t.round = 38 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 `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 = 139 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 `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 = 16 AND t.round = 42 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 `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 = 94 AND t.round = 38 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 = 22102 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC