4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1997/1998
LIGA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Neuchâtel Xamax Neuchâtel 14 35 22 26
2 FC Lugano FC Lugano 14 15 12 23
3 Basel Basel 14 27 22 22
4 Young Boys Young Boys 14 20 23 22
5 Solothurn Solothurn 14 17 15 21
6 Kriens Kriens 14 19 25 16
7 Baden Baden 14 15 23 12
8 Etoile Carouge Etoile 14 13 19 11
TEMPORADA 1996/1997
LIGA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Sion Sion 14 18 10 49
2 Neuchâtel Xamax Neuchâtel 14 22 14 46
3 Grasshopper Grasshopper 14 37 18 45
4 Lausanne Sports Lausanne 14 20 16 43
5 Aarau Aarau 14 17 22 31
6 St. Gallen St. Gallen 14 13 26 28
7 Zurich Zurich 14 9 18 24
8 Basel Basel 14 16 28 24
TEMPORADA 1995/1996
LIGA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Grasshopper Grasshopper 14 26 7 52
2 Sion Sion 14 20 14 47
3 Neuchâtel Xamax Neuchâtel 14 21 16 43
4 Aarau Aarau 14 23 18 39
5 Luzern Luzern 14 23 19 35
6 Basel Basel 14 11 20 28
7 St. Gallen St. Gallen 14 11 34 23
8 Servette Servette 14 18 25 22
TEMPORADA 1994/1995
LIGA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Grasshopper Grasshopper 14 25 13 37
2 FC Lugano FC Lugano 14 25 17 30
3 Neuchâtel Xamax Neuchâtel 14 27 20 28
4 Aarau Aarau 14 17 16 27
5 Luzern Luzern 14 14 18 25
6 Basel Basel 14 20 19 24
7 Sion Sion 14 24 25 24
8 Lausanne Sports Lausanne 14 11 35 15
TEMPORADA 1993/1994
LIGA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Neuchâtel Xamax Neuchâtel 14 21 12 29
2 St. Gallen St. Gallen 14 28 14 28
3 Basel Basel 14 22 7 27
4 Zurich Zurich 14 24 15 25
5 Kriens Kriens 14 21 20 16
6 Etoile Carouge Etoile 14 14 24 14
7 Schaffhausen Schaffhausen 14 14 31 9
8 Yverdon Yverdon 14 8 29 5
TEMPORADA 1992/1993
LIGA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Grasshopper Grasshopper 14 42 8 22
2 Luzern Luzern 14 30 6 22
3 Bulle Bulle 14 28 20 19
4 Basel Basel 14 25 17 18
5 Delemont Delemont 14 14 28 10
6 CS Chênois CS Chênois 14 9 29 9
7 Locarno Locarno 14 16 31 7
8 FC Wil FC Wil 14 7 32 5
TEMPORADA 1991/1992
LIGA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Aarau Aarau 14 22 11 21
2 FC Lugano FC Lugano 14 23 10 20
3 Yverdon Yverdon 14 24 17 18
4 Basel Basel 14 20 22 14
5 Baden Baden 14 14 16 13
6 Locarno Locarno 14 19 19 10
7 FC Malley FC Malley 14 18 30 10
8 AC Bellinzona Bellinzona 14 14 29 6
TEMPORADA 1987/1988
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Neuchâtel Xamax Neuchâtel 22 53 28 44
2 Grasshopper Grasshopper 22 30 16 42
3 Aarau Aarau 22 28 24 34
4 Young Boys Young Boys 22 37 28 33
5 St. Gallen St. Gallen 22 28 27 32
6 Servette Servette 22 32 31 31
7 Lausanne Sports Lausanne 22 39 39 31
8 Sion Sion 22 42 36 30
9 Luzern Luzern 22 30 29 30
10 AC Bellinzona Bellinzona 22 25 38 17
11 Basel Basel 22 27 55 17
12 Zurich Zurich 22 26 46 15
TEMPORADA 1986/1987
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Neuchâtel Xamax Neuchâtel 30 75 27 69
2 Grasshopper Grasshopper 30 60 36 62
3 Sion Sion 30 76 38 59
4 Servette Servette 30 65 44 52
5 Luzern Luzern 30 55 38 48
6 Zurich Zurich 30 52 44 48
7 St. Gallen St. Gallen 30 50 43 48
8 Lausanne Sports Lausanne 30 62 60 45
9 AC Bellinzona Bellinzona 30 42 39 41
10 Young Boys Young Boys 30 47 45 38
11 Aarau Aarau 30 37 42 35
12 Basel Basel 30 49 62 33
13 Vevey Sports Vevey Sports 30 31 70 26
14 FC Wettingen Wettingen 30 31 48 25
15 Locarno Locarno 30 44 65 25
16 La Chaux-de-Fonds Chaux-de-Fon 30 22 97 7
TEMPORADA 1985/1986
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Young Boys Young Boys 30 72 28 62
2 Neuchâtel Xamax Neuchâtel 30 78 32 60
3 Luzern Luzern 30 56 39 57
4 Zurich Zurich 30 64 43 54
5 Grasshopper Grasshopper 30 64 32 53
6 Aarau Aarau 30 62 47 48
7 Lausanne Sports Lausanne 30 59 50 48
8 Sion Sion 30 54 39 47
9 Servette Servette 30 49 50 45
10 St. Gallen St. Gallen 30 48 46 42
11 Basel Basel 30 44 40 40
12 FC Wettingen Wettingen 30 35 42 32
13 Vevey Sports Vevey Sports 30 36 76 23
14 La Chaux-de-Fonds Chaux-de-Fon 30 24 61 21
15 FC Grenchen FC Grenchen 30 33 81 21
16 Baden Baden 30 14 86 9
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 GRUPO 2
Equipo PJ GF GC Puntos
1 Basel Basel 10 24 11 20
2 Grasshopper Grasshopper 10 21 11 18
3 Servette Servette 10 18 11 16
4 Zurich Zurich 10 17 15 16
5 Sion Sion 10 22 20 14
6 Luzern Luzern 10 4 38 1

  USO DE MEMORIA  
6,453,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5648
Total Execution Time  0.5661
  CADENA URL  
/historico/Basel/1998
  GET DATOS  
$_GET['/historico/Basel/1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0165  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 = 1998 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=10035 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=10035 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=10035 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 = 10084
0.0151  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 = 10086
0.0159  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 = 1998 ORDER BY l.year DESC,cat.coefficient DESC
0.0167  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.0146  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 = 10086 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0156  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 (1997,1998,1999) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (23523,12060,10093) 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.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 10093 AND teamId = 10035
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 23523 AND teamId = 10035
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 12060 AND teamId = 10035
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 FROM `tables1998` 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 = 10084 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0159  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 events1998 e ON e.player_id = p.id AND e.league_id = 10084 WHERE rp.league_id = 10084 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.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 events1998 e ON e.player_id = p.id AND e.league_id = 10084 WHERE rp.league_id = 10084 AND rp.teamId = 10035 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158  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 events1998 e ON e.player_id = p.id AND e.league_id = 10084 WHERE rp.league_id = 10084 AND rp.teamId = 10035 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163  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 <= 1998 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1998` 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 = 10086 AND t.round = 14 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 `tables1996` 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 = 10096 AND t.round = 14 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 `tables1995` 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 = 10099 AND t.round = 22 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 `tables1995` 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 = 10100 AND t.round = 14 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 `tables1994` 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 = 10104 AND t.round = 14 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 `tables1993` 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 = 10109 AND t.round = 14 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 `tables1992` 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 = 10113 AND t.round = 14 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 `tables1988` 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 = 29638 AND t.round = 22 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 `tables1987` 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 = 29640 AND t.round = 30 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 = 10084 ORDER BY nameShow LIMIT 100