4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Eendracht Termien
TEMPORADA 2023/2024
PROMOCIÓN BÉLGICA GRUPO 3
Equipo PJ GF GC Puntos
1 Eendracht Termien Eendracht 30 89 31 72
2 Berg en Dal Berg en Dal 30 78 44 61
3 Esperanza Pelt Esperanza 30 54 34 53
4 Zepperen-Brustem Zepperen-Bru 30 53 38 53
5 Wellen Wellen 30 50 36 47
6 Verbroedering Geel Verbroederin 30 43 36 47
7 KFC Nijlen KFC Nijlen 30 57 54 43
8 Sint-Lenaarts Sint-Lenaart 30 50 49 42
9 Beerschot VA B Beerschot 30 54 47 41
10 KFC Turnhout Turnhout 30 49 46 41
11 Schoonbeek-Beverst Schoonbeek-B 30 37 43 40
12 Zwarte Leeuw Zwarte Leeuw 30 39 41 36
13 Betekom Betekom 30 55 61 34
14 Diest Diest 30 38 60 27
15 Witgoor Sport Witgoor 30 38 60 23
16 KFC Eksel KFC Eksel 30 19 123 3
TEMPORADA 2022/2023
PROMOCIÓN BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 KFC Houtvenne Houtvenne 30 80 26 63
2 Wezel Wezel 29 72 38 62
3 Eendracht Termien Eendracht 29 61 32 61
4 Geel-Meerhout Geel-Meerhou 29 64 35 57
5 Wellen Wellen 29 57 50 53
6 Sint-Lenaarts Sint-Lenaart 29 48 35 47
7 Betekom Betekom 29 52 53 40
8 Zwarte Leeuw Zwarte Leeuw 30 51 60 36
9 Esperanza Pelt Esperanza 29 35 38 35
10 Diest Diest 29 33 45 35
11 Schoonbeek-Beverst Schoonbeek-B 30 28 49 33
12 KFC Nijlen KFC Nijlen 29 38 59 29
13 Witgoor Sport Witgoor 29 41 55 26
14 Kampenhout Kampenhout 29 37 66 24
15 Olympia Wijgmaal Olympia 29 32 63 23
16 Beringen Beringen 30 37 62 20
TEMPORADA 2021/2022
PROMOCIÓN BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 Racing Mechelen Racing 30 63 41 59
2 Esperanza Pelt Esperanza 30 64 38 58
3 Diest Diest 30 47 28 56
4 KFC Lille KFC Lille 30 63 55 54
5 KFC Turnhout Turnhout 30 53 28 49
6 Sint-Lenaarts Sint-Lenaart 30 49 41 47
7 Zwarte Leeuw Zwarte Leeuw 30 61 38 46
8 Wellen Wellen 30 46 41 44
9 Eendracht Termien Eendracht 30 40 41 42
10 Beringen Beringen 30 48 43 41
11 Betekom Betekom 30 53 51 41
12 KFC Nijlen KFC Nijlen 30 52 55 41
13 Witgoor Sport Witgoor 30 37 43 35
14 De Kempen De Kempen 30 35 62 22
15 Berlaar-Heikant Berlaar-Heik 30 27 70 21
16 Weerstand Koersel Weerstand 30 30 93 11
TEMPORADA 2020/2021
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Betekom Betekom 4 11 6 9
2 KFC Nijlen KFC Nijlen 4 9 7 9
3 Berlaar-Heikant Berlaar-Heik 4 9 6 8
4 KFC Lille KFC Lille 4 13 7 7
5 Eendracht Termien Eendracht 4 11 8 7
6 Esperanza Pelt Esperanza 3 8 4 6
7 Witgoor Sport Witgoor 4 7 6 6
8 Sint-Lenaarts Sint-Lenaart 4 8 9 6
9 Racing Mechelen Racing 4 5 9 6
10 Diest Diest 4 6 7 4
11 Zwarte Leeuw Zwarte Leeuw 3 5 6 4
12 Wellen Wellen 4 5 6 3
13 KFC Turnhout Turnhout 3 3 7 3
14 De Kempen De Kempen 4 4 6 2
15 Beringen Beringen 4 4 8 2
16 Weerstand Koersel Weerstand 3 4 10 1
TEMPORADA 2019/2020
PROMOCIÓN BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 Lyra-Lierse Lyra-Lierse 24 46 23 49
2 Heur Tongeren Heur 24 48 26 48
3 KSC City Pirates City Pirates 24 40 29 48
4 KFC Houtvenne Houtvenne 24 47 29 45
5 Sint-Lenaarts Sint-Lenaart 24 57 34 38
6 Betekom Betekom 24 43 37 37
7 Eendracht Termien Eendracht 24 41 41 35
8 Wellen Wellen 24 36 41 33
9 Esperanza Pelt Esperanza 24 39 42 32
10 Zwarte Leeuw Zwarte Leeuw 24 46 38 31
11 Beringen Beringen 24 30 38 29
12 KFC Turnhout Turnhout 24 38 40 28
13 Witgoor Sport Witgoor 24 31 38 28
14 Bilzerse Waltwilder Bilzerse 24 37 51 20
15 Helson Helchteren Helson 24 26 51 18
16 Linden Linden 24 17 64 9
TEMPORADA 2018/2019
PROMOCIÓN BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 Tienen Tienen 30 57 28 65
2 KFC Houtvenne Houtvenne 30 54 37 53
3 Lyra Lyra 30 48 32 52
4 Sint-Lenaarts Sint-Lenaart 30 58 46 46
5 Betekom Betekom 30 52 50 45
6 Zwarte Leeuw Zwarte Leeuw 30 50 48 43
7 Wellen Wellen 30 45 42 42
8 Eendracht Termien Eendracht 30 45 46 42
9 Helson Helchteren Helson 30 49 54 42
10 Bornem Bornem 30 40 36 37
11 Esperanza Pelt Esperanza 30 37 52 37
12 Bilzerse Waltwilder Bilzerse 30 53 58 35
13 Ternesse Ternesse 30 38 52 33
14 KFC Nijlen KFC Nijlen 30 36 50 31
15 Leopoldsburg Leopoldsburg 30 35 56 30
16 Racing Mechelen Racing 30 36 46 27
TEMPORADA 2017/2018
PROMOCIÓN BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 Heur Tongeren Heur 30 59 37 55
2 Wellen Wellen 30 53 31 55
3 Eendracht Termien Eendracht 30 60 39 54
4 Diegem Sport Diegem Sport 30 61 43 50
5 Leopoldsburg Leopoldsburg 30 54 39 48
6 Bilzerse Waltwilder Bilzerse 30 60 54 48
7 Esperanza Pelt Esperanza 30 56 50 46
8 KFC Nijlen KFC Nijlen 30 54 55 45
9 Woluwe Woluwe 30 55 51 41
10 KFC Houtvenne Houtvenne 30 60 59 40
11 Kampenhout Kampenhout 30 41 49 38
12 Ternesse Ternesse 30 54 71 33
13 Diest Diest 30 41 66 32
14 Hoeilaart Hoeilaart 30 39 68 30
15 Sterrebeek Sterrebeek 30 40 54 27
16 VC Herentals Herentals 30 38 59 27
TEMPORADA 2016/2017
PROVINCIAL BÉLGICA GRUPO 9
Equipo PJ GF GC Puntos
1 Eendracht Termien Eendracht 30 78 45 66
2 Bilzerse Waltwilder Bilzerse 30 73 38 63
3 Heur Tongeren Heur 30 62 26 61
4 Huvo Jeuk Huvo Jeuk 30 58 41 52
5 Zepperen Zepperen 30 57 51 52
6 Melo Zonhoven Melo 30 57 55 49
7 Herk Herk 30 49 45 44
8 Vlijtingen Vlijtingen 30 55 56 41
9 HIH Hoepertingen Hoepertingen 30 50 63 36
10 Beringen Beringen 30 58 63 35
11 Racing Peer Racing Peer 30 53 66 35
12 Zonhoven Zonhoven 30 38 49 34
13 Bregel Sport Bregel Sport 30 40 54 34
14 Landen Landen 30 48 62 33
15 Bree Bree 30 43 72 23
16 Lutlommel Lutlommel 30 36 69 22
TEMPORADA 2015/2016
PROVINCIAL BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 Helson Helchteren Helson 30 66 33 70
2 Eendracht Termien Eendracht 30 68 38 60
3 Vlijtingen Vlijtingen 30 58 39 51
4 Heur Tongeren Heur 30 54 47 51
5 Lutlommel Lutlommel 30 66 55 48
6 Herk Herk 30 57 46 45
7 Zepperen Zepperen 30 53 55 44
8 Beringen Beringen 30 62 56 43
9 Zonhoven Zonhoven 30 51 44 41
10 Huvo Jeuk Huvo Jeuk 30 37 38 41
11 Bree Bree 30 46 48 41
12 Landen Landen 30 48 55 35
13 SP. Nevok Gruitrode Nevok 30 53 65 29
14 HIH Hoepertingen Hoepertingen 30 44 64 29
15 Weerstand Koersel Weerstand 30 46 83 20
16 MD Halen MD Halen 30 55 98 17
TEMPORADA 2014/2015
PROVINCIAL BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 Thes Sport Thes Sport 30 77 28 67
2 Lutlommel Lutlommel 30 61 42 52
3 Vlijtingen Vlijtingen 30 54 36 51
4 Helson Helchteren Helson 30 55 42 49
5 Herk Herk 30 54 48 48
6 Huvo Jeuk Huvo Jeuk 30 47 45 48
7 Zonhoven Zonhoven 30 47 30 47
8 Zepperen Zepperen 30 57 44 46
9 Eendracht Termien Eendracht 30 58 56 46
10 Apollo Gellik Apollo 30 46 45 38
11 Beringen Beringen 30 49 53 37
12 HIH Hoepertingen Hoepertingen 30 39 53 37
13 Weerstand Koersel Weerstand 30 31 64 36
14 Torpedo Hasselt Torpedo 30 35 58 30
15 Lindelhoeven Lindelhoeven 30 35 63 25
16 Moelingen Moelingen 30 29 67 17
TEMPORADA 2013/2014
PROVINCIAL BÉLGICA GRUPO 6
Equipo PJ GF GC Puntos
1 Wellen Wellen 30 56 25 64
2 Apollo Gellik Apollo 30 54 32 59
3 Herk Herk 30 59 30 58
4 Eendracht Termien Eendracht 30 63 38 53
5 Waltwilder Waltwilder 30 47 42 51
6 Thes Sport Thes Sport 30 53 37 49
7 Lindelhoeven Lindelhoeven 30 58 67 40
8 Huvo Jeuk Huvo Jeuk 30 51 68 36
9 Beringen Beringen 30 47 67 36
10 Helson Helchteren Helson 30 45 41 35
11 Zonhoven Zonhoven 30 53 61 35
12 Moelingen Moelingen 30 44 47 34
13 Melo Zonhoven Melo 30 46 65 32
14 Brustem Centrum Brustem 30 48 65 31
15 Landen Landen 30 38 45 30
16 Groen Star Beek Groen Star. 30 28 60 25

  USO DE MEMORIA  
6,196,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1205
Total Execution Time  0.1217
  CADENA URL  
/historico/Eendracht-Termien
  GET DATOS  
$_GET['/historico/Eendracht-Termien']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0035  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 = 'Eendracht-Termien' 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.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=16959 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=16959 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=16959 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 72774
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16959 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=569 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 569 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0020  SELECT /*53 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 (169732) ORDER BY n.cover_points DESC, update_date DESC
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 = '16959' AND l.year = 2024 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 = '16959' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 72774 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=16959 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (73206,72774,67320) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72774 AND teamId = 16959
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 16959
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 16959
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 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 = 72774 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '16959' 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 = '16959' and rp.type = 4
0.0021  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 = '16959' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  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 = 72774 WHERE rp.league_id = 72774 AND rp.teamId = 16959 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.0019  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 = 72774 WHERE rp.league_id = 72774 AND rp.teamId = 16959 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 72774 WHERE rp.league_id = 72774 AND rp.teamId = 16959 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 16959 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72774 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.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 `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 = 68886 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.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 `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 = 63442 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 `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 = 58300 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.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 `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 = 51112 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.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 `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 = 44697 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 `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 = 38985 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 `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 = 34024 AND t.round = 30 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 `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 = 15949 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 `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 = 4188 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0054  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 = 3524 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 72774 ORDER BY nameShow LIMIT 100