4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
TEMPORADA 1964/1965
SEGUNDA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Mallorca Mallorca 30 37 23 42
2 CD Málaga CD Málaga 30 49 26 38
3 Real Valladolid Real 30 47 24 35
4 Hércules Hércules 30 55 36 34
5 Granada Granada 30 45 35 32
6 Club Atlético De Ceuta Club 30 39 38 32
7 Puertollano Puertollano 30 40 42 32
8 Recreativo Recreativo 30 37 35 31
9 Valencia Mestalla Valencia 30 37 41 31
10 Algeciras CF Algeciras 30 30 30 28
11 Tenerife Tenerife 30 24 33 28
12 Melilla CF Melilla CF 30 24 34 27
13 Constància Constància 30 31 41 26
14 Cádiz Cádiz 30 35 44 25
15 Ontinyent CF Ontinyent 30 35 50 21
16 CD Abarán CD Abarán 30 20 53 18
TEMPORADA 1963/1964
SEGUNDA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Las Palmas Las Palmas 30 45 25 40
2 Hércules Hércules 30 48 38 38
3 Mallorca Mallorca 30 52 32 37
4 Valencia Mestalla Valencia 30 60 38 33
5 Granada Granada 30 41 32 32
6 Tenerife Tenerife 30 30 40 32
7 CD Málaga CD Málaga 30 38 33 30
8 Cádiz Cádiz 30 45 41 30
9 Algeciras CF Algeciras 30 40 53 30
10 Recreativo Recreativo 30 41 34 29
11 Ontinyent CF Ontinyent 30 33 29 29
12 Melilla CF Melilla CF 30 34 38 28
13 CD Abarán CD Abarán 30 38 49 26
14 Club Atlético De Ceuta Club 30 29 49 26
15 CD San Fernando Fernando 30 24 45 21
16 Eldense Eldense 30 33 55 19
TEMPORADA 1962/1963
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 AgD Ceuta AgD Ceuta 30 87 20 46
2 Algeciras CF Algeciras 30 86 19 45
3 Balón de Cádiz CF Balón 30 65 28 42
4 RC Portuense Portuense 30 69 43 40
5 Utrera Utrera 30 52 41 36
6 Ayamonte Ayamonte 30 45 44 32
7 RB Linense RB Linense 30 50 41 31
8 Coria CF Coria CF 29 44 52 29
9 Jerez Industrial CF Jerez 30 41 38 29
10 Puerto Real CF Puerto Real 30 42 50 27
11 Riotinto Balompié Riotinto 30 42 53 27
12 Xerez CD Xerez CD 30 42 49 25
13 La Palma La Palma 30 27 67 20
14 Barbate Barbate 29 34 71 19
15 Tarifa UD Tarifa UD 30 26 67 16
16 Bollullos CF Bollullos 30 23 92 12

  USO DE MEMORIA  
7,915,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5845
Total Execution Time  0.5858
  CADENA URL  
/historico/Algeciras-Cf/1987
  GET DATOS  
$_GET['/historico/Algeciras-Cf/1987']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0124  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 = 1987 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.0106  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.0106  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.0212  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 = 21040
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=166 AND type_rel = 2
0.0109  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.0110  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.0120  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 = 1987 ORDER BY l.year DESC,cat.coefficient DESC
0.0117  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.0106  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 = 21040 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0114  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 (1986,1987,1988) ORDER BY l.id DESC, l.year DESC ;
0.0107  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 (22237,21897,21785,21040) 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.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 22237 AND teamId = 166
0.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 21785 AND teamId = 166
0.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 21040 AND teamId = 166
0.0112  SELECT count(id) as num_players from rel_players WHERE league_id = 21897 AND teamId = 166
0.0106  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1987` 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 = 21040 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0106  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 events1987 e ON e.player_id = p.id AND e.league_id = 21040 WHERE rp.league_id = 21040 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.0106  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 events1987 e ON e.player_id = p.id AND e.league_id = 21040 WHERE rp.league_id = 21040 AND rp.teamId = 166 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0107  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 events1987 e ON e.player_id = p.id AND e.league_id = 21040 WHERE rp.league_id = 21040 AND rp.teamId = 166 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0115  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 <= 1987 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0112  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.0122  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.0117  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.0112  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.0114  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.0115  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.0119  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.0200  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.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 `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.0113  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.0112  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.0110  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.0113  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.0112  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.0110  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.0110  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.0111  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.0111  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 = 11720 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 11718 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 21558 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC