4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Dornach
TEMPORADA 2022/2023
CUARTA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Delemont Delemont 30 68 38 65
2 Solothurn Solothurn 30 61 42 52
3 Schotz Schotz 30 40 31 52
4 Concordia Basel Concordia 30 60 44 51
5 Black Stars Black Stars 30 56 43 50
6 Munsingen Munsingen 30 57 47 45
7 Rotkreuz Rotkreuz 30 47 50 41
8 Neuchâtel Xamax II Neuchâtel 30 58 52 40
9 Thun II Thun II 30 55 53 39
10 Bassecourt Bassecourt 30 44 44 39
11 Wohlen Wohlen 30 44 61 39
12 FC Koniz FC Koniz 30 30 42 33
13 Langenthal Langenthal 30 47 57 32
14 FC Muri FC Muri 30 55 90 32
15 Emmenbrücke Emmenbrücke 30 54 59 29
16 Dornach Dornach 30 37 60 23
TEMPORADA 2021/2022
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Dornach Dornach 26 67 38 56
2 Concordia Basel Concordia 26 78 28 53
3 Old Boys Old Boys 26 65 36 51
4 Liestal Liestal 26 54 46 50
5 Ajoie-Monterri Ajoie-Monter 26 39 24 46
6 Muttenz Muttenz 26 59 57 38
7 Tavannes / Tramelan Tavannes 26 35 37 36
8 FC Courtetelle Courtetelle 26 41 57 31
9 Binningen Binningen 26 42 41 30
10 Spiez Spiez 26 46 63 29
11 Bubendorf Bubendorf 26 44 65 28
12 Lerchenfeld Lerchenfeld 26 39 56 24
13 FC Konolfingen Konolfingen 26 29 50 23
14 Moutier Moutier 26 23 63 19
TEMPORADA 2020/2021
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Thun II Thun II 13 45 16 31
2 Ajoie-Monterri Ajoie-Monter 12 20 11 27
3 Spiez Spiez 13 21 24 23
4 FC Konolfingen Konolfingen 13 23 18 22
5 Moutier Moutier 12 17 14 18
6 Old Boys Old Boys 13 29 28 18
7 Binningen Binningen 13 26 28 18
8 Dornach Dornach 13 21 20 17
9 Liestal Liestal 13 21 32 17
10 Tavannes / Tramelan Tavannes 13 20 21 15
11 Lerchenfeld Lerchenfeld 13 21 26 15
12 Bubendorf Bubendorf 13 24 29 14
13 Allschwil Allschwil 13 17 23 10
14 Köniz II Köniz II 13 21 36 8
TEMPORADA 2019/2020
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Moutier Moutier 13 37 11 35
2 Dornach Dornach 13 36 16 29
3 Old Boys Old Boys 13 30 20 25
4 Liestal Liestal 13 24 26 23
5 Bubendorf Bubendorf 13 27 19 22
6 Courgenay Courgenay 12 27 22 19
7 Cornol Cornol 13 21 24 17
8 FC Konolfingen Konolfingen 13 23 29 16
9 Spiez Spiez 13 21 39 15
10 Binningen Binningen 13 25 32 14
11 Allschwil Allschwil 13 24 30 12
12 Tavannes / Tramelan Tavannes 12 15 17 11
13 Lerchenfeld Lerchenfeld 13 19 29 8
14 Köniz II Köniz II 13 18 33 8
TEMPORADA 2018/2019
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Muttenz Muttenz 26 99 32 58
2 Allschwil Allschwil 25 54 48 46
3 Moutier Moutier 26 57 30 45
4 FC Konolfingen Konolfingen 26 54 47 43
5 Dornach Dornach 26 52 42 41
6 Tavannes / Tramelan Tavannes 26 47 42 41
7 Liestal Liestal 26 63 45 39
8 Köniz II Köniz II 25 53 41 38
9 Binningen Binningen 26 42 43 35
10 Cornol Cornol 26 41 43 35
11 Lerchenfeld Lerchenfeld 26 34 41 29
12 FC Prishtina Bern Prishtina 26 46 58 28
13 Timau Basel Timau Basel 26 39 121 18
14 Subingen Subingen 26 21 69 12
TEMPORADA 2017/2018
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Biel-Bienne Biel-Bienne 26 76 30 59
2 Liestal Liestal 26 69 36 56
3 Dornach Dornach 26 41 32 44
4 Allschwil Allschwil 26 48 48 42
5 FC Konolfingen Konolfingen 26 44 41 41
6 Timau Basel Timau Basel 26 54 45 41
7 Binningen Binningen 26 46 42 40
8 Moutier Moutier 26 51 33 39
9 Tavannes / Tramelan Tavannes 26 43 45 36
10 Lerchenfeld Lerchenfeld 26 45 56 32
11 FC Prishtina Bern Prishtina 26 29 51 29
12 Muri-Gümligen Muri-Gümlig 26 34 45 27
13 Reinach Reinach 26 34 59 23
14 Bern 1894 Bern 1894 26 19 70 7
TEMPORADA 2016/2017
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Langenthal Langenthal 26 75 34 58
2 Allschwil Allschwil 26 47 34 45
3 Lerchenfeld Lerchenfeld 26 54 46 43
4 Timau Basel Timau Basel 26 54 55 42
5 Bern 1894 Bern 1894 26 49 43 41
6 FC Prishtina Bern Prishtina 26 66 47 41
7 Moutier Moutier 26 53 49 40
8 Tavannes / Tramelan Tavannes 26 54 41 38
9 Dornach Dornach 26 40 36 38
10 FC Konolfingen Konolfingen 26 46 47 38
11 Binningen Binningen 26 51 50 36
12 Muttenz Muttenz 26 43 50 26
13 Bümpliz Bümpliz 26 40 78 14
14 Grünstern Grünstern 26 29 91 12
TEMPORADA 2015/2016
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Bassecourt Bassecourt 26 58 31 50
2 Binningen Binningen 26 48 33 47
3 Dornach Dornach 26 44 35 44
4 Lerchenfeld Lerchenfeld 26 64 42 43
5 Langenthal Langenthal 26 48 40 39
6 Muttenz Muttenz 26 41 48 39
7 Allschwil Allschwil 26 46 35 38
8 Moutier Moutier 26 49 41 36
9 FC Konolfingen Konolfingen 26 51 50 34
10 Liestal Liestal 26 45 49 33
11 Tavannes / Tramelan Tavannes 26 34 55 31
12 Porrentruy Porrentruy 26 35 50 25
13 Concordia Basel Concordia 26 35 70 22
14 Kirchberg BE Kirchberg 26 39 58 20
TEMPORADA 2014/2015
QUINTA SUIZA GRUPO 5
Equipo PJ GF GC Puntos
1 United Zürich United 26 68 17 63
2 Hongg Hongg 26 66 27 53
3 Red Star Zürich Star Zürich 26 54 27 49
4 Allschwil Allschwil 26 71 46 41
5 Dornach Dornach 26 40 31 41
6 Seefeld Seefeld 26 42 31 40
7 Aarau II Aarau II 26 54 50 36
8 Muttenz Muttenz 26 42 56 35
9 Liestal Liestal 26 50 48 33
10 Binningen Binningen 26 47 53 33
11 Kilchberg-Rüschlikon Kilchberg-R 26 27 53 26
12 Dardania Basel Dardania 26 43 77 25
13 FC Blue Stars Zürich Blue Stars. 26 40 63 21
14 FC Beringen FC Beringen 26 36 101 19
TEMPORADA 2013/2014
QUINTA SUIZA GRUPO 5
Equipo PJ GF GC Puntos
1 Dietikon Dietikon 26 72 28 59
2 Seefeld Seefeld 26 50 25 53
3 Red Star Zürich Star Zürich 26 56 32 49
4 Kosova Kosova 26 58 59 40
5 Muttenz Muttenz 26 41 51 37
6 United Zürich United 26 53 44 35
7 Dornach Dornach 26 40 35 35
8 Liestal Liestal 26 49 57 35
9 Allschwil Allschwil 26 50 43 34
10 Kilchberg-Rüschlikon Kilchberg-R 26 35 45 31
11 Binningen Binningen 26 38 46 30
12 Dulliken Dulliken 26 43 60 28
13 Laufen Laufen 26 33 62 18
14 Oerlikon / Polizei Oerlikon 26 29 60 18
TEMPORADA 2012/2013
CUARTA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Baden Baden 26 61 19 59
2 FC Koniz FC Koniz 26 56 23 52
3 FC Grenchen FC Grenchen 26 50 35 46
4 Serrieres Neuchatel Serrieres 26 38 37 43
5 Wangen Wangen 26 38 37 40
6 Black Stars Black Stars 26 35 31 39
7 Munsingen Munsingen 26 41 35 36
8 Luzern II Luzern II 26 41 38 36
9 SC Zofingen SC Zofingen 26 43 47 31
10 Solothurn Solothurn 26 36 37 29
11 Grasshopper II Grasshopper 26 29 50 28
12 Schotz Schotz 26 34 60 28
13 Muttenz Muttenz 26 31 58 23
14 Dornach Dornach 26 24 50 15
TEMPORADA 2011/2012
CUARTA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Old Boys Old Boys 30 68 36 62
2 Breitenrain Breitenrain 30 54 25 61
3 Baden Baden 30 61 31 60
4 FC Zurich II Zurich 30 55 49 51
5 Munsingen Munsingen 30 42 36 50
6 FC Basel II FC Basel II 30 56 36 47
7 Solothurn Solothurn 30 52 43 45
8 Dornach Dornach 30 54 50 44
9 Schotz Schotz 30 54 57 42
10 Grasshopper II Grasshopper 30 50 58 40
11 Wangen Wangen 30 29 47 33
12 Serrieres Neuchatel Serrieres 30 43 47 32
13 FC Grenchen FC Grenchen 30 29 64 29
14 Muttenz Muttenz 30 41 74 27
15 Thun II Thun II 30 46 58 26
16 SC Zofingen SC Zofingen 30 35 58 22
TEMPORADA 2010/2011
CUARTA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Schotz Schotz 30 61 27 61
2 FC Zurich II Zurich 30 57 29 59
3 Breitenrain Breitenrain 30 48 36 55
4 FC Basel II FC Basel II 30 68 34 50
5 Grasshopper II Grasshopper 30 58 48 49
6 Thun II Thun II 30 54 52 48
7 Munsingen Munsingen 30 44 34 44
8 SC Zofingen SC Zofingen 30 50 48 42
9 Old Boys Old Boys 30 46 46 42
10 Wangen Wangen 30 43 47 40
11 Muttenz Muttenz 30 45 66 40
12 Solothurn Solothurn 30 46 49 35
13 Dornach Dornach 30 42 53 32
14 FC Grenchen FC Grenchen 30 40 49 28
15 Laufen Laufen 30 41 78 25
16 Bümpliz Bümpliz 30 38 85 18
TEMPORADA 2009/2010
QUINTA SUIZA GRUPO 4
Equipo PJ GF GC Puntos
1 Dornach Dornach 26 75 36 60
2 Liestal Liestal 26 57 35 54
3 Freienbach Freienbach 26 71 40 52
4 Langenthal Langenthal 26 59 32 49
5 FC Thalwil FC Thalwil 26 43 26 44
6 Kosova Kosova 26 50 46 38
7 Alle Alle 26 47 47 38
8 Black Stars Black Stars 26 42 40 34
9 Moutier Moutier 26 48 46 32
10 Red Star Zürich Star Zürich 26 38 41 30
11 Porrentruy Porrentruy 26 30 46 28
12 Nordstern Nordstern 26 43 53 26
13 Herzogenbuchsee Herzogenbuch 26 25 71 12
14 Zürich Affoltern Zürich 26 30 99 10
TEMPORADA 2008/2009
QUINTA SUIZA GRUPO 4
Equipo PJ GF GC Puntos
1 Laufen Laufen 25 67 28 57
2 Dornach Dornach 26 74 39 53
3 Alle Alle 26 47 23 51
4 Herzogenbuchsee Herzogenbuch 26 38 35 43
5 Liestal Liestal 26 59 48 39
6 Küsnacht Küsnacht 26 41 51 36
7 Seefeld Seefeld 26 46 39 35
8 Porrentruy Porrentruy 26 37 46 32
9 Bülach Bülach 26 36 44 29
10 Nordstern Nordstern 25 34 48 29
11 Langenthal Langenthal 25 38 47 28
12 Moutier Moutier 26 44 60 28
13 Binningen Binningen 25 29 46 27
14 Subingen Subingen 26 29 65 16
TEMPORADA 2006/2007
CUARTA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Basel II FC Basel II 30 100 23 75
2 Biel-Bienne Biel-Bienne 30 60 18 65
3 Solothurn Solothurn 30 55 22 62
4 SC Cham SC Cham 30 46 33 54
5 SC Zofingen SC Zofingen 30 49 49 45
6 Muttenz Muttenz 30 53 54 41
7 Luzern II Luzern II 30 48 51 41
8 Wangen Wangen 30 48 58 41
9 Young Boys II Young Boys 30 42 51 38
10 Zug 94 Zug 94 30 37 40 36
11 Laufen Laufen 30 39 39 34
12 Olten Olten 30 38 56 34
13 Munsingen Munsingen 30 33 40 32
14 FC Grenchen FC Grenchen 30 43 65 32
15 Dornach Dornach 30 33 72 19
16 Kickers Luzern Kickers 30 32 85 14
TEMPORADA 2005/2006
CUARTA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Biel-Bienne Biel-Bienne 30 65 20 68
2 Delemont Delemont 30 56 40 52
3 FC Basel II FC Basel II 31 80 50 50
4 Kickers Luzern Kickers 30 49 41 49
5 Solothurn Solothurn 30 51 40 46
6 SC Zofingen SC Zofingen 30 52 55 40
7 Wangen Wangen 31 53 57 39
8 FC Grenchen FC Grenchen 30 51 46 38
9 Laufen Laufen 30 37 45 36
10 Young Boys II Young Boys 30 44 45 35
11 Munsingen Munsingen 30 37 42 35
12 Dornach Dornach 30 42 63 35
13 Muttenz Muttenz 30 43 67 35
14 Luzern II Luzern II 30 45 53 34
15 Schotz Schotz 30 46 64 31
16 Buochs Buochs 30 39 62 24

  USO DE MEMORIA  
7,000,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1447
Total Execution Time  0.1465
  CADENA URL  
/historico/Dornach/2023
  GET DATOS  
$_GET['/historico/Dornach/2023']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0029  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 = 'Dornach' AND l.year = 2023 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.0018  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=60246 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=60246 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=60246 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 68183
0.0027  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 = 70640
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60246 AND type_rel = 2
0.0028  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 = '60246' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '60246' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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 = 70640 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 68183 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=60246 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (74875,72775,70640,68183) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 68183 AND teamId = 60246
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 72775 AND teamId = 60246
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 74875 AND teamId = 60246
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 70640 AND teamId = 60246
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 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 = 68183 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '60246' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60246' and rp.type = 4
0.0020  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 = '60246' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0039  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 events2023 e ON e.player_id = p.id AND e.league_id = 68183 WHERE rp.league_id = 68183 AND rp.teamId = 60246 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.0035  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 events2023 e ON e.player_id = p.id AND e.league_id = 68183 WHERE rp.league_id = 68183 AND rp.teamId = 60246 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 events2023 e ON e.player_id = p.id AND e.league_id = 68183 WHERE rp.league_id = 68183 AND rp.teamId = 60246 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 60246 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68183 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.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 `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 = 63977 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.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 `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 = 57522 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.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 `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 = 50505 AND t.round = 24 ORDER BY team.conference ASC,t.position 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 `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 = 44264 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 `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 = 39723 AND t.round = 26 ORDER BY team.conference 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 `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 = 34003 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 `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 = 15880 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 `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 = 9204 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 = 27116 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 `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 = 27075 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 `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 = 27079 AND t.round = 30 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 = 27082 AND t.round = 30 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 `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 = 27147 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 `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 = 27157 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 `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 = 63204 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 `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 = 63133 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 68183 ORDER BY nameShow LIMIT 100