4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Excelsior

Excelsior

Entrenador: Marinus Dijkhuizen

Temporada 1972/1973
TEMPORADA 1972/1973
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 102 18 60
2 Feyenoord Feyenoord 34 89 28 58
3 Twente Twente 34 53 22 50
4 Sparta Rotterdam Sparta 34 85 37 47
5 ADO Den Haag Haag 34 44 39 40
6 PSV PSV 34 46 35 38
7 MVV Maastricht Maastricht 34 49 38 37
8 Utrecht Utrecht 34 42 55 32
9 NEC Nijmegen Nijmegen 34 40 46 31
10 FC Amsterdam Amsterdam 34 44 54 29
11 HFC Haarlem Haarlem 34 43 55 29
12 SC Telstar SC Telstar 34 39 51 28
13 Groningen Groningen 34 37 61 27
14 Go Ahead Eagles Ahead Eagles 34 31 52 25
15 AZ Alkmaar AZ Alkmaar 34 32 58 25
16 NAC Breda NAC Breda 34 26 57 21
17 Excelsior Excelsior 34 24 70 18
18 Den Bosch Den Bosch 34 23 73 17
TEMPORADA 1971/1972
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 104 20 63
2 Feyenoord Feyenoord 34 73 24 55
3 Twente Twente 34 50 13 48
4 Sparta Rotterdam Sparta 34 73 38 46
5 ADO Den Haag Haag 34 59 33 44
6 Utrecht Utrecht 34 56 42 40
7 NEC Nijmegen Nijmegen 34 43 43 38
8 PSV PSV 34 47 32 36
9 Go Ahead Eagles Ahead Eagles 34 48 49 34
10 MVV Maastricht Maastricht 34 36 47 30
11 SC Telstar SC Telstar 34 39 52 29
12 Groningen Groningen 34 37 55 28
13 NAC Breda NAC Breda 34 39 58 27
14 Amsterdam FC DWS Amsterdam 34 28 54 20
15 Excelsior Excelsior 34 18 53 20
16 Den Bosch Den Bosch 34 24 70 20
17 FC Volendam FC Volendam 34 16 55 17
18 Vitesse Vitesse 34 22 74 17
TEMPORADA 1970/1971
EREDIVISIE
Equipo PJ GF GC Puntos
1 Feyenoord Feyenoord 34 82 25 57
2 Ajax Ajax 34 90 20 53
3 ADO Den Haag Haag 34 62 27 50
4 PSV PSV 34 73 25 49
5 Twente Twente 34 48 18 48
6 Sparta Rotterdam Sparta 34 54 34 45
7 Go Ahead Eagles Ahead Eagles 34 49 43 38
8 NEC Nijmegen Nijmegen 34 43 36 34
9 Utrecht Utrecht 34 46 64 33
10 FC Volendam FC Volendam 34 34 48 28
11 SC Telstar SC Telstar 34 32 46 27
12 Amsterdam FC DWS Amsterdam 34 26 54 27
13 MVV Maastricht Maastricht 34 28 42 26
14 NAC Breda NAC Breda 34 40 61 24
15 SHS Scheveningen Holland Scheveningen 34 34 60 24
16 Excelsior Excelsior 34 22 66 20
17 AZ Alkmaar AZ Alkmaar 34 24 76 15
18 HFC Haarlem Haarlem 34 22 64 14

  USO DE MEMORIA  
5,138,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.4121
Total Execution Time  0.4136
  CADENA URL  
/historico/Excelsior/1973
  GET DATOS  
$_GET['/historico/Excelsior/1973']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0144  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 = 'Excelsior' AND l.year = 1973 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=1019 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=1019 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 = 5779
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1019 AND type_rel = 2
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1019 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (6413,76459,87613,95414,97337) ORDER BY n.cover_points DESC, update_date DESC
0.0138  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 = '1019' ORDER BY l.year DESC,cat.coefficient DESC
0.0136  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 = '1019' AND l.year = 1973 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 = '1019' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 5779 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  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=1019 AND l.year in (1972,1973,1974) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (5779) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 5779 AND teamId = 1019
0.0141  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1973` 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 = 5779 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0136  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 events1973 e ON e.player_id = p.id AND e.league_id = 5779 WHERE rp.league_id = 5779 AND rp.teamId = 1019 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.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 events1973 e ON e.player_id = p.id AND e.league_id = 5779 WHERE rp.league_id = 5779 AND rp.teamId = 1019 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 events1973 e ON e.player_id = p.id AND e.league_id = 5779 WHERE rp.league_id = 5779 AND rp.teamId = 1019 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 1019 AND l.year <= 1973 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1973` 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 = 5779 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 `tables1972` 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 = 5778 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 `tables1971` 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 = 5777 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 5779 ORDER BY nameShow LIMIT 100