4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CS Chênois
TEMPORADA 2023/2024
CUARTA SUIZA GRUPO 1
Equipo PJ GF GC Puntos
1 Grand-Saconnex Grand-Saconn 26 55 29 55
2 Sion II Sion II 25 65 35 46
3 Lausanne Sport II Lausanne 26 48 30 45
4 Yverdon Sport II Yverdon 26 50 34 42
5 CS Chênois CS Chênois 26 44 36 39
6 Echallens Echallens 26 45 46 39
7 Vevey Sports Vevey Sports 25 42 26 38
8 Coffrane Coffrane 25 37 52 34
9 Meyrin Meyrin 26 40 48 33
10 La Chaux-de-Fonds Chaux-de-Fon 26 38 41 33
11 Naters Naters 26 40 44 33
12 Portalban / Gletterens Portalban 25 33 47 30
13 FC Monthey FC Monthey 25 28 33 28
14 La Sarraz-Eclépens Sarraz-Eclé 25 30 44 26
15 Pully Football Pully 25 32 60 19
16 Terre Sainte Terre Sainte 25 28 50 16
TEMPORADA 2022/2023
CUARTA SUIZA GRUPO 1
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
TEMPORADA 2021/2022
CUARTA SUIZA GRUPO 1
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
TEMPORADA 2020/2021
CUARTA SUIZA GRUPO 1
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
TEMPORADA 2019/2020
CUARTA SUIZA GRUPO 1
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
TEMPORADA 2018/2019
CUARTA SUIZA GRUPO 1
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
TEMPORADA 2017/2018
QUINTA SUIZA GRUPO 1
Equipo PJ GF GC Puntos
1 CS Chênois CS Chênois 26 65 20 58
2 FC Monthey FC Monthey 26 69 34 55
3 Terre Sainte Terre Sainte 26 63 30 55
4 Servette II Servette II 26 69 41 47
5 Interstar Interstar 26 55 43 41
6 Urania Genève Sport Urania 26 53 46 39
7 Veyrier Sports Veyrier 26 45 55 34
8 Chippis Chippis 26 48 78 34
9 Conthey Conthey 26 56 53 33
10 Collex-Bossy Collex-Bossy 26 45 57 33
11 Signal Bernex-Confignon Signal 26 43 49 30
12 Perly-Certoux Perly-Certou 26 32 46 23
13 Montreux Sports Montreux 26 29 69 20
14 Bex Bex 26 21 72 11
TEMPORADA 2016/2017
QUINTA SUIZA GRUPO 1
Equipo PJ GF GC Puntos
1 Meyrin Meyrin 26 70 22 60
2 FC Monthey FC Monthey 26 68 42 54
3 Servette II Servette II 26 56 25 49
4 Urania Genève Sport Urania 26 36 35 44
5 Terre Sainte Terre Sainte 26 58 40 42
6 Interstar Interstar 26 48 37 41
7 Signal Bernex-Confignon Signal 26 54 45 38
8 CS Chênois CS Chênois 26 46 43 36
9 Conthey Conthey 26 41 45 35
10 Perly-Certoux Perly-Certou 26 38 44 30
11 Collex-Bossy Collex-Bossy 26 30 43 29
12 Aigle Aigle 26 31 63 25
13 Sierre Sierre 26 28 61 17
14 Bramois Bramois 26 26 85 10
TEMPORADA 2015/2016
QUINTA SUIZA GRUPO 1
Equipo PJ GF GC Puntos
1 Vevey Sports Vevey Sports 26 62 27 55
2 Meyrin Meyrin 26 68 34 53
3 Aigle Aigle 26 48 43 41
4 Conthey Conthey 26 43 48 37
5 Urania Genève Sport Urania 26 40 43 36
6 Servette II Servette II 26 43 46 35
7 Perly-Certoux Perly-Certou 26 35 45 34
8 Sierre Sierre 26 46 48 33
9 Collex-Bossy Collex-Bossy 26 45 50 31
10 CS Chênois CS Chênois 26 39 49 31
11 FC Monthey FC Monthey 26 55 53 30
12 Dardania Lausanne Dardania 26 36 46 30
13 Plan-les-Ouates Plan-les-Oua 26 26 45 28
14 Veyrier Sports Veyrier 26 39 48 25
TEMPORADA 2013/2014
QUINTA SUIZA GRUPO 1
Equipo PJ GF GC Puntos
1 Stade Lausanne-Ouchy Stade 26 57 24 54
2 Sierre Sierre 26 49 38 50
3 Vevey Sports Vevey Sports 26 64 36 46
4 Signal Bernex-Confignon Signal 26 65 46 46
5 Perly-Certoux Perly-Certou 26 52 39 46
6 Collex-Bossy Collex-Bossy 26 67 34 44
7 Dardania Lausanne Dardania 26 61 47 41
8 Servette II Servette II 26 59 48 37
9 Vernier Vernier 26 35 40 36
10 Plan-les-Ouates Plan-les-Oua 26 37 51 33
11 Urania Genève Sport Urania 26 42 43 30
12 CS Chênois CS Chênois 26 35 55 28
13 Renens Renens 26 31 63 18
14 FC Malley FC Malley 26 18 108 5
TEMPORADA 2012/2013
QUINTA SUIZA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Azzurri 90 Azzurri 26 61 32 62
2 Stade Lausanne-Ouchy Stade 26 57 23 59
3 Servette II Servette II 26 68 33 56
4 Lutry Lutry 26 40 28 41
5 Perly-Certoux Perly-Certou 26 48 41 40
6 Renens Renens 26 50 39 38
7 Sierre Sierre 26 50 39 38
8 Collex-Bossy Collex-Bossy 26 54 40 35
9 CS Chênois CS Chênois 26 35 55 33
10 Vernier Vernier 26 32 46 30
11 Signal Bernex-Confignon Signal 26 43 56 26
12 Collombey-Muraz Collombey-Mu 26 31 45 24
13 Chippis Chippis 26 36 81 14
14 Montreux Sports Montreux 26 29 76 14
TEMPORADA 2011/2012
QUINTA SUIZA GRUPO 1
Equipo PJ GF GC Puntos
1 Terre Sainte Terre Sainte 26 54 21 54
2 Stade Lausanne-Ouchy Stade 26 58 28 53
3 Servette II Servette II 26 63 20 52
4 Signal Bernex-Confignon Signal 26 45 29 42
5 Bavois Bavois 26 59 39 41
6 CS Chênois CS Chênois 26 55 43 39
7 Sierre Sierre 26 49 52 38
8 Collex-Bossy Collex-Bossy 26 47 39 36
9 Lutry Lutry 26 40 37 36
10 Montreux Sports Montreux 26 27 68 30
11 Collombey-Muraz Collombey-Mu 26 39 61 29
12 Perly-Certoux Perly-Certou 26 44 53 27
13 Orbe Orbe 26 27 68 19
14 Bex Bex 26 30 79 17
TEMPORADA 2010/2011
CUARTA SUIZA GRUPO 1
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
TEMPORADA 2009/2010
CUARTA SUIZA GRUPO 1
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
TEMPORADA 2008/2009
CUARTA SUIZA GRUPO 1
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
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 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
Equipo PJ GF GC Puntos
1 Servette Servette 26 61 25 55
2 Basel Basel 26 67 27 52
3 Grasshopper Grasshopper 26 61 21 50
4 Luzern Luzern 26 44 44 46
5 Zurich Zurich 26 56 42 44
6 Sion Sion 26 47 37 42
7 St. Gallen St. Gallen 26 48 37 39
8 Lausanne Sports Lausanne 26 35 38 30
9 Young Boys Young Boys 26 34 49 29
10 Chiasso Chiasso 26 27 43 29
11 Neuchâtel Xamax Neuchâtel 26 33 48 28
12 CS Chênois CS Chênois 26 32 45 24
13 La Chaux-de-Fonds Chaux-de-Fon 26 24 57 22
14 FC Lugano FC Lugano 26 18 74 8
TEMPORADA 1978/1979
LIGA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Sion Sion 10 15 8 19
2 Chiasso Chiasso 10 16 10 18
3 CS Chênois CS Chênois 10 21 14 17
4 Lausanne Sports Lausanne 10 20 16 17
5 Neuchâtel Xamax Neuchâtel 10 11 19 7
6 Nordstern Nordstern 10 8 24 4

  USO DE MEMORIA  
7,256,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1987
Total Execution Time  0.2002
  CADENA URL  
/historico/Cs-Chenois
  GET DATOS  
$_GET['/historico/Cs-Chenois']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62269 AND type_rel = 2
0.0769  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 = '62269' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0039  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 = 62269 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0032  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 = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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.0028  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.0021  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.0025  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.0028  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.0026  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 = 39721 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 34001 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 15878 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 27110 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 27121 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 27120 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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.0027  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.0058  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.0022  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.0026  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 `tables1981` 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 = 29649 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 `tables1980` 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 = 29651 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables1979` 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 = 29654 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables1979` 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 = 57462 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC