4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1943/1944
Equipo PJ GF GC Puntos
1 Valencia Valencia 26 73 32 40
2 Atlético Atlético 26 66 49 34
3 Sevilla Sevilla 26 60 46 32
4 Real Oviedo Real Oviedo 26 71 47 29
5 CD Castellón Castellón 26 42 36 29
6 Barcelona Barcelona 26 59 46 28
7 Real Madrid Real Madrid 26 48 38 28
8 Granada Granada 26 41 46 26
9 CE Sabadell CE Sabadell 26 53 60 25
10 Athletic Athletic 26 47 51 25
11 Espanyol Espanyol 26 42 50 23
12 RC Deportivo Deportivo 26 35 64 19
13 Real Sociedad Real 26 34 54 17
14 Celta Celta 26 23 75 9
Ver
TEMPORADA 1942/1943
Equipo PJ GF GC Puntos
1 Athletic Athletic 26 73 38 36
2 Sevilla Sevilla 26 63 47 33
3 Barcelona Barcelona 26 77 50 32
4 CD Castellón Castellón 26 41 43 31
5 Celta Celta 26 52 50 30
6 Real Oviedo Real Oviedo 26 53 63 28
7 Valencia Valencia 26 58 45 27
8 Atlético Atlético 26 54 44 27
9 RC Deportivo Deportivo 26 35 32 26
10 Real Madrid Real Madrid 26 52 50 25
11 Espanyol Espanyol 26 45 51 24
12 Granada Granada 26 56 68 22
13 Real Zaragoza Real 26 25 57 13
14 Real Betis Real Betis 26 28 74 10
Ver
TEMPORADA 1941/1942
Equipo PJ GF GC Puntos
1 Valencia Valencia 26 85 39 40
2 Real Madrid Real Madrid 26 65 43 33
3 Atlético Atlético 26 50 44 33
4 RC Deportivo Deportivo 26 36 37 28
5 Celta Celta 26 53 58 28
6 Sevilla Sevilla 26 58 45 27
7 Athletic Athletic 26 55 41 27
8 CD Castellón Castellón 26 54 63 26
9 Espanyol Espanyol 26 49 42 26
10 Granada Granada 26 64 52 25
11 Real Oviedo Real Oviedo 26 42 63 23
12 Barcelona Barcelona 26 57 66 19
13 Hércules Hércules 26 42 71 17
14 Real Sociedad Real 26 31 77 12
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

Nombre Goles Equipo
Mundo es Mundo 28 VCF Valencia
Echevarría es Echevarría 25 OVI Real Oviedo
Martín es Martín 24 FCB Barcelona
Del Pino es Del Pino 21 SAB CE Sabadell
Barinaga es Barinaga 20 RMA Real Madrid
Arza es Arza 17 SEV Sevilla
Campos es Campos 17 ATM Atlético
Gorostiza es Gorostiza 16 VCF Valencia
Basilio es Basilio 15 CAS CD Castellón
Herrerita es Herrerita 14 OVI Real Oviedo

  USO DE MEMORIA  
6,087,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5122
Total Execution Time  0.5141
  CADENA URL  
/primera1944/grupo1/historico
  GET DATOS  
$_GET['/primera1944/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0146  SELECT type FROM routes WHERE alias = 'primera1944'
0.0292  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 = 1944 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0146  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 = 5369 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1 AND group_code = 1 and tables = 1 AND year <= 1944 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0148  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 `tables1944` 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 = 5369 AND t.round = 26 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 `tables1943` 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 = 5368 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables1942` 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 = 5367 AND t.round = 26 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 `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.0149  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.0148  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.0153  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.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 `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.0155  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.0156  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.0158  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.0157  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.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 22:35:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 22:35:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 22:35:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 22:35:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  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 = 1944 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0204  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 events1944 e ON e.player_id = p.id AND e.league_id = 5369 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5369 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.0155  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 events1944 e ON e.player_id = p.id AND e.league_id = 5369 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5369 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0160  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 events1944 e ON e.player_id = p.id AND e.league_id = 5369 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5369 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0181  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1944` 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 = 5369 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC