4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Grand-Saconnex Grand-Saconn 27 57 29 58
2 Sion II Sion II 27 67 41 46
3 Lausanne Sport II Lausanne 27 49 31 46
4 Yverdon Sport II Yverdon 27 54 36 45
5 Vevey Sports Vevey Sports 27 49 26 44
6 Echallens Echallens 27 49 46 42
7 CS Chênois CS Chênois 27 45 37 40
8 Naters Naters 27 46 45 36
9 Meyrin Meyrin 27 44 48 36
10 Coffrane Coffrane 27 39 58 35
11 La Chaux-de-Fonds Chaux-de-Fon 27 38 45 33
12 FC Monthey FC Monthey 27 33 35 31
13 Portalban / Gletterens Portalban 26 33 52 30
14 La Sarraz-Eclépens Sarraz-Eclé 27 32 49 29
15 Pully Football Pully 26 32 62 19
16 Terre Sainte Terre Sainte 27 31 58 17
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Servette II Servette II 30 97 27 77
2 FC Monthey FC Monthey 30 61 55 55
3 Vevey Sports Vevey Sports 30 54 36 54
4 Meyrin Meyrin 30 62 37 52
5 La Chaux-de-Fonds Chaux-de-Fon 30 47 33 50
6 Echallens Echallens 30 54 52 48
7 CS Chênois CS Chênois 30 48 49 42
8 Terre Sainte Terre Sainte 30 43 52 38
9 Coffrane Coffrane 30 39 53 37
10 Sion II Sion II 30 44 48 34
11 Grand-Saconnex Grand-Saconn 30 43 62 33
12 La Sarraz-Eclépens Sarraz-Eclé 30 45 52 32
13 Naters Naters 30 36 52 32
14 Portalban / Gletterens Portalban 30 37 55 32
15 Concordia Lausanne Concordia 30 42 66 28
16 Martigny Martigny 30 36 59 26
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Echallens Echallens 26 56 34 55
2 Vevey Sports Vevey Sports 26 42 29 51
3 Bulle Bulle 26 63 23 48
4 Thun II Thun II 26 56 38 46
5 Meyrin Meyrin 26 47 33 41
6 FC Monthey FC Monthey 26 41 47 37
7 Naters Naters 26 41 42 33
8 CS Chênois CS Chênois 26 38 46 33
9 La Chaux-de-Fonds Chaux-de-Fon 26 40 54 33
10 La Sarraz-Eclépens Sarraz-Eclé 26 50 61 30
11 Terre Sainte Terre Sainte 26 36 54 28
12 Martigny Martigny 26 34 65 28
13 Lausanne Sport II Lausanne 26 44 51 27
14 Lancy FC Lancy FC 26 40 51 25
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Young Boys II Young Boys 13 60 16 36
2 CS Chênois CS Chênois 13 22 19 27
3 Bulle Bulle 13 38 20 26
4 Lausanne Sport II Lausanne 13 29 20 24
5 Echallens Echallens 12 26 19 22
6 La Chaux-de-Fonds Chaux-de-Fon 13 24 24 19
7 Naters Naters 13 25 21 18
8 Lancy FC Lancy FC 13 19 18 18
9 Vevey Sports Vevey Sports 12 21 29 18
10 Meyrin Meyrin 13 22 28 15
11 Terre Sainte Terre Sainte 13 21 37 13
12 Martigny Martigny 12 13 34 9
13 FC Azzurri 90 Azzurri 13 17 31 7
14 Olympique de Geneve Olympique 12 7 28 7
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Lausanne Sport II Lausanne 13 36 17 29
2 Naters Naters 14 25 14 27
3 Meyrin Meyrin 14 26 24 25
4 Bulle Bulle 14 30 19 24
5 Echallens Echallens 13 29 14 22
6 Young Boys II Young Boys 14 34 21 22
7 Vevey Sports Vevey Sports 14 24 22 22
8 Olympique de Geneve Olympique 14 17 17 18
9 Lancy FC Lancy FC 14 24 31 18
10 Martigny Martigny 14 22 27 17
11 CS Chênois CS Chênois 14 19 27 13
12 Terre Sainte Terre Sainte 14 18 33 13
13 La Chaux-de-Fonds Chaux-de-Fon 14 13 27 12
14 FC Azzurri 90 Azzurri 14 8 32 2
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Etoile Carouge Etoile 26 52 31 52
2 Lausanne Sport II Lausanne 26 57 37 48
3 Martigny Martigny 26 46 31 48
4 Meyrin Meyrin 26 55 37 46
5 Lancy FC Lancy FC 26 54 49 45
6 Young Boys II Young Boys 26 48 34 42
7 Echallens Echallens 26 59 52 42
8 Vevey Sports Vevey Sports 26 44 30 41
9 Bulle Bulle 26 44 38 34
10 CS Chênois CS Chênois 26 37 51 31
11 Naters Naters 26 39 46 28
12 FC Azzurri 90 Azzurri 26 31 54 24
13 Thun II Thun II 26 36 57 21
14 Fribourg Fribourg 26 17 72 6
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Young Boys II Young Boys 26 57 29 51
2 Meyrin Meyrin 26 56 36 50
3 Lancy FC Lancy FC 26 65 46 47
4 Echallens Echallens 26 40 44 42
5 Lausanne Sport II Lausanne 26 50 37 41
6 Vevey Sports Vevey Sports 26 43 40 38
7 Naters Naters 26 45 42 37
8 Etoile Carouge Etoile 26 60 48 37
9 Martigny Martigny 26 48 54 36
10 Fribourg Fribourg 26 39 51 35
11 Thun II Thun II 26 41 55 28
12 FC Azzurri 90 Azzurri 26 44 66 27
13 Dudingen Dudingen 26 39 56 22
14 Portalban / Gletterens Portalban 26 31 54 20
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Yverdon Yverdon 26 63 27 62
2 Stade Lausanne-Ouchy Stade 26 54 26 51
3 Lancy FC Lancy FC 26 51 34 44
4 Echallens Echallens 26 44 50 40
5 Young Boys II Young Boys 26 57 42 39
6 Martigny Martigny 26 48 57 33
7 Naters Naters 26 40 41 32
8 FC Azzurri 90 Azzurri 26 38 45 31
9 Etoile Carouge Etoile 26 52 55 30
10 Vevey Sports Vevey Sports 26 34 46 29
11 Lausanne Sport II Lausanne 26 52 52 28
12 Dudingen Dudingen 26 31 54 28
13 Fribourg Fribourg 26 38 54 27
14 La Sarraz-Eclépens Sarraz-Eclé 26 37 56 26
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Stade Lausanne-Ouchy Stade 26 47 24 53
2 La Chaux-de-Fonds Chaux-de-Fon 26 59 26 48
3 Bavois Bavois 26 61 45 45
4 FC Azzurri 90 Azzurri 26 50 31 41
5 Yverdon Yverdon 26 37 34 38
6 Lancy FC Lancy FC 26 32 31 38
7 Fribourg Fribourg 26 42 34 34
8 Dudingen Dudingen 26 48 46 33
9 Naters Naters 26 42 43 33
10 Martigny Martigny 26 33 51 33
11 Echallens Echallens 26 32 58 32
12 Lausanne Sport II Lausanne 26 41 42 29
13 Terre Sainte Terre Sainte 26 40 54 26
14 Signal Bernex-Confignon Signal 26 27 72 20
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Stade Lausanne-Ouchy Stade 26 45 28 48
2 Yverdon Yverdon 26 58 42 47
3 Bavois Bavois 26 51 32 46
4 FC Azzurri 90 Azzurri 26 46 36 44
5 Lausanne Sport II Lausanne 26 39 31 41
6 Echallens Echallens 26 40 34 41
7 Dudingen Dudingen 26 50 41 39
8 Fribourg Fribourg 26 38 36 38
9 Lancy FC Lancy FC 26 33 36 34
10 Naters Naters 26 29 39 30
11 Terre Sainte Terre Sainte 26 38 46 28
12 Martigny Martigny 26 43 58 28
13 Meyrin Meyrin 26 31 43 27
14 FC Monthey FC Monthey 26 25 64 10
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Dudingen Dudingen 26 46 31 49
2 Naters Naters 26 42 30 45
3 Fribourg Fribourg 26 44 29 44
4 FC Azzurri 90 Azzurri 26 43 29 40
5 Young Boys II Young Boys 26 40 32 38
6 Echallens Echallens 26 37 37 36
7 Yverdon Yverdon 26 38 36 33
8 Martigny Martigny 26 48 49 33
9 Bavois Bavois 26 39 48 33
10 Lancy FC Lancy FC 26 28 39 32
11 Meyrin Meyrin 26 37 44 31
12 Terre Sainte Terre Sainte 26 33 45 29
13 FC Monthey FC Monthey 26 39 57 29
14 Bulle Bulle 26 31 39 28
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Le Mont LS Le Mont LS 26 69 27 63
2 Young Boys II Young Boys 26 82 36 54
3 Terre Sainte Terre Sainte 26 46 26 51
4 Meyrin Meyrin 26 57 32 48
5 Dudingen Dudingen 26 58 43 45
6 Echallens Echallens 26 73 49 44
7 Thun II Thun II 26 43 39 37
8 Martigny Martigny 26 52 58 35
9 Naters Naters 26 45 44 34
10 Lancy FC Lancy FC 26 41 47 32
11 FC Monthey FC Monthey 26 51 53 29
12 Bulle Bulle 26 39 67 25
13 Urania Genève Sport Urania 26 33 67 22
14 FC Malley FC Malley 26 25 126 4
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Sion II Sion II 30 70 41 56
2 Young Boys II Young Boys 30 74 50 52
3 Fribourg Fribourg 30 52 40 52
4 Yverdon Yverdon 30 53 44 52
5 Le Mont LS Le Mont LS 30 51 45 51
6 Grand-Lancy Grand-Lancy 30 56 44 48
7 Meyrin Meyrin 30 57 42 45
8 Dudingen Dudingen 30 63 59 45
9 Echallens Echallens 30 62 49 44
10 Martigny Martigny 30 51 50 41
11 FC Malley FC Malley 30 66 61 38
12 Bulle Bulle 30 46 59 37
13 Urania Genève Sport Urania 30 51 67 36
14 FC Monthey FC Monthey 30 50 66 30
15 Naters Naters 30 42 72 29
16 FC Baulmes FC Baulmes 30 25 80 14
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Meyrin Meyrin 30 74 38 66
2 Etoile Carouge Etoile 30 57 35 57
3 Le Mont LS Le Mont LS 30 62 43 51
4 FC Malley FC Malley 30 56 32 50
5 Grand-Lancy Grand-Lancy 30 43 42 46
6 Fribourg Fribourg 30 48 46 45
7 Urania Genève Sport Urania 30 48 53 44
8 Dudingen Dudingen 30 57 68 41
9 Echallens Echallens 30 47 52 39
10 Martigny Martigny 30 36 46 36
11 Young Boys II Young Boys 30 40 46 35
12 Sion II Sion II 30 44 51 33
13 FC Baulmes FC Baulmes 30 36 48 33
14 Naters Naters 30 51 65 32
15 Terre Sainte Terre Sainte 30 31 45 32
16 CS Chênois CS Chênois 30 35 55 29
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Sion II Sion II 30 66 50 54
2 FC Malley FC Malley 30 65 45 53
3 CS Chênois CS Chênois 30 46 40 48
4 Dudingen Dudingen 30 62 49 47
5 Etoile Carouge Etoile 30 60 54 46
6 Martigny Martigny 30 46 46 46
7 Meyrin Meyrin 30 64 51 45
8 Fribourg Fribourg 30 54 46 44
9 Echallens Echallens 30 59 52 44
10 Naters Naters 30 53 61 37
11 FC Baulmes FC Baulmes 30 53 76 36
12 Young Boys II Young Boys 30 48 58 34
13 Urania Genève Sport Urania 30 49 62 34
14 Grand-Lancy Grand-Lancy 30 43 62 34
15 Bavois Bavois 30 43 55 32
16 Bulle Bulle 30 46 50 28
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Etoile Carouge Etoile 30 71 34 66
2 Le Mont LS Le Mont LS 30 72 45 62
3 FC Malley FC Malley 30 80 39 60
4 Fribourg Fribourg 30 56 34 56
5 Meyrin Meyrin 30 61 51 50
6 Bulle Bulle 30 53 50 48
7 CS Chênois CS Chênois 30 54 42 42
8 Young Boys II Young Boys 30 51 56 36
9 Echallens Echallens 30 39 46 36
10 Naters Naters 30 43 48 35
11 FC Baulmes FC Baulmes 30 49 69 34
12 Martigny Martigny 30 41 62 34
13 Sion II Sion II 30 46 58 33
14 Urania Genève Sport Urania 30 50 64 33
15 Dudingen Dudingen 30 32 53 27
16 La Tour / Le Pâquier Tour 30 32 79 17
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Stade Nyonnais Stade 30 59 25 69
2 FC Baulmes FC Baulmes 30 66 26 63
3 Urania Genève Sport Urania 30 54 39 55
4 Etoile Carouge Etoile 30 65 38 49
5 Echallens Echallens 31 40 33 45
6 Meyrin Meyrin 31 42 44 43
7 Bulle Bulle 30 60 52 42
8 Fribourg Fribourg 30 53 49 41
9 FC Malley FC Malley 30 47 42 40
10 Dudingen Dudingen 30 36 44 38
11 Martigny Martigny 31 41 58 38
12 Naters Naters 30 35 45 37
13 La Tour / Le Pâquier Tour 31 40 52 35
14 Sion II Sion II 29 41 46 34
15 Serrieres Neuchatel Serrieres 29 36 48 33
16 Bex Bex 30 37 53 31
17 FC Savièse FC Savièse 30 30 88 12

  USO DE MEMORIA  
7,004,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.6218
Total Execution Time  0.6236
  CADENA URL  
/erste_liga_suiza2024/grupo1/historico
  GET DATOS  
$_GET['/erste_liga_suiza2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0128  SELECT type FROM routes WHERE alias = 'erste_liga_suiza2024'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'erste_liga_suiza' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=357 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 357 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  SELECT /*53 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 (846170,837416,414538,44513,905) ORDER BY n.cover_points DESC, update_date DESC
0.0129  SELECT id,name,alias,stepParent FROM categories WHERE parentId=357 ORDER BY order_id ASC
0.0139  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 357 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables2024` 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 = 72692 AND t.round = 27 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 `tables2023` 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 = 68182 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `tables2022` 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 = 63495 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.0132  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 = 56980 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.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 `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 = 50256 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 44258 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 38830 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 `tables2017` 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 = 33463 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 15803 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 4461 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 = 2799 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 27074 AND t.round = 26 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 `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 = 27078 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 27081 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 27085 AND t.round = 30 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 `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 = 27090 AND t.round = 30 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 `tables2008` 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 = 27094 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 09:18:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 09:18:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 09:18:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 09:18:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'erste_liga_suiza' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0606  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72692 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72692 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0277  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72692 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72692 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72692 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72692 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 72692 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC