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 2007/2008
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
TEMPORADA 1999/2000
2ª ANDALUZA GRANADA
Equipo PJ GF GC Puntos
1 Imperio De Albolote Imperio 36 68 18 87
2 Arenas de Armilla Arenas 36 75 27 82
3 Atarfe Industrial Atarfe 36 71 32 70
4 Gabia Gabia 36 83 44 62
5 Atlético Monachil Atlético 36 51 42 59
6 CD Baza CD Baza 36 56 47 58
7 Recreativo Granada Recreativo 36 54 46 55
8 Granada 74 B Granada 36 56 43 49
9 Churriana de la Vega Churriana 36 51 41 47
10 CD Santa Fe CD Santa Fe 36 49 55 46
11 Celtic Pulianas Celtic 36 61 57 44
12 Atl. La Zubia Atl. Zubia 36 48 56 44
13 CD Huétor Tájar Huétor 36 43 60 43
14 CD UD Íllora Íllora 36 49 68 39
15 Alfacar UD Alfacar UD 36 45 65 39
16 Huétor Vega Huétor Vega 36 49 74 38
17 C.D. Alhendinense C.D. 36 34 78 36
18 Cájar Cájar 36 34 54 35
19 Almuñecar 77 Almuñecar 36 39 109 23
TEMPORADA 1997/1998
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 CD Linares CD Linares 40 78 34 88
2 Poli Ejido Poli Ejido 40 110 30 86
3 Granada 74 Granada 74 40 65 29 73
4 Vélez CF Vélez CF 40 80 57 68
5 Baeza CF Baeza CF 40 54 44 66
6 At. Malagueño Malagueño 40 54 40 64
7 Martos CD Martos CD 40 46 45 64
8 J. Torremolinos Torremolinos 40 48 41 61
9 CD Ronda CD Ronda 40 65 60 60
10 Vandalia Vandalia 40 52 49 60
11 Mármol Macael Mármol 40 52 45 59
12 Maracena Maracena 40 57 41 56
13 Úbeda CF Úbeda CF 40 44 50 51
14 Arenas de Armilla Arenas 40 52 57 49
15 CD Roquetas CD Roquetas 40 49 61 46
16 Antequera CF Antequera 40 35 50 46
17 UD San Isidro Isidro 40 47 65 46
18 Recreativo Granada Recreativo 40 44 60 42
19 Manilva-Sabinillas Manilva-Sabi 40 40 69 35
20 UD Fuengirola Fuengirola 40 39 85 26
21 CD Gimnastico Melilla Gimnastico 40 22 121 15
TEMPORADA 1996/1997
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Motril CF Motril CF 40 77 26 82
2 Maracena Maracena 40 69 27 79
3 CD Linares CD Linares 40 62 28 75
4 Úbeda CF Úbeda CF 40 68 44 65
5 Martos CD Martos CD 40 52 32 61
6 J. Torremolinos Torremolinos 40 52 47 60
7 UD San Isidro Isidro 40 53 48 59
8 Manilva-Sabinillas Manilva-Sabi 40 61 43 58
9 UD Fuengirola Fuengirola 40 57 56 58
10 Granada 74 Granada 74 40 52 54 56
11 At. Malagueño Malagueño 40 62 45 55
12 Recreativo Granada Recreativo 40 64 67 53
13 Baeza CF Baeza CF 40 49 40 53
14 CD Roquetas CD Roquetas 40 61 56 52
15 Mármol Macael Mármol 40 44 47 51
16 Antequera CF Antequera 40 47 50 50
17 Alhaurín de la Torre Alhaurín 40 50 56 49
18 UD Melilla B Melilla 40 46 64 47
19 Baza Baza 40 42 61 47
20 Atarfe Industrial Atarfe 40 47 81 39
21 UD Carboneras Carboneras 40 10 153 3
TEMPORADA 1994/1995
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Málaga Málaga 40 99 13 71
2 UD San Pedro Pedro 40 99 24 66
3 Poli Ejido Poli Ejido 40 78 27 60
4 Vélez CF Vélez CF 40 95 34 57
5 CD Linares CD Linares 40 68 30 53
6 Antequera CF Antequera 40 60 35 48
7 J. Torremolinos Torremolinos 40 73 41 45
8 Guadix CF Guadix CF 40 63 43 44
9 Baeza CF Baeza CF 40 57 43 44
10 CD Roquetas CD Roquetas 40 69 63 44
11 Atarfe Industrial Atarfe 40 59 62 41
12 Martos CD Martos CD 40 41 43 39
13 Maracena Maracena 40 62 57 38
14 Adra Adra 40 44 46 38
15 Arenas de Armilla Arenas 40 38 61 31
16 Baza Baza 40 35 60 30
17 Plus Ultra Plus Ultra 40 43 87 25
18 Real de Melilla Real Melilla 40 39 92 23
19 Atlético Estación Atlético 40 24 87 19
20 Recreativo Granada Recreativo 40 44 120 14
21 PD Garrucha PD Garrucha 40 16 138 10
TEMPORADA 1993/1994
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Poli Almería Poli 38 95 19 67
2 Vélez CF Vélez CF 38 62 32 56
3 Martos CD Martos CD 38 56 33 49
4 Guadix CF Guadix CF 38 57 29 48
5 Baza Baza 38 62 46 47
6 Atarfe Industrial Atarfe 38 52 32 45
7 Maracena Maracena 38 66 46 44
8 Baeza CF Baeza CF 38 49 53 40
9 Recreativo Granada Recreativo 38 52 49 38
10 PD Garrucha PD Garrucha 38 53 53 37
11 UD San Pedro Pedro 38 37 41 37
12 Adra Adra 38 45 50 35
13 Arenas de Armilla Arenas 38 43 62 35
14 CD Roquetas CD Roquetas 38 55 50 34
15 J. Torremolinos Torremolinos 38 36 45 34
16 Atlético Estación Atlético 38 39 65 26
17 Antequera CF Antequera 38 33 56 25
18 CD Úbeda Viva Úbeda Viva 38 34 70 25
19 CD Los Boliches Boliches 38 29 64 23
20 Iliturgi CF Iliturgi CF 38 22 82 15
TEMPORADA 1992/1993
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 At. Malagueño Malagueño 38 93 22 64
2 Almería Almería 38 88 26 63
3 Poli Almería Poli 38 84 30 55
4 Mármol Macael Mármol 38 74 24 54
5 Guadix CF Guadix CF 38 42 33 46
6 CD Roquetas CD Roquetas 38 50 39 45
7 Atarfe Industrial Atarfe 38 70 53 42
8 Iliturgi CF Iliturgi CF 38 45 38 39
9 Martos CD Martos CD 38 38 36 38
10 Maracena Maracena 38 46 53 38
11 Adra Adra 38 44 39 37
12 Baeza CF Baeza CF 38 36 50 36
13 Vélez CF Vélez CF 38 38 43 35
14 CD Úbeda Viva Úbeda Viva 38 39 62 32
15 CD Los Boliches Boliches 38 36 50 30
16 J. Torremolinos Torremolinos 38 35 78 29
17 UD San Pedro Pedro 38 28 50 28
18 Recreativo Granada Recreativo 38 24 52 24
19 Motril CF Motril CF 38 18 67 13
20 Real de Melilla Real Melilla 38 23 106 12
TEMPORADA 1991/1992
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Vélez CF Vélez CF 36 70 41 54
2 Mármol Macael Mármol 36 69 24 51
3 Iliturgi CF Iliturgi CF 36 49 20 51
4 At. Malagueño Malagueño 36 72 31 51
5 Poli Almería Poli 36 59 28 49
6 Baeza CF Baeza CF 36 48 42 41
7 Martos CD Martos CD 36 42 39 39
8 Motril CF Motril CF 36 46 47 38
9 Atarfe Industrial Atarfe 36 66 46 38
10 Recreativo Granada Recreativo 36 49 48 37
11 Adra Adra 36 45 33 37
12 UD San Pedro Pedro 36 48 46 36
13 Maracena Maracena 36 46 46 32
14 CD Úbeda Viva Úbeda Viva 36 50 52 31
15 Guadix CF Guadix CF 36 42 46 30
16 J. Torremolinos Torremolinos 36 34 66 22
17 CD Ronda CD Ronda 36 31 76 19
18 CD Nerja Fundación Nerja 36 23 91 16
19 CD Mijas CD Mijas 36 18 85 12
20 Casino del Real Melilla Casino Real 0 0 0 0
TEMPORADA 1981/1982
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 CD Fuengirola Fuengirola 38 71 37 50
2 Martos CD Martos CD 38 83 50 49
3 J. Torremolinos Torremolinos 38 54 44 47
4 At. Malagueño Malagueño 38 62 49 46
5 CD Alhaurino Alhaurino 38 73 54 45
6 At. Benamiel Benamiel 38 48 43 43
7 Baza Baza 38 47 47 41
8 UD Melilla UD Melilla 38 57 49 38
9 Atlético Marbella Atlético 38 46 46 38
10 Bailén Bailén 38 45 49 38
11 UD San Pedro Pedro 38 56 47 37
12 Estepona Estepona 38 51 46 37
13 Vélez CF Vélez CF 38 45 46 37
14 Úbeda CF Úbeda CF 38 53 62 34
15 CD Motril CD Motril 38 34 47 34
16 Carolinense Carolinense 38 48 64 33
17 Iliturgi CF Iliturgi CF 38 29 37 32
18 CD Ronda CD Ronda 38 46 65 31
19 Atarfe Industrial Atarfe 38 43 65 30
20 Recreativo Granada Recreativo 38 26 70 20
TEMPORADA 1980/1981
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 CD Antequerano Antequerano 38 70 32 55
2 Martos CD Martos CD 38 67 31 50
3 UD Melilla UD Melilla 38 65 45 48
4 Estepona Estepona 38 58 46 45
5 J. Torremolinos Torremolinos 38 57 48 44
6 Úbeda CF Úbeda CF 38 61 39 42
7 UD San Pedro Pedro 38 45 35 42
8 Baza Baza 38 39 43 40
9 CD Ronda CD Ronda 38 62 57 39
10 Iliturgi CF Iliturgi CF 38 48 45 38
11 CD Motril CD Motril 38 46 49 38
12 Bailén Bailén 38 56 50 38
13 Vélez CF Vélez CF 38 50 50 36
14 Carolinense Carolinense 38 52 57 36
15 At. Malagueño Malagueño 38 43 43 35
16 Atlético Marbella Atlético 38 53 51 35
17 Atarfe Industrial Atarfe 38 47 61 33
18 Recreativo Granada Recreativo 38 49 67 26
19 Melilla Industrial Melilla 38 28 81 22
20 Loja Loja 38 33 99 18
TEMPORADA 1970/1971
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 38 50 24 55
2 Recreativo Recreativo 38 58 32 52
3 Cartagena F.C. UCAM Cartagena 38 63 25 49
4 RC Portuense Portuense 38 41 37 44
5 Sevilla At. Sevilla At. 38 54 47 44
6 AgD Ceuta AgD Ceuta 38 55 41 43
7 Real Jaén Real Jaén 38 45 31 42
8 Betis Deportivo Betis 38 42 41 40
9 Real Murcia Real Murcia 38 47 39 39
10 FC Jove Español Jove 38 52 42 38
11 Valdepeñas Valdepeñas 38 47 35 38
12 CD Badajoz CD Badajoz 38 46 50 37
13 Ilicitano Ilicitano 38 41 56 37
14 At. Malagueño Malagueño 38 40 44 36
15 Melilla CF Melilla CF 38 37 39 34
16 RB Linense RB Linense 38 31 46 33
17 Mérida CP Mérida CP 38 42 54 31
18 Real Murcia Imperial Real Murcia 38 29 50 25
19 Recreativo Granada Recreativo 38 34 65 25
20 AD Llerenense Llerenense 38 28 84 18
TEMPORADA 1969/1970
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 CF Gandia CF Gandia 38 71 37 51
2 Hércules Hércules 38 58 25 51
3 Cartagena F.C. UCAM Cartagena 38 63 38 49
4 Alcoyano Alcoyano 38 68 45 48
5 Real Jaén Real Jaén 38 54 37 47
6 Eldense Eldense 38 55 35 47
7 Real Murcia Imperial Real Murcia 38 67 28 46
8 Valdepeñas Valdepeñas 38 64 40 46
9 Recreativo Granada Recreativo 38 46 37 45
10 Albacete Albacete 38 43 45 39
11 CD Manchego CD Manchego 38 52 43 38
12 Linares CF Linares CF 38 32 34 38
13 Novelda CF Novelda CF 38 44 42 37
14 Orihuela Deportiva CF Orihuela 38 55 51 36
15 Calvo Sotelo PGR Calvo Sotelo 38 57 65 33
16 CD La Unión Unión 38 44 48 33
17 Benidorm Benidorm 38 47 63 29
18 Cartagena Atletico Cartagena 38 32 71 23
19 Iliturgi CF Iliturgi CF 38 19 95 15
20 Adra Adra 38 20 112 9
TEMPORADA 1967/1968
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 RB Linense RB Linense 30 56 20 46
2 C.D. Almería C.D. 30 57 24 44
3 Algeciras CF Algeciras 30 62 26 43
4 UD Melilla UD Melilla 30 51 30 37
5 Linares CF Linares CF 30 57 26 36
6 Atlético Marbella Atlético 30 50 35 35
7 Estepona Estepona 30 42 49 34
8 At. Malagueño Malagueño 30 36 28 33
9 Iliturgi CF Iliturgi CF 30 50 37 32
10 Adra Adra 30 32 38 31
11 CD Fuengirola Fuengirola 30 45 43 29
12 Recreativo Granada Recreativo 30 40 44 27
13 J. Torremolinos Torremolinos 30 29 54 20
14 C.D.Hispania C.D.Hispania 30 27 64 12
15 Olimpica Victoriana CF Olimpica 30 19 88 11
16 Vandalia Vandalia 30 22 69 10
TEMPORADA 1966/1967
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Real Jaén Real Jaén 30 67 27 45
2 C.D. Almería C.D. 30 55 28 42
3 RB Linense RB Linense 30 57 25 42
4 UD Melilla UD Melilla 30 53 33 33
5 Atlético Marbella Atlético 30 40 35 33
6 At. Malagueño Malagueño 30 48 38 33
7 Estepona Estepona 30 47 51 32
8 Linares CF Linares CF 30 43 44 28
9 Iliturgi CF Iliturgi CF 30 35 43 28
10 Algeciras CF B Algeciras 30 28 37 28
11 Olimpica Victoriana CF Olimpica 30 37 51 25
12 CD Fuengirola Fuengirola 30 39 55 24
13 Recreativo Granada Recreativo 30 31 49 24
14 Adra Adra 30 29 48 24
15 Imperio Ceuta Imperio 30 31 57 21
16 J. Torremolinos Torremolinos 30 40 59 18
TEMPORADA 1965/1966
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 RB Linense RB Linense 28 45 21 41
2 Atlético Marbella Atlético 28 56 32 38
3 C.D. Almería C.D. 28 46 26 37
4 At. Malagueño Malagueño 28 52 26 36
5 Real Jaén Real Jaén 28 37 26 33
6 Iliturgi CF Iliturgi CF 28 45 37 30
7 Algeciras CF B Algeciras 28 39 38 28
8 Recreativo Granada Recreativo 28 44 49 28
9 Adra Adra 27 34 39 27
10 CD Fuengirola Fuengirola 28 35 43 23
11 Imperio Ceuta Imperio 28 33 54 22
12 J. Torremolinos Torremolinos 28 34 46 21
13 Linares CF Linares CF 28 35 48 21
14 CD Antequerano Antequerano 27 20 41 19
15 Atl. Cordobes Atl. 28 29 58 14
16 CD Ronda CD Ronda 0 0 0 0

  USO DE MEMORIA  
7,903,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7996
Total Execution Time  0.8008
  CADENA URL  
/historico/Granada-B/2008
  GET DATOS  
$_GET['/historico/Granada-B/2008']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0207  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 = 2008 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.0152  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.0151  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.0316  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 = 111
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1252 AND type_rel = 2
0.0165  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.0150  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.0156  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 = 2008 ORDER BY l.year DESC,cat.coefficient DESC
0.0156  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.0147  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 111 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=1252 AND l.year in (2007,2008,2009) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (2966,325) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 325 AND teamId = 1252
0.0144  SELECT count(id) as num_players from rel_players WHERE league_id = 2966 AND teamId = 1252
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1252' and rp.type = 4
0.0146  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.0146  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 events2008 e ON e.player_id = p.id AND e.league_id = 111 WHERE rp.league_id = 111 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.0147  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 events2008 e ON e.player_id = p.id AND e.league_id = 111 WHERE rp.league_id = 111 AND rp.teamId = 1252 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 events2008 e ON e.player_id = p.id AND e.league_id = 111 WHERE rp.league_id = 111 AND rp.teamId = 1252 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 <= 2008 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0153  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` 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 = 2959 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 `tables1998` 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 = 21990 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1997` 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 = 21972 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1995` 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 = 21931 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1994` 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 = 21909 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 `tables1993` 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 = 21888 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1992` 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 = 21867 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1982` 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 = 21692 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 `tables1981` 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 = 21677 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1971` 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 = 21629 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1970` 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 = 21624 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1968` 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 = 21608 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1967` 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 = 22205 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1966` 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 = 21595 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 111 ORDER BY nameShow LIMIT 100