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 2021/2022
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
TEMPORADA 2001/2002
2ª ANDALUZA GRANADA
Equipo PJ GF GC Puntos
1 Imperio De Albolote Imperio 34 74 21 80
2 CD Santa Fe CD Santa Fe 34 82 23 76
3 Atarfe Industrial Atarfe 34 58 22 73
4 CD UD Íllora Íllora 34 43 20 62
5 Churriana de la Vega Churriana 34 78 40 61
6 Atlético Monachil Atlético 34 46 25 61
7 Atl. La Zubia Atl. Zubia 34 49 41 51
8 Gabia Gabia 34 57 37 50
9 Almuñecar 77 Almuñecar 34 65 74 48
10 Universal Calahonda Universal 34 54 46 47
11 Alfacar UD Alfacar UD 34 51 53 42
12 Peña de Peligros Peña 34 45 51 42
13 CD Huétor Tájar Huétor 34 36 47 41
14 Cullar Vega Cf Cullar Vega 34 42 57 35
15 Recreativo Granada Recreativo 34 47 64 34
16 Cájar Cájar 34 33 76 21
17 CF La Malaha Malaha 34 25 108 18
18 Pd La Herradura Herradura 34 31 111 12
TEMPORADA 2000/2001
2ª ANDALUZA GRANADA
Equipo PJ GF GC Puntos
1 Atarfe Industrial Atarfe 30 61 21 65
2 Churriana de la Vega Churriana 30 64 24 62
3 CD Baza CD Baza 30 58 24 61
4 CD Santa Fe CD Santa Fe 30 45 36 51
5 Alfacar UD Alfacar UD 30 47 39 49
6 Recreativo Granada Recreativo 30 41 33 49
7 CD Huétor Tájar Huétor 30 43 34 45
8 CD UD Íllora Íllora 30 27 30 42
9 Peña de Peligros Peña 30 39 42 38
10 Atlético Monachil Atlético 30 38 40 37
11 Atl. La Zubia Atl. Zubia 30 35 40 36
12 Gabia Gabia 30 47 55 36
13 Granada 74 B Granada 30 38 47 34
14 Ogijares 89 Cf Ogijares 30 33 58 31
15 Universal Calahonda Universal 30 31 46 30
16 Purullena CF Purullena 30 40 64 30
17 Cf Villanueva Mesia Villanueva 30 24 48 28
18 Celtic Pulianas Celtic 30 29 59 25

  USO DE MEMORIA  
8,089,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1972
Total Execution Time  0.1993
  CADENA URL  
/historico/Granada-B/2022
  GET DATOS  
$_GET['/historico/Granada-B/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0041  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 = 2022 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.0018  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.0018  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.0018  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.0041  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 = 62384
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1252 AND type_rel = 2
0.0027  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.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 (1872,1903,2601,2835,6752) ORDER BY n.cover_points DESC, update_date DESC
0.0027  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 = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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.0020  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 = 62384 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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 (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (71617,67968,67320,61745,58611) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 58611 AND teamId = 1252
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 67968 AND teamId = 1252
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 61745 AND teamId = 1252
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71617 AND teamId = 1252
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 1252
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0037  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 = '1252' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1252' and rp.type = 4
0.0021  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 = '1252' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0089  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 events2022 e ON e.player_id = p.id AND e.league_id = 62384 WHERE rp.league_id = 62384 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.0050  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 events2022 e ON e.player_id = p.id AND e.league_id = 62384 WHERE rp.league_id = 62384 AND rp.teamId = 1252 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 events2022 e ON e.player_id = p.id AND e.league_id = 62384 WHERE rp.league_id = 62384 AND rp.teamId = 1252 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039  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 <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.0069  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.0028  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.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 `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.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 = 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.0038  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.0053  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.0031  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.0027  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.0044  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.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 = 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.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 `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.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 `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.0022  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.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 `tables2002` 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 = 2961 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 `tables2001` 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 = 2960 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC