4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1980/1981
SERIE A
Equipo PJ GF GC Puntos
1 Juventus Juventus 30 46 15 44
2 Roma Roma 30 43 20 42
3 Napoli Napoli 30 31 21 38
4 Inter Inter 30 41 24 36
5 Fiorentina Fiorentina 30 28 25 32
6 Cagliari Cagliari 30 29 30 30
7 Bologna Bologna 30 32 27 29
8 Catanzaro Catanzaro 30 24 27 29
9 Torino Torino 30 26 29 26
10 Avellino Avellino 30 36 33 25
11 Ascoli Ascoli 30 18 34 25
12 Udinese Udinese 30 24 39 25
13 Como Como 30 25 33 25
14 Brescia Brescia 30 19 25 25
15 Perugia Perugia 30 18 31 18
16 Pistoiese Pistoiese 30 19 46 16
TEMPORADA 1979/1980
SERIE A
Equipo PJ GF GC Puntos
1 Inter Inter 30 44 25 41
2 Juventus Juventus 30 42 25 38
3 Torino Torino 30 26 15 35
4 Ascoli Ascoli 30 35 28 34
5 Fiorentina Fiorentina 30 33 27 33
6 Roma Roma 30 34 35 32
7 Bologna Bologna 30 23 24 30
8 Cagliari Cagliari 30 27 29 30
9 Perugia Perugia 30 27 32 30
10 Napoli Napoli 30 20 20 28
11 Avellino Avellino 30 24 32 27
12 Catanzaro Catanzaro 30 20 34 24
13 Udinese Udinese 30 24 38 21
14 Pescara Pescara 30 18 44 16
15 Milan Milan 30 34 19 0
16 Lazio Lazio 30 21 25 0
TEMPORADA 1978/1979
SERIE A
Equipo PJ GF GC Puntos
1 Milan Milan 30 46 19 44
2 Perugia Perugia 30 34 16 41
3 Juventus Juventus 30 40 23 37
4 Inter Inter 30 38 24 36
5 Torino Torino 30 35 23 36
6 Napoli Napoli 30 23 21 32
7 Fiorentina Fiorentina 30 26 26 32
8 Lazio Lazio 30 35 40 29
9 Catanzaro Catanzaro 30 23 30 28
10 Ascoli Ascoli 30 26 31 26
11 Avellino Avellino 30 19 26 26
12 Roma Roma 30 24 32 26
13 Bologna Bologna 30 23 30 24
14 Vicenza Vicenza 30 29 42 24
15 Atalanta Atalanta 30 20 33 24
16 Hellas Verona Hellas 30 14 39 15
TEMPORADA 1977/1978
SERIE B
Equipo PJ GF GC Puntos
1 Ascoli Ascoli 38 73 30 87
2 Catanzaro Catanzaro 38 50 41 60
3 Avellino Avellino 38 34 29 59
4 AC Monza AC Monza 38 36 29 56
5 Ternana Calcio Ternana 38 34 27 56
6 Palermo FC Palermo FC 38 42 36 52
7 Lecce Lecce 38 27 26 51
8 Sampdoria Sampdoria 38 41 37 50
9 Cagliari Cagliari 38 52 47 49
10 Cesena Cesena 38 36 33 49
11 Sambenedettese Sambenedette 38 30 28 49
12 SSC Bari SSC Bari 38 38 42 49
13 Taranto Taranto 38 31 38 48
14 Pistoiese Pistoiese 38 33 40 46
15 Varese Varese 38 34 44 45
16 Brescia Brescia 38 35 40 44
17 Rimini Rimini 38 31 39 43
18 Cremonese Cremonese 38 34 38 42
19 Como Como 38 25 37 39
20 Modena Modena 38 24 59 26
TEMPORADA 1976/1977
SERIE B
Equipo PJ GF GC Puntos
1 Vicenza Vicenza 38 47 29 69
2 Atalanta Atalanta 38 44 26 68
3 Pescara Pescara 38 48 29 66
4 Cagliari Cagliari 38 45 32 66
5 AC Monza AC Monza 38 46 27 65
6 Como Como 38 35 27 53
7 Lecce Lecce 38 33 32 52
8 Varese Varese 38 41 37 50
9 Taranto Taranto 38 32 31 49
10 Ascoli Ascoli 38 41 43 49
11 Sambenedettese Sambenedette 38 27 31 46
12 Ternana Calcio Ternana 38 32 45 43
13 Rimini Rimini 38 25 27 42
14 Modena Modena 38 28 35 42
15 Avellino Avellino 38 27 37 42
16 Brescia Brescia 38 35 46 41
17 Palermo FC Palermo FC 38 29 41 41
18 SPAL SPAL 38 29 37 37
19 Catania Catania 38 26 44 37
20 Novara Novara 38 34 48 36
TEMPORADA 1975/1976
SERIE A
Equipo PJ GF GC Puntos
1 Torino Torino 30 49 22 45
2 Juventus Juventus 30 46 26 43
3 Milan Milan 30 42 28 38
4 Inter Inter 30 36 28 37
5 Napoli Napoli 30 40 27 36
6 Cesena Cesena 30 39 35 32
7 Bologna Bologna 30 32 32 32
8 Perugia Perugia 30 31 34 31
9 Fiorentina Fiorentina 30 39 39 27
10 Roma Roma 30 25 31 25
11 Hellas Verona Hellas 30 35 46 24
12 Sampdoria Sampdoria 30 21 32 24
13 Lazio Lazio 30 35 40 23
14 Ascoli Ascoli 30 19 34 23
15 Como Como 30 28 36 21
16 Cagliari Cagliari 30 25 52 19
TEMPORADA 1974/1975
SERIE A
Equipo PJ GF GC Puntos
1 Juventus Juventus 30 49 19 43
2 Napoli Napoli 30 50 22 41
3 Roma Roma 30 27 15 39
4 Lazio Lazio 30 34 28 37
5 Milan Milan 30 37 22 36
6 Torino Torino 30 40 30 35
7 Bologna Bologna 30 36 33 32
8 Fiorentina Fiorentina 30 31 27 31
9 Inter Inter 30 26 26 30
10 Cagliari Cagliari 30 22 30 26
11 Cesena Cesena 30 23 35 25
12 Ascoli Ascoli 30 14 27 24
13 Sampdoria Sampdoria 30 21 35 24
14 Vicenza Vicenza 30 19 34 21
15 Ternana Calcio Ternana 30 19 42 19
16 Varese Varese 30 19 42 17
TEMPORADA 1973/1974
SERIE B
Equipo PJ GF GC Puntos
1 Varese Varese 38 51 28 69
2 Ternana Calcio Ternana 38 46 20 68
3 Ascoli Ascoli 38 41 22 67
4 Como Como 38 37 27 61
5 Taranto Taranto 38 27 26 50
6 Novara Novara 38 33 34 50
7 Parma Parma 38 39 32 49
8 SS Arezzo SS Arezzo 38 42 41 49
9 SPAL SPAL 38 29 32 49
10 Palermo FC Palermo FC 38 35 42 48
11 Atalanta Atalanta 38 24 24 47
12 Brescia Brescia 38 35 36 46
13 Avellino Avellino 38 34 39 46
14 Catanzaro Catanzaro 38 31 37 46
15 Perugia Perugia 38 30 31 44
16 Reggina Reggina 38 20 34 44
17 Reggiana Reggiana 38 30 37 43
18 Brindisi Brindisi 38 27 37 42
19 SSC Bari SSC Bari 38 12 26 37
20 Catania Catania 38 21 39 31
TEMPORADA 1972/1973
SERIE B
Equipo PJ GF GC Puntos
1 Genoa Genoa 38 47 26 73
2 Ascoli Ascoli 38 45 31 68
3 Calcio Foggia Calcio 38 37 25 68
4 Cesena Cesena 38 36 21 66
5 Catania Catania 38 29 20 57
6 Varese Varese 38 30 26 55
7 Brindisi Brindisi 38 32 24 53
8 Catanzaro Catanzaro 38 38 27 51
9 Novara Novara 38 37 37 51
10 Reggiana Reggiana 38 31 31 48
11 Como Como 38 31 33 47
12 SSC Bari SSC Bari 38 29 33 46
13 Perugia Perugia 38 29 34 44
14 SS Arezzo SS Arezzo 38 24 29 43
15 Taranto Taranto 38 29 39 41
16 Mantova Mantova 38 19 32 39
17 AC Monza AC Monza 38 24 39 39
18 Brescia Brescia 38 26 37 38
19 Reggina Reggina 38 18 26 37
20 Lecco Lecco 38 19 40 30

  USO DE MEMORIA  
6,279,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1182
Total Execution Time  0.1194
  CADENA URL  
/historico/Ascoli/1981
  GET DATOS  
$_GET['/historico/Ascoli/1981']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0040  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 = 'Ascoli' 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.0019  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=290 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=290 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=290 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 5586
0.0024  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 = 59434
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=290 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 290 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (94809,112005,159579,158208,159350) ORDER BY n.cover_points DESC, update_date DESC
0.0029  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 = '290' AND l.year = 1981 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '290' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0018  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 = 59434 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 5586 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=290 AND l.year in (1980,1981,1982) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (59438,5587) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 5587 AND teamId = 290
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 59438 AND teamId = 290
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 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 = 5586 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '290' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '290' and rp.type = 4
0.0025  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 = '290' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '290' and rp.type = 4
0.0026  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 = 5586 WHERE rp.league_id = 5586 AND rp.teamId = 290 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.0026  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 = 5586 WHERE rp.league_id = 5586 AND rp.teamId = 290 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 5586 WHERE rp.league_id = 5586 AND rp.teamId = 290 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 290 AND l.year <= 1981 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 5586 AND t.round = 30 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 `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 = 5585 AND t.round = 30 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 `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 = 5584 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 `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 = 30850 AND t.round = 38 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 `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 = 30849 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 `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 = 5581 AND t.round = 30 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 `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 = 5580 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 `tables1974` 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 = 30846 AND t.round = 38 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 `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 = 30845 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 5586 ORDER BY nameShow LIMIT 100