4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
TEMPORADA 1969/1970
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 100 23 60
2 Feyenoord Feyenoord 34 81 22 55
3 PSV PSV 34 70 34 46
4 Twente Twente 34 62 43 42
5 Sparta Rotterdam Sparta 34 56 41 41
6 ADO Den Haag Haag 34 56 33 40
7 Go Ahead Eagles Ahead Eagles 34 40 42 35
8 MVV Maastricht Maastricht 34 45 45 34
9 SHS Scheveningen Holland Scheveningen 34 48 63 33
10 NAC Breda NAC Breda 34 40 54 32
11 NEC Nijmegen Nijmegen 34 31 39 31
12 AZ Alkmaar AZ Alkmaar 34 31 48 28
13 HFC Haarlem Haarlem 34 23 36 27
14 SC Telstar SC Telstar 34 33 48 24
15 Amsterdam FC DWS Amsterdam 34 26 50 24
16 VV Dos VV Dos 34 27 64 23
17 Groningen Groningen 34 20 45 22
18 SVV SVV 34 31 90 15
TEMPORADA 1968/1969
EREDIVISIE
Equipo PJ GF GC Puntos
1 Feyenoord Feyenoord 34 73 21 57
2 Ajax Ajax 34 90 34 54
3 Twente Twente 34 69 38 47
4 Go Ahead Eagles Ahead Eagles 34 63 34 45
5 PSV PSV 34 54 36 44
6 ADO Den Haag Haag 34 45 37 37
7 NAC Breda NAC Breda 34 50 48 35
8 Sparta Rotterdam Sparta 34 45 33 34
9 Amsterdam FC DWS Amsterdam 34 42 41 34
10 SHS Scheveningen Holland Scheveningen 34 32 45 33
11 Groningen Groningen 34 32 48 28
12 NEC Nijmegen Nijmegen 34 29 38 27
13 MVV Maastricht Maastricht 34 34 46 26
14 SC Telstar SC Telstar 34 33 65 24
15 FC Volendam FC Volendam 34 24 45 23
16 AZ Alkmaar AZ Alkmaar 34 27 53 23
17 VV Dos VV Dos 34 37 74 23
18 Fortuna Sittard Fortuna 34 18 61 18
TEMPORADA 1967/1968
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 96 19 58
2 Feyenoord Feyenoord 34 84 21 55
3 Go Ahead Eagles Ahead Eagles 34 65 41 42
4 ADO Den Haag Haag 34 53 34 41
5 Sparta Rotterdam Sparta 34 53 33 40
6 Groningen Groningen 34 38 35 36
7 Xerxes Xerxes 34 45 47 35
8 Twente Twente 34 56 58 34
9 Amsterdam FC DWS Amsterdam 34 47 57 32
10 NEC Nijmegen Nijmegen 34 41 51 31
11 SC Telstar SC Telstar 34 43 55 29
12 FC Volendam FC Volendam 34 39 56 29
13 MVV Maastricht Maastricht 34 37 50 28
14 PSV PSV 34 43 54 27
15 NAC Breda NAC Breda 34 25 56 26
16 VV Dos VV Dos 34 40 64 25
17 Fortuna 54 Fortuna 54 34 37 70 25
18 Sittardia Sittardia 34 38 79 19
TEMPORADA 1966/1967
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 122 34 56
2 Feyenoord Feyenoord 34 81 33 51
3 Sparta Rotterdam Sparta 34 50 25 48
4 ADO Den Haag Haag 34 70 40 46
5 Go Ahead Eagles Ahead Eagles 34 57 37 40
6 PSV PSV 34 64 59 37
7 Sittardia Sittardia 34 34 40 35
8 Amsterdam FC DWS Amsterdam 34 56 51 34
9 Groningen Groningen 34 48 44 34
10 Xerxes Xerxes 34 47 48 34
11 MVV Maastricht Maastricht 34 43 59 30
12 NAC Breda NAC Breda 34 44 50 29
13 Twente Twente 34 47 62 29
14 Fortuna 54 Fortuna 54 34 44 66 25
15 VV Dos VV Dos 34 50 83 25
16 SC Telstar SC Telstar 34 44 68 24
17 Elinkwijk Elinkwijk 34 35 84 22
18 Willem II Willem II 34 27 80 13
TEMPORADA 1965/1966
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 30 79 25 52
2 Feyenoord Feyenoord 30 65 30 45
3 ADO Den Haag Haag 30 72 37 39
4 Amsterdam FC DWS Amsterdam 30 48 30 36
5 Go Ahead Eagles Ahead Eagles 30 49 33 36
6 Groningen Groningen 30 43 43 31
7 Sparta Rotterdam Sparta 30 53 51 29
8 PSV PSV 30 57 53 28
9 Fortuna 54 Fortuna 54 30 36 54 26
10 Willem II Willem II 30 42 59 25
11 Twente Twente 30 43 61 24
12 VV Dos VV Dos 30 48 72 24
13 SC Telstar SC Telstar 30 39 52 22
14 Elinkwijk Elinkwijk 30 37 64 22
15 MVV Maastricht Maastricht 30 36 56 21
16 Heracles Heracles 30 32 59 20
TEMPORADA 1964/1965
EREDIVISIE
Equipo PJ GF GC Puntos
1 Feyenoord Feyenoord 30 77 30 45
2 Amsterdam FC DWS Amsterdam 30 55 28 40
3 ADO Den Haag Haag 30 37 32 33
4 PSV PSV 30 48 45 33
5 Sparta Rotterdam Sparta 30 39 40 31
6 Fortuna 54 Fortuna 54 30 44 49 31
7 SC Enschede SC Enschede 30 33 37 30
8 MVV Maastricht Maastricht 30 41 51 29
9 Heracles Heracles 30 36 52 29
10 SC Telstar SC Telstar 30 31 36 28
11 Go Ahead Eagles Ahead Eagles 30 36 36 27
12 VV Dos VV Dos 30 43 52 27
13 Ajax Ajax 30 52 51 26
14 Groningen Groningen 30 39 47 26
15 Sittardia Sittardia 30 36 46 23
16 NAC Breda NAC Breda 30 34 49 22

  USO DE MEMORIA  
6,077,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5613
Total Execution Time  0.5626
  CADENA URL  
/historico/Stormvogels-Telstar/1973
  GET DATOS  
$_GET['/historico/Stormvogels-Telstar/1973']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0137  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 = 'Stormvogels-Telstar' 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.0126  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=2924 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=2924 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256  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.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2924 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2924 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (100056,252822,281533,701044,764297) ORDER BY n.cover_points DESC, update_date DESC
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 = '2924' ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '2924' AND l.year = 1973 ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '2924' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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.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=2924 AND l.year in (1972,1973,1974) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (5780) 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 = 5780 AND teamId = 2924
0.0129  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.0126  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 = '2924' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2924' and rp.type = 4
0.0141  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 = '2924' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0129  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2924' and rp.type = 4
0.0162  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 = 2924 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.0160  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 = 2924 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 2924 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 2924 AND l.year <= 1973 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 `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.0134  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.0136  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.0147  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 `tables1970` 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 = 5776 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 `tables1969` 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 = 5775 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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 `tables1968` 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 = 5774 AND t.round = 34 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 `tables1967` 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 = 5773 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 `tables1966` 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 = 5772 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 `tables1965` 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 = 5771 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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