4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1950/1951
Equipo PJ GF GC Puntos
1 SPAL SPAL 40 74 37 83
2 AC Legnano AC Legnano 40 89 47 78
3 Livorno Livorno 40 67 53 66
4 Modena Modena 40 73 49 64
5 Siracusa Siracusa 40 62 47 62
6 Fanfulla Fanfulla 40 69 61 60
7 Brescia Brescia 40 69 49 59
8 Catania Catania 40 63 63 59
9 Vicenza Vicenza 40 65 58 58
10 Hellas Verona Hellas 40 69 58 57
11 Venezia Venezia 40 62 65 57
12 Pisa SC Pisa SC 40 46 50 57
13 ACR Messina ACR Messina 40 50 48 55
14 Reggiana Reggiana 40 48 53 55
15 Salernitana Salernitana 40 57 65 55
16 Treviso Treviso 40 56 55 54
17 Spezia Spezia 40 44 61 50
18 SSC Bari SSC Bari 40 51 75 40
19 Seregno Seregno 40 42 67 40
20 Cremonese Cremonese 40 36 68 36
21 Ancona Ancona 40 32 95 21
Ver
TEMPORADA 1949/1950
Equipo PJ GF GC Puntos
1 Napoli Napoli 42 76 34 88
2 Udinese Udinese 42 78 39 86
3 AC Legnano AC Legnano 42 86 52 82
4 SPAL SPAL 42 95 65 79
5 Modena Modena 42 76 43 74
6 Spezia Spezia 42 69 55 69
7 Brescia Brescia 42 81 64 65
8 Livorno Livorno 42 61 59 65
9 Hellas Verona Hellas 42 68 68 58
10 Siracusa Siracusa 42 68 71 58
11 Catania Catania 42 54 61 55
12 Pisa SC Pisa SC 42 56 50 54
13 Salernitana Salernitana 42 58 56 54
14 Vicenza Vicenza 42 63 67 54
15 Fanfulla Fanfulla 42 63 71 54
16 Cremonese Cremonese 42 56 57 53
17 Reggiana Reggiana 42 56 64 52
18 US Alessandria Alessandria 42 70 74 51
19 Empoli Empoli 42 51 69 49
20 Taranto Taranto 42 56 96 47
21 Prato Prato 42 55 97 34
22 Pro Sesto Pro Sesto 42 35 119 19

JUGADORES DESTACADOS


  USO DE MEMORIA  
5,456,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.2894
Total Execution Time  0.2920
  CADENA URL  
/serie_b1951/grupo1/historico
  GET DATOS  
$_GET['/serie_b1951/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0125  SELECT type FROM routes WHERE alias = 'serie_b1951'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'serie_b' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1951 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 89 AND group_code = 1 and tables = 1 AND year <= 1951 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables1951` 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 = 30823 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 08:11:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 08:11:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 08:11:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 08:11:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'serie_b' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1951 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0247  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1951 e ON e.player_id = p.id AND e.league_id = 30823 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 30823 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1951 e ON e.player_id = p.id AND e.league_id = 30823 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 30823 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1951 e ON e.player_id = p.id AND e.league_id = 30823 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 30823 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0139  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1951` 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 = 30823 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC