4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
TERCERA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Frem 1886 Frem 1886 25 41 23 50
2 Ishøj Ishøj 25 45 32 41
3 VSK Aarhus VSK Aarhus 25 40 30 38
4 Holbæk Holbæk 25 27 28 34
5 Avarta Avarta 25 24 31 34
6 Næsby BK Næsby BK 25 38 39 32
TEMPORADA 2022/2023
SERIES DINAMARCA GRUPO 6
Equipo PJ GF GC Puntos
1 Holbæk Holbæk 14 25 13 32
2 Vejgaard Vejgaard 14 22 9 30
3 Avarta Avarta 14 16 11 26
4 Marienlyst Marienlyst 14 23 21 23
5 Frederikssund IK Frederikssun 14 18 29 17
6 Brønshøj Brønshøj 14 12 14 14
7 Odder Odder 14 17 25 14
8 Ringkøbing Ringkøbing 14 20 31 11
TEMPORADA 2021/2022
SERIES DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Ishøj Ishøj 27 88 41 59
2 Greve IF Greve IF 27 50 27 50
3 Allerød Allerød 27 66 35 50
4 Avarta Avarta 27 54 40 49
5 Frederikssund IK Frederikssun 27 67 51 43
6 Brønshøj Brønshøj 27 50 45 37
7 Herstedøster Herstedøste 27 40 57 30
8 B 1903 B 1903 27 33 66 25
9 Solröd Solröd 27 26 63 18
10 BK Union BK Union 27 33 82 12
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 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 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 1
Equipo PJ GF GC Puntos
1 HIK HIK 14 27 14 30
2 Hvidovre IF Hvidovre IF 14 19 12 23
3 Akademisk Boldklub Akademisk 14 17 13 23
4 Brønshøj Brønshøj 14 15 15 21
5 Avarta Avarta 14 19 16 20
6 Holbæk Holbæk 14 19 22 18
7 AB Tårnby AB Tårnby 14 16 30 11
8 B 1908 B 1908 14 18 28 10
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
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Roskilde Roskilde 30 88 22 80
2 Næstved Næstved 29 67 33 58
3 Fremad Amager Fremad 30 76 55 51
4 B 1908 B 1908 29 45 34 50
5 FC Helsingør Helsingør 30 55 38 47
6 Nordvest Nordvest 30 66 58 45
7 Nykøbing FC Nykøbing 30 55 60 40
8 Frem 1886 Frem 1886 30 50 46 40
9 BSV Søllerød Søllerød 29 38 41 38
10 B93 B93 30 42 43 36
11 GVI GVI 29 40 60 35
12 Svebølle Svebølle 30 32 46 32
13 Avarta Avarta 30 50 67 31
14 Skjold Birkerød Skjold 30 41 70 30
15 Vanløse Vanløse 30 34 67 29
16 SC Egedal SC Egedal 30 31 70 20
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,019,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1417
Total Execution Time  0.1429
  CADENA URL  
/historico/Avarta
  GET DATOS  
$_GET['/historico/Avarta']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0032  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 = 'Avarta' 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=7451 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=7451 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=7451 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=7451 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 75803
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 = 72492
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7451 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2481 AND type_rel = 3
0.0026  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 = '7451' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '7451' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '7451' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 72492 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=7451 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 (75803,71432,70734,68278) 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 = 75803 AND teamId = 7451
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 70734 AND teamId = 7451
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 68278 AND teamId = 7451
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7451
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 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 = 75803 AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '7451' 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 = '7451' 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 = '7451' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 75803 WHERE rp.league_id = 75803 AND rp.teamId = 7451 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 = 75803 WHERE rp.league_id = 75803 AND rp.teamId = 7451 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 = 75803 WHERE rp.league_id = 75803 AND rp.teamId = 7451 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 7451 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 = 72492 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 `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 = 75803 AND t.round = 4 ORDER BY team.conference ASC,t.position 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 `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 = 68397 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.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 `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 = 70734 AND t.round = 14 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 = 63283 AND t.round = 27 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 = 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.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 = 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.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 = 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.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 = 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.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 = 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.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 = 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.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 = 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.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.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 `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.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 `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 = 2480 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 `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
0.0019  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 = 75803 ORDER BY nameShow LIMIT 100