4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sarnen
TEMPORADA 2020/2021
QUINTA SUIZA GRUPO 4
Equipo PJ GF GC Puntos
1 Team Ticino U21 Team Ticino 13 24 17 28
2 Taverne Taverne 13 22 8 27
3 Emmenbrücke Emmenbrücke 13 39 17 26
4 Mendrisio-Stabio Mendrisio-St 13 28 15 25
5 Hergiswil Hergiswil 13 26 17 24
6 Brunnen Brunnen 13 18 16 21
7 Ibach Ibach 13 15 18 19
8 Kickers Luzern Kickers 13 25 16 18
9 Perlen-Buchrain Perlen-Buchr 13 20 22 14
10 Gambarogno - Contone Gambarogno 13 13 20 13
11 FC Sursee FC Sursee 13 17 30 13
12 Novazzano Novazzano 13 17 24 12
13 Willisau Willisau 13 18 38 8
14 Sarnen Sarnen 13 9 33 4
TEMPORADA 2019/2020
QUINTA SUIZA GRUPO 4
Equipo PJ GF GC Puntos
1 Willisau Willisau 14 33 16 33
2 Mendrisio-Stabio Mendrisio-St 14 29 14 31
3 Rotkreuz Rotkreuz 14 40 25 28
4 Ibach Ibach 14 22 27 23
5 Novazzano Novazzano 14 33 27 22
6 Emmenbrücke Emmenbrücke 13 30 21 21
7 Gambarogno - Contone Gambarogno 14 17 13 20
8 Kickers Luzern Kickers 14 24 21 20
9 Taverne Taverne 13 20 16 19
10 Perlen-Buchrain Perlen-Buchr 14 27 28 19
11 Hergiswil Hergiswil 14 19 26 19
12 FC Sursee FC Sursee 14 22 27 15
13 Aegeri Aegeri 14 18 31 12
14 Brunnen Brunnen 14 12 34 10
15 Sarnen Sarnen 14 14 34 6
TEMPORADA 2018/2019
QUINTA SUIZA GRUPO 4
Equipo PJ GF GC Puntos
1 FC Paradiso FC Paradiso 26 55 18 65
2 Lugano II Lugano II 26 69 30 61
3 Taverne Taverne 26 50 34 41
4 FC Sursee FC Sursee 26 57 46 38
5 Willisau Willisau 26 58 47 35
6 Novazzano Novazzano 26 46 47 35
7 Ibach Ibach 26 39 41 35
8 Brunnen Brunnen 26 33 41 35
9 Perlen-Buchrain Perlen-Buchr 26 48 51 33
10 Kickers Luzern Kickers 26 43 53 33
11 Sarnen Sarnen 26 34 49 32
12 Hergiswil Hergiswil 26 46 53 31
13 FC Altdorf FC Altdorf 26 31 55 24
14 Eschenbach Eschenbach 26 29 73 7
TEMPORADA 2017/2018
QUINTA SUIZA GRUPO 4
Equipo PJ GF GC Puntos
1 Goldau Goldau 25 75 24 56
2 Hergiswil Hergiswil 25 62 28 56
3 Taverne Taverne 25 50 37 40
4 Novazzano Novazzano 25 32 39 36
5 Ibach Ibach 25 42 34 35
6 Sarnen Sarnen 25 31 47 33
7 Lugano II Lugano II 25 46 41 32
8 Perlen-Buchrain Perlen-Buchr 25 36 51 32
9 Eschenbach Eschenbach 25 42 39 31
10 FC Altdorf FC Altdorf 25 37 40 30
11 Ascona Ascona 25 35 51 30
12 Brunnen Brunnen 25 32 48 30
13 Locarno Locarno 13 22 20 20
14 Hochdorf Hochdorf 25 17 60 9
TEMPORADA 2015/2016
QUINTA SUIZA GRUPO 4
Equipo PJ GF GC Puntos
1 AC Bellinzona Bellinzona 26 75 21 65
2 Team Ticino U21 Team Ticino 26 57 32 48
3 Ascona Ascona 26 46 34 47
4 Goldau Goldau 26 72 53 41
5 Hergiswil Hergiswil 26 55 48 40
6 Ibach Ibach 26 39 34 40
7 Eschenbach Eschenbach 26 41 33 39
8 AS Castello AS Castello 26 43 41 39
9 Taverne Taverne 26 41 34 36
10 Hochdorf Hochdorf 26 36 51 29
11 Kickers Luzern Kickers 26 42 57 27
12 FC Küssnacht am Rigi Küssnacht 26 24 74 21
13 Willisau Willisau 26 48 75 18
14 Sarnen Sarnen 26 22 54 16
TEMPORADA 2014/2015
QUINTA SUIZA GRUPO 4
Equipo PJ GF GC Puntos
1 Buochs Buochs 26 80 24 62
2 SC Zofingen SC Zofingen 26 74 36 59
3 Goldau Goldau 26 75 41 57
4 Ibach Ibach 26 38 28 39
5 Sarnen Sarnen 26 47 46 39
6 Hergiswil Hergiswil 26 51 46 37
7 AS Castello AS Castello 26 37 32 37
8 FC Küssnacht am Rigi Küssnacht 26 36 41 35
9 Hochdorf Hochdorf 26 40 50 34
10 Eschenbach Eschenbach 26 37 46 29
11 Ascona Ascona 26 23 42 28
12 Gunzwil Gunzwil 26 36 67 23
13 Ruswil Ruswil 26 27 64 19
14 Malters Malters 26 27 65 13
TEMPORADA 2013/2014
QUINTA SUIZA GRUPO 4
Equipo PJ GF GC Puntos
1 Taverne Taverne 26 50 18 62
2 Buochs Buochs 26 68 38 54
3 Goldau Goldau 26 61 42 47
4 Ascona Ascona 26 59 44 45
5 Hergiswil Hergiswil 26 59 48 43
6 Sarnen Sarnen 26 45 35 40
7 Gunzwil Gunzwil 26 53 48 39
8 Hochdorf Hochdorf 26 49 45 39
9 Ibach Ibach 26 38 40 31
10 Eschenbach Eschenbach 26 33 47 31
11 Ruswil Ruswil 26 45 50 30
12 Emmenbrücke Emmenbrücke 26 29 42 27
13 Willisau Willisau 26 43 77 19
14 Biaschesi Biaschesi 26 12 70 4
TEMPORADA 2012/2013
QUINTA SUIZA GRUPO 4
Equipo PJ GF GC Puntos
1 FC Sursee FC Sursee 26 61 16 52
2 Eschenbach Eschenbach 26 48 44 47
3 Buochs Buochs 26 64 41 44
4 Ruswil Ruswil 26 50 46 43
5 Ascona Ascona 26 39 36 41
6 Goldau Goldau 26 51 36 40
7 Sarnen Sarnen 26 46 47 40
8 Hergiswil Hergiswil 26 44 49 34
9 Emmenbrücke Emmenbrücke 26 36 42 33
10 Gunzwil Gunzwil 26 35 44 33
11 Ibach Ibach 26 43 51 29
12 Aegeri Aegeri 26 38 56 28
13 Baar Baar 26 22 46 25
14 Kickers Luzern Kickers 26 25 48 21
TEMPORADA 2011/2012
QUINTA SUIZA GRUPO 4
Equipo PJ GF GC Puntos
1 Zug 94 Zug 94 26 67 21 56
2 Hergiswil Hergiswil 26 54 42 48
3 Sarnen Sarnen 26 63 48 46
4 Goldau Goldau 26 57 47 45
5 Buochs Buochs 26 68 50 42
6 Emmenbrücke Emmenbrücke 26 54 42 42
7 FC Sursee FC Sursee 26 46 41 41
8 Ibach Ibach 26 43 40 37
9 Baar Baar 26 42 49 34
10 Ruswil Ruswil 26 42 57 30
11 Eschenbach Eschenbach 26 40 56 29
12 Aegeri Aegeri 26 34 55 27
13 Losone Sportiva Losone 26 25 55 19
14 Vedeggio Calcio Vedeggio 26 31 63 17
TEMPORADA 2010/2011
QUINTA SUIZA GRUPO 4
Equipo PJ GF GC Puntos
1 FC Muri FC Muri 26 51 26 51
2 Aarau II Aarau II 26 77 42 49
3 FC Sursee FC Sursee 26 51 35 49
4 Eschenbach Eschenbach 26 42 43 45
5 Losone Sportiva Losone 26 53 43 44
6 Goldau Goldau 26 52 46 43
7 Ibach Ibach 26 55 38 42
8 Sarnen Sarnen 26 44 41 38
9 Hergiswil Hergiswil 26 50 56 36
10 Emmenbrücke Emmenbrücke 26 45 47 29
11 Aegeri Aegeri 26 46 62 29
12 Kickers Luzern Kickers 26 37 52 26
13 Taverne Taverne 26 23 50 20
14 Balerna Balerna 26 31 76 11
TEMPORADA 2009/2010
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Aarau II Aarau II 26 46 21 56
2 Buochs Buochs 26 62 36 49
3 Losone Sportiva Losone 26 52 38 48
4 Goldau Goldau 26 48 36 41
5 FC Muri FC Muri 26 43 40 38
6 Ibach Ibach 26 32 31 38
7 Sarnen Sarnen 26 37 43 35
8 SC Schöftland Schöftland 26 43 48 32
9 FC Sursee FC Sursee 26 34 40 32
10 Aegeri Aegeri 26 39 44 28
11 Kickers Luzern Kickers 26 32 40 28
12 Olten Olten 26 34 49 28
13 FC Malcantone Malcantone 26 32 43 26
14 Sementina Sementina 26 22 47 20
TEMPORADA 2008/2009
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Lugano II Lugano II 26 77 21 64
2 FC Sursee FC Sursee 26 47 27 52
3 Aarau II Aarau II 26 64 32 51
4 Sarnen Sarnen 26 59 44 49
5 Buochs Buochs 26 45 23 43
6 FC Malcantone Malcantone 25 45 40 42
7 Ibach Ibach 26 46 38 35
8 Losone Sportiva Losone 26 53 50 34
9 Goldau Goldau 26 27 38 27
10 SC Schöftland Schöftland 26 39 58 27
11 Kickers Luzern Kickers 26 38 55 26
12 FC Küssnacht am Rigi Küssnacht 26 38 57 25
13 SAR Rivera SAR Rivera 26 29 49 25
14 FC Brugg FC Brugg 25 15 90 5

  USO DE MEMORIA  
5,885,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.3854
Total Execution Time  0.3876
  CADENA URL  
/historico/Sarnen
  GET DATOS  
$_GET['/historico/Sarnen']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
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 = 57523
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60238 AND type_rel = 2
0.0148  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 = '60238' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = '60238' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 60238 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2021` 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 = 57523 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `tables2020` 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 = 50506 AND t.round = 15 ORDER BY team.conference ASC,t.position 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 `tables2019` 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 = 44265 AND t.round = 26 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 `tables2018` 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 = 39724 AND t.round = 26 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 `tables2016` 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 = 15881 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168  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 `tables2015` 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 = 9203 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `tables2014` 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 = 27115 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `tables2013` 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 = 27129 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 `tables2012` 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 = 27134 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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 `tables2011` 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 = 27148 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2010` 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 = 27146 AND t.round = 26 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 `tables2009` 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 = 27156 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC