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

Recreativo Granada

Entrenador: Germán Crespo

Temporada 2023/2024
TEMPORADA 2023/2024
PRIMERA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 CD Castellón Castellón 33 68 32 75
2 Córdoba CF Córdoba CF 33 60 28 67
3 UD Ibiza UD Ibiza 33 52 28 63
4 Málaga Málaga 33 44 21 62
5 AD Ceuta FC AD Ceuta FC 33 46 33 56
6 Recreativo Recreativo 33 35 30 52
7 Real Murcia Real Murcia 33 31 31 51
8 Antequera CF Antequera 33 41 39 50
9 Atlético B Atlético B 33 47 39 45
10 Alcoyano Alcoyano 33 34 34 45
11 CF Intercity Intercity 33 34 40 42
12 Algeciras CF Algeciras 33 36 35 42
13 RM Castilla RM Castilla 33 38 40 41
14 At. Sanluqueño Sanluqueño 33 32 37 38
15 AD Mérida AD Mérida 33 29 41 38
16 San Fernando CD Fernando 33 31 42 35
17 Linares Deportivo Linares 33 26 45 32
18 UD Melilla UD Melilla 33 23 48 27
19 Atlético Baleares Atlético 33 17 52 23
20 Recreativo Granada Recreativo 33 23 52 18
TEMPORADA 2022/2023
SEGUNDA FEDERACIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Antequera CF Antequera 34 58 24 73
2 Recreativo Recreativo 34 39 24 63
3 Recreativo Granada Recreativo 34 47 32 59
4 At. Sanluqueño Sanluqueño 34 47 33 58
5 UCAM Murcia UCAM Murcia 34 46 27 54
6 Yeclano Deportivo Yeclano 34 35 29 52
7 San Roque de Lepe Roque Lepe 34 35 30 47
8 Racing Cartagena Mar Menor Racing 34 32 36 45
9 FC Cartagena B Cartagena 34 38 42 45
10 Sevilla At. Sevilla At. 34 36 31 45
11 Cádiz CF Mirandilla Cádiz 34 38 46 45
12 Betis Deportivo Betis 34 34 35 44
13 Vélez CF Vélez CF 34 41 52 44
14 Xerez Deportivo Xerez 34 30 36 40
15 Pvo. El Ejido Pvo. Ejido 34 34 41 39
16 J. Torremolinos Torremolinos 34 30 40 34
17 Mancha Real Mancha Real 34 26 48 31
18 Utrera Utrera 34 27 67 19
TEMPORADA 2021/2022
SEGUNDA FEDERACIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 CF Intercity Intercity 34 46 16 66
2 CF La Nucía Nucía 34 41 18 64
3 Real Murcia Real Murcia 34 42 27 58
4 Eldense Eldense 34 47 37 56
5 Hércules Hércules 34 41 31 56
6 Racing Cartagena Mar Menor Racing 34 34 29 55
7 UD Alzira UD Alzira 34 42 36 51
8 Recreativo Granada Recreativo 34 34 32 46
9 UD Melilla UD Melilla 34 36 39 45
10 Mancha Real Mancha Real 34 32 36 43
11 Pvo. El Ejido Pvo. Ejido 34 30 35 43
12 UD Yugo Socuéllamos Yugo 34 29 34 43
13 Águilas FC Águilas FC 34 32 36 41
14 At. Levante At. Levante 34 33 33 38
15 At. Pulpileño Pulpileño 34 23 48 34
16 CD Marchamalo Marchamalo 34 33 59 32
17 CS Puertollano Puertollano 34 38 50 29
18 CD Toledo CD Toledo 34 27 44 28
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 18 21 17 32
2 San Fernando CD Fernando 18 22 15 31
3 At. Sanluqueño Sanluqueño 18 18 17 31
4 RB Linense RB Linense 18 17 12 28
5 Tamaraceite Tamaraceite 18 19 15 27
6 Cádiz CF Mirandilla Cádiz 18 20 19 23
7 Las Palmas At. Palmas 18 13 16 21
8 Recreativo Recreativo 18 29 27 20
9 Marbella FC Marbella FC 18 20 19 18
10 Marino Marino 18 11 33 10
11 UCAM Murcia UCAM Murcia 18 22 15 33
12 Linares Deportivo Linares 18 22 16 33
13 Betis Deportivo Betis 18 23 15 30
14 Sevilla At. Sevilla At. 18 27 19 30
15 Córdoba CF Córdoba CF 18 21 16 27
16 Real Murcia Real Murcia 18 22 21 25
17 Recreativo Granada Recreativo 18 20 19 23
18 Pvo. El Ejido Pvo. Ejido 18 17 21 19
19 Yeclano Deportivo Yeclano 18 13 27 11
20 Lorca Deportiva Lorca 18 15 33 9
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 FC Cartagena Cartagena 28 33 19 54
2 Marbella FC Marbella FC 28 39 20 53
3 CD Badajoz CD Badajoz 28 37 22 49
4 Yeclano Deportivo Yeclano 28 42 33 47
5 Córdoba CF Córdoba CF 28 33 27 45
6 San Fernando CD Fernando 28 39 25 44
7 RB Linense RB Linense 28 27 26 41
8 Real Murcia Real Murcia 28 33 26 39
9 Sevilla At. Sevilla At. 28 31 33 36
10 UCAM Murcia UCAM Murcia 28 29 33 36
11 Cádiz CF Mirandilla Cádiz 28 23 27 36
12 Villarrubia CF Villarrubia 28 34 33 35
13 Recreativo Recreativo 28 30 31 33
14 CD Don Benito Benito 28 32 35 32
15 At. Sanluqueño Sanluqueño 28 20 28 30
16 Algeciras CF Algeciras 28 31 40 29
17 CF Talavera CF Talavera 28 23 33 29
18 Recreativo Granada Recreativo 28 21 35 29
19 AD Mérida AD Mérida 28 28 37 27
20 CP Villarrobledo Villarrobled 28 23 45 22
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 38 50 23 78
2 FC Cartagena Cartagena 38 62 27 75
3 UD Melilla UD Melilla 38 55 32 72
4 CD Badajoz CD Badajoz 38 44 31 66
5 UCAM Murcia UCAM Murcia 38 54 40 66
6 UD Ibiza UD Ibiza 38 41 31 63
7 Marbella FC Marbella FC 38 42 33 60
8 San Fernando CD Fernando 38 44 36 60
9 CF Talavera CF Talavera 38 34 34 50
10 Sevilla At. Sevilla At. 38 37 46 48
11 Real Murcia Real Murcia 38 32 32 48
12 RB Linense RB Linense 38 33 33 46
13 At. Sanluqueño Sanluqueño 38 32 48 46
14 Recreativo Granada Recreativo 38 37 42 45
15 CD Don Benito Benito 38 38 49 44
16 Jumilla Jumilla 38 31 42 43
17 Pvo. El Ejido Pvo. Ejido 38 29 47 39
18 Villanovense Villanovense 38 32 40 38
19 At. Malagueño Malagueño 38 27 54 29
20 Almería B Almería B 38 27 61 23
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 FC Cartagena Cartagena 38 51 33 71
2 Marbella FC Marbella FC 38 49 27 70
3 Real Murcia Real Murcia 38 49 33 65
4 Extremadura Extremadura 38 59 38 60
5 UD Melilla UD Melilla 38 43 24 60
6 Villanovense Villanovense 38 29 33 54
7 UCAM Murcia UCAM Murcia 38 38 42 52
8 Recreativo Granada Recreativo 38 34 35 51
9 San Fernando CD Fernando 38 47 46 49
10 Pvo. El Ejido Pvo. Ejido 38 54 55 49
11 RB Linense RB Linense 38 44 37 48
12 CD Badajoz CD Badajoz 38 46 44 48
13 Jumilla Jumilla 38 30 42 47
14 Las Palmas At. Palmas 38 45 44 47
15 Recreativo Recreativo 38 33 36 47
16 AD Mérida AD Mérida 38 34 42 46
17 Écija Balompié Écija 38 38 56 45
18 Córdoba CF B Córdoba 38 40 51 43
19 Betis Deportivo Betis 38 47 61 40
20 Lorca Deportiva Lorca 38 33 64 32
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Lorca FC Lorca FC 38 52 39 73
2 Real Murcia Real Murcia 38 48 29 67
3 Villanovense Villanovense 38 55 32 66
4 FC Cartagena Cartagena 38 49 35 65
5 AD Mérida AD Mérida 38 51 33 64
6 UD Melilla UD Melilla 38 39 25 60
7 Marbella FC Marbella FC 38 46 45 58
8 Recreativo Granada Recreativo 38 60 48 53
9 RB Linense RB Linense 38 41 48 52
10 Jumilla Jumilla 38 32 37 48
11 Córdoba CF B Córdoba 38 43 42 48
12 Recreativo Recreativo 38 35 41 47
13 Extremadura Extremadura 38 37 48 46
14 Pvo. El Ejido Pvo. Ejido 38 40 47 46
15 San Fernando CD Fernando 38 42 52 46
16 Linares Deportivo Linares 38 40 46 45
17 At. Sanluqueño Sanluqueño 38 36 51 39
18 Mancha Real Mancha Real 38 44 64 38
19 Real Jaén Real Jaén 38 37 43 37
20 La Roda CF La Roda CF 38 36 58 28
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 UCAM Murcia UCAM Murcia 38 46 17 77
2 Real Murcia Real Murcia 38 56 30 71
3 Sevilla At. Sevilla At. 38 53 31 68
4 Cádiz Cádiz 38 53 31 63
5 Recreativo Granada Recreativo 38 56 40 58
6 Lorca FC Lorca FC 38 43 41 56
7 FC Cartagena Cartagena 38 40 35 53
8 AD Mérida AD Mérida 38 39 41 52
9 UD Melilla UD Melilla 38 34 44 49
10 Real Jaén Real Jaén 38 46 37 48
11 RB Linense RB Linense 38 47 51 48
12 Villanovense Villanovense 38 49 56 47
13 Recreativo Recreativo 38 27 38 45
14 Marbella FC Marbella FC 38 46 47 45
15 Jumilla Jumilla 38 36 57 43
16 Linares Deportivo Linares 38 39 46 43
17 Betis Deportivo Betis 38 47 53 41
18 Algeciras CF Algeciras 38 28 48 41
19 San Roque de Lepe Roque Lepe 38 42 55 39
20 Almería B Almería B 38 26 55 28
TEMPORADA 2014/2015
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Cádiz Cádiz 38 66 24 76
2 UCAM Murcia UCAM Murcia 38 46 29 65
3 Almería B Almería B 38 47 30 62
4 Villanovense Villanovense 38 46 30 61
5 RB Linense RB Linense 38 56 52 58
6 Recreativo Granada Recreativo 38 50 39 58
7 UD Melilla UD Melilla 38 47 47 54
8 Betis Deportivo Betis 38 43 43 52
9 San Roque de Lepe Roque Lepe 38 52 56 51
10 Marbella FC Marbella FC 38 42 48 51
11 Real Jaén Real Jaén 38 45 36 49
12 CP Cacereño Cacereño 38 49 52 47
13 Lorca FC Lorca FC 38 42 44 45
14 Sevilla At. Sevilla At. 38 33 34 44
15 FC Cartagena Cartagena 38 36 46 43
16 La Roda CF La Roda CF 38 33 43 43
17 Arroyo Arroyo 38 30 50 43
18 Córdoba CF B Córdoba 38 33 60 43
19 El Palo FC El Palo FC 38 42 43 41
20 Lucena Lucena 38 32 64 39
TEMPORADA 2013/2014
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Albacete Albacete 38 62 30 82
2 Lorca FC Lorca FC 38 62 22 79
3 FC Cartagena Cartagena 38 59 35 73
4 Cádiz Cádiz 38 75 38 71
5 CD Guadalajara Guadalajara 38 57 33 69
6 Recreativo Granada Recreativo 38 65 47 58
7 RB Linense RB Linense 38 51 42 56
8 UD Melilla UD Melilla 38 47 45 55
9 Lucena Lucena 38 42 45 55
10 CP Cacereño Cacereño 38 43 49 53
11 Córdoba CF B Córdoba 38 42 50 45
12 El Palo FC El Palo FC 38 35 47 45
13 Almería B Almería B 38 42 49 43
14 Sevilla At. Sevilla At. 38 33 44 43
15 Arroyo Arroyo 38 38 47 43
16 Algeciras CF Algeciras 38 39 45 43
17 La Roda CF La Roda CF 38 39 46 40
18 San Fernando CD Fernando 38 36 60 39
19 At. Sanluqueño Sanluqueño 38 34 68 34
20 Écija Balompié Écija 38 28 87 23
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
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 Recreativo Granada Recreativo 33 67 23 73
2 Guadix CF Guadix CF 33 62 43 63
3 Español de Alquián Español 34 58 32 62
4 CD Huercal CD Huercal 34 80 49 59
5 CD Vera CD Vera 35 53 42 55
6 Atarfe Industrial Atarfe 34 74 59 52
7 Los Molinos Los Molinos 33 45 41 50
8 Parador Roquetas Parador 34 45 45 50
9 Águilas De Zujaira Águilas 34 51 52 47
10 Atl. La Zubia Atl. Zubia 33 42 53 47
11 Cullar Vega Cullar Vega 33 49 51 44
12 UD Pavía UD Pavía 34 54 62 44
13 Berja Berja 33 49 50 43
14 Baza Baza 34 41 59 39
15 Cd Adra Milenaria Adra 33 42 59 37
16 Atlético Monachil Atlético 34 51 58 34
17 Celtic Pulianas Celtic 33 37 62 32
18 Vandalia Vandalia 34 36 61 28
19 Atlético Bellavista Atlético 33 42 77 26
TEMPORADA 2010/2011
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 Arenas de Armilla Arenas 33 57 26 68
2 Los Molinos Los Molinos 32 71 32 62
3 Atlético Monachil Atlético 32 69 45 56
4 Español de Alquián Español 32 74 51 56
5 Guadix CF Guadix CF 32 55 29 55
6 Parador Roquetas Parador 32 50 43 54
7 Recreativo Granada Recreativo 32 67 33 53
8 Cullar Vega Cullar Vega 32 52 41 53
9 Atarfe Industrial Atarfe 32 48 30 51
10 Berja Berja 32 51 48 46
11 UD Pavía UD Pavía 32 44 43 44
12 Atl. La Zubia Atl. Zubia 32 50 65 40
13 Vandalia Vandalia 32 30 39 37
14 CD Vera CD Vera 32 32 65 31
15 Huétor Vega Huétor Vega 32 29 65 21
16 CD UD Íllora Íllora 32 33 94 17
17 UD Los Marinos Marinos 32 25 86 12
18 San Isidro CD Isidro 1 0 2 0
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
2ª ANDALUZA GRANADA
Equipo PJ GF GC Puntos
1 CF Sierra Nevada Cenes Sierra 30 76 33 71
2 Cullar Vega Cullar Vega 30 80 43 64
3 Recreativo Granada Recreativo 30 60 32 57
4 Salobreña Salobreña 30 64 41 57
5 CD Huétor Tájar Huétor 30 59 32 51
6 CD El Padul CD El Padul 30 62 50 50
7 Águilas De Zujaira Águilas 30 61 43 46
8 Casalarreina Casalarreina 30 43 55 39
9 Vandalia de Peligros B Vandalia 30 39 46 38
10 Chauchina Molino Vueltas Se Chauchina 30 38 50 38
11 Alhameña Alhameña 30 36 33 37
12 Celtic Pulianas Celtic 30 51 60 37
13 CD Comarcal CD Comarcal 30 32 47 34
14 UD Los Marinos Marinos 30 38 56 33
15 Maracena Maracena 30 36 77 23
16 Atlético Monachil Atlético 30 24 101 5
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
TEMPORADA 2003/2004
2ª ANDALUZA GRANADA
Equipo PJ GF GC Puntos
1 Maracena Maracena 34 65 14 78
2 Imperio De Albolote Imperio 34 53 19 73
3 Churriana de la Vega Churriana 34 66 27 71
4 CD UD Íllora Íllora 34 46 37 55
5 Atarfe Industrial Atarfe 34 51 29 54
6 Recreativo Granada Recreativo 34 47 34 51
7 CD Iznalloz CD Iznalloz 34 45 39 49
8 Atlético Monachil Atlético 34 46 45 47
9 Gabia Gabia 34 52 51 45
10 CF Sierra Nevada Cenes Sierra 34 59 68 44
11 CD Huétor Tájar Huétor 34 44 47 42
12 Salobreña Salobreña 34 36 62 40
13 Cf Villanueva Mesia Villanueva 34 30 44 34
14 Ogijares 89 Cf Ogijares 34 28 50 34
15 U.D.E. Chana U.D.E. Chana 34 41 55 31
16 Atl. La Zubia Atl. Zubia 34 29 44 31
17 Haza Grande Haza Grande 34 49 78 31
18 Celtic Pulianas Celtic 34 35 79 23

  USO DE MEMORIA  
8,103,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6496
Total Execution Time  0.6508
  CADENA URL  
/historico/Granada-B
  GET DATOS  
$_GET['/historico/Granada-B']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0137  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 = 'Granada-B' 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.0125  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=1252 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=1252 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=1252 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1252 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1252 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (1872,1903,2601,2835,6752) ORDER BY n.cover_points DESC, update_date DESC
0.0154  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 = '1252' 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 = '1252' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0157  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=1252 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0134  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 (72359,71617,71432,67968) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 72359 AND teamId = 1252
0.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 67968 AND teamId = 1252
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71617 AND teamId = 1252
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1252
0.0142  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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 1252 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.0138  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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 1252 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 1252 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 1252 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0260  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 = 67968 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.0144  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 = 62384 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.0145  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 = 58611 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 50268 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.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 `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 = 44098 AND t.round = 38 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 `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 = 38809 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 33381 AND t.round = 38 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 = 15378 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 3866 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 2467 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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.0129  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 = 1467 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 1234 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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.0129  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.0131  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.0132  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.0140  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
0.0142  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 `tables2004` 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 = 2963 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC