4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Serie B 1974

La temporada finalizó el Domingo, 16 Junio 1974.
 
20 Ene 74
Finalizado
Perugia Perugia 1-2 Como Como más información Jugadas destacadas ...
0-1 35' Doriano Pozzato
67' Riccardo Innocenti 1-1
1-2 86' Giancarlo Savoia
 
20 Ene 74
Finalizado
Catania Catania 0-0 Taranto Taranto más información ...
 
20 Ene 74
Finalizado
Avellino Avellino 3-0 Reggina Reggina más información Jugadas destacadas ...
22' Giovanni Roccotelli 1-0
54' Luciano Poppi
67' Costantino Fava 3-0
 
20 Ene 74
Finalizado
Varese Varese 2-0 Novara Novara más información Jugadas destacadas ...
63' Giorgio Valmassoi 1-0
67' Antonio Veschetti
70' Franco Carrera
86' Enrico Prato 2-0
 
20 Ene 74
Finalizado
Parma Parma 1-1 Atalanta Atalanta más información Jugadas destacadas ...
0-1 11' Emanuele Gattelli
65' Alberto Rizzati 1-1
 
20 Ene 74
Finalizado
Brindisi Brindisi 1-1 Ternana Calcio Ternana Calcio más información Jugadas destacadas ...
4' Bruno Del Pelo 1-0
1-1 81' Andrea Prunecchi
 
20 Ene 74
Finalizado
Ascoli Ascoli 1-0 Reggiana Reggiana más información Jugadas destacadas ...
73' Massimo Silva 1-0
 
20 Ene 74
Finalizado
SPAL SPAL 1-1 SS Arezzo SS Arezzo más información Jugadas destacadas ...
24' Franco Pezzato 1-0
1-1 32' Mario Fara
 
20 Ene 74
Finalizado
Catanzaro Catanzaro 1-1 Palermo FC Palermo FC más información Jugadas destacadas ...
43' Sergio Zuccheri 1-0
1-1 85' Giacomo La Rosa
 
20 Ene 74
Finalizado
SSC Bari SSC Bari 1-0 Brescia Brescia más información Jugadas destacadas ...
13' Antonio D'angelo 1-0
Equipos Puntos J. G. E. P. F. C. Forma
1 Ascoli Ascoli 32 17 8 8 1 19 9
  • EMPATE
  • SS Arezzo 0
  • Ascoli 0
  • DERROTA
  • Taranto 1
  • Ascoli 0
  • VICTORIA
  • Ascoli 1
  • Catanzaro 0
  • VICTORIA
  • Brescia 0
  • Ascoli 1
  • VICTORIA
  • Ascoli 1
  • Reggiana 0
2 Varese Varese 30 17 8 6 3 24 13
  • EMPATE
  • Varese 1
  • Ternana Calcio 1
  • DERROTA
  • Palermo FC 1
  • Varese 0
  • EMPATE
  • SS Arezzo 1
  • Varese 1
  • VICTORIA
  • Varese 2
  • Parma 1
  • VICTORIA
  • Varese 2
  • Novara 0
3 Como Como 28 17 7 7 3 12 8
  • EMPATE
  • SSC Bari 0
  • Como 0
  • VICTORIA
  • Como 1
  • SS Arezzo 0
  • VICTORIA
  • Como 1
  • Brescia 0
  • DERROTA
  • Ternana Calcio 1
  • Como 0
  • VICTORIA
  • Perugia 1
  • Como 2
4 Avellino Avellino 26 17 6 8 3 18 13
  • EMPATE
  • Reggiana 1
  • Avellino 1
  • DERROTA
  • Perugia 1
  • Avellino 0
  • VICTORIA
  • Avellino 1
  • Ternana Calcio 0
  • VICTORIA
  • Avellino 3
  • Reggina 0
  • EMPATE
  • Novara 0
  • Avellino 0
5 Ternana Calcio Ternana Calcio 25 17 6 7 4 18 9
  • EMPATE
  • Varese 1
  • Ternana Calcio 1
  • DERROTA
  • Ternana Calcio 0
  • SPAL 1
  • DERROTA
  • Avellino 1
  • Ternana Calcio 0
  • VICTORIA
  • Ternana Calcio 1
  • Como 0
  • EMPATE
  • Brindisi 1
  • Ternana Calcio 1
6 Parma Parma 24 17 5 9 3 21 12
  • EMPATE
  • Palermo FC 0
  • Parma 0
  • VICTORIA
  • Parma 4
  • Catanzaro 0
  • EMPATE
  • SSC Bari 0
  • Parma 0
  • DERROTA
  • Varese 2
  • Parma 1
  • EMPATE
  • Parma 1
  • Atalanta 1
7 Novara Novara 24 17 5 9 3 13 12
  • VICTORIA
  • Novara 2
  • Perugia 1
  • VICTORIA
  • Novara 2
  • SSC Bari 0
  • EMPATE
  • Reggina 1
  • Novara 1
  • DERROTA
  • Varese 2
  • Novara 0
  • EMPATE
  • Novara 0
  • Avellino 0
8 Brindisi Brindisi 24 17 6 6 5 16 16
  • EMPATE
  • Brindisi 0
  • Brescia 0
  • EMPATE
  • Atalanta 0
  • Brindisi 0
  • DERROTA
  • Brindisi 0
  • Taranto 1
  • DERROTA
  • SS Arezzo 1
  • Brindisi 0
  • EMPATE
  • Brindisi 1
  • Ternana Calcio 1
9 SPAL SPAL 24 17 5 9 3 11 12
  • VICTORIA
  • SPAL 1
  • Reggina 0
  • VICTORIA
  • Ternana Calcio 0
  • SPAL 1
  • VICTORIA
  • SPAL 1
  • Perugia 0
  • EMPATE
  • Atalanta 0
  • SPAL 0
  • EMPATE
  • SPAL 1
  • SS Arezzo 1
10 Taranto Taranto 23 17 5 8 4 10 9
  • DERROTA
  • Catanzaro 1
  • Taranto 0
  • VICTORIA
  • Taranto 1
  • Ascoli 0
  • VICTORIA
  • Brindisi 0
  • Taranto 1
  • VICTORIA
  • Taranto 2
  • Reggina 0
  • EMPATE
  • Catania 0
  • Taranto 0
11 Catania Catania 22 17 4 10 3 13 14
  • VICTORIA
  • Catania 1
  • Atalanta 0
  • EMPATE
  • Brescia 0
  • Catania 0
  • EMPATE
  • Catania 1
  • Palermo FC 1
  • VICTORIA
  • Catanzaro 0
  • Catania 1
  • EMPATE
  • Catania 0
  • Taranto 0
12 SS Arezzo SS Arezzo 21 17 6 3 8 20 22
  • EMPATE
  • SS Arezzo 0
  • Ascoli 0
  • DERROTA
  • Como 1
  • SS Arezzo 0
  • EMPATE
  • SS Arezzo 1
  • Varese 1
  • VICTORIA
  • SS Arezzo 1
  • Brindisi 0
  • EMPATE
  • SPAL 1
  • SS Arezzo 1
13 Palermo FC Palermo FC 21 17 4 9 4 14 20
  • EMPATE
  • Palermo FC 0
  • Parma 0
  • VICTORIA
  • Palermo FC 1
  • Varese 0
  • EMPATE
  • Catania 1
  • Palermo FC 1
  • VICTORIA
  • Palermo FC 1
  • Perugia 0
  • EMPATE
  • Catanzaro 1
  • Palermo FC 1
14 Reggiana Reggiana 19 17 4 7 6 13 17
  • EMPATE
  • Reggiana 1
  • Avellino 1
  • EMPATE
  • Reggina 1
  • Reggiana 1
  • VICTORIA
  • Reggiana 1
  • Atalanta 0
  • VICTORIA
  • Reggiana 1
  • SSC Bari 0
  • DERROTA
  • Ascoli 1
  • Reggiana 0
15 Atalanta Atalanta 18 17 3 9 5 6 8
  • DERROTA
  • Catania 1
  • Atalanta 0
  • EMPATE
  • Atalanta 0
  • Brindisi 0
  • DERROTA
  • Reggiana 1
  • Atalanta 0
  • EMPATE
  • Atalanta 0
  • SPAL 0
  • EMPATE
  • Parma 1
  • Atalanta 1
16 Brescia Brescia 17 17 3 8 6 14 17
  • EMPATE
  • Brindisi 0
  • Brescia 0
  • EMPATE
  • Brescia 0
  • Catania 0
  • DERROTA
  • Como 1
  • Brescia 0
  • DERROTA
  • Brescia 0
  • Ascoli 1
  • DERROTA
  • SSC Bari 1
  • Brescia 0
17 Catanzaro Catanzaro 17 17 4 5 8 10 16
  • VICTORIA
  • Catanzaro 1
  • Taranto 0
  • DERROTA
  • Parma 4
  • Catanzaro 0
  • DERROTA
  • Ascoli 1
  • Catanzaro 0
  • DERROTA
  • Catanzaro 0
  • Catania 1
  • EMPATE
  • Catanzaro 1
  • Palermo FC 1
18 Reggina Reggina 17 17 3 8 6 8 15
  • DERROTA
  • SPAL 1
  • Reggina 0
  • EMPATE
  • Reggina 1
  • Reggiana 1
  • EMPATE
  • Reggina 1
  • Novara 1
  • DERROTA
  • Taranto 2
  • Reggina 0
  • DERROTA
  • Avellino 3
  • Reggina 0
19 Perugia Perugia 15 17 3 6 8 10 16
  • DERROTA
  • Novara 2
  • Perugia 1
  • VICTORIA
  • Perugia 1
  • Avellino 0
  • DERROTA
  • SPAL 1
  • Perugia 0
  • DERROTA
  • Palermo FC 1
  • Perugia 0
  • DERROTA
  • Perugia 1
  • Como 2
20 SSC Bari SSC Bari 10 17 2 4 11 2 14
  • EMPATE
  • SSC Bari 0
  • Como 0
  • DERROTA
  • Novara 2
  • SSC Bari 0
  • EMPATE
  • SSC Bari 0
  • Parma 0
  • DERROTA
  • Reggiana 1
  • SSC Bari 0
  • VICTORIA
  • SSC Bari 1
  • Brescia 0

Esta división se compone de 22 clubes, donde juegan todos contra todos. Al final, el que obtenga más puntos, será el nuevo campeón de la competencia y puede acceder a disputar la Serie A, Italiana. También asciende el sublíder, pero desde el tercer al sexto lugar se juega el repechaje, para ver quién es el tercer club que consigue dicho ascenso.

Los 3 últimos descienden a la Serie C1, pero los equipos que están por delante de los ya descendidos (que son dos clubes), juegan una repesca para definir su continuidad en esta Serie.

  USO DE MEMORIA  
5,903,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0901
Total Execution Time  0.0921
  CADENA URL  
/serie_b1974/grupo1/jornada17
  GET DATOS  
$_GET['/serie_b1974/grupo1/jornada17']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89 AND type_rel = 3
0.0033  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 89 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  SELECT /*53 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 (1311583,1309107,1308896,1307681,1306185) ORDER BY n.cover_points DESC, update_date DESC
0.0038  SELECT text_es as historical_text FROM leagues_text WHERE id=2590
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 30846 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 16:55:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 16:55:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 16:55:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 16:55:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=30846 AND rel.round=17
0.0026  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars1974` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 30846 AND c.`round` = 17 ORDER BY shedule ASC LIMIT 200
0.0035  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events1974 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1974 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 30846 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (12416,12415,12414,12413,12412,12411,12410,12409,12408,12407) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0065  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1974` e INNER JOIN calendars1974 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 17 AND e.real_date IS NOT NULL AND e.league_id = 30846 ORDER BY total DESC LIMIT 40
0.0041  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 = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0051  SELECT *,(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 = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT data1, data2 FROM services_tags WHERE categoryId=89
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=89 AND year=1974