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

Algeciras CF

Entrenador: Lolo Escobar

Temporada 2005/2006
TEMPORADA 2005/2006
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 FC Cartagena Cartagena 38 54 33 73
2 Águilas CF Águilas CF 38 43 32 65
3 Sevilla At. Sevilla At. 38 48 30 60
4 CD Linares CD Linares 38 39 31 60
5 Écija Balompié Écija 38 46 34 56
6 Córdoba CF Córdoba CF 38 57 46 55
7 CD Badajoz CD Badajoz 38 36 34 54
8 CD Alcalá CD Alcalá 38 37 39 53
9 Mérida UD Mérida UD 38 40 43 52
10 AgD Ceuta AgD Ceuta 38 43 31 52
11 CF Extremadura Extremadura 38 52 48 52
12 Marbella FC Marbella FC 38 41 41 52
13 Real Jaén Real Jaén 38 41 41 51
14 Talavera CF Talavera CF 38 56 53 50
15 CD Villanueva Villanueva 38 47 58 46
16 Baza Baza 38 38 39 45
17 UD Almansa UD Almansa 38 35 43 43
18 UB Conquense Conquense 38 36 57 39
19 Algeciras CF Algeciras 38 38 55 36
20 Diter Zafra Diter Zafra 38 37 76 28
TEMPORADA 2004/2005
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Sevilla At. Sevilla At. 38 52 29 66
2 UB Conquense Conquense 38 43 31 66
3 AgD Ceuta AgD Ceuta 38 38 22 65
4 Lorca Deportiva Lorca 38 61 39 61
5 Marbella FC Marbella FC 38 46 42 59
6 Algeciras CF Algeciras 38 26 25 54
7 CD Badajoz CD Badajoz 38 50 43 53
8 UD Melilla UD Melilla 38 43 37 52
9 Real Jaén Real Jaén 38 35 34 51
10 CF Extremadura Extremadura 38 45 39 50
11 CD Linares CD Linares 38 30 29 50
12 Écija Balompié Écija 38 30 46 50
13 FC Cartagena Cartagena 38 31 30 49
14 Diter Zafra Diter Zafra 38 30 42 49
15 CD Alcalá CD Alcalá 38 37 43 48
16 Talavera CF Talavera CF 38 35 34 46
17 Tomelloso Tomelloso 38 26 41 42
18 CD Don Benito Benito 38 22 36 36
19 Jerez Jerez 38 26 47 36
20 Arenas de Armilla Arenas 38 32 49 28
TEMPORADA 2003/2004
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Levante Levante 42 59 33 79
2 Getafe Getafe 42 55 38 76
3 Numancia Numancia 42 60 30 76
4 Deportivo Alavés Deportivo 42 48 32 74
5 Real Sporting Real 42 58 40 70
6 Recreativo Recreativo 42 45 34 62
7 Cádiz Cádiz 42 52 47 61
8 Tenerife Tenerife 42 40 40 54
9 Xerez CD Xerez CD 42 47 49 54
10 Eibar Eibar 42 44 39 52
11 UD Salamanca Salamanca 42 47 44 51
12 Terrassa FC Terrassa FC 42 45 50 50
13 Almería Almería 42 45 49 50
14 Elche Elche 42 50 63 50
15 At. Malagueño Malagueño 42 46 56 49
16 Córdoba CF Córdoba CF 42 37 42 49
17 Ciudad de Murcia Ciudad 42 51 63 49
18 Poli Ejido Poli Ejido 42 29 40 49
19 Leganés Leganés 42 36 47 46
20 Las Palmas Las Palmas 42 46 68 44
21 Rayo Vallecano Rayo 42 45 63 43
22 Algeciras CF Algeciras 42 39 57 33
TEMPORADA 2002/2003
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 38 46 22 72
2 At. Malagueño Malagueño 38 50 28 70
3 Ciudad de Murcia Ciudad 38 52 25 68
4 Cádiz Cádiz 38 57 32 68
5 CF Extremadura Extremadura 38 52 36 65
6 CP Cacereño Cacereño 38 58 42 62
7 AgD Ceuta AgD Ceuta 38 43 38 60
8 Écija Balompié Écija 38 44 45 53
9 Jerez Jerez 38 30 26 48
10 Sevilla At. Sevilla At. 38 34 39 48
11 FC Cartagena Cartagena 38 30 31 47
12 Real Jaén Real Jaén 38 43 45 46
13 Mérida UD Mérida UD 38 32 39 46
14 UD Melilla UD Melilla 38 31 42 46
15 Betis Deportivo Betis 38 44 45 45
16 CD Linares CD Linares 38 31 39 44
17 Diter Zafra Diter Zafra 38 32 39 43
18 Moralo Moralo 38 30 56 37
19 Torredonjimeno Torredonjime 38 33 62 28
20 Motril CF Motril CF 38 32 73 22
TEMPORADA 2001/2002
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Motril CF Motril CF 38 55 29 77
2 AgD Ceuta AgD Ceuta 38 47 22 77
3 Almería Almería 38 56 35 73
4 Mérida UD Mérida UD 38 42 30 64
5 Ciudad de Murcia Ciudad 38 39 38 60
6 Jerez Jerez 38 46 36 55
7 Cádiz Cádiz 38 38 33 54
8 Betis Deportivo Betis 38 38 40 53
9 Écija Balompié Écija 38 33 32 51
10 Granada Granada 38 40 45 50
11 Sevilla At. Sevilla At. 38 29 30 45
12 FC Cartagena Cartagena 38 30 47 44
13 Diter Zafra Diter Zafra 38 35 42 44
14 Algeciras CF Algeciras 38 26 33 44
15 Mallorca B Mallorca B 38 44 45 43
16 UD Melilla UD Melilla 38 35 39 43
17 RB Linense RB Linense 38 29 36 42
18 Dos Hermanas CF Hermanas 38 34 38 40
19 CD San Fernando Fernando 38 34 51 35
20 Coria CF Coria CF 38 27 56 30
TEMPORADA 2000/2001
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Cádiz Cádiz 37 37 15 70
2 Xerez CD Xerez CD 37 52 30 66
3 Poli Ejido Poli Ejido 36 40 25 66
4 AgD Ceuta AgD Ceuta 37 52 32 62
5 Dos Hermanas CF Hermanas 37 40 35 52
6 Granada Granada 37 45 41 52
7 Coria CF Coria CF 36 38 37 51
8 UD Melilla UD Melilla 37 36 43 51
9 Almería Almería 37 43 38 49
10 Écija Balompié Écija 37 28 31 47
11 Jerez Jerez 37 37 36 47
12 CD San Fernando Fernando 37 26 26 46
13 Talavera CF Talavera CF 37 31 40 46
14 RB Linense RB Linense 37 45 50 45
15 Motril CF Motril CF 37 32 40 45
16 Algeciras CF Algeciras 37 38 41 44
17 Guadix CF Guadix CF 37 29 46 42
18 CD Linares CD Linares 37 28 38 37
19 CD Don Benito Benito 37 24 42 26
20 Poli Almería Poli 17 12 27 11
TEMPORADA 1999/2000
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 38 64 32 73
2 CD San Fernando Fernando 38 58 31 68
3 Puerto Real CF Puerto Real 38 62 40 66
4 RC Portuense Portuense 38 44 41 65
5 UD Los Palacios Palacios 38 54 43 64
6 At. Sanluqueño Sanluqueño 38 61 47 63
7 CD Pozoblanco Pozoblanco 38 62 43 61
8 Lucena Lucena 38 45 37 55
9 Atlético Onubense Atlético 38 45 38 55
10 UD Tomares UD Tomares 38 55 52 55
11 CD Villanueva Villanueva 38 43 49 51
12 Córdoba CF B Córdoba 38 53 54 48
13 AD Cartaya AD Cartaya 38 49 54 47
14 La Palma La Palma 37 37 45 43
15 Ayamonte Ayamonte 38 35 53 41
16 Los Barrios Los Barrios 38 36 49 40
17 Chiclana CF Chiclana CF 38 42 58 39
18 Montilla Montilla 38 38 59 38
19 AD Ceuta FC B Ceuta 38 43 67 28
20 CD Rota CD Rota 37 32 66 26
TEMPORADA 1998/1999
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 UD Melilla UD Melilla 38 42 25 69
2 Sevilla At. Sevilla At. 38 53 31 68
3 Córdoba CF Córdoba CF 38 64 35 67
4 Poli Almería Poli 38 45 20 67
5 Cádiz Cádiz 38 47 34 64
6 Granada Granada 38 51 35 64
7 AgD Ceuta AgD Ceuta 38 54 36 61
8 Real Jaén Real Jaén 38 40 34 58
9 Betis Deportivo Betis 38 59 52 56
10 Motril CF Motril CF 38 38 36 55
11 Xerez CD Xerez CD 38 43 38 55
12 Jerez Jerez 38 51 34 54
13 CD Manchego CD Manchego 38 32 32 48
14 CP Cacereño Cacereño 38 42 42 47
15 Écija Balompié Écija 38 36 41 47
16 Algeciras CF Algeciras 38 38 35 46
17 Plasencia Plasencia 38 33 51 40
18 Almería Almería 38 45 40 40
19 Moralo Moralo 38 41 65 31
20 CD Isla Cristina Isla 38 12 150 4
TEMPORADA 1997/1998
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 AgD Ceuta AgD Ceuta 38 81 27 82
2 CD San Fernando Fernando 38 91 31 78
3 San Roque de Lepe Roque Lepe 38 50 30 64
4 Algeciras CF Algeciras 38 54 46 64
5 Lucena Lucena 38 34 21 63
6 Coria CF Coria CF 38 57 36 63
7 Chiclana CF Chiclana CF 38 54 43 58
8 Utrera Utrera 38 48 48 53
9 La Palma La Palma 38 45 60 52
10 CD Rota CD Rota 38 53 65 50
11 RB Linense RB Linense 38 39 60 46
12 Ayamonte Ayamonte 38 46 48 46
13 Puerto Real CF Puerto Real 38 49 61 45
14 Montilla Montilla 38 35 47 45
15 At. Sanluqueño Sanluqueño 38 49 49 44
16 CD Pozoblanco Pozoblanco 38 43 48 44
17 UD Los Palacios Palacios 38 40 53 42
18 Cádiz CF Mirandilla Cádiz 38 35 47 40
19 La Rambla CF Rambla 38 38 74 34
20 Rayo Sanluqueño Rayo 38 36 83 24
TEMPORADA 1996/1997
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 UA. Ceutí UA. Ceutí 42 69 41 79
2 CD Isla Cristina Isla 42 76 40 76
3 Algeciras CF Algeciras 42 61 39 72
4 Ayamonte Ayamonte 42 64 38 71
5 Montilla Montilla 42 62 51 70
6 UD Los Palacios Palacios 42 60 44 66
7 CD San Fernando Fernando 42 67 57 66
8 At. Sanluqueño Sanluqueño 42 59 53 64
9 CD Pozoblanco Pozoblanco 42 55 49 61
10 CD Rota CD Rota 42 57 58 59
11 San Roque de Lepe Roque Lepe 42 57 56 57
12 RB Linense RB Linense 42 57 52 55
13 Cádiz CF Mirandilla Cádiz 42 51 55 54
14 La Palma La Palma 42 51 54 54
15 Utrera Utrera 42 71 49 54
16 Lucena Lucena 42 53 69 50
17 Chiclana CF Chiclana CF 42 45 59 50
18 Dos Hermanas CF Hermanas 42 53 60 50
19 Mairena Mairena 42 36 62 37
20 Conil Conil 42 30 77 33
21 Roteña Roteña 42 23 90 23
TEMPORADA 1995/1996
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 CD San Fernando Fernando 38 73 34 70
2 At. Sanluqueño Sanluqueño 38 60 27 67
3 CD Isla Cristina Isla 38 61 39 65
4 Chiclana CF Chiclana CF 38 53 34 64
5 San Roque de Lepe Roque Lepe 38 54 43 63
6 Montilla Montilla 38 49 31 62
7 La Palma La Palma 38 65 47 59
8 CD Pozoblanco Pozoblanco 38 52 41 58
9 Coria CF Coria CF 38 47 39 58
10 RB Linense RB Linense 38 48 36 55
11 CD Rota CD Rota 38 48 44 55
12 UD Los Palacios Palacios 38 43 53 50
13 Dos Hermanas CF Hermanas 38 62 68 48
14 Algeciras CF Algeciras 38 43 41 46
15 Mairena Mairena 38 41 56 44
16 Cádiz CF Mirandilla Cádiz 38 55 61 43
17 Conil Conil 38 36 67 39
18 Jerez Industrial CF Jerez 38 37 60 38
19 San Juan San Juan 38 29 54 37
20 O Donnell O Donnell 38 25 106 12
TEMPORADA 1992/1993
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 At. Cortegana Cortegana 38 56 23 52
2 Mairena Mairena 38 48 29 50
3 CD San Fernando Fernando 38 57 30 49
4 San Juan San Juan 38 42 34 45
5 At. Sanluqueño Sanluqueño 38 43 29 44
6 UD Los Palacios Palacios 38 46 29 44
7 Coria CF Coria CF 38 61 50 42
8 Cádiz CF Mirandilla Cádiz 38 56 45 40
9 Lucena Lucena 38 45 42 38
10 CD Pozoblanco Pozoblanco 38 49 39 37
11 Puente Genil Puente Genil 38 30 34 37
12 Roteña Roteña 38 35 41 36
13 Jerez Industrial CF Jerez 38 41 43 36
14 Montilla Montilla 38 40 49 35
15 Lebrija Lebrija 38 50 48 35
16 La Palma La Palma 38 35 48 33
17 Algeciras CF Algeciras 38 53 65 32
18 Arcos CF Arcos CF 38 30 58 29
19 CD Rota CD Rota 38 28 60 28
20 Chiclana CF Chiclana CF 38 27 76 18
TEMPORADA 1991/1992
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Sevilla At. Sevilla At. 38 65 25 54
2 Écija Balompié Écija 38 67 22 52
3 San Roque de Lepe Roque Lepe 38 64 36 49
4 Algeciras CF Algeciras 38 56 28 49
5 San Juan San Juan 38 50 34 45
6 Mairena Mairena 38 52 42 44
7 CD Pozoblanco Pozoblanco 38 50 33 43
8 Lebrija Lebrija 38 47 41 43
9 UD Los Palacios Palacios 38 54 41 41
10 Roteña Roteña 38 54 56 39
11 Coria CF Coria CF 38 55 46 38
12 Jerez Industrial CF Jerez 38 39 44 38
13 Montilla Montilla 38 38 41 36
14 Lucena Lucena 38 42 55 33
15 Chiclana CF Chiclana CF 38 52 60 31
16 Cádiz CF Mirandilla Cádiz 38 37 52 30
17 Palma del Rio Atletico CF Palma 38 32 64 27
18 CD San Fernando Fernando 38 30 58 26
19 Santaella 2010 Santaella 38 29 74 24
20 AgD Ceuta AgD Ceuta 38 25 86 18
TEMPORADA 1990/1991
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Cádiz CF Mirandilla Cádiz 38 70 34 53
2 RC Portuense Portuense 38 59 35 50
3 Écija Balompié Écija 38 49 25 50
4 San Roque de Lepe Roque Lepe 38 54 30 49
5 CD Pozoblanco Pozoblanco 38 48 33 49
6 Palma del Rio Atletico CF Palma 38 45 29 47
7 Algeciras CF Algeciras 38 57 41 45
8 Chiclana CF Chiclana CF 38 46 40 43
9 Mairena Mairena 38 36 31 42
10 Montilla Montilla 38 37 31 41
11 CD San Fernando Fernando 38 45 48 37
12 Lebrija Lebrija 38 47 50 33
13 Coria CF Coria CF 38 45 50 33
14 Lucena Lucena 38 39 52 32
15 Santaella 2010 Santaella 38 37 62 31
16 Jerez Industrial CF Jerez 38 37 43 29
17 La Palma La Palma 38 30 52 27
18 Ayamonte Ayamonte 38 35 56 26
19 Utrera Utrera 38 31 56 25
20 Puerto Real CF Puerto Real 38 18 67 18
TEMPORADA 1989/1990
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Betis Deportivo Betis 38 64 26 56
2 RC Portuense Portuense 38 65 32 53
3 San Roque de Lepe Roque Lepe 38 49 35 48
4 Algeciras CF Algeciras 38 51 31 45
5 CD Pozoblanco Pozoblanco 38 53 33 45
6 CD San Fernando Fernando 38 58 39 44
7 Lebrija Lebrija 38 47 35 40
8 Écija Balompié Écija 38 48 40 40
9 Santaella 2010 Santaella 38 54 56 39
10 Palma del Rio Atletico CF Palma 38 39 40 39
11 Coria CF Coria CF 38 43 44 39
12 Chiclana CF Chiclana CF 38 44 52 38
13 Ayamonte Ayamonte 38 45 49 38
14 Cádiz CF Mirandilla Cádiz 38 47 52 36
15 La Palma La Palma 38 43 52 35
16 Montilla Montilla 38 30 41 31
17 Puerto Real CF Puerto Real 38 27 40 30
18 Dos Hermanas CF Hermanas 38 43 52 29
19 CD Rota CD Rota 38 34 63 24
20 Club Atlético De Ceuta Club 38 22 94 11
TEMPORADA 1988/1989
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Levante Levante 38 66 29 59
2 AgD Ceuta AgD Ceuta 38 44 23 48
3 At. Sanluqueño Sanluqueño 38 47 27 47
4 Villarreal Villarreal 38 53 34 45
5 Eldense Eldense 38 37 32 44
6 Atlético Marbella Atlético 38 46 32 43
7 Cartagena F.C. UCAM Cartagena 38 39 29 41
8 Hércules Hércules 38 49 47 40
9 Alcoyano Alcoyano 38 48 44 39
10 Olimpic Xátiva Olimpic 38 41 41 39
11 CF Gandia CF Gandia 38 32 30 38
12 Albacete Albacete 38 46 45 36
13 Torrevieja Torrevieja 38 45 52 35
14 RB Linense RB Linense 38 36 41 35
15 UD Melilla UD Melilla 38 37 49 35
16 Granada Granada 38 40 47 32
17 Poli Almería Poli 38 37 59 28
18 Algeciras CF Algeciras 38 28 43 27
19 CF Lorca Deportiva Lorca 38 20 53 26
20 Nules Nules 38 32 66 23
TEMPORADA 1987/1988
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 42 70 31 64
2 CD San Fernando Fernando 42 64 33 57
3 Palma del Rio Atletico CF Palma 42 66 40 56
4 Cádiz CF Mirandilla Cádiz 42 70 44 53
5 Atlético Antoniano Atlético 42 63 35 52
6 Ayamonte Ayamonte 42 55 32 50
7 Écija Balompié Écija 42 59 41 50
8 Bollullos CF Bollullos 42 57 44 46
9 Coria CF Coria CF 42 55 44 44
10 San Roque de Lepe Roque Lepe 42 45 41 44
11 Dos Hermanas CF Hermanas 42 63 53 43
12 Utrera Utrera 42 51 43 41
13 CD Rota CD Rota 42 47 57 41
14 Brenes Balompié Brenes 42 41 50 40
15 Pilas Pilas 42 42 42 40
16 Montilla Montilla 42 47 48 39
17 RC Portuense Portuense 41 48 71 35
18 Ubrique Ind. Ubrique Ind. 42 35 55 34
19 Mairena Mairena 42 35 72 29
20 UA. Ceutí UA. Ceutí 42 35 67 26
21 Imperio Ceuta Imperio 42 38 85 22
22 Moguer CD Moguer CD 41 24 82 16
TEMPORADA 1985/1986
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 38 43 24 47
2 RB Linense RB Linense 38 64 44 46
3 Córdoba CF Córdoba CF 38 42 38 43
4 AgD Ceuta AgD Ceuta 38 43 35 43
5 Alcoyano Alcoyano 38 44 39 42
6 Poblense Poblense 38 48 43 42
7 Granada Granada 38 62 47 41
8 Puertollano Puertollano 38 44 41 41
9 Orihuela Deportiva CF Orihuela 38 39 39 41
10 Levante Levante 38 43 50 38
11 AD Parla AD Parla 38 34 41 38
12 Plasencia Plasencia 38 41 46 37
13 Talavera CF Talavera CF 38 41 46 37
14 Linares CF Linares CF 38 39 40 36
15 Betis Deportivo Betis 38 56 45 35
16 Manacor Manacor 38 40 47 35
17 RSD Alcalá RSD Alcalá 38 36 40 34
18 Real Jaén Real Jaén 38 47 53 33
19 Algeciras CF Algeciras 38 35 55 27
20 CF Lorca Deportiva Lorca 38 39 67 24
TEMPORADA 1984/1985
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Rayo Vallecano Rayo 38 57 39 50
2 Albacete Albacete 38 47 29 47
3 Algeciras CF Algeciras 38 40 25 47
4 RB Linense RB Linense 38 54 38 47
5 Orihuela Deportiva CF Orihuela 38 46 32 45
6 Xerez CD Xerez CD 38 39 30 43
7 Real Jaén Real Jaén 38 45 36 40
8 Alcoyano Alcoyano 38 48 44 40
9 Linares CF Linares CF 38 43 43 40
10 AgD Ceuta AgD Ceuta 38 42 41 38
11 Levante Levante 38 54 47 37
12 L´Hospitalet L´Hospitale 38 45 52 35
13 Talavera CF Talavera CF 38 34 40 35
14 Poblense Poblense 38 35 41 34
15 AD Parla AD Parla 38 37 46 33
16 RSD Alcalá RSD Alcalá 38 30 47 33
17 Manacor Manacor 38 39 42 32
18 Atlético Marbella Atlético 38 38 48 31
19 CD Badajoz CD Badajoz 38 40 50 30
20 CD Antequerano Antequerano 38 26 69 23
TEMPORADA 1983/1984
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 RM Castilla RM Castilla 38 69 47 50
2 Bilbao Ath. Bilbao Ath. 38 61 39 50
3 Hércules Hércules 38 46 35 45
4 Racing Racing 38 53 39 44
5 Elche Elche 38 64 40 43
6 Celta Celta 38 45 36 42
7 Barça Atlètic Barça 38 55 48 40
8 Granada Granada 38 42 36 40
9 RC Deportivo Deportivo 38 37 39 39
10 CD Castellón Castellón 38 45 57 37
11 Las Palmas Las Palmas 38 46 52 36
12 Recreativo Recreativo 38 32 48 36
13 Real Oviedo Real Oviedo 38 44 49 35
14 Atlético B Atlético B 38 64 63 34
15 Tenerife Tenerife 38 45 49 34
16 Cartagena F.C. UCAM Cartagena 38 35 46 33
17 Linares CF Linares CF 38 39 55 32
18 Algeciras CF Algeciras 38 34 45 32
19 Palencia Palencia 38 33 49 29
20 Rayo Vallecano Rayo 38 34 51 29

  USO DE MEMORIA  
8,569,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0157
Controller Execution Time ( Home / Category )  0.1338
Total Execution Time  0.1495
  CADENA URL  
/historico/Algeciras-Cf/2006
  GET DATOS  
$_GET['/historico/Algeciras-Cf/2006']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0040  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 = 20577
0.0023  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 = 171
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=166 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 166 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (1903,2601,2835,3254,4075) ORDER BY n.cover_points DESC, update_date DESC
0.0032  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 = '166' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 20577 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 171 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034  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 events2006 e ON e.player_id = p.id AND e.league_id = 20577 WHERE rp.league_id = 20577 AND rp.teamId = 166 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.0028  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 events2006 e ON e.player_id = p.id AND e.league_id = 20577 WHERE rp.league_id = 20577 AND rp.teamId = 166 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 events2006 e ON e.player_id = p.id AND e.league_id = 20577 WHERE rp.league_id = 20577 AND rp.teamId = 166 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 166 AND l.year <= 2006 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 171 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 `tables2005` 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 = 175 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 `tables2003` 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 = 5523 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 `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 = 5521 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 `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 = 22023 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 `tables1999` 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 = 5519 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 `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 = 21991 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 `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 = 21973 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 `tables1996` 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 = 21952 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 = 21889 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 `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 = 21868 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 `tables1991` 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 = 21845 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 `tables1990` 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 = 21824 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 `tables1989` 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 = 22243 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 `tables1988` 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 = 21785 AND t.round = 51 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 `tables1986` 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 = 22237 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 `tables1985` 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 = 22236 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 `tables1984` 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 = 5480 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC