4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1974/1975
SERIE B
Equipo PJ GF GC Puntos
1 Perugia Perugia 38 44 27 66
2 Como Como 38 40 23 64
3 Hellas Verona Hellas 38 39 30 61
4 Catanzaro Catanzaro 38 27 18 58
5 Palermo FC Palermo FC 38 31 25 56
6 Atalanta Atalanta 38 37 36 53
7 Genoa Genoa 38 31 33 52
8 Sambenedettese Sambenedette 38 36 43 49
9 SPAL SPAL 38 38 42 48
10 Calcio Foggia Calcio 38 31 35 48
11 Brescia Brescia 38 24 28 47
12 Brindisi Brindisi 38 32 38 46
13 Avellino Avellino 38 33 29 45
14 Pescara Pescara 38 37 38 45
15 Novara Novara 38 30 33 45
16 Taranto Taranto 38 24 34 45
17 US Alessandria Alessandria 38 35 38 43
18 Reggiana Reggiana 38 33 36 43
19 Parma Parma 38 30 37 42
20 SS Arezzo SS Arezzo 38 35 44 42
TEMPORADA 1962/1963
SERIE B
Equipo PJ GF GC Puntos
1 ACR Messina ACR Messina 38 50 31 68
2 Lazio Lazio 38 50 31 66
3 SSC Bari SSC Bari 38 47 26 63
4 Brescia Brescia 38 40 27 60
5 Calcio Foggia Calcio 38 56 42 59
6 Lecco Lecco 38 45 36 56
7 Hellas Verona Hellas 38 41 34 56
8 Padova Padova 38 45 47 54
9 AC Monza AC Monza 38 56 52 52
10 Cagliari Cagliari 38 41 40 50
11 Pro Patria Pro Patria 38 36 33 49
12 Catanzaro Catanzaro 38 34 43 49
13 Parma Parma 38 32 44 47
14 US Alessandria Alessandria 38 32 34 45
15 Udinese Udinese 38 49 48 44
16 Triestina Triestina 38 49 59 44
17 Cosenza Calcio Cosenza 38 27 37 42
18 Como Como 38 38 51 40
19 Sambenedettese Sambenedette 38 29 51 38
20 Lucchese Libertas Lucchese 38 36 67 28
TEMPORADA 1961/1962
SERIE B
Equipo PJ GF GC Puntos
1 Genoa Genoa 38 64 28 76
2 Napoli Napoli 38 44 35 58
3 Modena Modena 38 39 36 58
4 Lazio Lazio 38 50 28 56
5 Hellas Verona Hellas 38 39 27 56
6 SSC Bari SSC Bari 38 48 38 56
7 Pro Patria Pro Patria 38 43 38 56
8 ACR Messina ACR Messina 38 53 46 53
9 Brescia Brescia 38 37 36 51
10 AC Monza AC Monza 38 37 44 50
11 US Alessandria Alessandria 38 45 46 49
12 Novara Novara 38 37 43 48
13 Lucchese Libertas Lucchese 38 46 54 47
14 Sambenedettese Sambenedette 38 30 42 45
15 Como Como 38 33 46 45
16 Parma Parma 38 25 33 44
17 Cosenza Calcio Cosenza 38 29 46 44
18 Catanzaro Catanzaro 38 37 50 43
19 Prato Prato 38 33 47 41
20 Reggiana Reggiana 38 34 40 40
TEMPORADA 1960/1961
SERIE B
Equipo PJ GF GC Puntos
1 Venezia Venezia 38 54 31 72
2 Mantova Mantova 38 44 25 67
3 Palermo FC Palermo FC 38 46 27 59
4 Reggiana Reggiana 38 63 55 59
5 AC Monza AC Monza 38 36 26 56
6 Genoa Genoa 38 47 42 56
7 ACR Messina ACR Messina 38 45 34 54
8 US Alessandria Alessandria 38 43 41 54
9 Sambenedettese Sambenedette 38 35 42 54
10 Pro Patria Pro Patria 38 46 39 53
11 Catanzaro Catanzaro 38 46 42 53
12 Prato Prato 38 35 41 51
13 Como Como 38 42 45 50
14 Parma Parma 38 36 36 47
15 Brescia Brescia 38 44 38 46
16 Hellas Verona Hellas 38 31 44 45
17 Novara Novara 38 31 51 44
18 Triestina Triestina 38 31 39 42
19 Calcio Foggia Calcio 38 40 56 39
20 AC Marzotto AC Marzotto 38 28 69 25
TEMPORADA 1959/1960
SERIE B
Equipo PJ GF GC Puntos
1 Lecco Lecco 38 51 28 67
2 Torino Torino 38 44 21 67
3 Catania Catania 38 55 38 61
4 Triestina Triestina 38 49 32 61
5 Mantova Mantova 38 42 38 54
6 Reggiana Reggiana 38 51 50 53
7 ACR Messina ACR Messina 38 35 38 52
8 Como Como 38 51 48 51
9 Hellas Verona Hellas 38 49 45 49
10 AC Marzotto AC Marzotto 38 37 40 49
11 Brescia Brescia 38 35 38 49
12 Catanzaro Catanzaro 38 41 40 48
13 Novara Novara 38 38 40 48
14 Sambenedettese Sambenedette 38 38 47 45
15 Taranto Taranto 38 33 48 45
16 AC Monza AC Monza 38 46 53 44
17 Parma Parma 38 38 50 43
18 Venezia Venezia 38 34 42 42
19 Modena Modena 38 38 51 41
20 Cagliari Cagliari 38 36 54 39
TEMPORADA 1958/1959
SERIE B
Equipo PJ GF GC Puntos
1 Atalanta Atalanta 38 62 30 69
2 Palermo FC Palermo FC 38 52 28 67
3 Lecco Lecco 38 50 42 61
4 Reggiana Reggiana 38 45 36 60
5 Hellas Verona Hellas 38 54 43 58
6 Cagliari Cagliari 38 48 48 58
7 Como Como 38 47 42 56
8 AC Monza AC Monza 38 42 33 54
9 Venezia Venezia 38 45 41 53
10 Novara Novara 38 45 48 52
11 ACR Messina ACR Messina 38 49 42 50
12 Taranto Taranto 38 37 41 48
13 Brescia Brescia 38 47 46 46
14 AC Marzotto AC Marzotto 38 26 36 46
15 Modena Modena 38 34 45 44
16 Catania Catania 38 37 42 42
17 Parma Parma 38 41 64 42
18 Sambenedettese Sambenedette 38 32 44 39
19 Vigevano Calcio Vigevano 38 30 49 37
20 Prato Prato 38 31 54 33
TEMPORADA 1957/1958
SERIE B
Equipo PJ GF GC Puntos
1 Triestina Triestina 34 64 29 67
2 SSC Bari SSC Bari 34 47 28 62
3 Venezia Venezia 34 42 30 57
4 AC Marzotto AC Marzotto 34 50 40 55
5 AC Monza AC Monza 34 47 39 54
6 Brescia Brescia 34 46 36 49
7 Palermo FC Palermo FC 34 36 35 49
8 Modena Modena 34 50 46 47
9 Como Como 34 30 23 46
10 Prato Prato 34 34 40 46
11 Taranto Taranto 34 25 31 40
12 Novara Novara 34 42 39 39
13 Catania Catania 34 29 36 38
14 Lecco Lecco 34 28 44 37
15 Sambenedettese Sambenedette 34 25 44 36
16 ACR Messina ACR Messina 34 23 41 35
17 Cagliari Cagliari 34 31 44 34
18 Parma Parma 34 25 49 29
TEMPORADA 1956/1957
SERIE B
Equipo PJ GF GC Puntos
1 Brescia Brescia 34 42 29 62
2 Hellas Verona Hellas 34 46 29 61
3 Catania Catania 34 53 31 60
4 US Alessandria Alessandria 34 57 36 60
5 Venezia Venezia 34 46 27 56
6 Como Como 34 37 38 49
7 AC Monza AC Monza 34 44 44 48
8 Novara Novara 34 39 38 47
9 SSC Bari SSC Bari 34 31 41 44
10 AC Marzotto AC Marzotto 34 38 40 43
11 Cagliari Cagliari 34 30 34 43
12 Modena Modena 34 32 37 42
13 Parma Parma 34 33 38 40
14 ACR Messina ACR Messina 34 28 35 38
15 Taranto Taranto 34 35 47 38
16 Sambenedettese Sambenedette 34 32 45 37
17 Pro Patria Pro Patria 34 35 49 32
18 AC Legnano AC Legnano 34 31 51 30

  USO DE MEMORIA  
6,139,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5315
Total Execution Time  0.5328
  CADENA URL  
/historico/Ss-Sambenedettese-Calcio/1975
  GET DATOS  
$_GET['/historico/Ss-Sambenedettese-Calcio/1975']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0163  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 = 'Ss-Sambenedettese-Calcio' AND l.year = 1975 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.0150  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=2408 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=2408 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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=2408 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0309  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 = 30847
0.0173  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 = 59454
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2408 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2408 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  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 (468433,648783,797663,870260,871850) ORDER BY n.cover_points DESC, update_date DESC
0.0164  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 = '2408' AND l.year = 1975 ORDER BY l.year DESC,cat.coefficient DESC
0.0179  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 = '2408' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0157  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 = 59454 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158  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 = 30847 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0175  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=2408 AND l.year in (1974,1975,1976) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (59470,30848) 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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 30848 AND teamId = 2408
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 59470 AND teamId = 2408
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 30847 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0152  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 events1975 e ON e.player_id = p.id AND e.league_id = 30847 WHERE rp.league_id = 30847 AND rp.teamId = 2408 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.0149  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 events1975 e ON e.player_id = p.id AND e.league_id = 30847 WHERE rp.league_id = 30847 AND rp.teamId = 2408 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 events1975 e ON e.player_id = p.id AND e.league_id = 30847 WHERE rp.league_id = 30847 AND rp.teamId = 2408 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 2408 AND l.year <= 1975 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 30832 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 30831 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 30830 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables1957` 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 = 30829 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC