4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Dalum
TEMPORADA 2023/2024
SERIES DINAMARCA GRUPO 8
Equipo PJ GF GC Puntos
1 Tarup-Paarup Tarup-Paarup 18 27 33 23
2 Ringkøbing Ringkøbing 18 29 28 22
3 B 1913 B 1913 18 23 25 22
4 Hedensted Hedensted 18 32 36 22
5 Hobro II Hobro II 18 35 38 21
6 Dalum Dalum 18 25 33 20
7 VRI VRI 18 33 47 18
8 Aalborg BK II Aalborg 18 19 38 13
9 Fjordager Fjordager 18 8 50 6
10 Varde IF Elite Varde Elite 18 20 51 5
TEMPORADA 2022/2023
TERCERA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Young Boys FD Young Boys 32 60 29 59
2 Holstebro Holstebro 32 46 42 42
3 IF Lyseng IF Lyseng 32 53 55 41
4 SfB-Oure SfB-Oure 32 49 71 38
5 AB Tårnby AB Tårnby 32 41 74 28
6 Dalum Dalum 32 12 110 3
TEMPORADA 2021/2022
TERCERA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Roskilde Roskilde 32 93 38 69
2 Frem 1886 Frem 1886 32 72 38 60
3 VSK Aarhus VSK Aarhus 32 56 45 53
4 Næsby BK Næsby BK 32 53 46 47
5 Dalum Dalum 32 42 47 42
6 IF Lyseng IF Lyseng 32 40 68 37
TEMPORADA 2020/2021
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Jammerbugt Jammerbugt 26 53 24 60
2 B93 B93 26 48 29 53
3 Aarhus Fremad Aarhus 26 53 35 46
4 Middelfart Middelfart 26 47 36 43
5 Thisted Thisted 26 34 25 43
6 Brabrand Brabrand 26 39 29 41
7 VSK Aarhus VSK Aarhus 26 33 26 39
8 Frem 1886 Frem 1886 26 36 31 39
9 Dalum Dalum 26 33 40 33
10 Næsby BK Næsby BK 26 35 44 32
11 Holbæk Holbæk 26 35 47 28
12 Sydvest Sydvest 26 30 45 24
13 SfB-Oure SfB-Oure 26 34 72 15
14 Holstebro Holstebro 26 27 54 11
TEMPORADA 2019/2020
SEGUNDA DINAMARCA GRUPO 4
Equipo PJ GF GC Puntos
1 B93 B93 6 18 5 35
2 Hillerød Hillerød 6 13 2 35
3 VSK Aarhus VSK Aarhus 6 4 10 29
4 Holbæk Holbæk 6 11 9 27
5 FA 2000 FA 2000 6 6 8 27
6 Dalum Dalum 6 3 7 26
7 Sydvest Sydvest 6 8 8 25
8 Skovshoved Skovshoved 6 7 4 23
9 Næsby BK Næsby BK 6 5 11 22
10 Slagelse B&I Slagelse 6 10 8 21
11 Vejgaard B Vejgaard B 6 9 12 18
12 Ringkøbing Ringkøbing 6 7 17 16
TEMPORADA 2018/2019
SEGUNDA DINAMARCA GRUPO 4
Equipo PJ GF GC Puntos
1 Frem 1886 Frem 1886 11 26 16 55
2 Hillerød Hillerød 11 18 14 49
3 Avarta Avarta 11 25 15 45
4 Slagelse B&I Slagelse 11 15 13 44
5 Vejgaard B Vejgaard B 11 17 13 43
6 Dalum Dalum 11 21 20 37
7 Sydvest Sydvest 11 19 17 36
8 Skovshoved Skovshoved 11 16 15 36
9 Odder Odder 11 20 18 35
10 Tarup-Paarup Tarup-Paarup 11 16 14 29
11 Kjellerup Kjellerup 11 14 31 19
12 Marienlyst Marienlyst 11 7 28 16
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 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 5
Equipo PJ GF GC Puntos
1 B93 B93 16 39 21 39
2 Avarta Avarta 16 18 16 39
3 Odder Odder 16 30 15 38
4 Dalum Dalum 16 25 11 37
5 Næsby BK Næsby BK 16 31 15 36
6 VSK Aarhus VSK Aarhus 16 30 27 29
7 Kolding IF Kolding IF 16 23 28 28
8 Holbæk Holbæk 16 20 26 28
9 Svendborg Svendborg 16 19 23 27
10 Jammerbugt Jammerbugt 16 24 30 27
11 AB Tårnby AB Tårnby 16 21 41 22
12 B 1908 B 1908 16 16 43 16
TEMPORADA 2014/2015
SERIES DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Sønderborg Sønderborg 16 35 19 32
2 Skanderborg Skanderborg 16 33 24 30
3 Ledoeje-Smoerum Ledoeje-Smoe 15 45 30 29
4 Dalum Dalum 16 30 16 29
5 Kalundborg Kalundborg 16 43 30 29
6 Boldklubben 1909 Boldklubben 16 37 26 29
7 Marstal/Rise Marstal/Rise 16 23 12 29
8 FA 2000 FA 2000 16 35 24 25
9 Otterup Otterup 16 18 23 20
10 Ringsted Ringsted 15 22 25 19
11 Døllefjelde-Musse Døllefjelde 16 25 35 13
12 Slagelse Slagelse 16 23 54 8
13 Næsby BK II Næsby 16 16 50 8
14 Næstved II Næstved II 16 20 37 7
TEMPORADA 2009/2010
SERIES DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Rishøj Rishøj 25 71 36 51
2 Svebølle Svebølle 25 67 38 51
3 Middelfart Middelfart 25 52 32 51
4 Herlev Herlev 25 55 32 50
5 Næstved II Næstved II 25 52 37 47
6 Avedøre Avedøre 25 51 39 42
7 Skjold Birkerød Skjold 25 56 41 39
8 Marienlyst Marienlyst 25 56 51 37
9 Fjordager Fjordager 25 37 52 30
10 Kolding IF Kolding IF 25 31 38 28
11 Odense Kammeraternes SK Odense 25 22 54 23
12 B 1913 B 1913 25 26 52 22
13 Dalum Dalum 25 22 61 13
14 Boldklubben 1909 Boldklubben 25 18 53 10
TEMPORADA 2008/2009
SERIES DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Otterup Otterup 26 82 37 61
2 Nordvest Nordvest 26 78 34 57
3 Næstved II Næstved II 26 71 36 51
4 Middelfart Middelfart 26 67 49 45
5 B 1921 B 1921 26 59 41 45
6 Svebølle Svebølle 26 57 53 40
7 Dalum Dalum 26 53 43 39
8 Herfølge BK II Herfølge 26 59 52 38
9 Boldklubben 1909 Boldklubben 26 58 57 38
10 B 1913 B 1913 25 34 50 31
11 Odense Kammeraternes SK Odense 26 44 59 29
12 Frem Sakskøbing Frem 25 54 59 25
13 Nakskov Nakskov 26 27 95 8
14 Køge BK II Køge BK II 26 4 82 3

  USO DE MEMORIA  
5,993,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6940
Total Execution Time  0.6952
  CADENA URL  
/historico/Dalum
  GET DATOS  
$_GET['/historico/Dalum']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0145  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 = 'Dalum' 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.0125  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=19351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=19351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=19351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=19351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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 = 72497
0.0132  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 = 72646
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19351 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=340 AND type_rel = 3
0.0129  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 = '19351' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0133  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 = '19351' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 72497 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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=19351 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 (75829,72646,71482,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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 71482 AND teamId = 19351
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 75829 AND teamId = 19351
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 19351
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 19351
0.0127  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 = '19351' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19351' and rp.type = 4
0.0127  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 = '19351' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 = 75829 WHERE rp.league_id = 75829 AND rp.teamId = 19351 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.0129  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 = 75829 WHERE rp.league_id = 75829 AND rp.teamId = 19351 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 75829 WHERE rp.league_id = 75829 AND rp.teamId = 19351 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 19351 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72497 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 75829 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.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 `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 = 68165 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.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 `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 = 71482 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.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 `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 = 63192 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.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 `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 = 67333 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.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 `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 = 58309 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.0127  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 = 50400 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.0127  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 = 56777 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.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 `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 = 44272 AND t.round = 22 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 `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 = 49554 AND t.round = 11 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 `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.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 `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.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 `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 = 33544 AND t.round = 14 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 `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.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 `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 = 16251 AND t.round = 14 ORDER BY team.conference 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 `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 = 20329 AND t.round = 16 ORDER BY team.conference 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 `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 = 4227 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 = 24331 AND t.round = 26 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 `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 = 24336 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC