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 2003/2004
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
TEMPORADA 1964/1965
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Real Jaén Real Jaén 30 52 23 44
2 C.D. Almería C.D. 30 43 25 40
3 Atlético Marbella Atlético 30 49 38 36
4 Iliturgi CF Iliturgi CF 30 45 42 35
5 At. Malagueño Malagueño 30 51 28 34
6 CD Fuengirola Fuengirola 30 47 37 31
7 Recreativo Granada Recreativo 30 40 41 30
8 Antequera CF Antequera 30 42 48 30
9 Atl. Cordobes Atl. 30 41 43 29
10 Adra Adra 30 41 46 28
11 J. Torremolinos Torremolinos 30 49 50 26
12 CD Ronda CD Ronda 30 40 59 26
13 Algeciras CF B Algeciras 30 38 45 25
14 Imperio Ceuta Imperio 30 41 52 25
15 Prieguense A.F. Prieguense 30 31 46 23
16 Puerto Malagueño Puerto 30 27 54 18
TEMPORADA 1963/1964
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 At. Malagueño Malagueño 30 41 18 39
2 Atl. Cordobes Atl. 30 56 26 37
3 CD Antequerano Antequerano 30 43 32 35
4 Real Jaén Real Jaén 30 42 34 35
5 Atlético Marbella Atlético 30 54 36 34
6 Algeciras CF B Algeciras 30 39 33 34
7 CD Ronda CD Ronda 30 50 46 31
8 CD Fuengirola Fuengirola 30 45 47 31
9 Prieguense A.F. Prieguense 30 37 36 30
10 Recreativo Granada Recreativo 30 45 43 29
11 C.D. Almería C.D. 30 38 41 28
12 Adra Adra 30 43 48 25
13 CD Linares CD Linares 30 34 49 25
14 Iliturgi CF Iliturgi CF 30 26 40 23
15 Imperio Ceuta Imperio 30 21 58 22
16 Vélez CF Vélez CF 30 22 49 22
TEMPORADA 1962/1963
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 C.D. Almería C.D. 28 59 30 39
2 At. Malagueño Malagueño 28 40 16 36
3 Antequera CF Antequera 28 53 27 36
4 Adra Adra 28 38 27 35
5 Écija Balompié Écija 28 51 32 32
6 Recreativo Granada Recreativo 28 52 41 30
7 CD Linares CD Linares 28 51 44 29
8 CD Fuengirola Fuengirola 28 35 42 29
9 Prieguense A.F. Prieguense 28 37 35 28
10 Atl. Cordobes Atl. 28 50 37 27
11 Iliturgi CF Iliturgi CF 28 43 65 27
12 CD Ronda CD Ronda 28 39 43 26
13 Vélez CF Vélez CF 28 26 41 26
14 Imperio Ceuta Imperio 28 29 51 17
15 CD Alhaurino Alhaurino 28 20 92 3
16 Peñarroya Pueblonuevo Peñarroya 0 0 0 0

  USO DE MEMORIA  
7,913,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1762
Total Execution Time  0.1781
  CADENA URL  
/historico/Granada-B/2004
  GET DATOS  
$_GET['/historico/Granada-B/2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0069  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 = 2004 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.0043  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 = 2963
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1252 AND type_rel = 2
0.0024  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.0029  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.0043  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 = 2004 ORDER BY l.year DESC,cat.coefficient DESC
0.0033  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 = 2963 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0041  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 (2003,2004,2005) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (2963) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 2963 AND teamId = 1252
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025  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.0020  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.0019  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 events2004 e ON e.player_id = p.id AND e.league_id = 2963 WHERE rp.league_id = 2963 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.0020  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 events2004 e ON e.player_id = p.id AND e.league_id = 2963 WHERE rp.league_id = 2963 AND rp.teamId = 1252 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2004 e ON e.player_id = p.id AND e.league_id = 2963 WHERE rp.league_id = 2963 AND rp.teamId = 1252 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 <= 2004 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0032  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.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.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 `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.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.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 `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.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 `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.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0036  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.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 `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.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0037  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.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 `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.0039  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.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 `tables1965` 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 = 21582 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1964` 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 = 21569 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 `tables1963` 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 = 21557 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC