4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bavois
TEMPORADA 2023/2024
TERCERA SUIZA
Equipo PJ GF GC Puntos
1 Etoile Carouge Etoile 30 62 32 67
2 Rapperswil Rapperswil 30 64 39 61
3 Biel-Bienne Biel-Bienne 30 56 32 52
4 Delemont Delemont 30 49 53 50
5 FC Paradiso FC Paradiso 30 32 28 49
6 Kriens Kriens 30 44 50 43
7 SC Bruhl SC Bruhl 30 44 54 43
8 SC Cham SC Cham 30 66 57 42
9 Bavois Bavois 30 63 52 41
10 FC Zurich II Zurich 30 55 50 41
11 Luzern II Luzern II 30 57 62 38
12 Young Boys II Young Boys 30 44 57 38
13 Breitenrain Breitenrain 30 43 52 38
14 Bulle Bulle 30 40 51 35
15 Lugano II Lugano II 30 43 57 34
16 FC Basel II FC Basel II 29 44 54 31
17 St. Gallen II Gallen 30 49 52 30
18 Servette II Servette II 29 39 62 19
TEMPORADA 2022/2023
TERCERA SUIZA
Equipo PJ GF GC Puntos
1 Luzern II Luzern II 33 95 55 74
2 Stade Nyonnais Stade 33 85 46 69
3 Baden Baden 33 64 50 61
4 Rapperswil Rapperswil 33 60 54 57
5 Etoile Carouge Etoile 33 66 39 55
6 SC Cham SC Cham 33 60 48 54
7 SC Bruhl SC Bruhl 33 59 47 52
8 Breitenrain Breitenrain 33 58 59 51
9 FC Basel II FC Basel II 33 53 58 44
10 Kriens Kriens 33 54 60 43
11 Bavois Bavois 33 47 65 40
12 Young Boys II Young Boys 33 65 70 39
13 FC Zurich II Zurich 33 53 58 38
14 Bulle Bulle 34 51 61 38
15 Chiasso Chiasso 19 27 18 34
16 St. Gallen II Gallen 33 58 87 33
17 Biel-Bienne Biel-Bienne 34 32 60 28
18 YF Juventus YF Juventus 33 28 80 15
TEMPORADA 2021/2022
TERCERA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Bavois Bavois 35 50 51 52
2 SC Cham SC Cham 35 63 62 51
3 Rapperswil Rapperswil 35 52 57 44
4 Young Boys II Young Boys 35 55 64 42
5 Biel-Bienne Biel-Bienne 35 56 61 40
6 FC Basel II FC Basel II 35 72 84 39
TEMPORADA 2020/2021
TERCERA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Basel II FC Basel II 7 18 9 13
2 Rapperswil Rapperswil 7 14 9 12
3 Bavois Bavois 7 16 12 12
4 SC Cham SC Cham 7 16 13 10
5 Yverdon Yverdon 7 13 12 10
6 Etoile Carouge Etoile 7 12 14 7
7 Stade Nyonnais Stade 7 8 13 5
8 SC Bruhl SC Bruhl 7 6 21 4
TEMPORADA 2019/2020
TERCERA SUIZA
Equipo PJ GF GC Puntos
1 Yverdon Yverdon 17 45 15 38
2 Rapperswil Rapperswil 17 31 24 31
3 Stade Nyonnais Stade 17 37 21 30
4 Etoile Carouge Etoile 17 35 22 30
5 Black Stars Black Stars 17 26 19 29
6 AC Bellinzona Bellinzona 17 33 24 27
7 SC Bruhl SC Bruhl 17 31 33 26
8 FC Basel II FC Basel II 17 21 18 22
9 Breitenrain Breitenrain 17 32 33 22
10 Sion II Sion II 17 21 25 20
11 FC Koniz FC Koniz 17 22 38 20
12 SC Cham SC Cham 17 22 30 19
13 FC Zurich II Zurich 17 25 31 18
14 Bavois Bavois 17 21 35 16
15 YF Juventus YF Juventus 17 24 35 15
16 Munsingen Munsingen 17 19 42 9
TEMPORADA 2018/2019
TERCERA SUIZA
Equipo PJ GF GC Puntos
1 Stade Lausanne-Ouchy Stade 30 74 28 69
2 Yverdon Yverdon 30 62 22 65
3 AC Bellinzona Bellinzona 30 49 23 58
4 SC Cham SC Cham 30 53 42 48
5 Stade Nyonnais Stade 30 58 37 44
6 Sion II Sion II 30 38 41 42
7 FC Koniz FC Koniz 30 41 46 41
8 Bavois Bavois 30 51 47 39
9 FC Basel II FC Basel II 30 49 43 38
10 Breitenrain Breitenrain 30 44 54 38
11 Munsingen Munsingen 30 29 44 37
12 SC Bruhl SC Bruhl 30 53 55 36
13 FC Zurich II Zurich 30 32 44 33
14 YF Juventus YF Juventus 30 35 54 29
15 Wohlen Wohlen 30 40 58 28
16 La Chaux-de-Fonds Chaux-de-Fon 30 25 95 11
TEMPORADA 2017/2018
TERCERA SUIZA
Equipo PJ GF GC Puntos
1 Kriens Kriens 30 76 31 69
2 Stade Nyonnais Stade 30 64 33 64
3 Yverdon Yverdon 30 64 48 56
4 FC Basel II FC Basel II 30 53 44 45
5 FC Zurich II Zurich 30 60 50 43
6 Stade Lausanne-Ouchy Stade 30 56 57 43
7 FC Koniz FC Koniz 30 56 53 42
8 SC Bruhl SC Bruhl 30 51 45 40
9 Breitenrain Breitenrain 30 56 61 39
10 Sion II Sion II 30 47 46 38
11 SC Cham SC Cham 30 50 58 38
12 YF Juventus YF Juventus 30 48 57 36
13 Bavois Bavois 30 38 56 34
14 Old Boys Old Boys 30 48 61 31
15 La Chaux-de-Fonds Chaux-de-Fon 30 37 50 30
16 United Zürich United 30 35 89 18
TEMPORADA 2016/2017
TERCERA SUIZA
Equipo PJ GF GC Puntos
1 Rapperswil Rapperswil 30 60 29 62
2 Kriens Kriens 30 65 31 57
3 FC Basel II FC Basel II 30 64 37 55
4 Stade Nyonnais Stade 30 51 39 49
5 FC Zurich II Zurich 30 54 52 48
6 Breitenrain Breitenrain 30 46 49 45
7 SC Bruhl SC Bruhl 30 56 54 40
8 FC Koniz FC Koniz 30 40 43 40
9 La Chaux-de-Fonds Chaux-de-Fon 30 44 46 39
10 Sion II Sion II 30 48 58 39
11 SC Cham SC Cham 30 47 46 37
12 Old Boys Old Boys 30 47 48 34
13 YF Juventus YF Juventus 30 44 53 33
14 Bavois Bavois 30 37 69 31
15 United Zürich United 30 32 61 27
16 Tuggen Tuggen 30 37 57 26
TEMPORADA 2015/2016
CUARTA SUIZA GRUPO 1
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
TEMPORADA 2014/2015
CUARTA SUIZA GRUPO 1
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
TEMPORADA 2013/2014
CUARTA SUIZA GRUPO 1
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
TEMPORADA 2012/2013
QUINTA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Bavois Bavois 26 84 21 70
2 Lausanne Sport II Lausanne 26 81 24 59
3 Lerchenfeld Lerchenfeld 26 41 44 43
4 Bern 1894 Bern 1894 26 49 41 41
5 La Sarraz-Eclépens Sarraz-Eclé 26 50 39 40
6 La Tour / Le Pâquier Tour 26 53 49 40
7 Bümpliz Bümpliz 26 39 48 38
8 Thierrens Thierrens 26 56 48 37
9 Gumefens / Sorens Gumefens 26 53 63 34
10 Portalban / Gletterens Portalban 26 49 51 33
11 Romontois Romontois 26 44 50 33
12 Dürrenast Dürrenast 26 44 49 32
13 Spiez Spiez 26 41 66 16
14 FC Baulmes FC Baulmes 26 26 117 3
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
QUINTA SUIZA GRUPO 1
Equipo PJ GF GC Puntos
1 Servette II Servette II 26 63 21 58
2 FC Monthey FC Monthey 26 48 19 57
3 Bavois Bavois 26 58 21 52
4 Montreux Sports Montreux 26 59 34 50
5 Stade Lausanne-Ouchy Stade 26 35 30 42
6 La Sarraz-Eclépens Sarraz-Eclé 26 38 34 34
7 Signal Bernex-Confignon Signal 26 37 39 32
8 Perly-Certoux Perly-Certou 26 32 42 31
9 Bex Bex 26 37 53 31
10 Orbe Orbe 26 29 42 28
11 Sierre Sierre 26 44 57 26
12 Geneva Geneva 26 28 45 25
13 Vevey Sports Vevey Sports 26 32 54 22
14 Versoix Versoix 26 28 77 16
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
QUINTA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Breitenrain Breitenrain 26 55 17 63
2 Bavois Bavois 26 59 29 62
3 Serrieres Neuchatel Serrieres 26 55 21 59
4 Thun II Thun II 25 74 45 44
5 Bern 1894 Bern 1894 26 32 36 37
6 Lyss Lyss 25 36 41 31
7 Bümpliz Bümpliz 26 44 57 30
8 Dürrenast Dürrenast 26 37 40 29
9 Colombier Colombier 26 36 46 28
10 Belfaux Belfaux 26 38 58 28
11 Romontois Romontois 25 32 43 26
12 Portalban / Gletterens Portalban 26 23 55 26
13 Gumefens / Sorens Gumefens 26 26 40 25
14 Cortaillod Cortaillod 25 34 53 18

  USO DE MEMORIA  
6,714,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6973
Total Execution Time  0.6987
  CADENA URL  
/historico/Bavois
  GET DATOS  
$_GET['/historico/Bavois']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0161  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Bavois' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0144  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12846 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12846 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12846 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12846 AND type_rel = 2
0.0149  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 = '12846' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0157  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 = '12846' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 72648 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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=12846 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (72648,71432,68166) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 72648 AND teamId = 12846
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 68166 AND teamId = 12846
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12846
0.0145  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '12846' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12846' and rp.type = 4
0.0146  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '12846' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0162  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 = 72648 WHERE rp.league_id = 72648 AND rp.teamId = 12846 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.0159  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 = 72648 WHERE rp.league_id = 72648 AND rp.teamId = 12846 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0172  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 = 72648 WHERE rp.league_id = 72648 AND rp.teamId = 12846 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 12846 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0294  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 = 68181 AND t.round = 34 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 `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 = 63333 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.0147  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 = 67461 AND t.round = 5 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 `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 = 56979 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.0154  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 = 62530 AND t.round = 7 ORDER BY team.conference ASC,t.position 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 `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 = 50255 AND t.round = 17 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 = 44257 AND t.round = 30 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 = 38829 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 33448 AND t.round = 30 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 `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.0153  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.0154  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.0160  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 = 27123 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 `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.0163  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 = 27138 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171  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.0159  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 = 27154 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC