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

Maracena

Entrenador: Jesús Sierra Ruiz

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 J. Torremolinos Torremolinos 30 62 21 69
2 Real Jaén Real Jaén 31 61 25 66
3 UD Torre Del Mar Torre 31 43 27 59
4 At. Malagueño Malagueño 30 48 19 57
5 Almería B Almería B 30 56 24 57
6 CF Motril CF Motril 30 34 18 49
7 Arenas de Armilla Arenas 31 29 35 44
8 Huétor Vega Huétor Vega 31 37 37 42
9 Poli Almería Poli 31 30 32 40
10 UDC Torredonjimeno Torredonjime 30 31 41 36
11 CD Torreperogil Torreperogil 30 29 37 35
12 Mancha Real Mancha Real 30 36 36 35
13 Pvo. El Ejido Pvo. Ejido 31 26 37 33
14 CD Huétor Tájar Huétor 31 20 35 31
15 FC Málaga City Málaga City 30 22 38 30
16 Maracena Maracena 31 27 47 29
17 CD Rincón CD Rincón 31 26 50 22
18 Atletico Melilla Atletico 31 15 73 4
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Marbella FC Marbella FC 30 67 17 72
2 Real Jaén Real Jaén 30 59 12 68
3 El Palo FC El Palo FC 30 43 20 63
4 UD Torre Del Mar Torre 30 53 31 55
5 At. Malagueño Malagueño 30 45 27 45
6 Huétor Vega Huétor Vega 30 42 35 45
7 CF Motril CF Motril 30 37 41 41
8 UDC Torredonjimeno Torredonjime 30 45 42 41
9 Almería B Almería B 30 40 34 41
10 Arenas de Armilla Arenas 30 36 36 39
11 CD Torreperogil Torreperogil 30 40 45 38
12 CD Huétor Tájar Huétor 30 52 44 37
13 Maracena Maracena 30 34 48 33
14 FC Málaga City Málaga City 30 22 48 25
15 Atletico Porcuna Atletico 30 30 54 21
16 CD Huracán Melilla Huracán 30 8 119 5
TEMPORADA 2021/2022
DIVISIÓN HONOR SENIOR GRUPO 2
Equipo PJ GF GC Puntos
1 CD Estepona CD Estepona 36 82 26 83
2 FC Málaga City Málaga City 36 61 29 75
3 Arenas de Armilla Arenas 36 64 23 70
4 Maracena Maracena 36 73 36 66
5 CD Villacarrillo Villacarrill 36 53 39 62
6 CD Rincón CD Rincón 36 54 39 60
7 CD Cantoria CD Cantoria 36 58 52 58
8 Atarfe Industrial Atarfe 36 53 50 54
9 Berja Berja 36 51 47 53
10 Cubillas FC Cubillas FC 36 48 40 52
11 Poli Almería Poli 36 42 36 50
12 CD Casabermeja Casabermeja 36 43 45 48
13 Celtic Pulianas Celtic 36 48 46 48
14 Begíjar CF Begíjar CF 36 40 45 45
15 Iliturgi 2016 Iliturgi 36 48 58 38
16 La Cañada Atlético Cañada 36 39 69 26
17 Loja Loja 36 29 73 18
18 Atlético Monachil Atlético 36 30 79 18
19 CD Churriana Churriana 36 29 113 16
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
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Linares Deportivo Linares 29 60 16 75
2 Pvo. El Ejido Pvo. Ejido 29 48 28 57
3 CF Motril CF Motril 29 50 24 56
4 Real Jaén Real Jaén 29 54 25 56
5 Almería B Almería B 29 60 28 53
6 UDC Torredonjimeno Torredonjime 29 53 33 50
7 Antequera CF Antequera 29 42 32 49
8 El Palo FC El Palo FC 29 44 37 48
9 At. Malagueño Malagueño 29 41 37 39
10 Loja Loja 29 49 55 37
11 Mancha Real Mancha Real 29 25 29 35
12 CD Huétor Tájar Huétor 29 42 48 35
13 CD Torreperogil Torreperogil 29 30 35 34
14 Maracena Maracena 29 33 41 30
15 Poli Almería Poli 29 35 49 29
16 Vélez CF Vélez CF 29 37 56 28
17 Huétor Vega Huétor Vega 29 33 48 27
18 Melilla CD Melilla CD 29 21 64 23
19 Atletico Porcuna Atletico 29 21 48 20
20 Alhaurín de la Torre Alhaurín 29 29 74 13
TEMPORADA 2018/2019
DIVISIÓN HONOR SENIOR GRUPO 2
Equipo PJ GF GC Puntos
1 Atletico Porcuna Atletico 34 61 29 71
2 Maracena Maracena 34 58 33 69
3 Berja Berja 34 69 34 63
4 CD Casabermeja Casabermeja 34 41 32 56
5 Begíjar CF Begíjar CF 34 54 42 55
6 Celtic Pulianas Celtic 34 43 38 52
7 CD Estepona CD Estepona 34 42 41 51
8 Athletic Coín Athletic 34 48 35 50
9 Arenas de Armilla Arenas 34 58 51 50
10 CD Villacarrillo Villacarrill 34 43 44 49
11 Cd Oriente Cd Oriente 34 47 47 45
12 CD Vera CD Vera 34 46 47 41
13 Malaka Malaka 34 41 51 41
14 Navas CD Navas CD 34 42 42 40
15 CD Cártama CD Cártama 34 53 72 39
16 Cullar Vega Cullar Vega 34 43 60 33
17 Atlético Monachil Atlético 34 31 77 26
18 Cd Adra Milenaria Adra 34 24 69 18
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 At. Malagueño Malagueño 42 95 31 96
2 Almería B Almería B 42 97 35 86
3 Real Jaén Real Jaén 42 58 29 82
4 Antequera CF Antequera 42 78 37 82
5 CD Huétor Tájar Huétor 42 77 49 82
6 CF Motril CF Motril 42 85 56 81
7 Linares Deportivo Linares 42 68 47 74
8 Mancha Real Mancha Real 42 66 46 72
9 Loja Loja 42 87 63 69
10 El Palo FC El Palo FC 42 66 50 67
11 UDC Torredonjimeno Torredonjime 42 79 65 67
12 Vélez CF Vélez CF 42 60 65 56
13 CD Rincón CD Rincón 42 53 61 52
14 J. Torremolinos Torremolinos 42 64 76 50
15 Martos CD Martos CD 42 58 85 47
16 Atarfe Industrial Atarfe 42 46 69 43
17 UD San Pedro Pedro 42 43 80 43
18 Huétor Vega Huétor Vega 42 47 74 38
19 Guadix CF Guadix CF 42 40 77 37
20 Maracena Maracena 42 44 73 35
21 CD Villacarrillo Villacarrill 42 44 79 28
22 Melistar Melistar 42 24 132 12
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
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Mancha Real Mancha Real 38 73 25 86
2 At. Malagueño Malagueño 38 96 34 86
3 Loja Loja 38 68 26 81
4 Pvo. El Ejido Pvo. Ejido 38 77 32 79
5 El Palo FC El Palo FC 38 69 24 76
6 Antequera CF Antequera 38 67 33 71
7 Guadix CF Guadix CF 38 68 46 70
8 Vélez CF Vélez CF 38 55 33 65
9 CD Huétor Tájar Huétor 38 60 37 59
10 Martos CD Martos CD 38 58 55 56
11 UD San Pedro Pedro 38 55 67 48
12 Los Villares CF Villares 38 46 57 44
13 CD Rincón CD Rincón 38 48 59 41
14 Alhaurín de la Torre Alhaurín 38 42 67 40
15 Atarfe Industrial Atarfe 38 45 71 36
16 Maracena Maracena 38 48 69 36
17 River Melilla River 38 44 88 32
18 Comarca Del Marmol Comarca 38 30 62 31
19 CD Ronda CD Ronda 38 32 97 24
20 Español de Alquián Español 38 11 110 4
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Linares Deportivo Linares 38 88 26 88
2 At. Malagueño Malagueño 38 69 36 75
3 UD San Pedro Pedro 38 65 35 73
4 Martos CD Martos CD 38 66 42 71
5 Loja Loja 38 55 36 69
6 CD Huétor Tájar Huétor 38 53 37 62
7 Los Villares CF Villares 38 43 37 58
8 Maracena Maracena 38 66 52 57
9 Guadix CF Guadix CF 38 49 49 51
10 Mancha Real Mancha Real 38 36 34 50
11 Vélez CF Vélez CF 38 49 47 49
12 Español de Alquián Español 38 53 70 48
13 Pvo. El Ejido Pvo. Ejido 38 55 75 47
14 CD Ronda CD Ronda 38 52 63 43
15 Antequera CF Antequera 38 51 55 42
16 Alhaurín de la Torre Alhaurín 38 43 74 41
17 Atarfe Industrial Atarfe 38 53 70 37
18 CD Villacarrillo Villacarrill 38 32 64 31
19 Atletico Melilla Atletico 38 29 58 30
20 Los Molinos Los Molinos 38 32 79 26
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Marbella FC Marbella FC 38 81 37 86
2 Linares Deportivo Linares 38 71 28 82
3 At. Malagueño Malagueño 38 74 34 82
4 Loja Loja 38 88 44 79
5 Mancha Real Mancha Real 38 51 31 72
6 Vélez CF Vélez CF 38 60 31 67
7 Martos CD Martos CD 38 65 49 60
8 CD Villacarrillo Villacarrill 38 63 46 59
9 CD Huétor Tájar Huétor 38 36 42 53
10 Atarfe Industrial Atarfe 38 48 49 50
11 Maracena Maracena 38 44 44 49
12 Español de Alquián Español 38 58 71 49
13 Antequera CF Antequera 38 43 54 44
14 UD San Pedro Pedro 38 34 54 44
15 CD Ronda CD Ronda 38 48 58 43
16 Los Molinos Los Molinos 38 53 64 43
17 Los Villares CF Villares 38 36 55 42
18 UD Melilla B Melilla 38 44 66 40
19 CD Huercal CD Huercal 38 29 106 13
20 Unión Estepona Unión 38 16 79 0
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 El Palo FC El Palo FC 38 72 36 74
2 Mancha Real Mancha Real 38 50 27 72
3 Recreativo Granada Recreativo 38 73 35 72
4 At. Malagueño Malagueño 38 71 27 71
5 Linares Deportivo Linares 38 52 30 70
6 CD Villacarrillo Villacarrill 38 66 41 65
7 Martos CD Martos CD 38 52 44 64
8 Vélez CF Vélez CF 38 51 47 56
9 Atarfe Industrial Atarfe 38 58 48 53
10 Maracena Maracena 38 47 49 51
11 Marbella FC Marbella FC 38 52 53 49
12 Casino Real CF Casino Real 38 43 44 48
13 UD San Pedro Pedro 38 50 45 47
14 CD Ronda CD Ronda 38 53 56 45
15 Unión Estepona Unión 38 45 55 45
16 CD Huétor Tájar Huétor 38 44 67 41
17 CD Huercal CD Huercal 38 33 73 31
18 J. Torremolinos Torremolinos 38 32 67 30
19 Alhaurín de la Torre Alhaurín 38 29 79 23
20 CD Comarca de Níjar Comarca 38 24 74 23
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Loja Loja 40 87 33 86
2 Unión Estepona Unión 40 76 37 85
3 Marbella FC Marbella FC 40 66 28 78
4 At. Malagueño Malagueño 39 77 34 76
5 Maracena Maracena 39 62 40 73
6 CD Comarca de Níjar Comarca 40 57 34 70
7 Mancha Real Mancha Real 40 53 34 70
8 UD San Pedro Pedro 40 67 46 67
9 El Palo FC El Palo FC 40 63 57 65
10 Martos CD Martos CD 40 49 45 59
11 Casino Real CF Casino Real 39 44 49 54
12 CD Ronda CD Ronda 40 49 60 51
13 Alhaurín de la Torre Alhaurín 40 59 63 50
14 CD Huétor Tájar Huétor 39 50 56 49
15 Motril CF Motril CF 40 51 45 48
16 CD Nerja Fundación Nerja 39 42 57 45
17 Vélez CF Vélez CF 39 36 60 39
18 Arenas de Armilla Arenas 40 35 51 37
19 Antequera CF Antequera 40 47 70 37
20 Ciudad Vícar Ciudad 40 22 80 18
21 UD Carboneras Carboneras 40 6 119 4
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
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 Maracena Maracena 34 73 28 75
2 San Isidro CD Isidro 34 87 54 69
3 Guadix CF Guadix CF 34 63 31 66
4 Atarfe Industrial Atarfe 34 64 35 62
5 Español de Alquián Español 34 61 37 57
6 Recreativo Granada Recreativo 34 65 52 54
7 Atl. La Zubia Atl. Zubia 34 59 49 53
8 Cullar Vega Cullar Vega 34 60 52 49
9 UD Los Marinos Marinos 34 57 78 44
10 UD Pavía UD Pavía 34 61 68 43
11 Vandalia Vandalia 34 41 41 42
12 Berja Berja 34 48 52 42
13 Huétor Vega Huétor Vega 34 41 52 40
14 Las Norias Las Norias 34 53 82 38
15 CD Churriana Churriana 34 42 64 37
16 Imperio Albolote Imperio 34 44 71 33
17 La Cañada Atlético Cañada 34 58 78 29
18 Gabia Gabia 34 52 105 25
TEMPORADA 2008/2009
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 Carboneras Carboneras 32 77 29 75
2 Español de Alquián Español 32 71 38 60
3 Atarfe Industrial Atarfe 32 50 26 58
4 CD Huétor Tájar Huétor 32 45 31 58
5 Vandalia Vandalia 32 52 37 50
6 Guadix CF Guadix CF 32 50 50 47
7 Cullar Vega Cullar Vega 32 44 49 46
8 Las Norias Las Norias 32 40 50 43
9 Recreativo Granada Recreativo 32 32 39 41
10 Maracena Maracena 32 43 52 40
11 Atl. La Zubia Atl. Zubia 32 47 46 38
12 CD Churriana Churriana 32 52 52 37
13 San Isidro CD Isidro 32 35 41 37
14 Hermandad Adra Hermandad 32 33 57 34
15 Gabia Gabia 32 34 60 34
16 Parador Roquetas Parador 32 29 52 32
17 Villa De Albox Villa Albox 32 33 58 26
TEMPORADA 2007/2008
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 CD Santa Fe CD Santa Fe 32 76 31 75
2 Imperio Albolote Imperio 32 49 24 66
3 Atarfe Industrial Atarfe 32 62 36 65
4 Parador Roquetas Parador 32 44 29 58
5 Atl. La Zubia Atl. Zubia 32 43 28 52
6 CD Huercal CD Huercal 32 38 33 51
7 CD Churriana Churriana 32 51 51 45
8 Las Norias Las Norias 32 36 45 41
9 Cullar Vega Cullar Vega 32 31 38 40
10 Recreativo Granada Recreativo 32 36 43 39
11 Vandalia Vandalia 32 31 39 36
12 Villa De Albox Villa Albox 32 36 41 34
13 CF Sierra Nevada Cenes Sierra 32 43 52 34
14 Gabia Gabia 32 26 43 33
15 Español de Alquián Español 32 44 56 31
16 Maracena Maracena 32 25 47 29
17 Almuñecar 77 Almuñecar 32 28 63 24
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
2ª ANDALUZA GRANADA
Equipo PJ GF GC Puntos
1 Atl. La Zubia Atl. Zubia 30 67 28 66
2 Granada Atlético B Granada 30 52 24 64
3 Motril CF B Motril CF B 30 67 34 63
4 Cullar Vega Cullar Vega 30 50 32 56
5 CD Iznalloz CD Iznalloz 30 46 22 55
6 Recreativo Granada Recreativo 30 46 32 48
7 CD Huétor Tájar Huétor 30 52 43 45
8 Chauchina Molino Vueltas Se Chauchina 30 44 47 41
9 Salobreña Salobreña 30 38 45 39
10 Maracena Maracena 30 38 56 30
11 Águilas De Zujaira Águilas 30 48 76 30
12 Vandalia Vandalia 30 41 62 29
13 Celtic Pulianas Celtic 30 42 61 28
14 U.D.E. Chana U.D.E. Chana 30 46 59 27
15 Alfacar UD Alfacar UD 30 36 63 24
16 Huétor Vega Huétor Vega 30 27 56 18

  USO DE MEMORIA  
7,960,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5883
Total Execution Time  0.5896
  CADENA URL  
/historico/Maracena
  GET DATOS  
$_GET['/historico/Maracena']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0119  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 = 'Maracena' 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.0105  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=1643 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=1643 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=1643 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1643 AND type_rel = 2
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1643 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109  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 (164342,291451,348215,364890,427423) ORDER BY n.cover_points DESC, update_date DESC
0.0112  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 = '1643' ORDER BY l.year DESC,cat.coefficient DESC
0.0109  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 = '1643' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0109  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 = '1643' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  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=1643 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (72268,71432,67773) 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.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 72268 AND teamId = 1643
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 67773 AND teamId = 1643
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1643
0.0216  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 = 72268 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0110  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 = '1643' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0108  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1643' and rp.type = 4
0.0107  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 = '1643' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0118  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 = 72268 WHERE rp.league_id = 72268 AND rp.teamId = 1643 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.0123  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 = 72268 WHERE rp.league_id = 72268 AND rp.teamId = 1643 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0116  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 = 72268 WHERE rp.league_id = 72268 AND rp.teamId = 1643 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0113  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 = 1643 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 67983 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.0111  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 = 63952 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.0109  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.0111  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 = 50277 AND t.round = 29 ORDER BY team.conference ASC,t.position 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 `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 = 44942 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 39033 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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.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 `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 = 15450 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 3918 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 2708 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 1953 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 1405 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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.0116  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 = 858 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  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 = 325 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122  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 = 111 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116  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 = 2966 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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.0109  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 = 2965 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC