4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Servette

Servette

Entrenador: René Weiler

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Young Boys Young Boys 33 67 32 65
2 FC Lugano FC Lugano 33 61 44 59
3 Servette Servette 33 53 38 57
4 St. Gallen St. Gallen 33 53 44 50
5 Winterthur Winterthur 33 55 56 49
6 Zurich Zurich 33 44 35 48
TEMPORADA 2022/2023
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Young Boys Young Boys 36 82 30 74
2 Servette Servette 36 53 48 58
3 FC Lugano FC Lugano 36 59 47 57
4 Luzern Luzern 36 56 52 50
5 Basel Basel 36 51 50 47
6 St. Gallen St. Gallen 36 66 52 45
7 Grasshopper Grasshopper 36 56 64 44
8 Zurich Zurich 36 41 55 44
9 Winterthur Winterthur 36 32 66 32
10 Sion Sion 36 41 73 31
TEMPORADA 2021/2022
LIGA SUIZA
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
TEMPORADA 2020/2021
LIGA SUIZA
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
TEMPORADA 2019/2020
LIGA SUIZA
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
TEMPORADA 2018/2019
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 Servette Servette 36 90 37 79
2 Aarau Aarau 36 63 46 64
3 Lausanne Sports Lausanne 36 64 37 63
4 Winterthur Winterthur 36 57 51 56
5 FC Wil FC Wil 36 33 47 42
6 FC Vaduz FC Vaduz 36 48 70 42
7 Schaffhausen Schaffhausen 36 43 62 39
8 Kriens Kriens 36 46 58 36
9 Chiasso Chiasso 36 43 67 36
10 Rapperswil Rapperswil 36 47 59 35
TEMPORADA 2017/2018
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 Neuchâtel Xamax Neuchâtel 36 82 39 85
2 Schaffhausen Schaffhausen 36 70 51 64
3 Servette Servette 36 56 38 62
4 FC Vaduz FC Vaduz 36 66 50 59
5 Rapperswil Rapperswil 36 53 45 56
6 Aarau Aarau 36 53 62 44
7 FC Wil FC Wil 36 40 50 39
8 Chiasso Chiasso 36 42 60 36
9 Winterthur Winterthur 36 45 60 32
10 Wohlen Wohlen 36 41 93 18
TEMPORADA 2016/2017
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 Zurich Zurich 36 91 30 85
2 Neuchâtel Xamax Neuchâtel 36 66 36 73
3 Servette Servette 36 55 43 62
4 Schaffhausen Schaffhausen 36 64 59 51
5 Aarau Aarau 36 57 64 45
6 Winterthur Winterthur 36 45 62 41
7 Wohlen Wohlen 36 42 60 39
8 Chiasso Chiasso 36 43 63 37
9 Le Mont LS Le Mont LS 36 31 54 35
10 FC Wil FC Wil 36 35 58 34
TEMPORADA 2015/2016
TERCERA SUIZA
Equipo PJ GF GC Puntos
1 Servette Servette 30 61 26 66
2 SC Cham SC Cham 30 72 48 56
3 Kriens Kriens 30 47 35 54
4 FC Basel II FC Basel II 30 65 52 50
5 Old Boys Old Boys 30 60 49 49
6 Rapperswil Rapperswil 30 41 33 46
7 Stade Nyonnais Stade 30 46 45 39
8 Breitenrain Breitenrain 30 48 49 39
9 SC Bruhl SC Bruhl 30 52 52 38
10 YF Juventus YF Juventus 30 47 55 36
11 FC Zurich II Zurich 30 57 65 35
12 Tuggen Tuggen 30 41 59 35
13 FC Koniz FC Koniz 30 49 52 34
14 Sion II Sion II 30 27 47 31
15 St. Gallen II Gallen 30 40 51 30
16 Etoile Carouge Etoile 30 33 68 25
TEMPORADA 2014/2015
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 FC Lugano FC Lugano 36 64 31 74
2 Servette Servette 36 51 39 67
3 Wohlen Wohlen 36 56 43 64
4 Winterthur Winterthur 36 65 49 53
5 Schaffhausen Schaffhausen 36 55 54 47
6 Lausanne Sports Lausanne 36 47 57 44
7 Le Mont LS Le Mont LS 36 39 56 39
8 Chiasso Chiasso 36 30 49 39
9 FC Wil FC Wil 36 47 63 37
10 Biel-Bienne Biel-Bienne 36 39 52 33
TEMPORADA 2013/2014
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 FC Vaduz FC Vaduz 36 71 34 73
2 FC Lugano FC Lugano 36 55 46 64
3 FC Wil FC Wil 36 74 45 63
4 Schaffhausen Schaffhausen 36 57 40 62
5 Servette Servette 36 49 48 61
6 Winterthur Winterthur 36 45 50 42
7 Biel-Bienne Biel-Bienne 36 56 68 37
8 Chiasso Chiasso 36 35 52 33
9 Wohlen Wohlen 36 47 67 32
10 Locarno Locarno 36 31 70 26
TEMPORADA 2012/2013
LIGA SUIZA
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
TEMPORADA 2011/2012
LIGA SUIZA
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
TEMPORADA 2010/2011
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 Lausanne Sports Lausanne 30 67 28 65
2 Servette Servette 30 75 27 62
3 FC Lugano FC Lugano 30 56 35 62
4 FC Vaduz FC Vaduz 30 59 41 60
5 FC Wil FC Wil 30 45 42 46
6 Stade Nyonnais Stade 30 48 51 46
7 Chiasso Chiasso 30 34 37 41
8 Delemont Delemont 30 47 60 40
9 Biel-Bienne Biel-Bienne 30 57 57 39
10 Wohlen Wohlen 30 45 44 37
11 Aarau Aarau 30 39 51 36
12 Kriens Kriens 30 26 50 33
13 Winterthur Winterthur 30 42 51 32
14 Locarno Locarno 30 40 52 31
15 Schaffhausen Schaffhausen 30 36 53 26
16 Yverdon Yverdon 30 27 64 20
TEMPORADA 2009/2010
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 Thun Thun 30 70 36 60
2 FC Lugano FC Lugano 30 65 29 59
3 Winterthur Winterthur 30 69 46 56
4 Servette Servette 30 49 37 52
5 Kriens Kriens 30 50 41 46
6 FC Wil FC Wil 30 44 37 45
7 Biel-Bienne Biel-Bienne 30 54 39 42
8 FC Vaduz FC Vaduz 30 44 43 41
9 Yverdon Yverdon 30 50 38 39
10 Lausanne Sports Lausanne 30 40 43 39
11 Schaffhausen Schaffhausen 30 42 51 39
12 Wohlen Wohlen 30 44 55 31
13 Locarno Locarno 30 46 65 31
14 Stade Nyonnais Stade 30 36 64 31
15 Le Mont LS Le Mont LS 30 30 56 27
16 FC Gossau FC Gossau 30 27 80 13
TEMPORADA 2008/2009
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 St. Gallen St. Gallen 30 78 22 78
2 FC Lugano FC Lugano 30 72 30 70
3 FC Wil FC Wil 30 41 25 51
4 Yverdon Yverdon 30 52 41 51
5 Biel-Bienne Biel-Bienne 30 58 53 47
6 Wohlen Wohlen 30 43 47 45
7 Lausanne Sports Lausanne 30 41 43 41
8 Concordia Basel Concordia 30 48 51 40
9 Thun Thun 30 54 65 38
10 Winterthur Winterthur 30 45 46 36
11 Schaffhausen Schaffhausen 30 40 45 34
12 La Chaux-de-Fonds Chaux-de-Fon 30 39 46 33
13 Servette Servette 30 31 46 31
14 Stade Nyonnais Stade 30 26 56 28
15 Locarno Locarno 30 46 56 26
16 FC Gossau FC Gossau 30 27 69 19
TEMPORADA 2007/2008
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 FC Vaduz FC Vaduz 34 75 40 70
2 AC Bellinzona Bellinzona 34 74 39 69
3 FC Wil FC Wil 34 63 35 68
4 Wohlen Wohlen 34 65 46 56
5 Winterthur Winterthur 34 59 56 51
6 Schaffhausen Schaffhausen 34 53 40 49
7 Concordia Basel Concordia 34 55 54 49
8 Servette Servette 34 55 46 46
9 FC Lugano FC Lugano 34 61 63 46
10 Yverdon Yverdon 34 39 35 43
11 FC Gossau FC Gossau 34 50 54 43
12 La Chaux-de-Fonds Chaux-de-Fon 34 53 63 43
13 Lausanne Sports Lausanne 34 46 47 42
14 Locarno Locarno 34 37 61 41
15 Kriens Kriens 34 43 54 38
16 Delemont Delemont 34 42 58 37
17 Chiasso Chiasso 34 43 68 33
18 SC Cham SC Cham 34 31 85 16
TEMPORADA 2006/2007
SEGUNDA SUIZA
Equipo PJ GF GC Puntos
1 Neuchâtel Xamax Neuchâtel 34 73 28 76
2 AC Bellinzona Bellinzona 34 58 26 70
3 Kriens Kriens 34 65 36 67
4 Chiasso Chiasso 34 55 39 58
5 Concordia Basel Concordia 34 59 49 57
6 Winterthur Winterthur 34 60 47 55
7 Servette Servette 34 63 51 53
8 FC Wil FC Wil 34 56 50 46
9 FC Vaduz FC Vaduz 34 57 52 46
10 La Chaux-de-Fonds Chaux-de-Fon 34 51 47 46
11 Yverdon Yverdon 34 45 60 42
12 FC Lugano FC Lugano 34 42 46 41
13 Lausanne Sports Lausanne 34 44 51 39
14 Locarno Locarno 34 42 60 39
15 Delemont Delemont 34 39 63 33
16 Wohlen Wohlen 34 39 64 31
17 FC Baulmes FC Baulmes 34 30 63 30
18 YF Juventus YF Juventus 34 29 75 19
TEMPORADA 2004/2005
LIGA SUIZA
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

  USO DE MEMORIA  
7,446,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6485
Total Execution Time  0.6497
  CADENA URL  
/historico/Servette
  GET DATOS  
$_GET['/historico/Servette']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0254  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 = 73877
0.0131  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 = 72095
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3041 AND type_rel = 2
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3041 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (41229,41968,45281,72684,93728) ORDER BY n.cover_points DESC, update_date DESC
0.0134  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 = '3041' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0134  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 = '3041' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = 72094 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 75881 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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=3041 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (75881,74792,73877,72510,72095,71432) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 75881 AND teamId = 3041
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 73877 AND teamId = 3041
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 74792 AND teamId = 3041
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 72095 AND teamId = 3041
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 72510 AND teamId = 3041
0.0215  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 3041
0.0126  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 74792 AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0137  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 events2024 e ON e.player_id = p.id AND e.league_id = 74792 WHERE rp.league_id = 74792 AND rp.teamId = 3041 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.0134  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 events2024 e ON e.player_id = p.id AND e.league_id = 74792 WHERE rp.league_id = 74792 AND rp.teamId = 3041 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 events2024 e ON e.player_id = p.id AND e.league_id = 74792 WHERE rp.league_id = 74792 AND rp.teamId = 3041 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 3041 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 67779 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.0128  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.0128  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.0128  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.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 `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 = 43609 AND t.round = 36 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 `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 = 38785 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 33334 AND t.round = 36 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 `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 = 15801 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 `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 = 3882 AND t.round = 36 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 `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 = 2797 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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.0127  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.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 = 10178 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 10179 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 `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 = 10180 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 = 10181 AND t.round = 34 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 `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 = 10182 AND t.round = 34 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 `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