4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
TEMPORADA 1982/1983
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Granada Granada 38 51 29 53
2 Algeciras CF Algeciras 38 37 21 50
3 Albacete Albacete 38 50 24 50
4 CD Antequerano Antequerano 38 49 28 47
5 RC Portuense Portuense 38 37 31 43
6 Talavera CF Talavera CF 38 49 38 41
7 Alcoyano Alcoyano 38 38 42 41
8 CD Badajoz CD Badajoz 38 47 33 41
9 AgD Ceuta AgD Ceuta 38 51 37 39
10 AD Parla AD Parla 38 39 39 39
11 CF Lorca Deportiva Lorca 38 40 32 39
12 Real Jaén Real Jaén 38 41 40 38
13 Puertollano Puertollano 38 47 47 38
14 L´Hospitalet L´Hospitale 38 45 46 38
15 Poblense Poblense 38 46 45 34
16 RSD Alcalá RSD Alcalá 38 31 44 30
17 SD Ibiza SD Ibiza 38 29 47 29
18 CD Fuengirola Fuengirola 38 29 61 24
19 CD San Fernando Fernando 38 38 75 24
20 AD Torrejón CF Torrejón 38 26 61 22
TEMPORADA 1981/1982
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 38 51 32 50
2 CF Lorca Deportiva Lorca 38 45 28 48
3 Cartagena F.C. UCAM Cartagena 38 43 26 48
4 CD Antequerano Antequerano 38 43 28 48
5 AgD Ceuta AgD Ceuta 38 62 38 46
6 Algeciras CF Algeciras 38 32 22 44
7 Puertollano Puertollano 38 46 35 42
8 FC Andorra FC Andorra 38 56 44 41
9 RC Portuense Portuense 38 30 31 39
10 Granada Granada 38 34 32 39
11 Gimnàstic Tarragona Gimnàstic 38 38 31 38
12 CD San Fernando Fernando 38 38 40 36
13 SD Ibiza SD Ibiza 38 36 45 36
14 Reus Deportiu Reus 38 32 48 35
15 Real Jaén Real Jaén 38 43 55 32
16 AD Torrejón CF Torrejón 38 41 49 32
17 CD Badajoz CD Badajoz 38 38 46 32
18 Terrassa FC Terrassa FC 38 36 54 28
19 UD Vall de Uxó Vall Uxó 38 24 51 24
20 Las Palmas At. Palmas 38 36 69 22
TEMPORADA 1980/1981
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Mallorca Mallorca 38 62 33 54
2 Córdoba CF Córdoba CF 38 62 33 53
3 Barça Atlètic Barça 38 47 39 45
4 Algeciras CF Algeciras 38 38 26 44
5 Cartagena F.C. UCAM Cartagena 38 47 36 44
6 CD Badajoz CD Badajoz 38 38 28 43
7 Real Jaén Real Jaén 38 51 43 41
8 Xerez CD Xerez CD 38 52 48 40
9 Gimnàstic Tarragona Gimnàstic 38 37 35 39
10 Lleida Lleida 38 43 43 39
11 FC Andorra FC Andorra 38 50 47 38
12 RC Portuense Portuense 38 40 36 38
13 Puertollano Puertollano 38 51 47 37
14 SD Ibiza SD Ibiza 38 28 37 34
15 Terrassa FC Terrassa FC 38 33 46 32
16 UD Vall de Uxó Vall Uxó 38 41 62 32
17 CD San Fernando Fernando 38 36 44 31
18 Mérida CP Mérida CP 38 35 52 29
19 Diter Zafra Diter Zafra 38 27 54 24
20 Eldense Eldense 38 32 61 23
TEMPORADA 1979/1980
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Murcia Real Murcia 38 58 39 47
2 Real Valladolid Real 38 53 40 45
3 Osasuna Osasuna 38 74 49 44
4 CD Castellón Castellón 38 47 42 42
5 Elche Elche 38 46 41 42
6 CE Sabadell CE Sabadell 38 47 49 41
7 RM Castilla RM Castilla 38 46 39 40
8 Cádiz Cádiz 38 43 42 39
9 Deportivo Alavés Deportivo 38 37 39 38
10 Levante Levante 38 47 51 38
11 Real Oviedo Real Oviedo 38 40 45 38
12 Recreativo Recreativo 38 38 42 37
13 Granada Granada 38 42 42 37
14 Getafe Deportivo Getafe 38 44 50 37
15 Palencia Palencia 38 49 49 36
16 Racing Racing 38 34 39 36
17 Celta Celta 38 48 43 35
18 RC Deportivo Deportivo 38 49 50 35
19 Gimnàstic Tarragona Gimnàstic 38 29 61 27
20 Algeciras CF Algeciras 38 29 48 26
TEMPORADA 1978/1979
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 AD Almería AD Almería 38 62 44 47
2 CD Málaga CD Málaga 38 47 27 47
3 Real Betis Real Betis 38 58 35 46
4 Real Valladolid Real 38 47 32 46
5 Elche Elche 38 50 31 45
6 Granada Granada 38 46 34 44
7 RM Castilla RM Castilla 38 55 45 42
8 Cádiz Cádiz 38 52 47 41
9 Deportivo Alavés Deportivo 38 45 31 40
10 Getafe Deportivo Getafe 38 57 56 40
11 CD Castellón Castellón 38 48 43 38
12 CE Sabadell CE Sabadell 38 50 49 37
13 Osasuna Osasuna 38 51 51 37
14 Real Murcia Real Murcia 38 35 52 35
15 RC Deportivo Deportivo 38 43 45 35
16 Algeciras CF Algeciras 38 40 53 34
17 Real Jaén Real Jaén 38 41 55 34
18 Terrassa FC Terrassa FC 38 34 51 29
19 Barakaldo Barakaldo 38 31 53 28
20 Racing Ferrol Racing 38 22 80 15
TEMPORADA 1977/1978
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 AD Almería AD Almería 38 68 27 56
2 Algeciras CF Algeciras 38 54 27 53
3 AgD Ceuta AgD Ceuta 38 60 29 52
4 Levante Levante 38 53 37 42
5 Barça Atlètic Barça 38 59 43 41
6 Girona Girona 38 48 49 39
7 Xerez CD Xerez CD 38 54 47 39
8 Olimpic Xátiva Olimpic 38 44 41 38
9 Diter Zafra Diter Zafra 38 46 54 38
10 RC Portuense Portuense 38 33 34 37
11 UE Sant Andreu Sant Andreu 38 34 46 37
12 Vinaròs Vinaròs 38 46 51 36
13 Sevilla At. Sevilla At. 38 51 61 36
14 Linares CF Linares CF 38 33 41 35
15 CD Badajoz CD Badajoz 38 42 43 34
16 Lleida Lleida 38 39 46 34
17 Ontinyent CF Ontinyent 38 38 53 31
18 Mallorca Mallorca 38 28 46 28
19 Eldense Eldense 38 41 61 28
20 Atlético Baleares Atlético 38 31 66 26
TEMPORADA 1976/1977
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Real Murcia Real Murcia 36 73 25 53
2 AD Almería AD Almería 36 68 33 46
3 AgD Ceuta AgD Ceuta 36 59 30 46
4 Linares CF Linares CF 36 38 25 44
5 Diter Zafra Diter Zafra 36 50 40 42
6 Algeciras CF Algeciras 36 42 41 40
7 CD Badajoz CD Badajoz 36 46 50 39
8 Xerez CD Xerez CD 36 51 41 37
9 RC Portuense Portuense 36 43 39 37
10 Sevilla At. Sevilla At. 36 39 46 36
11 CP Cacereño Cacereño 36 41 49 35
12 Jerez Industrial CF Jerez 36 32 51 33
13 CD San Fernando Fernando 36 38 48 29
14 Valdepeñas Valdepeñas 36 40 50 29
15 Mérida CP Mérida CP 36 32 51 29
16 UD Melilla UD Melilla 36 38 51 28
17 Orihuela Deportiva CF Orihuela 36 31 55 28
18 CD Guadalajara Guadalajara 36 45 57 27
19 Betis Deportivo Betis 36 42 66 26
20 SD Melilla SD Melilla 0 0 0 0
TEMPORADA 1975/1976
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Real Jaén Real Jaén 38 52 18 55
2 AD Almería AD Almería 38 64 35 50
3 Linares CF Linares CF 38 48 34 47
4 CD San Fernando Fernando 38 57 39 46
5 Algeciras CF Algeciras 38 44 34 43
6 AgD Ceuta AgD Ceuta 38 42 42 41
7 Orihuela Deportiva CF Orihuela 38 41 44 40
8 CP Cacereño Cacereño 38 45 44 40
9 Xerez CD Xerez CD 38 60 45 40
10 Jerez Industrial CF Jerez 38 42 45 38
11 Eldense Eldense 38 32 33 37
12 Atlético Marbella Atlético 38 47 47 36
13 RC Portuense Portuense 38 35 35 36
14 CD Badajoz CD Badajoz 38 46 43 35
15 Diter Zafra Diter Zafra 38 33 43 35
16 SD Melilla SD Melilla 38 51 53 34
17 Albacete Albacete 38 37 53 31
18 Melilla CF Melilla CF 38 42 61 30
19 RB Linense RB Linense 38 26 50 28
20 Imperio Ceuta Imperio 38 27 73 18
TEMPORADA 1974/1975
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Puertollano Puertollano 38 57 25 50
2 Atlético Marbella Atlético 38 61 32 49
3 Linares CF Linares CF 38 47 35 47
4 Xerez CD Xerez CD 38 44 42 43
5 CD Badajoz CD Badajoz 38 59 43 42
6 Eldense Eldense 38 42 34 41
7 RC Portuense Portuense 38 47 36 41
8 SD Melilla SD Melilla 38 43 41 40
9 AgD Ceuta AgD Ceuta 38 49 48 40
10 Real Jaén Real Jaén 38 34 27 40
11 RB Linense RB Linense 38 34 34 38
12 CD San Fernando Fernando 38 42 49 38
13 Orihuela Deportiva CF Orihuela 38 32 42 36
14 Cartagena F.C. UCAM Cartagena 38 46 46 36
15 Algeciras CF Algeciras 38 33 37 36
16 AD Almería AD Almería 38 52 46 34
17 Melilla CF Melilla CF 38 39 61 34
18 Hellin Deportivo Hellin 38 40 53 31
19 CF Extremadura Extremadura 38 33 66 24
20 Real Granada Real Granada 38 26 63 20
TEMPORADA 1969/1970
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Cádiz Cádiz 38 64 14 63
2 Xerez CD Xerez CD 38 53 24 54
3 UD Melilla UD Melilla 38 61 32 49
4 Recreativo Recreativo 38 60 32 48
5 Sevilla At. Sevilla At. 38 60 37 48
6 RC Portuense Portuense 38 61 46 47
7 Betis Deportivo Betis 38 63 43 46
8 RB Linense RB Linense 38 59 45 46
9 Estepona Estepona 38 53 45 44
10 Jerez Industrial CF Jerez 38 55 38 40
11 CD San Fernando Fernando 38 43 51 38
12 Atlético Marbella Atlético 38 37 35 36
13 Algeciras CF Algeciras 38 48 53 36
14 Alcalá de Guadaira Alcalá 38 38 44 34
15 AgD Ceuta AgD Ceuta 38 40 47 33
16 At. Sanluqueño Sanluqueño 38 37 61 30
17 Ayamonte Ayamonte 38 31 66 20
18 Puerto Malagueño Puerto 38 32 87 19
19 UA. Ceutí UA. Ceutí 38 29 71 15
20 CD Rota CD Rota 38 21 74 14
TEMPORADA 1968/1969
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 36 63 32 52
2 UD Melilla UD Melilla 36 50 25 50
3 Betis Deportivo Betis 36 66 42 49
4 AgD Ceuta AgD Ceuta 36 54 41 44
5 Sevilla At. Sevilla At. 36 60 26 41
6 Algeciras CF Algeciras 36 57 50 39
7 Atlético Marbella Atlético 36 45 41 38
8 RB Linense RB Linense 36 45 45 38
9 Xerez CD Xerez CD 36 59 47 38
10 CD Alcalá CD Alcalá 36 45 39 37
11 At. Malagueño Malagueño 36 50 44 36
12 CD San Fernando Fernando 36 56 58 34
13 Estepona Estepona 36 46 58 33
14 RC Portuense Portuense 36 41 43 32
15 Adra Adra 35 39 81 28
16 CD Rota CD Rota 36 37 66 28
17 Ayamonte Ayamonte 36 41 59 26
18 At. Sanluqueño Sanluqueño 35 36 55 24
19 Balón de Cádiz CF Balón 36 33 71 15
20 C.D. Almería C.D. 0 0 0 0
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
SEGUNDA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 CD Málaga CD Málaga 30 44 18 44
2 Real Betis Real Betis 30 47 26 40
3 CD Castellón Castellón 30 42 24 37
4 Levante Levante 30 41 26 37
5 Mallorca Mallorca 30 45 30 35
6 Real Murcia Real Murcia 30 39 36 32
7 CE Europa CE Europa 30 29 33 32
8 Cádiz Cádiz 30 35 41 29
9 Valencia Mestalla Valencia 30 45 53 29
10 Badalona Badalona 30 32 40 27
11 Recreativo Recreativo 30 31 34 25
12 Lleida Lleida 30 30 40 24
13 Club Atlético De Ceuta Club 30 31 44 24
14 Constància Constància 30 29 41 22
15 Algeciras CF Algeciras 30 22 36 22
16 Condal CD Condal CD 30 33 53 21
TEMPORADA 1965/1966
SEGUNDA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Hércules Hércules 30 44 24 39
2 Granada Granada 30 40 29 37
3 Real Valladolid Real 30 49 32 35
4 Algeciras CF Algeciras 30 42 29 35
5 Levante Levante 30 42 22 34
6 Valencia Mestalla Valencia 30 45 44 33
7 Tenerife Tenerife 30 40 34 32
8 Puertollano Puertollano 30 33 36 32
9 Rayo Vallecano Rayo 30 37 26 31
10 Recreativo Recreativo 30 31 30 29
11 Real Murcia Real Murcia 30 31 37 29
12 Cádiz Cádiz 30 25 28 27
13 Constància Constància 30 34 49 26
14 Club Atlético De Ceuta Club 30 35 47 25
15 Melilla CF Melilla CF 30 26 51 20
16 CD Badajoz CD Badajoz 30 22 58 16

  USO DE MEMORIA  
8,259,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7749
Total Execution Time  0.7762
  CADENA URL  
/historico/Algeciras-Cf/1990
  GET DATOS  
$_GET['/historico/Algeciras-Cf/1990']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0151  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 = 'Algeciras-Cf' AND l.year = 1990 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.0134  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=166 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=166 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0258  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 = 21824
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=166 AND type_rel = 2
0.0144  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.0137  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.0188  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 = '166' AND l.year = 1990 ORDER BY l.year DESC,cat.coefficient DESC
0.0181  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.0136  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 = 21824 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0184  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=166 AND l.year in (1989,1990,1991) ORDER BY l.id DESC, l.year DESC ;
0.0129  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 (22243,21853,21845) 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.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 22243 AND teamId = 166
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 21845 AND teamId = 166
0.0139  SELECT count(id) as num_players from rel_players WHERE league_id = 21853 AND teamId = 166
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0142  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 = '166' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '166' and rp.type = 4
0.0127  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 = '166' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0126  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '166' and rp.type = 4
0.0130  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 events1990 e ON e.player_id = p.id AND e.league_id = 21824 WHERE rp.league_id = 21824 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.0128  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 events1990 e ON e.player_id = p.id AND e.league_id = 21824 WHERE rp.league_id = 21824 AND rp.teamId = 166 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 events1990 e ON e.player_id = p.id AND e.league_id = 21824 WHERE rp.league_id = 21824 AND rp.teamId = 166 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 <= 1990 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0140  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0161  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.0158  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.0143  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.0135  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.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1983` 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 = 22234 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 22233 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 22232 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1980` 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 = 5476 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 `tables1979` 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 = 5475 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 `tables1978` 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 = 22229 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 `tables1977` 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 = 21647 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 `tables1976` 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 = 21644 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1975` 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 = 21641 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 21625 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1969` 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 = 21618 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 11721 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 11734 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 21824 ORDER BY nameShow LIMIT 100