4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1953/1954
SEGUNDA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Deportivo Alavés Deportivo 30 65 42 41
2 Barakaldo Barakaldo 30 56 36 38
3 Lleida Lleida 30 62 44 38
4 Cultural Leonesa Cultural 30 63 46 34
5 Condal CD Condal CD 30 62 48 33
6 CE Sabadell CE Sabadell 30 52 53 32
7 Eibar Eibar 30 56 54 29
8 Racing Ferrol Racing 30 44 58 29
9 Real Zaragoza Real 30 76 59 29
10 CD Logroñés Logroñés 30 65 55 28
11 Real Avilés Industrial Real Avilés 30 45 61 28
12 Caudal Deportivo Caudal 30 38 46 28
13 Circulo Popular Circulo 30 49 63 25
14 Gimnástica Torrelavega Gimnástica 30 35 64 25
15 UD Salamanca Salamanca 30 44 56 22
16 SD Escoriaza Escoriaza 30 42 69 21
TEMPORADA 1952/1953
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Eibar Eibar 34 93 40 52
2 Sestao Sport Club Sestao Sport 34 62 33 43
3 Mirandés Mirandés 34 73 48 42
4 CD Getxo CD Getxo 34 67 45 42
5 Mondragón Mondragón 34 69 51 40
6 Numancia Numancia 34 60 61 37
7 CD Basconia CD Basconia 34 65 62 37
8 Izarra Izarra 34 68 60 36
9 SD Indautxu SD Indautxu 34 54 51 34
10 Arenas de Getxo Arenas Getxo 34 46 67 30
11 Portugalete Portugalete 34 43 52 30
12 Garellano Garellano 34 57 72 29
13 Azkoyen Azkoyen 34 48 80 29
14 At. Calatayud Calatayud 34 40 68 28
15 Deportivo Rayo Cantabria Deportivo 33 54 61 27
16 SD Erandio SD Erandio 34 58 61 26
17 Recreacion de Logroño Recreacion 33 43 60 25
18 CD Calahorra Calahorra 34 51 79 23
TEMPORADA 1951/1952
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Burgos Burgos 30 75 42 40
2 Eibar Eibar 30 68 38 39
3 Recreacion de Logroño Recreacion 30 59 57 34
4 Deportivo Rayo Cantabria Deportivo 30 48 39 34
5 CD Getxo CD Getxo 30 52 37 33
6 Arenas de Zaragoza Arenas 29 50 50 32
7 Mirandés Mirandés 30 57 48 32
8 Portugalete Portugalete 30 54 55 30
9 CD Basconia CD Basconia 30 43 49 29
10 Sestao Sport Club Sestao Sport 30 54 55 29
11 Izarra Izarra 30 51 70 28
12 SD Erandio SD Erandio 30 29 53 26
13 Numancia Numancia 29 64 55 26
14 CD Calahorra Calahorra 30 42 67 24
15 SD Indautxu SD Indautxu 30 50 59 22
16 Arenas de Getxo Arenas Getxo 30 42 64 20
TEMPORADA 1950/1951
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Eibar Eibar 34 84 45 52
2 Deportivo Alavés Deportivo 34 75 31 47
3 Burgos Burgos 34 71 42 47
4 CD Getxo CD Getxo 34 70 38 45
5 SD Indautxu SD Indautxu 34 68 63 38
6 Mirandés Mirandés 34 63 53 38
7 Izarra Izarra 34 75 78 34
8 CD Calahorra Calahorra 34 54 63 33
9 Sestao Sport Club Sestao Sport 34 58 63 33
10 Arenas de Getxo Arenas Getxo 34 70 59 32
11 CD Naval CD Naval 34 66 66 30
12 SD Erandio SD Erandio 34 59 63 30
13 CD Basconia CD Basconia 34 52 52 30
14 Recreacion de Logroño Recreacion 34 62 71 30
15 Juventud Real Santander Juventud 34 57 76 28
16 Rayo Cantabria Rayo 34 59 74 24
17 Real Unión Club Real Unión 34 49 91 22
18 Tudelano Tudelano 34 43 107 19

  USO DE MEMORIA  
5,506,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3543
Total Execution Time  0.3555
  CADENA URL  
/historico/Eibar/1954
  GET DATOS  
$_GET['/historico/Eibar/1954']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0141  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 = 'Eibar' AND l.year = 1954 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.0125  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=957 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=957 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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 = 20963
0.0135  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 = '957' AND l.year = 1954 ORDER BY l.year DESC,cat.coefficient DESC
0.0137  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 = '957' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 20963 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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=957 AND l.year in (1953,1954,1955) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (21397,21055) 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.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 21055 AND teamId = 957
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 21397 AND teamId = 957
0.0137  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 events1954 e ON e.player_id = p.id AND e.league_id = 20963 WHERE rp.league_id = 20963 AND rp.teamId = 957 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.0131  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 events1954 e ON e.player_id = p.id AND e.league_id = 20963 WHERE rp.league_id = 20963 AND rp.teamId = 957 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 events1954 e ON e.player_id = p.id AND e.league_id = 20963 WHERE rp.league_id = 20963 AND rp.teamId = 957 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 957 AND l.year <= 1954 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1954` 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 = 20963 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables1953` 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 = 21397 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables1952` 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 = 21391 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 21385 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC