4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1946/1947
Equipo PJ GF GC Puntos
1 Alcoyano Alcoyano 26 65 36 38
2 Gimnàstic Tarragona Gimnàstic 26 67 42 35
3 Real Sociedad Real 26 55 37 32
4 Hércules Hércules 26 48 44 30
5 Mallorca Mallorca 26 47 48 26
6 Levante Levante 26 62 54 26
7 Granada Granada 26 36 51 25
8 RCD Córdoba Córdoba 26 38 41 24
9 CD Málaga CD Málaga 26 38 44 23
10 Racing Ferrol Racing 26 48 62 22
11 Barakaldo Barakaldo 26 58 59 21
12 Racing Racing 26 38 54 21
13 Real Zaragoza Real 26 42 47 21
14 Real Betis Real Betis 26 37 60 20
Ver
TEMPORADA 1945/1946
Equipo PJ GF GC Puntos
1 CE Sabadell CE Sabadell 26 50 29 35
2 RC Deportivo Deportivo 26 38 28 33
3 Gimnàstic Tarragona Gimnàstic 26 50 46 29
4 Granada Granada 26 49 35 29
5 RCD Córdoba Córdoba 26 36 34 29
6 Real Sociedad Real 26 46 33 27
7 Racing Ferrol Racing 26 39 52 25
8 Mallorca Mallorca 26 37 39 25
9 Racing Racing 26 56 51 24
10 Real Zaragoza Real 26 44 53 24
11 Real Betis Real Betis 26 41 40 24
12 Jerez FC Jerez FC 26 43 59 22
13 UD Salamanca Salamanca 26 41 48 20
14 SD Ceuta SD Ceuta 26 35 58 18
Ver
TEMPORADA 1944/1945
Equipo PJ GF GC Puntos
1 Alcoyano Alcoyano 26 57 35 34
2 Hércules Hércules 26 55 39 33
3 Celta Celta 26 65 40 32
4 Real Sociedad Real 26 56 34 31
5 Jerez FC Jerez FC 26 52 50 29
6 Racing Racing 26 69 57 26
7 Real Betis Real Betis 26 45 47 26
8 Real Zaragoza Real 26 50 53 26
9 SD Ceuta SD Ceuta 26 40 49 24
10 Racing Ferrol Racing 26 44 68 24
11 Mallorca Mallorca 26 44 55 22
12 Constància Constància 26 42 53 22
13 Cultural Leonesa Cultural 26 41 49 22
14 Barakaldo Barakaldo 26 31 62 13
Ver
TEMPORADA 1943/1944
Equipo PJ GF GC Puntos
1 Real Sporting Real 26 50 19 37
2 Real Murcia Real Murcia 26 62 40 32
3 Constància Constància 26 49 37 31
4 Alcoyano Alcoyano 26 44 34 30
5 Jerez FC Jerez FC 26 50 41 30
6 Real Zaragoza Real 26 56 40 29
7 Real Betis Real Betis 26 50 44 29
8 SD Ceuta SD Ceuta 26 47 45 25
9 Cultural Leonesa Cultural 26 42 45 25
10 Hércules Hércules 26 38 45 22
11 Barakaldo Barakaldo 26 34 61 19
12 Arenas de Getxo Arenas Getxo 26 39 60 19
13 Osasuna Osasuna 26 34 60 18
14 Real Valladolid Real 26 29 53 18
Ver
TEMPORADA 1942/1943
Equipo PJ GF GC Puntos
1 Real Sporting Real 14 34 23 19
2 Real Valladolid Real 14 27 17 19
3 Cultural Leonesa Cultural 14 30 19 18
4 Arenas de Getxo Arenas Getxo 14 18 22 13
5 Barakaldo Barakaldo 14 29 30 13
6 Racing Ferrol Racing 14 28 33 11
7 Racing Racing 14 29 35 11
8 UD Salamanca Salamanca 14 20 36 8
Ver
TEMPORADA 1941/1942
Equipo PJ GF GC Puntos
1 Real Sporting Real 14 37 23 20
2 UD Salamanca Salamanca 14 31 25 18
3 Racing Ferrol Racing 14 34 20 17
4 Racing Racing 14 26 26 15
5 Real Valladolid Real 14 32 21 14
6 Barakaldo Barakaldo 14 32 29 14
7 Arenas de Getxo Arenas Getxo 14 24 38 10
8 Real Unión Club Real Unión 14 16 50 4
Ver
TEMPORADA 1940/1941
Equipo PJ GF GC Puntos
1 Real Sociedad Real 22 81 40 34
2 RC Deportivo Deportivo 22 75 26 33
3 Real Sporting Real 22 54 40 29
4 Racing Ferrol Racing 22 49 38 26
5 Osasuna Osasuna 22 44 45 24
6 Racing Racing 22 42 40 22
7 UD Salamanca Salamanca 22 38 48 18
8 Arenas de Getxo Arenas Getxo 22 28 47 18
9 Real Unión Club Real Unión 22 37 58 17
10 Real Valladolid Real 22 40 62 16
11 Barakaldo Barakaldo 22 40 57 16
12 Real Avilés Industrial Real Avilés 22 27 54 11
Ver
TEMPORADA 1939/1940
Equipo PJ GF GC Puntos
1 RC Deportivo Deportivo 14 38 10 22
2 Racing Ferrol Racing 14 40 13 22
3 Real Sporting Real 14 28 17 17
4 Oriamendi Oriamendi 14 28 29 15
5 UD Salamanca Salamanca 14 25 36 12
6 Real Valladolid Real 14 24 35 8
7 Real Avilés Industrial Real Avilés 14 20 40 8
8 Gimnástica Torrelavega Gimnástica 14 16 39 8
Ver
TEMPORADA 1935/1936
Equipo PJ GF GC Puntos
1 Celta Celta 14 43 24 18
2 Real Zaragoza Real 14 30 11 18
3 Real Sporting Real 14 32 26 16
4 Real Valladolid Real 14 31 26 15
5 Real Avilés Industrial Real Avilés 14 26 41 14
6 CD Nacional de Madrid Nacional 14 34 27 13
7 RC Deportivo Deportivo 14 19 35 11
8 Unión SC Unión SC 14 26 51 7
Ver
TEMPORADA 1934/1935
Equipo PJ GF GC Puntos
1 Celta Celta 14 44 21 20
2 Real Valladolid Real 14 41 21 18
3 Real Sporting Real 14 23 21 16
4 Real Avilés Industrial Real Avilés 14 28 38 14
5 CD Nacional de Madrid Nacional 14 25 26 14
6 Barakaldo Barakaldo 14 22 23 11
7 RC Deportivo Deportivo 14 14 27 10
8 Racing Ferrol Racing 14 12 32 9
Ver
TEMPORADA 1933/1934
Equipo PJ GF GC Puntos
1 Sevilla Sevilla 18 57 27 27
2 Atlético Atlético 18 45 28 24
3 Real Murcia Real Murcia 18 41 31 21
4 Celta Celta 18 44 28 20
5 Osasuna Osasuna 18 47 39 18
6 Real Sporting Real 18 30 38 18
7 RC Deportivo Deportivo 18 35 38 17
8 Real Unión Club Real Unión 18 31 43 16
9 CE Sabadell CE Sabadell 18 31 45 14
10 Deportivo Alavés Deportivo 18 18 62 5
Ver
TEMPORADA 1932/1933
Equipo PJ GF GC Puntos
1 Real Oviedo Real Oviedo 18 58 26 27
2 Atlético Atlético 18 40 35 24
3 Real Murcia Real Murcia 18 33 41 20
4 Real Unión Club Real Unión 18 51 36 20
5 RC Deportivo Deportivo 18 39 38 20
6 Real Sporting Real 18 50 40 18
7 Celta Celta 18 37 38 17
8 Osasuna Osasuna 18 46 47 17
9 Sevilla Sevilla 18 29 38 13
10 Castellón Castellón 18 14 58 4
Ver
TEMPORADA 1931/1932
Equipo PJ GF GC Puntos
1 Real Betis Real Betis 18 40 30 25
2 Real Oviedo Real Oviedo 18 48 26 23
3 Real Sporting Real 18 33 26 22
4 Real Murcia Real Murcia 18 39 32 21
5 RC Deportivo Deportivo 18 33 37 19
6 Atlético Atlético 18 39 37 18
7 Castellón Castellón 17 26 32 17
8 Sevilla Sevilla 17 27 31 13
9 Celta Celta 17 30 47 11
10 CE Europa CE Europa 15 13 30 5
Ver
TEMPORADA 1930/1931
Equipo PJ GF GC Puntos
1 Valencia Valencia 18 37 25 26
2 Sevilla Sevilla 18 42 26 23
3 Atlético Atlético 18 47 31 23
4 Real Sporting Real 18 48 32 18
5 Castellón Castellón 18 27 31 18
6 Real Betis Real Betis 18 25 36 17
7 Real Murcia Real Murcia 18 29 46 14
8 Real Oviedo Real Oviedo 18 39 41 14
9 RC Deportivo Deportivo 18 32 43 14
10 Iberia SC Iberia SC 18 23 38 13
Ver
TEMPORADA 1929/1930
Equipo PJ GF GC Puntos
1 Deportivo Alavés Deportivo 18 44 19 22
2 Real Sporting Real 18 29 28 21
3 Iberia SC Iberia SC 18 26 22 21
4 Sevilla Sevilla 18 41 26 20
5 Real Oviedo Real Oviedo 18 37 44 18
6 Valencia Valencia 18 40 43 18
7 RC Deportivo Deportivo 18 33 37 17
8 Real Murcia Real Murcia 18 40 50 15
9 Real Betis Real Betis 18 29 39 14
10 CD Leonesa CD Leonesa 18 30 41 14
Ver
TEMPORADA 1928/1929
Equipo PJ GF GC Puntos
1 Sevilla Sevilla 18 35 24 22
2 Iberia SC Iberia SC 18 33 27 22
3 Deportivo Alavés Deportivo 18 28 20 21
4 Real Sporting Real 18 41 35 19
5 Valencia Valencia 18 33 31 19
6 Real Betis Real Betis 18 35 36 18
7 Real Oviedo Real Oviedo 18 43 39 17
8 RC Deportivo Deportivo 18 27 37 16
9 Celta Celta 18 29 38 13
10 Racing Club Madrid Racing Club 18 31 48 13

JUGADORES DESTACADOS


  USO DE MEMORIA  
6,266,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.1316
Total Execution Time  0.1342
  CADENA URL  
/segunda1947/grupo1/historico
  GET DATOS  
$_GET['/segunda1947/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0026  SELECT type FROM routes WHERE alias = 'segunda1947'
0.0056  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1947 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
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 = 10378 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2 AND group_code = 1 and tables = 1 AND year <= 1947 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0045  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 `tables1947` 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 = 10378 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1946` 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 = 10381 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables1945` 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 = 10380 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 10392 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 20933 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 20934 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 20932 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 20931 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 20930 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0054  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 = 21003 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 10382 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 10383 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 10384 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 10387 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 10385 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 10386 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 15:33:27' 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-27 15:33:27' 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-27 15:33:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 15:33:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1947 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0101  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 events1947 e ON e.player_id = p.id AND e.league_id = 10378 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10378 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.0025  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 events1947 e ON e.player_id = p.id AND e.league_id = 10378 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10378 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  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 events1947 e ON e.player_id = p.id AND e.league_id = 10378 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10378 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1947` 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 = 10378 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC