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 2015/2016
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 3
Equipo PJ GF GC Puntos
1 Incheon United Incheon 14 19 11 67
2 Daegu FC Daegu FC 14 21 15 61
3 Jeonnam Dragons Jeonnam 14 18 10 53
4 Seongnam FC Seongnam FC 14 16 19 52
5 Gangwon FC Gangwon FC 14 25 16 51
6 Gwangju FC Gwangju FC 14 19 18 46
7 Gimcheon Sangmu FC Gimcheon 14 2 26 30
8 Daejeon Citizen Daejeon 14 18 23 19
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
TEMPORADA 2007/2008
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Suwon Bluewings Suwon 26 46 24 54
2 FC Seoul FC Seoul 26 44 25 54
3 Seongnam FC Seongnam FC 26 45 21 51
4 Ulsan HD FC Ulsan HD FC 26 39 26 49
5 Pohang Steelers Pohang 26 43 34 44
6 Jeonbuk Hyundai Motors Jeonbuk 26 39 37 37
7 Incheon United Incheon 26 29 30 36
8 Gyeongnam FC Gyeongnam 26 35 39 35
9 Jeonnam Dragons Jeonnam 26 26 40 29
10 Jeju United Jeju United 26 23 31 28
11 Daegu FC Daegu FC 26 46 58 26
12 Busan I Park Busan Park 26 30 39 22
13 Daejeon Citizen Daejeon 26 18 35 21
14 Gwangju Sangmu Gwangju 26 22 46 16
TEMPORADA 2006/2007
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Seongnam FC Seongnam FC 26 43 18 55
2 Suwon Bluewings Suwon 26 36 24 51
3 Ulsan HD FC Ulsan HD FC 26 34 22 45
4 Gyeongnam FC Gyeongnam 26 41 31 44
5 Pohang Steelers Pohang 26 27 31 39
6 Daejeon Citizen Daejeon 26 34 27 37
7 FC Seoul FC Seoul 26 23 16 37
8 Jeonbuk Hyundai Motors Jeonbuk 26 36 32 36
9 Incheon United Incheon 26 30 32 33
10 Jeonnam Dragons Jeonnam 26 24 27 30
11 Jeju United Jeju United 26 27 35 30
12 Daegu FC Daegu FC 26 35 46 24
13 Busan I Park Busan Park 26 20 39 20
14 Gwangju Sangmu Gwangju 26 14 44 12
TEMPORADA 2005/2006
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Pohang Steelers Pohang 26 42 26 50
2 Seongnam FC Seongnam FC 26 41 25 47
3 Suwon Bluewings Suwon 26 29 22 43
4 FC Seoul FC Seoul 26 32 23 39
5 Ulsan HD FC Ulsan HD FC 26 22 23 35
6 Jeonnam Dragons Jeonnam 26 28 25 34
7 Daegu FC Daegu FC 26 32 30 34
8 Incheon United Incheon 26 24 27 33
9 Busan I Park Busan Park 26 38 42 31
10 Daejeon Citizen Daejeon 26 28 32 31
11 Jeonbuk Hyundai Motors Jeonbuk 26 25 34 28
12 Gyeongnam FC Gyeongnam 26 22 34 27
13 Jeju United Jeju United 26 23 30 25
14 Gwangju Sangmu Gwangju 26 17 30 22
TEMPORADA 2004/2005
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Incheon United Incheon 24 36 26 45
2 Seongnam FC Seongnam FC 24 40 24 43
3 Ulsan HD FC Ulsan HD FC 24 31 24 43
4 Jeju United Jeju United 24 26 18 42
5 Pohang Steelers Pohang 24 28 22 40
6 FC Seoul FC Seoul 24 37 32 32
7 Daejeon Citizen Daejeon 24 19 20 30
8 Daegu FC Daegu FC 24 29 36 30
9 Suwon Bluewings Suwon 24 29 32 28
10 Busan I Park Busan Park 24 28 31 28
11 Jeonnam Dragons Jeonnam 24 23 29 27
12 Jeonbuk Hyundai Motors Jeonbuk 24 24 41 18
13 Gwangju Sangmu Gwangju 24 23 38 17
TEMPORADA 2003/2004
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Ulsan HD FC Ulsan HD FC 24 22 14 41
2 Suwon Bluewings Suwon 24 31 24 41
3 Jeonnam Dragons Jeonnam 24 29 20 37
4 FC Seoul FC Seoul 24 20 17 33
5 Jeonbuk Hyundai Motors Jeonbuk 24 23 18 32
6 Pohang Steelers Pohang 24 23 24 32
7 Busan I Park Busan Park 24 21 19 30
8 Gwangju Sangmu Gwangju 24 18 20 29
9 Seongnam FC Seongnam FC 24 23 28 29
10 Daegu FC Daegu FC 24 30 31 28
11 Daejeon Citizen Daejeon 24 18 26 26
12 Incheon United Incheon 24 20 29 26
13 Jeju United Jeju United 24 19 27 25
TEMPORADA 2002/2003
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Seongnam FC Seongnam FC 44 85 50 91
2 Ulsan HD FC Ulsan HD FC 44 63 44 73
3 Suwon Bluewings Suwon 44 59 46 72
4 Jeonnam Dragons Jeonnam 44 65 48 71
5 Jeonbuk Hyundai Motors Jeonbuk 44 72 58 69
6 Daejeon Citizen Daejeon 44 50 51 65
7 Pohang Steelers Pohang 44 53 46 64
8 FC Seoul FC Seoul 44 69 68 56
9 Busan I Park Busan Park 44 41 71 49
10 Gwangju Sangmu Gwangju 44 41 60 46
11 Daegu FC Daegu FC 44 38 60 37
12 Bucheon SK Bucheon SK 44 39 73 21

  USO DE MEMORIA  
6,311,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1550
Total Execution Time  0.1562
  CADENA URL  
/historico/Daegu-Fc/2016
  GET DATOS  
$_GET['/historico/Daegu-Fc/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0038  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 = 2016 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.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.0041  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 = 20316
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 = 22216
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=880 AND type_rel = 2
0.0022  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.0025  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.0035  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' ORDER BY l.year DESC,cat.coefficient DESC
0.0034  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 = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0030  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.0023  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 = 22216 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 = 20316 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032  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 (2015,2016,2017) 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 (41142,38028,20316) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 41142 AND teamId = 880
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 20316 AND teamId = 880
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 38028 AND teamId = 880
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  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.0021  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.0048  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 events2016 e ON e.player_id = p.id AND e.league_id = 20316 WHERE rp.league_id = 20316 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.0039  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 events2016 e ON e.player_id = p.id AND e.league_id = 20316 WHERE rp.league_id = 20316 AND rp.teamId = 880 AND (e.action = 4 or e.action = 5) 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 events2016 e ON e.player_id = p.id AND e.league_id = 20316 WHERE rp.league_id = 20316 AND rp.teamId = 880 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 <= 2016 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 `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.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 `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.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 `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.0031  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.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 `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.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 `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.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 = 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.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 `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.0033  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.0027  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
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 `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 = 268 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables2007` 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 = 10279 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables2006` 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 = 10280 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables2005` 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 = 10281 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables2004` 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 = 10283 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 `tables2003` 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 = 15157 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 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 = 20316 ORDER BY nameShow LIMIT 100