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 1980/1981
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
TEMPORADA 1961/1962
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 30 69 20 49
2 UD Melilla UD Melilla 30 61 15 45
3 RB Linense RB Linense 30 59 40 39
4 At. Malagueño Malagueño 30 60 35 38
5 C.D. Almería C.D. 30 60 42 38
6 CD Linares CD Linares 30 48 44 33
7 Antequera CF Antequera 30 50 46 33
8 Vélez CF Vélez CF 30 46 45 29
9 Adra Adra 30 35 44 27
10 Iliturgi CF Iliturgi CF 30 47 54 26
11 CD Ronda CD Ronda 30 38 54 23
12 Peñarroya Pueblonuevo Peñarroya 30 52 80 23
13 Prieguense A.F. Prieguense 30 39 56 22
14 CD Alhaurino Alhaurino 30 39 75 21
15 Recreativo Granada Recreativo 30 44 61 19
16 Atl. Cordobes Atl. 30 43 79 15
TEMPORADA 1960/1961
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Sevilla At. Sevilla At. 30 74 19 48
2 Melilla CF Melilla CF 30 58 19 43
3 CD Linares CD Linares 30 57 30 40
4 RB Linense RB Linense 30 68 49 35
5 Peñarroya Peñarroya 30 57 50 33
6 Algeciras CF Algeciras 30 46 43 32
7 CD Ronda CD Ronda 30 41 54 29
8 Vélez CF Vélez CF 30 36 55 29
9 At. Malagueño Malagueño 30 50 46 28
10 Adra Adra 30 50 54 28
11 Atl. Cordobes Atl. 30 49 56 26
12 Recreativo Granada Recreativo 30 51 45 25
13 Antequera CF Antequera 30 31 47 22
14 Baeza CF Baeza CF 30 28 65 21
15 Écija Balompié Écija 30 37 59 21
16 Iliturgi CF Iliturgi CF 30 37 79 20
TEMPORADA 1959/1960
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 CD Málaga CD Málaga 30 80 32 45
2 RB Linense RB Linense 30 74 39 42
3 Algeciras CF Algeciras 30 60 26 42
4 CD Linares CD Linares 30 74 36 37
5 Iliturgi CF Iliturgi CF 30 40 39 35
6 Adra Adra 30 60 47 31
7 At. Malagueño Malagueño 30 53 47 30
8 Atl. Cordobes Atl. 30 50 50 29
9 Melilla CF Melilla CF 30 54 56 29
10 Peñarroya Pueblonuevo Peñarroya 30 51 50 28
11 CD Ronda CD Ronda 30 48 52 28
12 Recreativo Granada Recreativo 30 52 60 26
13 Antequera CF Antequera 30 57 79 22
14 Guadix CF Guadix CF 30 39 73 21
15 CD Pozoblanco Pozoblanco 30 45 96 18
16 Puente Genil Puente Genil 30 28 83 17
TEMPORADA 1958/1959
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Adra Adra 30 69 35 45
2 CD Linares CD Linares 30 54 27 40
3 Algeciras CF Algeciras 30 54 43 37
4 At. Malagueño Malagueño 30 75 49 33
5 Atl. Cordobes Atl. 30 77 64 33
6 Antequera CF Antequera 30 64 51 31
7 CD Ronda CD Ronda 30 55 54 31
8 Iliturgi CF Iliturgi CF 30 58 51 29
9 Guadix CF Guadix CF 30 49 67 29
10 Recreativo Granada Recreativo 30 47 48 28
11 Imperio Ceuta Imperio 30 55 58 27
12 RB Linense RB Linense 30 57 73 25
13 Melilla CF Melilla CF 30 51 51 24
14 Puente Genil Puente Genil 30 45 68 24
15 CD Úbeda Viva Úbeda Viva 30 31 60 22
16 UD Lucentina Lucentina 30 31 73 22
TEMPORADA 1957/1958
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Coria CF Coria CF 38 90 51 52
2 Utrera Utrera 38 76 47 50
3 Jerez Industrial CF Jerez 38 77 52 49
4 Moron Moron 38 88 48 49
5 RB Linense RB Linense 38 87 51 48
6 Algeciras CF Algeciras 38 69 52 44
7 Puerto Real CF Puerto Real 38 80 62 43
8 RC Portuense Portuense 38 68 59 41
9 La Palma CF La Palma CF 38 65 65 41
10 Marchena Balompié Marchena 38 75 57 41
11 Ayamonte Ayamonte 37 56 59 37
12 CD Puerto Sevilla Puerto 38 81 62 36
13 Barbate Barbate 38 78 84 36
14 Ol. Valverdeña Valverdeña 38 72 75 35
15 U. D. Gaditana Gaditana 38 51 75 31
16 Imperio Riffien Imperio 37 48 78 29
17 Lora CF Lora CF 38 57 82 28
18 Imperio Ceuta Imperio 38 49 83 23
19 Los Barrios Los Barrios 37 58 135 19
20 Arcos CF Arcos CF 37 48 96 18

  USO DE MEMORIA  
8,205,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6314
Total Execution Time  0.6327
  CADENA URL  
/historico/Algeciras-Cf/1981
  GET DATOS  
$_GET['/historico/Algeciras-Cf/1981']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0145  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 = 1981 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.0126  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.0128  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 total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=166 AND type_rel = 2
0.0145  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.0154  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.0158  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 = 1981 ORDER BY l.year DESC,cat.coefficient DESC
0.0155  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.0163  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 (1980,1981,1982) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (22233,21960,5476) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 5476 AND teamId = 166
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 22233 AND teamId = 166
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 21960 AND teamId = 166
0.0145  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 events1981 e ON e.player_id = p.id AND e.league_id = 21940 WHERE rp.league_id = 21940 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.0137  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 events1981 e ON e.player_id = p.id AND e.league_id = 21940 WHERE rp.league_id = 21940 AND rp.teamId = 166 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 events1981 e ON e.player_id = p.id AND e.league_id = 21940 WHERE rp.league_id = 21940 AND rp.teamId = 166 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 <= 1981 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0255  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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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
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 `tables1962` 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 = 21544 AND t.round = 30 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 `tables1961` 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 = 21529 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1960` 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 = 21516 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 `tables1959` 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 = 21503 AND t.round = 30 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 `tables1958` 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 = 21457 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC