4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1940/1941
Equipo PJ GF GC Puntos
1 Atlético Atlético 22 70 36 33
2 Athletic Athletic 22 49 24 31
3 Valencia Valencia 22 60 52 27
4 Barcelona Barcelona 22 55 45 27
5 Sevilla Sevilla 22 70 43 26
6 Real Madrid Real Madrid 22 51 38 24
7 Espanyol Espanyol 22 50 54 22
8 Real Oviedo Real Oviedo 22 36 63 16
9 Hércules Hércules 22 28 67 16
10 Celta Celta 22 45 51 15
11 Real Zaragoza Real 22 26 41 14
12 Real Murcia Real Murcia 22 29 55 13
Ver
TEMPORADA 1939/1940
Equipo PJ GF GC Puntos
1 Atlético Atlético 22 43 29 29
2 Sevilla Sevilla 22 60 44 28
3 Athletic Athletic 22 57 44 26
4 Real Madrid Real Madrid 22 47 35 25
5 Espanyol Espanyol 22 43 43 24
6 Hércules Hércules 22 41 34 23
7 Real Zaragoza Real 22 30 40 21
8 Valencia Valencia 22 40 36 21
9 Barcelona Barcelona 22 32 38 19
10 Celta Celta 22 45 50 19
11 Real Betis Real Betis 22 26 51 16
12 Racing Racing 22 37 57 13
Ver
TEMPORADA 1935/1936
Equipo PJ GF GC Puntos
1 Athletic Athletic 22 59 33 31
2 Real Madrid Real Madrid 22 62 35 29
3 Real Oviedo Real Oviedo 22 63 47 28
4 Racing Racing 22 58 46 27
5 Barcelona Barcelona 22 39 32 24
6 Hércules Hércules 22 37 41 24
7 Real Betis Real Betis 22 31 46 20
8 Valencia Valencia 22 36 42 19
9 Espanyol Espanyol 22 36 53 17
10 Sevilla Sevilla 22 27 48 16
11 Atlético Atlético 22 34 50 15
12 Osasuna Osasuna 22 46 55 14
Ver
TEMPORADA 1934/1935
Equipo PJ GF GC Puntos
1 Real Betis Real Betis 22 43 19 34
2 Real Madrid Real Madrid 22 61 34 33
3 Real Oviedo Real Oviedo 22 60 47 26
4 Athletic Athletic 22 60 37 25
5 Sevilla Sevilla 22 53 38 24
6 Barcelona Barcelona 22 55 44 24
7 Atlético Atlético 22 40 45 21
8 Espanyol Espanyol 22 47 59 20
9 Valencia Valencia 22 40 49 20
10 Racing Racing 22 37 46 17
11 Real Sociedad Real 22 28 67 11
12 Arenas de Getxo Arenas Getxo 22 17 56 9
Ver
TEMPORADA 1933/1934
Equipo PJ GF GC Puntos
1 Athletic Athletic 18 61 27 24
2 Real Madrid Real Madrid 18 41 29 22
3 Racing Racing 18 38 39 19
4 Real Betis Real Betis 18 29 36 19
5 Real Sociedad Real 18 29 33 18
6 Real Oviedo Real Oviedo 18 51 45 18
7 Valencia Valencia 18 28 38 17
8 Espanyol Espanyol 18 41 42 17
9 Barcelona Barcelona 18 42 40 16
10 Arenas de Getxo Arenas Getxo 18 18 49 10
Ver
TEMPORADA 1932/1933
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 18 49 17 28
2 Athletic Athletic 18 63 30 26
3 Espanyol Espanyol 18 33 30 22
4 Barcelona Barcelona 18 42 34 19
5 Real Betis Real Betis 18 31 45 17
6 Real Sociedad Real 18 41 47 15
7 Arenas de Getxo Arenas Getxo 18 39 44 14
8 Racing Racing 18 47 58 14
9 Valencia Valencia 18 34 53 13
10 Deportivo Alavés Deportivo 18 21 42 12
Ver
TEMPORADA 1931/1932
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 18 37 15 28
2 Athletic Athletic 18 47 23 25
3 Barcelona Barcelona 18 40 26 24
4 Racing Racing 18 36 35 20
5 Arenas de Getxo Arenas Getxo 18 35 42 17
6 Espanyol Espanyol 18 34 39 15
7 Valencia Valencia 18 38 47 15
8 Real Sociedad Real 18 38 35 14
9 Deportivo Alavés Deportivo 18 22 44 11
10 Real Unión Club Real Unión 18 24 45 11
Ver
TEMPORADA 1930/1931
Equipo PJ GF GC Puntos
1 Athletic Athletic 18 73 33 22
2 Racing Racing 18 49 37 22
3 Real Sociedad Real 18 42 39 22
4 Barcelona Barcelona 18 40 43 21
5 Arenas de Getxo Arenas Getxo 18 35 38 18
6 Real Madrid Real Madrid 18 24 27 18
7 Real Unión Club Real Unión 18 41 45 16
8 Deportivo Alavés Deportivo 18 25 39 14
9 Espanyol Espanyol 18 32 45 14
10 CE Europa CE Europa 18 23 38 13
Ver
TEMPORADA 1929/1930
Equipo PJ GF GC Puntos
1 Athletic Athletic 18 63 28 30
2 Barcelona Barcelona 18 46 36 23
3 Arenas de Getxo Arenas Getxo 18 51 40 20
4 Espanyol Espanyol 18 40 33 20
5 Real Madrid Real Madrid 18 45 42 17
6 Real Unión Club Real Unión 18 48 52 17
7 Real Sociedad Real 18 34 37 14
8 Racing Racing 18 32 58 14
9 CE Europa CE Europa 18 29 44 13
10 Atlético Atlético 18 32 50 12
Ver
TEMPORADA 1928/1929
Equipo PJ GF GC Puntos
1 Barcelona Barcelona 18 37 23 25
2 Real Madrid Real Madrid 18 40 27 23
3 Athletic Athletic 18 43 33 20
4 Real Sociedad Real 18 46 41 20
5 Arenas de Getxo Arenas Getxo 18 32 39 19
6 Atlético Atlético 18 43 41 18
7 Espanyol Espanyol 18 32 38 18
8 CE Europa CE Europa 18 45 49 16
9 Real Unión Club Real Unión 18 40 42 12
10 Racing Racing 18 25 50 9

JUGADORES DESTACADOS


  USO DE MEMORIA  
5,605,664 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5008
Total Execution Time  0.5027
  CADENA URL  
/primera1941/grupo1/historico
  GET DATOS  
$_GET['/primera1941/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0144  SELECT type FROM routes WHERE alias = 'primera1941'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1941 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0156  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 = 5366 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0163  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1 AND group_code = 1 and tables = 1 AND year <= 1941 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0165  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 `tables1941` 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 = 5366 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `tables1940` 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 = 5365 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 `tables1936` 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 = 5361 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `tables1935` 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 = 5360 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 `tables1934` 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 = 5359 AND t.round = 18 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 `tables1933` 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 = 5358 AND t.round = 18 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 `tables1932` 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 = 5357 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 `tables1931` 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 = 5356 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 `tables1930` 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 = 5355 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `tables1929` 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 = 5354 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 19:49:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 19:49:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 19:49:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 19:49:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0160  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1941 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0341  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 events1941 e ON e.player_id = p.id AND e.league_id = 5366 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5366 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.0154  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 events1941 e ON e.player_id = p.id AND e.league_id = 5366 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5366 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0154  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 events1941 e ON e.player_id = p.id AND e.league_id = 5366 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5366 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0161  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1941` 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 = 5366 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC