4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1962/1963
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Eibar Eibar 32 78 34 51
2 Real Unión Club Real Unión 32 75 32 46
3 CD Logroñés Logroñés 32 61 36 43
4 Mirandés Mirandés 32 69 41 42
5 Mondragón Mondragón 31 75 46 41
6 Txantrea Txantrea 32 51 48 34
7 CD Alfaro CD Alfaro 32 50 44 34
8 CD Touring CD Touring 32 54 63 31
9 Real Sociedad B Real 32 58 49 31
10 CD Iruña CD Iruña 32 50 51 30
11 Euskalduna Euskalduna 32 49 45 29
12 Tolosa CF Tolosa CF 32 46 70 26
13 Azkoyen Azkoyen 32 38 64 24
14 Beasain KE Beasain KE 32 44 84 23
15 Villafranca Villafranca 32 47 71 23
16 Bergara KE Bergara KE 31 41 60 21
17 CD Aurrera Vitoria Aurrera 32 30 78 11
TEMPORADA 1961/1962
SEGUNDA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 RC Deportivo Deportivo 30 68 35 43
2 Real Valladolid Real 30 64 31 40
3 CD Ourense CD Ourense 30 39 34 37
4 Deportivo Alavés Deportivo 30 48 39 35
5 Real Sociedad B Real 30 60 44 34
6 Celta Celta 30 53 36 33
7 AD Plus Ultra Plus Ultra 30 47 40 29
8 CE Sabadell CE Sabadell 30 43 60 28
9 Pontevedra Pontevedra 30 43 44 27
10 Atlético Baleares Atlético 30 41 53 27
11 Burgos Burgos 30 39 47 27
12 UD Salamanca Salamanca 30 46 56 26
13 Real Sporting Real 30 52 63 25
14 SD Indautxu SD Indautxu 30 39 50 25
15 CD Basconia CD Basconia 30 33 51 22
16 Cultural Leonesa Cultural 30 34 66 22
TEMPORADA 1960/1961
SEGUNDA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Osasuna Osasuna 30 83 25 46
2 Celta Celta 30 56 30 40
3 RC Deportivo Deportivo 30 68 47 36
4 CD Ourense CD Ourense 30 45 36 36
5 Pontevedra Pontevedra 30 39 40 31
6 CE Sabadell CE Sabadell 30 30 40 31
7 Cultural Leonesa Cultural 30 39 42 30
8 CD Basconia CD Basconia 30 41 57 29
9 Real Sociedad B Real 30 51 50 29
10 UD Salamanca Salamanca 30 42 36 29
11 SD Indautxu SD Indautxu 30 46 59 27
12 Condal CD Condal CD 30 44 49 26
13 Real Sporting Real 30 41 53 25
14 Sestao Sport Club Sestao Sport 30 35 51 24
15 Barakaldo Barakaldo 30 33 51 22
16 Terrassa FC Terrassa FC 30 33 60 19
TEMPORADA 1959/1960
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Real Sociedad B Real 30 103 26 51
2 Real Unión Club Real Unión 30 57 29 41
3 Bergara KE Bergara KE 30 76 72 36
4 CD Logroñés Logroñés 30 56 43 34
5 Mirandés Mirandés 30 58 55 32
6 CD Elgoibar CD Elgoibar 30 59 56 31
7 Eibar Eibar 30 66 63 31
8 Tolosa CF Tolosa CF 30 60 47 31
9 Villafranca Villafranca 30 44 56 30
10 Beasain KE Beasain KE 30 67 55 30
11 CD Aurrera Vitoria Aurrera 30 46 59 27
12 CD Iruña CD Iruña 30 35 46 26
13 CD Alfaro CD Alfaro 30 50 63 26
14 Tudelano Tudelano 30 43 65 23
15 Anaitasuna FT Anaitasuna 30 43 76 18
16 Azkoyen Azkoyen 30 27 79 13
TEMPORADA 1958/1959
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 CD Logroñés Logroñés 30 65 32 46
2 Eibar Eibar 30 78 27 43
3 Real Sociedad B Real 30 65 43 35
4 Bergara KE Bergara KE 30 43 33 34
5 Mirandés Mirandés 30 60 48 31
6 Tolosa CF Tolosa CF 30 55 53 30
7 Beasain KE Beasain KE 30 51 53 30
8 Villafranca Villafranca 30 58 65 29
9 CD Iruña CD Iruña 30 36 39 28
10 Tudelano Tudelano 30 52 54 28
11 Azkoyen Azkoyen 30 39 51 26
12 CD Elgoibar CD Elgoibar 30 42 53 26
13 CD Hernani CD Hernani 30 40 60 26
14 Anaitasuna FT Anaitasuna 30 49 59 26
15 Recreacion de Logroño Recreacion 30 38 69 21
16 Oberena Oberena 30 45 77 21
TEMPORADA 1957/1958
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Real Unión Club Real Unión 34 85 49 49
2 Mirandés Mirandés 34 71 38 48
3 Tolosa CF Tolosa CF 34 78 38 46
4 CD Logroñés Logroñés 34 89 40 46
5 Real Sociedad B Real 34 96 55 42
6 Tudelano Tudelano 34 60 54 38
7 Azkoyen Azkoyen 34 61 51 37
8 Oberena Oberena 34 73 75 35
9 CD Elgoibar CD Elgoibar 34 51 54 32
10 Beasain KE Beasain KE 34 84 87 32
11 Anaitasuna FT Anaitasuna 34 57 76 31
12 CD Hernani CD Hernani 33 59 74 31
13 CD Iruña CD Iruña 34 54 55 31
14 Villafranca Villafranca 34 54 60 30
15 CD Touring CD Touring 34 54 99 24
16 CD Calahorra Calahorra 34 48 84 23
17 CD Aurrera Vitoria Aurrera 34 49 83 18
18 Izarra Izarra 33 36 87 17

  USO DE MEMORIA  
5,756,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5973
Total Execution Time  0.5985
  CADENA URL  
/historico/Real-Sociedad-B/1963
  GET DATOS  
$_GET['/historico/Real-Sociedad-B/1963']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0188  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 = 'Real-Sociedad-B' AND l.year = 1963 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.0145  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=2121 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2121 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0294  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 = 21550
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2121 AND type_rel = 2
0.0155  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2121 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0159  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (2599,2827,5751,12886,38263) ORDER BY n.cover_points DESC, update_date DESC
0.0156  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 = '2121' AND l.year = 1963 ORDER BY l.year DESC,cat.coefficient DESC
0.0162  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 = '2121' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0145  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 = 21550 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  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=2121 AND l.year in (1962,1963,1964) ORDER BY l.id DESC, l.year DESC ;
0.0149  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 (22140,21563,5458) 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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 5458 AND teamId = 2121
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 21563 AND teamId = 2121
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 22140 AND teamId = 2121
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 FROM `tables1963` 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 = 21550 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0152  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2121' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2121' and rp.type = 4
0.0150  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2121' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2121' and rp.type = 4
0.0155  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 events1963 e ON e.player_id = p.id AND e.league_id = 21550 WHERE rp.league_id = 21550 AND rp.teamId = 2121 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.0156  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 events1963 e ON e.player_id = p.id AND e.league_id = 21550 WHERE rp.league_id = 21550 AND rp.teamId = 2121 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 events1963 e ON e.player_id = p.id AND e.league_id = 21550 WHERE rp.league_id = 21550 AND rp.teamId = 2121 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165  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 = 2121 AND l.year <= 1963 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0160  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 `tables1963` 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 = 21550 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables1962` 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 = 5458 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables1961` 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 = 5457 AND t.round = 30 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 `tables1960` 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 = 21509 AND t.round = 30 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 `tables1959` 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 = 21496 AND t.round = 30 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 `tables1958` 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 = 21449 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 21550 ORDER BY nameShow LIMIT 100