4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1984/1985
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Servette Servette 30 71 28 65
2 Aarau Aarau 30 62 43 58
3 Neuchâtel Xamax Neuchâtel 30 59 34 53
4 St. Gallen St. Gallen 30 67 34 50
5 Sion Sion 30 56 49 50
6 Grasshopper Grasshopper 30 53 47 43
7 Zurich Zurich 30 59 52 42
8 Basel Basel 30 46 49 42
9 Young Boys Young Boys 30 42 45 40
10 Lausanne Sports Lausanne 30 50 57 39
11 Luzern Luzern 30 33 53 35
12 Vevey Sports Vevey Sports 30 42 48 33
13 FC Wettingen Wettingen 30 31 37 33
14 La Chaux-de-Fonds Chaux-de-Fon 30 41 54 30
15 Zug 94 Zug 94 30 29 71 18
16 Winterthur Winterthur 30 32 72 17
TEMPORADA 1983/1984
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Servette Servette 30 67 31 63
2 Grasshopper Grasshopper 30 59 32 63
3 Sion Sion 30 74 39 61
4 St. Gallen St. Gallen 30 57 41 56
5 Neuchâtel Xamax Neuchâtel 30 54 27 55
6 Lausanne Sports Lausanne 30 49 37 47
7 La Chaux-de-Fonds Chaux-de-Fon 30 52 47 45
8 FC Wettingen Wettingen 30 43 43 42
9 Basel Basel 30 55 59 39
10 Aarau Aarau 30 50 42 36
11 Young Boys Young Boys 30 39 40 33
12 Vevey Sports Vevey Sports 30 43 65 33
13 Zurich Zurich 30 39 56 32
14 Luzern Luzern 30 35 52 31
15 AC Bellinzona Bellinzona 30 30 79 16
16 Chiasso Chiasso 30 26 82 14
TEMPORADA 1982/1983
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Grasshopper Grasshopper 9 25 7 24
2 Servette Servette 9 20 8 20
3 St. Gallen St. Gallen 9 17 6 19
4 Zurich Zurich 9 18 10 19
5 Neuchâtel Xamax Neuchâtel 9 22 9 17
6 Sion Sion 9 18 11 16
7 Lausanne Sports Lausanne 9 11 7 15
8 FC Wettingen Wettingen 9 12 15 11
9 Aarau Aarau 9 13 16 10
10 Young Boys Young Boys 9 10 13 10
11 AC Bellinzona Bellinzona 9 14 19 9
12 Luzern Luzern 9 10 18 9
13 Vevey Sports Vevey Sports 9 11 17 8
14 Basel Basel 9 13 22 6
15 Winterthur Winterthur 9 14 28 5
16 Bulle Bulle 9 6 28 3
TEMPORADA 1981/1982
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Grasshopper Grasshopper 30 72 24 70
2 Servette Servette 30 76 32 66
3 Zurich Zurich 30 62 25 64
4 Neuchâtel Xamax Neuchâtel 30 67 30 63
5 Young Boys Young Boys 30 52 40 54
6 Sion Sion 30 51 46 43
7 Basel Basel 30 47 51 39
8 Aarau Aarau 30 51 55 38
9 Luzern Luzern 30 54 59 37
10 St. Gallen St. Gallen 30 40 45 35
11 Vevey Sports Vevey Sports 30 44 57 29
12 AC Bellinzona Bellinzona 30 34 66 28
13 Lausanne Sports Lausanne 30 39 52 26
14 Bulle Bulle 30 29 58 24
15 Nordstern Nordstern 30 29 69 23
16 Chiasso Chiasso 30 25 63 20
TEMPORADA 1980/1981
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Zurich Zurich 26 57 28 58
2 Neuchâtel Xamax Neuchâtel 26 44 25 48
3 Grasshopper Grasshopper 26 45 24 45
4 Young Boys Young Boys 26 46 33 44
5 Lausanne Sports Lausanne 26 40 29 42
6 Basel Basel 26 48 44 37
7 Servette Servette 26 38 36 34
8 Sion Sion 26 35 42 32
9 St. Gallen St. Gallen 26 35 42 29
10 Luzern Luzern 26 39 46 28
11 AC Bellinzona Bellinzona 26 25 46 26
12 Nordstern Nordstern 26 28 37 25
13 Chiasso Chiasso 26 28 46 23
14 CS Chênois CS Chênois 26 23 53 18
TEMPORADA 1979/1980
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Servette Servette 26 61 25 55
2 Basel Basel 26 67 27 52
3 Grasshopper Grasshopper 26 61 21 50
4 Luzern Luzern 26 44 44 46
5 Zurich Zurich 26 56 42 44
6 Sion Sion 26 47 37 42
7 St. Gallen St. Gallen 26 48 37 39
8 Lausanne Sports Lausanne 26 35 38 30
9 Young Boys Young Boys 26 34 49 29
10 Chiasso Chiasso 26 27 43 29
11 Neuchâtel Xamax Neuchâtel 26 33 48 28
12 CS Chênois CS Chênois 26 32 45 24
13 La Chaux-de-Fonds Chaux-de-Fon 26 24 57 22
14 FC Lugano FC Lugano 26 18 74 8
TEMPORADA 1978/1979
LIGA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Servette Servette 10 23 5 30
2 Zurich Zurich 10 19 14 19
3 Grasshopper Grasshopper 10 11 13 12
4 St. Gallen St. Gallen 10 8 10 9
5 Basel Basel 10 17 24 7
6 Young Boys Young Boys 10 5 17 7
TEMPORADA 1977/1978
LIGA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Basel Basel 10 21 14 18
2 Zurich Zurich 10 15 15 17
3 Grasshopper Grasshopper 10 17 12 16
4 Lausanne Sports Lausanne 10 21 14 15
5 Servette Servette 10 10 10 14
6 Sion Sion 10 8 27 1
TEMPORADA 1976/1977
LIGA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Grasshopper Grasshopper 10 15 10 17
2 Basel Basel 10 19 16 17
3 Zurich Zurich 10 24 18 16
4 Servette Servette 10 16 14 16
5 Neuchâtel Xamax Neuchâtel 10 14 18 10
6 Young Boys Young Boys 10 12 24 10

  USO DE MEMORIA  
5,769,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1188
Total Execution Time  0.1204
  CADENA URL  
/historico/Basel/1985
  GET DATOS  
$_GET['/historico/Basel/1985']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0073  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 = 'Basel' AND l.year = 1985 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.0019  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=10035 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=10035 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 29644
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10035 AND type_rel = 2
0.0029  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10035 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  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 (236,665,916,1062,2898) ORDER BY n.cover_points DESC, update_date DESC
0.0041  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 = '10035' AND l.year = 1985 ORDER BY l.year DESC,cat.coefficient DESC
0.0040  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 = '10035' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 29644 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036  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=10035 AND l.year in (1984,1985,1986) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (29645) 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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 29645 AND teamId = 10035
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 FROM `tables1985` 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 = 29644 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0040  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 events1985 e ON e.player_id = p.id AND e.league_id = 29644 WHERE rp.league_id = 29644 AND rp.teamId = 10035 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.0036  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 events1985 e ON e.player_id = p.id AND e.league_id = 29644 WHERE rp.league_id = 29644 AND rp.teamId = 10035 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 events1985 e ON e.player_id = p.id AND e.league_id = 29644 WHERE rp.league_id = 29644 AND rp.teamId = 10035 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039  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 = 10035 AND l.year <= 1985 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0025  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 `tables1985` 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 = 29644 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables1984` 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 = 29645 AND t.round = 30 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 `tables1983` 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 = 29646 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables1982` 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 = 29647 AND t.round = 30 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 `tables1981` 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 = 29649 AND t.round = 26 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 `tables1980` 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 = 57445 AND t.round = 10 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 `tables1980` 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 = 29651 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 `tables1979` 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 = 29654 AND t.round = 22 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 `tables1979` 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 = 57461 AND t.round = 10 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 `tables1978` 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 = 57463 AND t.round = 10 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 `tables1977` 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 = 57482 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 29644 ORDER BY nameShow LIMIT 100