Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Zurich Zurich 36 78 46 76
2 Basel Basel 36 70 41 62
3 Young Boys Young Boys 36 80 50 60
4 FC Lugano FC Lugano 36 50 54 54
5 St. Gallen St. Gallen 36 68 63 50
6 Servette Servette 36 50 66 44
7 Sion Sion 36 46 67 41
8 Grasshopper Grasshopper 36 54 58 40
9 Luzern Luzern 36 52 64 40
10 Lausanne Sports Lausanne 36 37 76 22
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Young Boys Young Boys 36 74 29 84
2 Basel Basel 36 60 53 53
3 Servette Servette 36 45 56 50
4 FC Lugano FC Lugano 36 40 42 49
5 Luzern Luzern 36 62 59 46
6 Lausanne Sports Lausanne 36 52 55 46
7 St. Gallen St. Gallen 36 45 48 44
8 Zurich Zurich 36 53 57 43
9 Sion Sion 36 48 58 38
10 FC Vaduz FC Vaduz 36 36 58 36
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Young Boys Young Boys 36 80 41 76
2 St. Gallen St. Gallen 36 79 56 68
3 Basel Basel 36 74 38 62
4 Servette Servette 36 57 48 49
5 FC Lugano FC Lugano 36 46 46 47
6 Luzern Luzern 36 42 50 46
7 Zurich Zurich 36 45 72 43
8 Sion Sion 36 40 55 39
9 Thun Thun 36 45 67 38
10 Neuchâtel Xamax Neuchâtel 36 33 68 27
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Young Boys Young Boys 36 99 36 91
2 Basel Basel 36 71 46 71
3 FC Lugano FC Lugano 36 50 49 46
4 Thun Thun 36 57 58 46
5 Luzern Luzern 36 56 61 46
6 St. Gallen St. Gallen 36 49 58 46
7 Zurich Zurich 36 43 52 44
8 Sion Sion 36 50 55 43
9 Neuchâtel Xamax Neuchâtel 36 44 65 37
10 Grasshopper Grasshopper 36 32 71 25
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Young Boys Young Boys 36 84 41 84
2 Basel Basel 36 72 36 69
3 Luzern Luzern 36 51 51 54
4 Zurich Zurich 36 50 44 49
5 St. Gallen St. Gallen 36 52 72 45
6 Sion Sion 36 53 56 42
7 Thun Thun 36 52 68 42
8 FC Lugano FC Lugano 36 38 55 42
9 Grasshopper Grasshopper 36 43 52 39
10 Lausanne Sports Lausanne 36 46 66 35
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Basel Basel 36 92 35 86
2 Young Boys Young Boys 36 72 44 69
3 FC Lugano FC Lugano 36 52 61 53
4 Sion Sion 36 60 55 51
5 Luzern Luzern 36 62 66 50
6 Thun Thun 36 58 63 45
7 St. Gallen St. Gallen 36 43 57 41
8 Grasshopper Grasshopper 36 47 61 38
9 Lausanne Sports Lausanne 36 51 62 35
10 FC Vaduz FC Vaduz 36 45 78 30
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Basel Basel 36 88 38 83
2 Young Boys Young Boys 36 78 47 69
3 Luzern Luzern 36 59 50 54
4 Grasshopper Grasshopper 36 65 56 53
5 Sion Sion 36 52 49 50
6 Thun Thun 36 45 54 41
7 St. Gallen St. Gallen 36 41 66 38
8 FC Vaduz FC Vaduz 36 44 60 36
9 FC Lugano FC Lugano 36 46 75 35
10 Zurich Zurich 36 48 71 34
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Basel Basel 36 84 41 78
2 Young Boys Young Boys 36 64 45 66
3 Zurich Zurich 36 55 48 53
4 Thun Thun 36 47 45 52
5 Luzern Luzern 36 54 46 47
6 St. Gallen St. Gallen 36 57 65 47
7 Grasshopper Grasshopper 36 50 56 43
8 Sion Sion 36 47 51 42
9 Aarau Aarau 36 34 64 33
10 FC Vaduz FC Vaduz 36 28 59 31
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Basel Basel 36 70 34 72
2 Grasshopper Grasshopper 36 67 43 65
3 Young Boys Young Boys 36 59 50 59
4 Luzern Luzern 36 48 54 51
5 Zurich Zurich 36 51 52 50
6 Thun Thun 36 57 53 48
7 St. Gallen St. Gallen 36 37 47 45
8 Sion Sion 36 38 45 43
9 Aarau Aarau 36 55 71 42
10 Lausanne Sports Lausanne 36 38 71 24
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Basel Basel 36 61 31 72
2 Grasshopper Grasshopper 36 48 32 69
3 St. Gallen St. Gallen 36 54 36 59
4 Zurich Zurich 36 62 48 55
5 Thun Thun 36 44 46 48
6 Sion Sion 36 40 54 48
7 Young Boys Young Boys 36 48 50 43
8 Luzern Luzern 36 41 52 42
9 Lausanne Sports Lausanne 36 32 51 33
10 Servette Servette 36 32 62 26
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Basel Basel 34 78 33 74
2 Luzern Luzern 34 46 32 54
3 Young Boys Young Boys 34 52 38 51
4 Servette Servette 34 45 53 48
5 Thun Thun 34 38 41 43
6 Zurich Zurich 34 43 44 41
7 Lausanne Sports Lausanne 34 29 61 30
8 Grasshopper Grasshopper 34 32 66 26
9 Neuchâtel Xamax Neuchâtel 18 22 22 26
10 Sion Sion 34 40 35 17
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Basel Basel 36 76 44 73
2 Zurich Zurich 36 74 44 72
3 Young Boys Young Boys 36 65 50 57
4 Sion Sion 36 47 36 54
5 Thun Thun 36 48 43 49
6 Luzern Luzern 36 62 57 48
7 Grasshopper Grasshopper 36 45 54 41
8 Neuchâtel Xamax Neuchâtel 36 44 67 32
9 AC Bellinzona Bellinzona 36 42 75 32
10 St. Gallen St. Gallen 36 34 67 31
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Basel Basel 36 90 46 80
2 Young Boys Young Boys 36 78 47 77
3 Grasshopper Grasshopper 36 65 43 65
4 Luzern Luzern 36 66 55 58
5 Sion Sion 36 63 57 51
6 St. Gallen St. Gallen 36 53 56 46
7 Zurich Zurich 36 55 58 45
8 Neuchâtel Xamax Neuchâtel 36 55 57 41
9 AC Bellinzona Bellinzona 36 42 92 25
10 Aarau Aarau 36 32 88 23
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Zurich Zurich 36 80 36 79
2 Young Boys Young Boys 36 85 46 73
3 Basel Basel 36 72 44 72
4 Grasshopper Grasshopper 36 57 48 50
5 Aarau Aarau 36 35 51 44
6 AC Bellinzona Bellinzona 36 44 51 43
7 Neuchâtel Xamax Neuchâtel 36 50 57 40
8 Sion Sion 36 44 60 37
9 Luzern Luzern 36 45 62 35
10 FC Vaduz FC Vaduz 36 28 85 22
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Basel Basel 36 73 39 74
2 Young Boys Young Boys 36 82 49 70
3 Zurich Zurich 36 58 43 56
4 Grasshopper Grasshopper 36 57 49 54
5 Aarau Aarau 36 47 48 47
6 Luzern Luzern 36 40 49 44
7 Sion Sion 36 48 51 43
8 Neuchâtel Xamax Neuchâtel 36 48 55 41
9 St. Gallen St. Gallen 36 39 69 34
10 Thun Thun 36 30 70 27
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Zurich Zurich 36 67 32 75
2 Basel Basel 36 77 40 74
3 Sion Sion 36 57 42 60
4 Young Boys Young Boys 36 52 42 59
5 St. Gallen St. Gallen 36 47 44 55
6 Grasshopper Grasshopper 36 54 41 50
7 Thun Thun 36 30 58 37
8 Luzern Luzern 36 31 58 33
9 Aarau Aarau 36 28 55 26
10 Schaffhausen Schaffhausen 36 27 58 25
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Zurich Zurich 36 86 36 78
2 Basel Basel 36 87 42 78
3 Young Boys Young Boys 36 60 46 62
4 Grasshopper Grasshopper 36 44 33 55
5 Thun Thun 36 50 53 49
6 St. Gallen St. Gallen 36 51 56 40
7 Aarau Aarau 36 29 63 35
8 Schaffhausen Schaffhausen 36 32 55 33
9 Neuchâtel Xamax Neuchâtel 36 41 70 33
10 Yverdon Yverdon 36 38 64 32
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Basel Basel 34 81 45 70
2 Thun Thun 34 69 42 60
3 Grasshopper Grasshopper 34 51 50 50
4 Young Boys Young Boys 34 60 52 49
5 Zurich Zurich 34 55 57 48
6 Neuchâtel Xamax Neuchâtel 34 36 48 38
7 St. Gallen St. Gallen 34 51 60 36
8 Aarau Aarau 34 42 64 32
9 Schaffhausen Schaffhausen 34 36 59 32
10 Servette Servette 18 24 28 20
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Basel Basel 36 86 32 85
2 Young Boys Young Boys 36 75 48 72
3 Servette Servette 36 61 62 52
4 Zurich Zurich 36 58 52 50
5 St. Gallen St. Gallen 36 54 57 50
6 Thun Thun 36 51 57 49
7 Grasshopper Grasshopper 36 62 74 41
8 Aarau Aarau 36 57 69 38
9 Neuchâtel Xamax Neuchâtel 36 46 63 36
10 FC Wil FC Wil 36 37 73 29
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Grasshopper Grasshopper 22 58 26 49
2 Basel Basel 22 57 25 47
3 Thun Thun 22 33 33 31
4 FC Wil FC Wil 22 43 45 31
5 Zurich Zurich 22 35 37 31
6 Neuchâtel Xamax Neuchâtel 22 30 33 31
7 Young Boys Young Boys 22 41 41 30
8 Servette Servette 22 45 37 29
9 Luzern Luzern 22 31 38 26
10 St. Gallen St. Gallen 22 31 48 24
11 Delemont Delemont 22 24 44 20
12 Aarau Aarau 22 19 40 18
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Basel Basel 22 52 37 43
2 FC Lugano FC Lugano 22 39 33 38
3 Grasshopper Grasshopper 22 50 33 37
4 Sion Sion 22 41 26 36
5 Servette Servette 22 36 29 34
6 St. Gallen St. Gallen 22 35 33 32
7 Young Boys Young Boys 22 35 28 31
8 Zurich Zurich 22 24 27 30
9 Aarau Aarau 22 28 25 27
10 Neuchâtel Xamax Neuchâtel 22 28 36 25
11 Lausanne Sports Lausanne 22 24 49 16
12 Luzern Luzern 22 23 59 13
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 FC Lugano FC Lugano 22 33 16 42
2 St. Gallen St. Gallen 22 43 18 40
3 Grasshopper Grasshopper 22 46 25 36
4 Lausanne Sports Lausanne 22 37 34 35
5 Basel Basel 22 42 36 34
6 Servette Servette 22 34 26 33
7 Sion Sion 22 27 31 32
8 Zurich Zurich 22 36 29 31
9 Aarau Aarau 22 31 43 24
10 Yverdon Yverdon 22 27 43 21
11 Neuchâtel Xamax Neuchâtel 22 21 53 20
12 Luzern Luzern 22 27 50 19
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,704,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.5549
Total Execution Time  0.5577
  CADENA URL  
/suiza2022/grupo1/historico
  GET DATOS  
$_GET['/suiza2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0106  SELECT type FROM routes WHERE alias = 'suiza2022'
0.0216  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'suiza' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=36 AND type_rel = 3
0.0112  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 36 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  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 (1295393,1287617,1287396,1279364,1277727) ORDER BY n.cover_points DESC, update_date DESC
0.0106  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63179 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 36 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0110  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 = 63179 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 58545 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 49949 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 43608 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 38676 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 33333 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 15573 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 3821 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 2420 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 2039 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 1358 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 1094 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 874 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 457 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 675 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 `tables2007` 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 = 676 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  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 `tables2006` 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 = 677 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 `tables2005` 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 = 678 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124  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 `tables2004` 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 = 679 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123  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 `tables2003` 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 = 680 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124  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 `tables2002` 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 = 681 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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 `tables2001` 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 = 682 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 07:22:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0115  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 07:22:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0114  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 07:22:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0113  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 07:22:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'suiza' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0245  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 events2022 e ON e.player_id = p.id AND e.league_id = 63179 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63179 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.0223  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 events2022 e ON e.player_id = p.id AND e.league_id = 63179 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63179 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0114  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 events2022 e ON e.player_id = p.id AND e.league_id = 63179 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63179 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0115  SELECT *,(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 = 63179 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC