4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SEGUNDA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Fremad Amager Fremad 3 7 2 9
2 Hellerup IK Hellerup IK 3 2 3 6
3 FA 2000 FA 2000 3 4 4 4
4 Skive Skive 3 4 5 3
5 Thisted Thisted 3 2 3 3
6 Brabrand Brabrand 3 1 3 1
TEMPORADA 2022/2023
SEGUNDA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Roskilde Roskilde 32 52 39 47
2 Brabrand Brabrand 32 39 45 41
3 Hellerup IK Hellerup IK 32 43 49 40
4 Skive Skive 32 43 50 37
5 Frem 1886 Frem 1886 32 41 56 30
6 Jammerbugt Jammerbugt 32 1 94 0
TEMPORADA 2021/2022
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Næstved Næstved 32 60 33 73
2 Hillerød Hillerød 32 53 38 56
3 Thisted Thisted 32 44 41 54
4 B93 B93 32 53 49 42
5 Akademisk Boldklub Akademisk 32 42 38 38
6 Hellerup IK Hellerup IK 32 46 56 37
TEMPORADA 2020/2021
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Nykøbing FC Nykøbing 26 60 22 62
2 Hellerup IK Hellerup IK 26 39 25 53
3 Akademisk Boldklub Akademisk 26 44 31 51
4 Næstved Næstved 26 48 31 43
5 Hillerød Hillerød 26 33 31 43
6 FA 2000 FA 2000 26 29 24 41
7 Roskilde Roskilde 26 39 33 39
8 Vanløse Vanløse 26 31 29 34
9 Slagelse B&I Slagelse 26 29 33 32
10 KFUM Roskilde KFUM 26 31 44 26
11 Skovshoved Skovshoved 26 30 43 24
12 Avarta Avarta 26 25 43 24
13 Brønshøj Brønshøj 26 34 50 23
14 AB Tårnby AB Tårnby 26 23 56 12
TEMPORADA 2019/2020
SEGUNDA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Aarhus Fremad Aarhus 6 21 2 54
2 FC Helsingør Helsingør 6 9 4 54
3 Middelfart Middelfart 6 15 10 43
4 Brabrand Brabrand 6 7 10 39
5 Thisted Thisted 6 8 9 38
6 Jammerbugt Jammerbugt 6 11 3 37
7 Akademisk Boldklub Akademisk 6 13 12 36
8 Hellerup IK Hellerup IK 6 9 9 35
9 Vanløse Vanløse 6 6 11 34
10 Brønshøj Brønshøj 6 6 20 31
11 Frem 1886 Frem 1886 6 9 17 29
12 Avarta Avarta 6 7 14 25
TEMPORADA 2018/2019
SEGUNDA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Skive Skive 11 17 10 72
2 Kolding IF Kolding IF 11 19 10 66
3 Brabrand Brabrand 11 22 15 65
4 Middelfart Middelfart 11 25 12 61
5 Akademisk Boldklub Akademisk 11 14 11 54
6 Jammerbugt Jammerbugt 11 14 19 54
7 B93 B93 11 18 12 53
8 Aarhus Fremad Aarhus 11 17 17 53
9 Vanløse Vanløse 11 14 16 46
10 Brønshøj Brønshøj 11 12 29 45
11 Hellerup IK Hellerup IK 11 15 21 43
12 Ringkøbing Ringkøbing 11 10 25 40
TEMPORADA 2017/2018
SEGUNDA DINAMARCA GRUPO 5
Equipo PJ GF GC Puntos
1 Hellerup IK Hellerup IK 16 38 20 51
2 Akademisk Boldklub Akademisk 16 27 17 38
3 Aarhus Fremad Aarhus 16 23 26 37
4 B93 B93 16 28 22 35
5 Hillerød Hillerød 16 41 26 34
6 Brønshøj Brønshøj 16 34 23 32
7 Dalum Dalum 16 18 26 30
8 Odder Odder 16 20 30 30
9 Greve IF Greve IF 16 28 32 28
10 Næsby BK Næsby BK 16 36 29 27
11 VSK Aarhus VSK Aarhus 16 27 35 22
12 IF Lyseng IF Lyseng 16 8 42 5
TEMPORADA 2016/2017
SEGUNDA DINAMARCA GRUPO 5
Equipo PJ GF GC Puntos
1 Middelfart Middelfart 16 30 12 51
2 Frem 1886 Frem 1886 16 17 20 36
3 Næsby BK Næsby BK 16 21 22 35
4 Sydvest Sydvest 16 24 17 34
5 VSK Aarhus VSK Aarhus 16 24 20 33
6 Odder Odder 16 27 22 30
7 Jammerbugt Jammerbugt 16 24 21 29
8 Hellerup IK Hellerup IK 16 22 22 29
9 Holbæk Holbæk 16 25 21 25
10 Svendborg Svendborg 16 17 26 23
11 Vejgaard Vejgaard 16 15 27 17
12 Fredensborg BI Fredensborg 16 10 26 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 2010/2011
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Nordvest Nordvest 30 59 29 65
2 FC Helsingør Helsingør 30 63 41 57
3 Hellerup IK Hellerup IK 30 43 24 54
4 Nykøbing FC Nykøbing 30 56 25 53
5 BSV Søllerød Søllerød 30 58 47 50
6 B93 B93 30 57 44 45
7 Avarta Avarta 30 51 44 42
8 Vanløse Vanløse 30 58 52 42
9 Herlev Herlev 30 44 51 41
10 Stenløse BK Stenløse 30 38 44 37
11 BGA BGA 30 40 45 35
12 Skjold Skjold 30 36 43 33
13 Frederikssund IK Frederikssun 30 43 66 32
14 Allerød Allerød 30 32 61 22
15 Greve IF Greve IF 30 32 65 21
16 Ballerup-Skovlunde Ballerup-Sko 30 30 59 20
TEMPORADA 2009/2010
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Brønshøj Brønshøj 30 47 27 61
2 B93 B93 30 60 33 60
3 BSV Søllerød Søllerød 30 70 36 59
4 Avarta Avarta 30 49 33 53
5 Brøndby IF II Brøndby 30 62 39 51
6 Nordvest Nordvest 30 49 49 46
7 Hellerup IK Hellerup IK 30 50 48 43
8 Vanløse Vanløse 30 32 31 43
9 Copenhague II Copenhague 30 42 45 43
10 Greve IF Greve IF 30 41 55 39
11 Nykøbing FC Nykøbing 30 24 33 35
12 Stenløse BK Stenløse 30 50 54 33
13 BGA BGA 30 37 49 33
14 B 1908 B 1908 30 35 54 29
15 Allerød Allerød 30 23 53 20
16 Skjold Skjold 30 22 54 20
TEMPORADA 2008/2009
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Vestsjælland Vestsjællan 30 80 31 65
2 B93 B93 30 67 31 62
3 Brønshøj Brønshøj 30 62 37 56
4 Brøndby IF II Brøndby 30 63 48 52
5 Hellerup IK Hellerup IK 30 44 40 48
6 Stenløse BK Stenløse 30 55 51 43
7 Copenhague II Copenhague 29 41 40 39
8 Avarta Avarta 30 47 49 38
9 Skjold Skjold 30 47 50 37
10 Ølstykke FC Ølstykke 30 50 62 37
11 BGA BGA 30 37 52 37
12 Greve IF Greve IF 30 39 55 35
13 BSV Søllerød Søllerød 30 43 62 34
14 Vanløse Vanløse 29 43 47 28
15 Skovlunde IF Skovlunde 30 40 63 26
16 Værløse Værløse 30 39 79 21
TEMPORADA 2007/2008
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Vejle BK Vejle BK 30 80 24 78
2 SonderjyskE SonderjyskE 30 55 32 61
3 Silkeborg IF Silkeborg 30 60 33 57
4 Herfølge BK Herfølge 30 55 43 51
5 Fredericia Fredericia 30 49 36 44
6 Akademisk Boldklub Akademisk 30 38 36 41
7 Kolding IF Kolding IF 30 53 47 40
8 Næstved Næstved 30 36 39 40
9 Frem 1886 Frem 1886 30 46 54 39
10 Hvidovre IF Hvidovre IF 30 31 33 37
11 Skive Skive 30 36 52 34
12 Nykøbing FC Nykøbing 30 28 41 33
13 Køge BK Køge BK 30 36 51 33
14 Hellerup IK Hellerup IK 30 36 56 31
15 Aarhus Fremad Aarhus 30 22 43 28
16 Ølstykke FC Ølstykke 30 20 61 18

  USO DE MEMORIA  
6,139,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7794
Total Execution Time  0.7806
  CADENA URL  
/historico/Hellerup-Ik
  GET DATOS  
$_GET['/historico/Hellerup-Ik']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0195  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 = 'Hellerup-Ik' 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.0146  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=62304 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=62304 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=62304 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=62304 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=62304 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0294  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 = 72491
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62304 AND type_rel = 2
0.0151  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 = '62304' ORDER BY l.year DESC,cat.coefficient DESC
0.0169  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 = '62304' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  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 = '62304' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0160  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=62304 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (75800,72646,71432) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 75800 AND teamId = 62304
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 62304
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 62304
0.0147  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 = '62304' 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 = '62304' 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 = '62304' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0148  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 = 75800 WHERE rp.league_id = 75800 AND rp.teamId = 62304 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.0146  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 = 75800 WHERE rp.league_id = 75800 AND rp.teamId = 62304 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 75800 WHERE rp.league_id = 75800 AND rp.teamId = 62304 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 62304 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72491 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.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 `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 = 75800 AND t.round = 3 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 `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 = 68164 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.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 `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 = 71480 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.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 `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 = 63169 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.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 = 67321 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.0152  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 = 58310 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.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 `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 = 50399 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 `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 = 56776 AND t.round = 6 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 `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 = 44273 AND t.round = 22 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 `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 = 49553 AND t.round = 11 ORDER BY team.conference 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 `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 = 38875 AND t.round = 14 ORDER BY team.conference 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 `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 = 43169 AND t.round = 16 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 `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.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 `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 = 38477 AND t.round = 16 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 = 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.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 `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 = 24342 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 `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 = 24358 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 `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 = 24415 AND t.round = 30 ORDER BY team.conference 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 `tables2008` 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 = 10295 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC