4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SUPERLIGA DANESA GRUPO 3
Equipo PJ GF GC Puntos
1 Viborg FF Viborg FF 26 33 41 33
2 Randers Randers 26 36 43 33
3 Odense BK Odense BK 26 28 38 26
4 Lyngby BK Lyngby BK 26 31 48 25
5 Vejle BK Vejle BK 26 23 31 23
6 Hvidovre IF Hvidovre IF 26 22 53 15
TEMPORADA 2022/2023
PRIMERA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Vejle BK Vejle BK 32 61 30 67
2 Hvidovre IF Hvidovre IF 32 65 41 58
3 SonderjyskE SonderjyskE 32 60 45 56
4 Vendsyssel Vendsyssel 32 48 43 46
5 Næstved Næstved 32 50 48 43
6 FC Helsingør Helsingør 32 47 56 42
TEMPORADA 2021/2022
PRIMERA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Helsingør Helsingør 22 52 20 51
2 Lyngby BK Lyngby BK 22 45 21 43
3 Hvidovre IF Hvidovre IF 22 37 22 43
4 AC Horsens AC Horsens 22 37 21 40
5 Fredericia Fredericia 22 38 36 37
6 Nykøbing FC Nykøbing 22 35 37 25
7 HB Køge HB Køge 22 28 32 25
8 Vendsyssel Vendsyssel 22 25 31 24
9 Hobro Hobro 22 31 38 22
10 Esbjerg Esbjerg 22 24 38 20
11 Fremad Amager Fremad 22 24 48 18
12 Jammerbugt Jammerbugt 22 19 51 16
TEMPORADA 2020/2021
PRIMERA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Hvidovre IF Hvidovre IF 32 40 47 39
2 Fremad Amager Fremad 32 47 41 35
3 Hobro Hobro 32 38 51 34
4 Vendsyssel Vendsyssel 32 33 51 32
5 Kolding IF Kolding IF 32 31 49 32
6 Skive Skive 32 28 60 28
TEMPORADA 2019/2020
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
TEMPORADA 2018/2019
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Silkeborg IF Silkeborg 33 60 41 61
2 Viborg FF Viborg FF 33 61 37 60
3 Lyngby BK Lyngby BK 33 51 47 52
4 Næstved Næstved 33 43 40 50
5 Fremad Amager Fremad 33 42 45 50
6 Fredericia Fredericia 33 51 47 47
7 HB Køge HB Køge 33 52 47 45
8 Nykøbing FC Nykøbing 33 44 47 45
9 Roskilde Roskilde 33 57 66 35
10 Hvidovre IF Hvidovre IF 33 39 49 35
11 FC Helsingør Helsingør 33 35 43 31
12 Thisted Thisted 33 35 61 30
TEMPORADA 2017/2018
SEGUNDA DINAMARCA GRUPO 4
Equipo PJ GF GC Puntos
1 Hvidovre IF Hvidovre IF 16 42 14 54
2 Næstved Næstved 16 34 11 46
3 Jammerbugt Jammerbugt 16 25 16 38
4 Kjellerup Kjellerup 16 23 30 34
5 Kolding IF Kolding IF 16 20 19 33
6 Middelfart Middelfart 16 29 25 30
7 Marienlyst Marienlyst 16 19 36 27
8 Skovshoved Skovshoved 16 24 19 26
9 Frem 1886 Frem 1886 16 23 19 25
10 Ringkøbing Ringkøbing 16 22 34 22
11 Avarta Avarta 16 20 32 21
12 Sydvest Sydvest 16 12 38 14
TEMPORADA 2016/2017
SEGUNDA DINAMARCA GRUPO 4
Equipo PJ GF GC Puntos
1 Thisted Thisted 16 38 9 52
2 Brabrand Brabrand 16 32 17 41
3 Kolding IF Kolding IF 16 30 17 40
4 Avarta Avarta 16 32 20 37
5 B93 B93 16 25 22 35
6 Kjellerup Kjellerup 16 32 27 29
7 Brønshøj Brønshøj 16 21 29 27
8 Marienlyst Marienlyst 16 22 30 26
9 Aarhus Fremad Aarhus 16 18 21 24
10 Hvidovre IF Hvidovre IF 16 17 27 22
11 Dalum Dalum 16 12 32 18
12 Greve IF Greve IF 16 15 43 16
TEMPORADA 2015/2016
SEGUNDA DINAMARCA GRUPO 4
Equipo PJ GF GC Puntos
1 Akademisk Boldklub Akademisk 16 40 11 38
2 Nykøbing FC Nykøbing 16 37 21 31
3 Fremad Amager Fremad 16 29 19 30
4 Brønshøj Brønshøj 16 30 24 26
5 Frem 1886 Frem 1886 16 19 16 23
6 Aarhus Fremad Aarhus 16 16 24 23
7 Thisted Thisted 16 28 27 21
8 Brabrand Brabrand 16 24 21 20
9 Hvidovre IF Hvidovre IF 16 21 20 18
10 Marienlyst Marienlyst 16 22 39 17
11 Hellerup IK Hellerup IK 16 13 33 15
12 Middelfart Middelfart 16 12 36 7
TEMPORADA 2014/2015
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Helsingør Helsingør 30 59 22 71
2 Frem 1886 Frem 1886 30 58 28 61
3 Hvidovre IF Hvidovre IF 30 67 38 57
4 Fremad Amager Fremad 30 55 35 56
5 Nykøbing FC Nykøbing 30 69 34 55
6 HIK HIK 30 61 36 48
7 B93 B93 30 36 35 43
8 Avarta Avarta 30 57 48 42
9 Holbæk Holbæk 30 41 44 41
10 B 1908 B 1908 30 42 36 37
11 Rishøj Rishøj 30 31 40 36
12 Avedøre Avedøre 30 33 46 36
13 GVI GVI 30 28 57 26
14 BSV Søllerød Søllerød 30 30 62 21
15 Herlev Herlev 30 29 78 14
16 Svebølle Svebølle 30 20 77 10
TEMPORADA 2013/2014
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Silkeborg IF Silkeborg 33 67 38 66
2 Hobro Hobro 33 58 36 65
3 Lyngby BK Lyngby BK 33 58 41 57
4 Brønshøj Brønshøj 33 47 39 53
5 AC Horsens AC Horsens 33 60 48 52
6 HB Køge HB Køge 33 39 31 49
7 Vejle BK Vejle BK 33 49 38 47
8 Fredericia Fredericia 33 47 45 43
9 Vendsyssel Vendsyssel 33 35 59 38
10 Akademisk Boldklub Akademisk 33 42 57 36
11 Hvidovre IF Hvidovre IF 33 43 63 36
12 Marienlyst Marienlyst 33 28 78 15
TEMPORADA 2012/2013
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Hvidovre IF Hvidovre IF 30 84 31 69
2 FC Helsingør Helsingør 30 79 38 64
3 Rishøj Rishøj 30 50 29 60
4 Næstved Næstved 30 64 32 59
5 HIK HIK 30 58 45 51
6 B 1908 B 1908 30 46 41 51
7 Frem 1886 Frem 1886 30 45 40 48
8 Roskilde Roskilde 30 52 41 46
9 Nordvest Nordvest 30 51 49 44
10 Nykøbing FC Nykøbing 30 48 59 36
11 Avarta Avarta 30 39 47 33
12 Svebølle Svebølle 30 37 61 31
13 Skjold Birkerød Skjold 30 44 65 29
14 Fremad Amager Fremad 30 39 59 23
15 Herlev Herlev 30 27 67 21
16 NB Bornholm NB Bornholm 30 14 73 6
TEMPORADA 2011/2012
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 HIK HIK 30 69 44 71
2 Hvidovre IF Hvidovre IF 30 79 36 66
3 Herlev Herlev 30 56 42 48
4 Rishøj Rishøj 30 48 42 44
5 Fremad Amager Fremad 30 50 47 44
6 Svebølle Svebølle 30 54 55 43
7 Elite 3 Elite 3 30 49 51 43
8 BSV Søllerød Søllerød 30 40 41 42
9 Skjold Birkerød Skjold 30 43 45 42
10 Nordvest Nordvest 30 46 41 41
11 Avarta Avarta 30 38 36 38
12 Vanløse Vanløse 30 41 48 35
13 B93 B93 30 37 44 33
14 SC Egedal SC Egedal 30 47 50 32
15 BGA BGA 30 21 94 5

  USO DE MEMORIA  
6,136,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1342
Total Execution Time  0.1354
  CADENA URL  
/historico/Hvidovre
  GET DATOS  
$_GET['/historico/Hvidovre']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0036  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 = 'Hvidovre' 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=7442 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=7442 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=7442 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=7442 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=7442 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 75671
0.0025  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 = 72110
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7442 AND type_rel = 2
0.0027  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 = '7442' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '7442' 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 = 72110 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=7442 AND l.year in (2023,2024,2025) 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 (75671,75586,72646,71291) 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 = 75671 AND teamId = 7442
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71291 AND teamId = 7442
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 7442
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 75586 AND teamId = 7442
0.0022  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 = '7442' 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 = '7442' 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 = '7442' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0030  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 = 75671 WHERE rp.league_id = 75671 AND rp.teamId = 7442 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 75671 WHERE rp.league_id = 75671 AND rp.teamId = 7442 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 75671 WHERE rp.league_id = 75671 AND rp.teamId = 7442 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 7442 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72110 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 75671 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.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 = 67913 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 71291 AND t.round = 10 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 `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 = 67134 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 63039 AND t.round = 22 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 = 57736 AND t.round = 22 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 = 61986 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 50116 AND t.round = 33 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 = 43923 AND t.round = 33 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 `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 = 38874 AND t.round = 14 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 = 43168 AND t.round = 16 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 = 33543 AND t.round = 14 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 `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 = 38476 AND t.round = 16 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 `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 = 16250 AND t.round = 14 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 = 20328 AND t.round = 16 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 `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 = 4158 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 `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 = 2474 AND t.round = 33 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 `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 = 2022 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 `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 = 1734 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC