4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Koniz
TEMPORADA 2023/2024
CUARTA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Schotz Schotz 26 64 26 54
2 Rotkreuz Rotkreuz 26 40 23 54
3 Solothurn Solothurn 26 54 41 52
4 Concordia Basel Concordia 26 57 32 50
5 Black Stars Black Stars 26 60 35 49
6 Muttenz Muttenz 26 69 41 46
7 FC Courtetelle Courtetelle 25 55 34 42
8 Wohlen Wohlen 26 35 38 32
9 Munsingen Munsingen 25 35 41 30
10 Dietikon Dietikon 26 40 44 29
11 Thun II Thun II 25 36 48 29
12 FC Koniz FC Koniz 25 25 39 28
13 Bassecourt Bassecourt 26 37 56 23
14 Langenthal Langenthal 25 22 41 20
15 Emmenbrücke Emmenbrücke 25 24 61 18
16 FC Muri FC Muri 26 29 82 12
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
CUARTA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Wohlen Wohlen 26 57 27 54
2 Grasshopper II Grasshopper 26 60 39 47
3 Delemont Delemont 26 53 42 44
4 FC Koniz FC Koniz 26 49 37 43
5 Langenthal Langenthal 26 45 46 42
6 Luzern II Luzern II 26 40 36 39
7 Schotz Schotz 26 42 50 36
8 Solothurn Solothurn 26 42 39 35
9 Bassecourt Bassecourt 26 46 43 33
10 Munsingen Munsingen 26 36 39 33
11 Hongg Hongg 26 31 31 32
12 Kosova Kosova 26 39 47 31
13 Zug 94 Zug 94 26 27 45 24
14 Buochs Buochs 26 24 70 16
TEMPORADA 2020/2021
TERCERA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 AC Bellinzona Bellinzona 7 13 6 16
2 Black Stars Black Stars 7 16 6 14
3 FC Zurich II Zurich 7 12 7 13
4 Breitenrain Breitenrain 7 12 12 11
5 YF Juventus YF Juventus 7 16 14 8
6 Sion II Sion II 7 14 19 6
7 FC Koniz FC Koniz 7 6 12 6
8 Munsingen Munsingen 7 4 17 1
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
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
TERCERA SUIZA
Equipo PJ GF GC Puntos
1 Neuchâtel Xamax Neuchâtel 30 79 31 70
2 FC Koniz FC Koniz 30 60 34 57
3 Breitenrain Breitenrain 30 50 40 49
4 YF Juventus YF Juventus 30 54 52 47
5 Sion II Sion II 30 51 50 44
6 Rapperswil Rapperswil 30 46 48 44
7 Etoile Carouge Etoile 30 41 39 43
8 FC Zurich II Zurich 30 48 50 43
9 Stade Nyonnais Stade 30 39 37 42
10 St. Gallen II Gallen 30 52 51 41
11 FC Basel II FC Basel II 30 57 55 40
12 Tuggen Tuggen 30 41 64 35
13 SC Bruhl SC Bruhl 30 45 64 33
14 Old Boys Old Boys 30 42 52 31
15 Locarno Locarno 30 38 54 29
16 Delemont Delemont 30 42 64 27
TEMPORADA 2013/2014
TERCERA SUIZA
Equipo PJ GF GC Puntos
1 Le Mont LS Le Mont LS 28 49 36 53
2 YF Juventus YF Juventus 28 54 33 49
3 Etoile Carouge Etoile 28 71 54 49
4 FC Koniz FC Koniz 28 48 31 49
5 Tuggen Tuggen 28 63 52 46
6 Delemont Delemont 28 40 43 41
7 FC Zurich II Zurich 28 38 39 40
8 FC Basel II FC Basel II 28 38 41 37
9 Sion II Sion II 28 45 52 37
10 SC Bruhl SC Bruhl 28 35 45 36
11 Stade Nyonnais Stade 28 36 48 35
12 Breitenrain Breitenrain 28 41 40 34
13 Old Boys Old Boys 28 50 55 30
14 St. Gallen II Gallen 28 28 43 25
15 Kriens Kriens 28 38 62 25
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
QUINTA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Koniz FC Koniz 26 56 21 61
2 Lausanne Sport II Lausanne 26 66 26 59
3 Bern 1894 Bern 1894 26 53 36 43
4 Dürrenast Dürrenast 26 52 51 41
5 Lerchenfeld Lerchenfeld 26 52 49 37
6 Spiez Spiez 26 45 41 36
7 La Sarraz-Eclépens Sarraz-Eclé 26 42 42 36
8 Romontois Romontois 26 48 52 33
9 Bümpliz Bümpliz 26 48 55 32
10 Portalban / Gletterens Portalban 26 49 43 31
11 La Tour / Le Pâquier Tour 26 35 48 25
12 Thierrens Thierrens 26 43 63 25
13 Langnau Langnau 26 36 62 22
14 Estavayer le Lac Estavayer 26 32 68 18
TEMPORADA 2010/2011
QUINTA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Bulle Bulle 26 57 27 57
2 Lerchenfeld Lerchenfeld 26 72 32 52
3 Lausanne Sport II Lausanne 26 47 26 51
4 Lyss Lyss 26 53 40 50
5 Bern 1894 Bern 1894 26 48 33 43
6 Portalban / Gletterens Portalban 26 48 34 43
7 La Tour / Le Pâquier Tour 26 52 46 37
8 FC Koniz FC Koniz 26 37 39 36
9 Spiez Spiez 26 42 41 35
10 Romontois Romontois 26 48 48 35
11 Dürrenast Dürrenast 26 35 45 31
12 Gumefens / Sorens Gumefens 26 31 43 27
13 Farvagny / Ogoz Farvagny 26 21 78 11
14 Kerzers Kerzers 26 30 89 9
TEMPORADA 2009/2010
QUINTA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Thun II Thun II 26 78 32 60
2 Bümpliz Bümpliz 26 68 34 55
3 Bern 1894 Bern 1894 26 48 36 43
4 Lerchenfeld Lerchenfeld 26 52 39 41
5 La Tour / Le Pâquier Tour 26 64 65 39
6 Lyss Lyss 26 53 48 37
7 FC Koniz FC Koniz 26 52 53 35
8 Kerzers Kerzers 26 52 56 35
9 Dürrenast Dürrenast 26 50 55 33
10 Portalban / Gletterens Portalban 26 48 61 33
11 Sierre Sierre 26 45 45 31
12 Romontois Romontois 26 42 52 30
13 Belfaux Belfaux 26 51 83 20
14 Härkingen Härkingen 26 40 84 14

  USO DE MEMORIA  
6,830,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5966
Total Execution Time  0.5978
  CADENA URL  
/historico/Fc-Koniz
  GET DATOS  
$_GET['/historico/Fc-Koniz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0159  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 = 'Fc-Koniz' 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.0131  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=12845 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=12845 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=12845 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=12845 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0266  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 = 72693
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12845 AND type_rel = 2
0.0131  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 = '12845' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '12845' 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 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=12845 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 (72765,72693,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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 72693 AND teamId = 12845
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 68166 AND teamId = 12845
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 72765 AND teamId = 12845
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12845
0.0138  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 = 72693 WHERE rp.league_id = 72693 AND rp.teamId = 12845 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.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 = 72693 WHERE rp.league_id = 72693 AND rp.teamId = 12845 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 72693 WHERE rp.league_id = 72693 AND rp.teamId = 12845 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 12845 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72693 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.0133  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.0133  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 = 63496 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.0132  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.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 `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 = 62531 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.0133  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.0132  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.0133  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.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 `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.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 `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.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 `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 = 4823 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 `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 = 2798 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 `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.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 `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 = 27124 AND t.round = 26 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 = 27141 AND t.round = 26 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 `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 = 27142 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 72693 ORDER BY nameShow LIMIT 100