4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sevilla At.

Sevilla At.

Entrenador: Jesús Galván

Temporada 1979/1980
TEMPORADA 1979/1980
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Linares CF Linares CF 38 47 32 48
2 AgD Ceuta AgD Ceuta 38 61 44 47
3 RC Portuense Portuense 38 42 35 46
4 Puertollano Puertollano 38 55 34 45
5 Terrassa FC Terrassa FC 38 44 38 44
6 Lleida Lleida 38 40 35 43
7 Córdoba CF Córdoba CF 38 47 38 41
8 CD San Fernando Fernando 38 43 37 40
9 Eldense Eldense 38 49 47 39
10 CD Badajoz CD Badajoz 38 45 50 39
11 UD Vall de Uxó Vall Uxó 38 44 46 38
12 Real Jaén Real Jaén 38 41 34 37
13 Xerez CD Xerez CD 38 43 49 37
14 Barça Atlètic Barça 38 36 35 36
15 SD Ibiza SD Ibiza 38 31 35 35
16 Diter Zafra Diter Zafra 38 41 48 32
17 UE Sant Andreu Sant Andreu 38 39 45 32
18 Sevilla At. Sevilla At. 38 44 49 32
19 Girona Girona 38 40 64 28
20 Ontinyent CF Ontinyent 38 27 64 21
TEMPORADA 1978/1979
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Levante Levante 38 80 20 55
2 AgD Ceuta AgD Ceuta 38 61 37 52
3 Gimnàstic Tarragona Gimnàstic 38 42 22 52
4 Barça Atlètic Barça 38 68 42 49
5 Puertollano Puertollano 38 57 38 49
6 Sevilla At. Sevilla At. 38 48 39 42
7 Xerez CD Xerez CD 38 48 41 41
8 UE Sant Andreu Sant Andreu 38 45 45 40
9 Linares CF Linares CF 38 36 46 40
10 Ontinyent CF Ontinyent 38 57 56 39
11 Lleida Lleida 38 56 45 37
12 Diter Zafra Diter Zafra 38 39 40 33
13 Girona Girona 38 52 58 33
14 SD Ibiza SD Ibiza 38 37 50 32
15 RC Portuense Portuense 38 38 53 32
16 CD Badajoz CD Badajoz 38 42 53 31
17 Córdoba CF Córdoba CF 38 41 53 31
18 CP Cacereño Cacereño 38 39 58 30
19 Vinaròs Vinaròs 38 53 73 30
20 Olimpic Xátiva Olimpic 38 39 109 12
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 1972/1973
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Linares CF Linares CF 38 67 29 50
2 Cartagena F.C. UCAM Cartagena 38 61 26 49
3 CD Badajoz CD Badajoz 38 52 35 45
4 Valdepeñas Valdepeñas 38 39 34 40
5 Xerez CD Xerez CD 38 48 46 40
6 Melilla CF Melilla CF 38 46 49 40
7 Recreativo Recreativo 38 36 28 40
8 Real Jaén Real Jaén 38 42 41 40
9 AD Almería AD Almería 38 57 55 39
10 RC Portuense Portuense 38 43 43 39
11 Hellin Deportivo Hellin 38 48 49 39
12 AgD Ceuta AgD Ceuta 38 49 44 38
13 CD San Fernando Fernando 38 46 49 37
14 O Donnell O Donnell 38 42 59 36
15 Eldense Eldense 38 37 41 34
16 RB Linense RB Linense 38 26 47 34
17 Racing D´ Algemesí Racing 38 41 55 33
18 CF Extremadura Extremadura 38 46 52 33
19 At. Malagueño Malagueño 38 31 48 28
20 Sevilla At. Sevilla At. 38 28 55 26
TEMPORADA 1971/1972
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Real Murcia Real Murcia 38 77 26 62
2 Cartagena F.C. UCAM Cartagena 38 90 32 59
3 Real Jaén Real Jaén 38 52 40 41
4 Valdepeñas Valdepeñas 38 66 59 41
5 Melilla CF Melilla CF 38 50 41 40
6 RB Linense RB Linense 38 50 45 39
7 RC Portuense Portuense 38 41 37 39
8 CD Badajoz CD Badajoz 38 53 51 38
9 AgD Ceuta AgD Ceuta 38 49 47 38
10 Eldense Eldense 38 43 46 38
11 At. Malagueño Malagueño 38 46 43 37
12 Sevilla At. Sevilla At. 38 43 54 37
13 Recreativo Recreativo 38 47 41 37
14 CP Cacereño Cacereño 38 55 54 36
15 Olimpic Xátiva Olimpic 38 44 50 35
16 Linares CF Linares CF 38 34 46 35
17 Betis Deportivo Betis 38 39 46 34
18 Ilicitano Ilicitano 38 33 65 28
19 FC Jove Español Jove 38 42 74 26
20 UA. Ceutí UA. Ceutí 38 32 89 20
TEMPORADA 1970/1971
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 38 50 24 55
2 Recreativo Recreativo 38 58 32 52
3 Cartagena F.C. UCAM Cartagena 38 63 25 49
4 RC Portuense Portuense 38 41 37 44
5 Sevilla At. Sevilla At. 38 54 47 44
6 AgD Ceuta AgD Ceuta 38 55 41 43
7 Real Jaén Real Jaén 38 45 31 42
8 Betis Deportivo Betis 38 42 41 40
9 Real Murcia Real Murcia 38 47 39 39
10 FC Jove Español Jove 38 52 42 38
11 Valdepeñas Valdepeñas 38 47 35 38
12 CD Badajoz CD Badajoz 38 46 50 37
13 Ilicitano Ilicitano 38 41 56 37
14 At. Malagueño Malagueño 38 40 44 36
15 Melilla CF Melilla CF 38 37 39 34
16 RB Linense RB Linense 38 31 46 33
17 Mérida CP Mérida CP 38 42 54 31
18 Real Murcia Imperial Real Murcia 38 29 50 25
19 Recreativo Granada Recreativo 38 34 65 25
20 AD Llerenense Llerenense 38 28 84 18
TEMPORADA 1969/1970
TERCERA DIVISIÓN GRUPO 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 11
Equipo PJ GF GC Puntos
1 RC Portuense Portuense 30 73 22 52
2 Sevilla At. Sevilla At. 30 74 17 50
3 Jerez Industrial CF Jerez 30 78 25 49
4 Betis Deportivo Betis 30 58 34 38
5 CD San Fernando Fernando 30 66 32 37
6 CD Alcalá CD Alcalá 30 52 30 36
7 Balón de Cádiz CF Balón 30 48 36 33
8 At. Sanluqueño Sanluqueño 30 45 34 32
9 Ayamonte Ayamonte 30 42 40 29
10 CD Rota CD Rota 30 33 37 28
11 AD. Carmona AD. Carmona 30 38 70 24
12 Coria CF Coria CF 30 26 57 18
13 Riotinto Balompié Riotinto 30 29 73 16
14 Utrera Utrera 30 34 72 15
15 La Palma CF La Palma CF 30 27 78 12
16 Atl. Onubense Atl. 30 18 84 11
TEMPORADA 1966/1967
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 30 63 26 49
2 Jerez Industrial CF Jerez 30 77 21 48
3 Sevilla At. Sevilla At. 30 70 26 44
4 RC Portuense Portuense 30 39 24 38
5 Atl. Onubense Atl. 30 39 32 35
6 Betis Deportivo Betis 30 50 30 33
7 CD San Fernando Fernando 30 56 44 30
8 At. Sanluqueño Sanluqueño 30 37 40 29
9 Ayamonte Ayamonte 30 30 36 27
10 Coria CF Coria CF 30 29 38 24
11 Riotinto Balompié Riotinto 30 28 55 23
12 Balón de Cádiz CF Balón 30 39 46 23
13 CD Alcalá CD Alcalá 30 33 52 22
14 CD Rota CD Rota 30 24 51 19
15 Utrera Utrera 30 25 69 18
16 San Roque de Lepe Roque Lepe 30 18 67 18
TEMPORADA 1965/1966
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Jerez Industrial CF Jerez 30 65 21 49
2 Xerez CD Xerez CD 30 63 18 46
3 Sevilla At. Sevilla At. 30 75 27 46
4 CD San Fernando Fernando 30 60 35 38
5 Atlético Onubense Atlético 30 36 26 33
6 Betis Deportivo Betis 30 37 39 30
7 RC Portuense Portuense 30 46 40 29
8 Utrera Utrera 30 45 54 28
9 Ayamonte Ayamonte 30 26 36 25
10 At. Sanluqueño Sanluqueño 30 36 47 25
11 Coria CF Coria CF 30 40 65 24
12 CD Alcalá CD Alcalá 29 35 44 24
13 Riotinto Balompié Riotinto 29 36 59 24
14 Balón de Cádiz CF Balón 30 26 48 22
15 Puerto Real CF Puerto Real 30 31 67 18
16 Chiclana CF Chiclana CF 28 28 59 15
TEMPORADA 1964/1965
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 28 65 16 45
2 RB Linense RB Linense 28 64 26 44
3 Jerez Industrial CF Jerez 28 65 22 42
4 RC Portuense Portuense 28 49 31 37
5 Sevilla At. Sevilla At. 28 62 38 36
6 Atlético Onubense Atlético 28 47 27 34
7 Betis Deportivo Betis 28 49 28 33
8 CD San Fernando Fernando 28 53 57 21
9 Balón de Cádiz CF Balón 28 38 55 21
10 Puerto Real CF Puerto Real 28 38 63 20
11 Coria CF Coria CF 28 33 65 19
12 Utrera Utrera 28 33 61 19
13 Riotinto Balompié Riotinto 28 26 65 18
14 Ayamonte Ayamonte 28 30 53 16
15 Chiclana CF Chiclana CF 28 35 80 15
16 Écija Balompié Écija 0 0 0 0
TEMPORADA 1963/1964
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Jerez Industrial CF Jerez 30 64 29 45
2 Xerez CD Xerez CD 30 73 22 44
3 RB Linense RB Linense 30 58 26 43
4 RC Portuense Portuense 30 59 23 42
5 Riotinto Balompié Riotinto 30 55 30 41
6 Ayamonte Ayamonte 30 41 46 34
7 Sevilla At. Sevilla At. 30 62 42 31
8 Balón de Cádiz CF Balón 30 45 49 29
9 Écija Balompié Écija 30 45 59 27
10 Puerto Real CF Puerto Real 30 36 43 27
11 Chiclana CF Chiclana CF 30 39 46 26
12 Utrera Utrera 30 48 45 26
13 Coria CF Coria CF 30 29 61 17
14 La Palma La Palma 30 35 77 17
15 Barbate Barbate 30 24 70 16
16 Cañamera Cañamera 30 24 69 15
TEMPORADA 1962/1963
SEGUNDA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Murcia Real Murcia 30 40 20 42
2 Levante Levante 30 61 34 41
3 Las Palmas Las Palmas 30 45 32 38
4 Cádiz Cádiz 30 49 46 37
5 Recreativo Recreativo 30 40 26 32
6 Granada Granada 30 38 29 30
7 Hércules Hércules 30 51 42 29
8 Tenerife Tenerife 30 42 34 29
9 Valencia Mestalla Valencia 30 50 55 29
10 Eldense Eldense 30 51 58 29
11 Melilla CF Melilla CF 30 36 42 27
12 CD San Fernando Fernando 30 33 58 27
13 Cartagena F.C. UCAM Cartagena 30 40 53 26
14 Real Jaén Real Jaén 30 35 41 25
15 Sevilla At. Sevilla At. 30 34 54 22
16 AD Plus Ultra Plus Ultra 30 29 50 17
TEMPORADA 1961/1962
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Sevilla At. Sevilla At. 30 102 21 50
2 Xerez CD Xerez CD 30 69 17 48
3 Jerez Industrial CF Jerez 30 74 32 48
4 Utrera Utrera 30 60 40 39
5 Balón de Cádiz CF Balón 30 51 43 30
6 Riotinto Balompié Riotinto 30 46 47 30
7 Puerto Real CF Puerto Real 30 39 49 28
8 Ol. Valverdeña Valverdeña 30 45 53 28
9 RC Portuense Portuense 30 42 48 28
10 La Palma La Palma 30 37 47 28
11 Ayamonte Ayamonte 30 47 50 26
12 Imperio Riffien Imperio 30 36 54 24
13 Coria CF Coria CF 30 46 59 23
14 Barbate Barbate 30 27 69 22
15 Bollullos CF Bollullos 30 29 75 15
16 Imperio Ceuta Imperio 30 38 84 13
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 12
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 30 73 25 46
2 Sevilla At. Sevilla At. 30 54 27 41
3 RC Portuense Portuense 30 76 36 37
4 Ayamonte Ayamonte 30 50 39 36
5 La Palma La Palma 30 60 43 35
6 At. Sanluqueño Sanluqueño 30 45 41 33
7 Puerto Real CF Puerto Real 30 53 44 33
8 Jerez Industrial CF Jerez 30 63 41 32
9 Bollullos CF Bollullos 30 43 43 31
10 Ol. Valverdeña Valverdeña 30 61 69 28
11 Lebrijana Lebrijana 30 42 60 26
12 Imperio Riffien Imperio 30 54 71 24
13 Utrera Utrera 30 46 63 23
14 Barbate Barbate 30 52 81 20
15 Atletico Victoria Atletico 30 36 80 19
16 Moron Moron 30 31 76 16

  USO DE MEMORIA  
7,860,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.2022
Total Execution Time  0.2035
  CADENA URL  
/historico/Sevilla-B/1980
  GET DATOS  
$_GET['/historico/Sevilla-B/1980']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0044  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 = 'Sevilla-B' AND l.year = 1980 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.0021  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=2311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=2311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=2311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0045  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 = 22231
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2311 AND type_rel = 2
0.0067  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2311 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0034  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,6752,7337) ORDER BY n.cover_points DESC, update_date DESC
0.0074  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 = '2311' AND l.year = 1980 ORDER BY l.year DESC,cat.coefficient DESC
0.0062  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 = '2311' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0030  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 = 22231 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0100  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=2311 AND l.year in (1979,1980,1981) ORDER BY l.id DESC, l.year DESC ;
0.0032  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 (22231,21961,21678) 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.0046  SELECT count(id) as num_players from rel_players WHERE league_id = 22231 AND teamId = 2311
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 21678 AND teamId = 2311
0.0058  SELECT count(id) as num_players from rel_players WHERE league_id = 21961 AND teamId = 2311
0.0033  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 = '2311' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2311' and rp.type = 4
0.0028  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 = '2311' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2311' and rp.type = 4
0.0050  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 events1980 e ON e.player_id = p.id AND e.league_id = 21960 WHERE rp.league_id = 21960 AND rp.teamId = 2311 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.0045  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 events1980 e ON e.player_id = p.id AND e.league_id = 21960 WHERE rp.league_id = 21960 AND rp.teamId = 2311 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 events1980 e ON e.player_id = p.id AND e.league_id = 21960 WHERE rp.league_id = 21960 AND rp.teamId = 2311 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 2311 AND l.year <= 1980 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0029  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 = 22231 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 `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 = 22230 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 `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.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 `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.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 `tables1973` 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 = 21635 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 `tables1972` 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 = 21632 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1971` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21629 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `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.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 `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.0022  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 = 21609 AND t.round = 30 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 `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 = 22206 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 21596 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 21583 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 21570 AND t.round = 30 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 `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 = 11713 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 21545 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.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 `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 = 21517 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC