4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Daegu FC

Daegu FC

Entrenador: Chang-hyeon Park

TEMPORADA 2020/2021
K LEAGUE 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Jeonbuk Hyundai Motors Jeonbuk 5 13 5 12
2 Ulsan HD FC Ulsan HD FC 5 10 6 10
3 Jeju United Jeju United 5 9 5 9
4 Suwon FC Suwon FC 5 8 8 6
5 Daegu FC Daegu FC 5 4 11 6
6 Suwon Bluewings Suwon 5 1 10 1
TEMPORADA 2019/2020
K LEAGUE 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Jeonbuk Hyundai Motors Jeonbuk 5 8 2 60
2 Ulsan HD FC Ulsan HD FC 5 9 8 57
3 Pohang Steelers Pohang 5 15 7 50
4 Gimcheon Sangmu FC Gimcheon 5 5 9 44
5 Daegu FC Daegu FC 5 7 8 38
6 Gwangju FC Gwangju FC 5 4 14 25
TEMPORADA 2018/2019
K LEAGUE 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Jeonbuk Hyundai Motors Jeonbuk 5 8 2 79
2 Ulsan HD FC Ulsan HD FC 5 7 7 79
3 Pohang Steelers Pohang 5 9 6 56
4 FC Seoul FC Seoul 5 3 8 56
5 Daegu FC Daegu FC 5 5 6 55
6 Gangwon FC Gangwon FC 5 8 11 50
TEMPORADA 2017/2018
K LEAGUE 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Daegu FC Daegu FC 5 5 2 50
2 Gangwon FC Gangwon FC 5 5 5 46
3 Incheon United Incheon 5 9 5 42
4 Gimcheon Sangmu FC Gimcheon 5 3 3 40
5 FC Seoul FC Seoul 5 5 6 40
6 Jeonnam Dragons Jeonnam 5 4 10 32
TEMPORADA 2016/2017
K LEAGUE 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Pohang Steelers Pohang 5 17 6 52
2 Daegu FC Daegu FC 5 7 3 47
3 Incheon United Incheon 5 4 7 39
4 Gimcheon Sangmu FC Gimcheon 5 5 9 35
5 Jeonnam Dragons Jeonnam 5 5 10 35
6 Gwangju FC Gwangju FC 5 5 8 30
TEMPORADA 2015/2016
K LEAGUE 2
Equipo PJ GF GC Puntos
1 Daegu FC Daegu FC 40 53 36 70
2 Chungnam Asan FC Chungnam 40 57 55 70
3 Bucheon FC 1995 Bucheon 1995 40 49 33 67
4 Gangwon FC Gangwon FC 40 50 33 66
5 Busan I Park Busan Park 40 52 39 64
6 Seoul E-Land FC Seoul E-Land 40 47 35 64
7 Daejeon Citizen Daejeon 40 56 52 55
8 Gyeongnam FC Gyeongnam 40 61 58 50
9 FC Anyang FC Anyang 40 40 53 46
10 Chungju Hummel Chungju 40 42 62 29
11 Goyang Hi FC Goyang 40 21 72 16
TEMPORADA 2014/2015
K LEAGUE 2
Equipo PJ GF GC Puntos
1 Gimcheon Sangmu FC Gimcheon 40 77 57 67
2 Daegu FC Daegu FC 40 67 47 67
3 Suwon FC Suwon FC 40 64 54 65
4 Seoul E-Land FC Seoul E-Land 40 69 58 61
5 Bucheon FC 1995 Bucheon 1995 40 43 45 55
6 FC Anyang FC Anyang 40 53 52 54
7 Gangwon FC Gangwon FC 40 64 56 51
8 Goyang Hi FC Goyang 40 46 68 49
9 Gyeongnam FC Gyeongnam 40 30 43 43
10 Chungnam Asan FC Chungnam 40 31 48 42
11 Chungju Hummel Chungju 40 49 65 41
TEMPORADA 2013/2014
K LEAGUE 2
Equipo PJ GF GC Puntos
1 Daejeon Citizen Daejeon 36 64 36 70
2 Chungnam Asan FC Chungnam 36 58 48 59
3 Gangwon FC Gangwon FC 36 48 50 54
4 Gwangju FC Gwangju FC 36 40 35 51
5 FC Anyang FC Anyang 36 49 52 51
6 Suwon FC Suwon FC 36 52 49 48
7 Daegu FC Daegu FC 36 50 47 47
8 Goyang Hi FC Goyang 36 36 41 47
9 Chungju Hummel Chungju 36 37 57 34
10 Bucheon FC 1995 Bucheon 1995 36 33 52 27
TEMPORADA 2012/2013
K LEAGUE 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Seongnam FC Seongnam FC 12 15 11 60
2 Jeju United Jeju United 12 11 12 58
3 Jeonnam Dragons Jeonnam 12 10 16 40
4 Gyeongnam FC Gyeongnam 12 16 14 37
5 Gangwon FC Gangwon FC 12 19 15 36
6 Daejeon Citizen Daejeon 12 17 16 32
7 Daegu FC Daegu FC 12 12 16 32
TEMPORADA 2011/2012
K LEAGUE 1 GRUPO 1
Equipo PJ GF GC Puntos
1 FC Seoul FC Seoul 30 54 28 64
2 Jeonbuk Hyundai Motors Jeonbuk 30 60 30 59
3 Suwon Bluewings Suwon 30 48 36 53
4 Ulsan HD FC Ulsan HD FC 30 43 31 53
5 Pohang Steelers Pohang 30 40 31 50
6 Busan I Park Busan Park 30 29 30 46
7 Jeju United Jeju United 30 56 43 43
8 Gyeongnam FC Gyeongnam 30 40 37 40
9 Incheon United Incheon 30 27 29 40
10 Daegu FC Daegu FC 30 34 41 39
11 Seongnam FC Seongnam FC 30 31 37 37
12 Jeonnam Dragons Jeonnam 30 29 50 29
13 Daejeon Citizen Daejeon 30 26 46 28
14 Gwangju FC Gwangju FC 30 38 49 27
15 Gimcheon Sangmu FC Gimcheon 30 29 46 27
16 Gangwon FC Gangwon FC 30 32 52 25
TEMPORADA 2010/2011
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Jeonbuk Hyundai Motors Jeonbuk 30 67 32 63
2 Pohang Steelers Pohang 30 59 33 59
3 FC Seoul FC Seoul 30 56 38 55
4 Suwon Bluewings Suwon 30 51 33 55
5 Busan I Park Busan Park 30 49 43 46
6 Ulsan HD FC Ulsan HD FC 30 33 29 46
7 Jeonnam Dragons Jeonnam 30 33 29 43
8 Gyeongnam FC Gyeongnam 30 41 40 42
9 Jeju United Jeju United 30 44 45 40
10 Seongnam FC Seongnam FC 30 43 47 35
11 Gwangju FC Gwangju FC 30 32 43 35
12 Daegu FC Daegu FC 30 35 46 33
13 Incheon United Incheon 30 31 40 32
14 Gimcheon Sangmu FC Gimcheon 30 36 53 29
15 Daejeon Citizen Daejeon 30 31 59 27
16 Gangwon FC Gangwon FC 30 14 45 15
TEMPORADA 2009/2010
K LEAGUE 1
Equipo PJ GF GC Puntos
1 FC Seoul FC Seoul 28 58 26 62
2 Jeju United Jeju United 28 54 25 59
3 Jeonbuk Hyundai Motors Jeonbuk 28 54 36 51
4 Ulsan HD FC Ulsan HD FC 28 47 30 50
5 Seongnam FC Seongnam FC 28 46 26 48
6 Gyeongnam FC Gyeongnam 28 41 32 48
7 Suwon Bluewings Suwon 28 39 44 41
8 Busan I Park Busan Park 28 36 37 33
9 Pohang Steelers Pohang 28 39 48 33
10 Jeonnam Dragons Jeonnam 28 40 49 32
11 Incheon United Incheon 28 42 51 31
12 Gangwon FC Gangwon FC 28 36 50 30
13 Daejeon Citizen Daejeon 28 27 50 22
14 Gwangju Sangmu Gwangju 28 17 43 19
15 Daegu FC Daegu FC 28 28 57 19
TEMPORADA 2008/2009
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Jeonbuk Hyundai Motors Jeonbuk 28 59 33 57
2 Pohang Steelers Pohang 28 55 33 53
3 FC Seoul FC Seoul 28 47 27 53
4 Seongnam FC Seongnam FC 28 40 34 45
5 Incheon United Incheon 28 31 29 43
6 Jeonnam Dragons Jeonnam 28 41 39 42
7 Gyeongnam FC Gyeongnam 28 38 32 40
8 Ulsan HD FC Ulsan HD FC 28 32 29 36
9 Daejeon Citizen Daejeon 28 29 38 33
10 Suwon Bluewings Suwon 28 29 32 32
11 Gwangju Sangmu Gwangju 28 33 40 30
12 Busan I Park Busan Park 28 36 42 29
13 Gangwon FC Gangwon FC 28 42 57 28
14 Jeju United Jeju United 28 22 44 28
15 Daegu FC Daegu FC 28 20 45 23

  USO DE MEMORIA  
6,440,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1712
Total Execution Time  0.1725
  CADENA URL  
/historico/Daegu-Fc/2021
  GET DATOS  
$_GET['/historico/Daegu-Fc/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (57)  
0.0044  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 = 'Daegu-Fc' AND l.year = 2021 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=880 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=880 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=880 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=880 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=880 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=880 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=880 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 = 61108
0.0023  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 = 65507
0.0026  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 = 61157
0.0027  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 = 62554
0.0027  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 = 61147
0.0023  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 = 61381
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=880 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 880 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  SELECT /*35 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 (261503,1012178) ORDER BY n.cover_points DESC, update_date DESC
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 = '880' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0037  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 = '880' 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 = 61147 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 62554 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 61381 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 61108 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=880 AND l.year in (2020,2021,2022) 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 (69718,67473,66717,66456) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 69718 AND teamId = 880
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 67473 AND teamId = 880
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 66456 AND teamId = 880
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 66717 AND teamId = 880
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 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 = 61108 AND t.round = 33 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 = '880' 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 = '880' 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 = '880' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0035  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 events2021 e ON e.player_id = p.id AND e.league_id = 61108 WHERE rp.league_id = 61108 AND rp.teamId = 880 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.0033  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 events2021 e ON e.player_id = p.id AND e.league_id = 61108 WHERE rp.league_id = 61108 AND rp.teamId = 880 AND (e.action = 4 or e.action = 5) 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 events2021 e ON e.player_id = p.id AND e.league_id = 61108 WHERE rp.league_id = 61108 AND rp.teamId = 880 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 880 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 61108 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.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 `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 = 65507 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 `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 = 55071 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 `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 = 59654 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.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 = 48770 AND t.round = 33 ORDER BY team.conference 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 `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 = 51584 AND t.round = 5 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 = 42464 AND t.round = 33 ORDER BY team.conference 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 `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 = 48451 AND t.round = 5 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 = 37552 AND t.round = 33 ORDER BY team.conference 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 `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 = 41142 AND t.round = 5 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 = 20316 AND t.round = 44 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 = 10004 AND t.round = 44 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 `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 = 4832 AND t.round = 36 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 `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 = 2306 AND t.round = 26 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 `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 = 10271 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 `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 = 10270 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 `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 = 1591 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 `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 = 1590 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 `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 = 1052 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 `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 = 890 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC