4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Dolný Kubín
TEMPORADA 2023/2024
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Komárno Komárno 28 60 22 67
2 Tatran Prešov Tatran 28 50 19 60
3 FC Petržalka Petržalka 28 57 27 58
4 Považská Bystrica Považská 28 47 34 47
5 Humenné Humenné 28 41 31 47
6 Púchov Púchov 28 49 47 43
7 Žilina II Žilina II 28 56 56 40
8 Spartak Myjava Spartak 28 39 40 40
9 Liptovsky Mikulas Liptovsky 28 47 48 36
10 Pohronie Pohronie 28 41 47 36
11 Šamorín Šamorín 28 46 55 34
12 Slovan Bratislava II Slovan 28 42 53 32
13 Slavoj Trebišov Slavoj 28 33 47 32
14 Malženice Malženice 28 34 46 25
15 Dolný Kubín Dolný 28 23 62 17
16 Spišská Nová Ves Spišská 28 19 50 10
TEMPORADA 2022/2023
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 FK Košice FK Košice 30 61 21 66
2 Tatran Prešov Tatran 30 49 24 62
3 Komárno Komárno 30 41 26 53
4 Žilina II Žilina II 30 63 53 47
5 Pohronie Pohronie 30 45 41 44
6 Spartak Myjava Spartak 30 46 41 43
7 Slovan Bratislava II Slovan 30 43 45 43
8 Považská Bystrica Považská 30 52 48 40
9 Šamorín Šamorín 30 44 50 40
10 Púchov Púchov 30 47 44 38
11 Slavoj Trebišov Slavoj 30 32 44 36
12 FC Petržalka Petržalka 30 40 43 34
13 Dolný Kubín Dolný 30 36 60 34
14 Humenné Humenné 30 24 35 32
15 FK Rača FK Rača 30 25 52 26
16 Dubnica Dubnica 30 38 59 25
TEMPORADA 2021/2022
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Dolný Kubín Dolný 30 81 31 68
2 FK Rakytovce 85 Rakytovce 30 60 25 62
3 Fomat Martin Fomat Martin 30 58 30 62
4 Oravské Veselé Oravské 30 55 27 56
5 Bánová Bánová 30 45 20 54
6 Novohrad Lučenec Novohrad 30 44 35 52
7 FTC Filakovo Filakovo 30 43 37 48
8 Podkonice Podkonice 30 60 38 46
9 Baník Kalinovo Baník 30 39 47 40
10 Sobota Sobota 30 32 58 35
11 Tatran Krásno Tatran 30 43 49 34
12 TJ Kováčová Kováčová 30 34 51 33
13 Liptovský Hrádok Liptovský 30 41 67 32
14 Žarnovica Žarnovica 30 39 73 24
15 Liptovská Štiavnica Liptovská 30 28 65 21
16 Čadca Čadca 30 31 80 13
TEMPORADA 2015/2016
SEGUNDA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 FC VSS Kosice Kosice 20 36 15 42
2 Tatran Prešov Tatran 20 46 18 40
3 Liptovsky Mikulas Liptovsky 20 32 18 36
4 Lokomotiva Zvolen Lokomotiva 20 25 22 33
5 Lokomotíva Košice Lokomotíva 20 28 22 32
6 Poprad Poprad 20 33 24 31
7 Bardejov Bardejov 20 30 26 31
8 Haniska Haniska 20 20 32 25
9 Spišská Nová Ves Spišská 20 16 37 15
10 Teplička nad Váhom Teplička 20 14 38 13
11 Sobota Sobota 20 14 42 9
12 Dolný Kubín Dolný 0 0 0 0
TEMPORADA 2014/2015
SEGUNDA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Zemplin Michalovce Zemplin 22 46 11 51
2 Lokomotiva Zvolen Lokomotiva 22 35 14 39
3 Bardejov Bardejov 22 36 17 39
4 Tatran Prešov Tatran 22 39 22 38
5 Liptovsky Mikulas Liptovsky 22 31 18 37
6 Poprad Poprad 22 31 37 28
7 Sobota Sobota 22 21 27 28
8 Lokomotíva Košice Lokomotíva 22 30 36 24
9 Dolný Kubín Dolný 22 21 40 23
10 Košice II Košice II 22 29 40 21
11 Bodva Moldava Bodva 22 18 37 19
12 Slavoj Trebišov Slavoj 22 13 51 16
TEMPORADA 2013/2014
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Baník Ruziná Baník 30 71 38 62
2 Žilina II Žilina II 30 60 35 60
3 Dolný Kubín Dolný 30 46 30 54
4 Poprad Poprad 30 46 31 49
5 Bodva Moldava Bodva 30 51 36 47
6 Fomat Martin Fomat Martin 30 43 32 45
7 Košice II Košice II 30 51 38 44
8 Lokomotíva Košice Lokomotíva 30 36 33 43
9 Slavoj Trebišov Slavoj 30 38 49 43
10 Futura Humenné Futura 30 37 54 42
11 Tatran Prešov II Tatran 30 32 31 39
12 Námestovo Námestovo 30 34 34 35
13 Kremnička Kremnička 30 26 40 30
14 Odeva Lipany Odeva Lipany 30 32 55 29
15 Vranov nad Topľou Vranov 30 30 58 27
16 Milénium Milénium 30 27 66 21
TEMPORADA 2012/2013
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 DAC DAC 33 41 26 65
2 Podbrezová Podbrezová 33 45 20 61
3 Senec Senec 33 48 32 57
4 Bardejov Bardejov 33 41 36 53
5 Zemplin Michalovce Zemplin 33 41 43 43
6 FC ŠTK 1914 ŠTK 1914 33 29 32 41
7 Slovan Duslo Sala Slovan Duslo 33 41 45 41
8 Dubnica Dubnica 33 31 38 41
9 Sobota Sobota 33 39 47 40
10 Liptovsky Mikulas Liptovsky 33 26 39 36
11 Dolný Kubín Dolný 33 34 42 34
12 Baník Ruziná Baník 33 38 54 30
TEMPORADA 2011/2012
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Spartak Myjava Spartak 33 64 16 71
2 Podbrezová Podbrezová 33 53 19 65
3 Dolný Kubín Dolný 33 43 42 51
4 Senec Senec 33 41 33 50
5 Sobota Sobota 33 42 42 48
6 Zemplin Michalovce Zemplin 33 41 46 46
7 Ružomberok II Ružomberok 33 42 39 45
8 Dubnica Dubnica 33 32 31 43
9 Bodva Moldava Bodva 33 30 35 42
10 Liptovsky Mikulas Liptovsky 33 34 48 35
11 LAFC Lučenec LAFC 33 26 65 24
12 FC Petržalka Petržalka 33 22 54 19
TEMPORADA 2010/2011
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Trenčín Trenčín 33 77 30 72
2 Sobota Sobota 33 41 35 54
3 FC Petržalka Petržalka 33 55 36 51
4 Zemplin Michalovce Zemplin 33 51 48 51
5 Senec Senec 33 39 39 48
6 Liptovsky Mikulas Liptovsky 33 43 44 48
7 Bodva Moldava Bodva 33 46 40 47
8 Dolný Kubín Dolný 33 45 38 46
9 LAFC Lučenec LAFC 33 41 48 41
10 Ružomberok II Ružomberok 33 37 44 38
11 Slovan Duslo Sala Slovan Duslo 33 24 44 33
12 Púchov Púchov 33 24 77 22
TEMPORADA 2009/2010
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Zlaté Moravce Zlaté 27 54 21 59
2 Trenčín Trenčín 27 53 21 50
3 Púchov Púchov 27 38 31 50
4 LAFC Lučenec LAFC 27 36 28 38
5 Dolný Kubín Dolný 27 39 31 37
6 Zemplin Michalovce Zemplin 27 23 33 30
7 Ružomberok II Ružomberok 27 23 45 29
8 Sobota Sobota 27 21 36 28
9 Liptovsky Mikulas Liptovsky 27 27 42 26
10 Slovan Duslo Sala Slovan Duslo 27 15 41 23
TEMPORADA 2008/2009
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos

  USO DE MEMORIA  
6,095,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.7263
Total Execution Time  0.7277
  CADENA URL  
/historico/Dolny-Kubin
  GET DATOS  
$_GET['/historico/Dolny-Kubin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0157  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 = 'Dolny-Kubin' 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.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=25028 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=25028 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=25028 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=25028 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 = 72189
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25028 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=388 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 388 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0146  SELECT /*53 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 (16697) ORDER BY n.cover_points DESC, update_date DESC
0.0153  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 = '25028' ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '25028' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '25028' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156  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 = 72674 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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 = 72189 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=25028 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (72674,72189,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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 72189 AND teamId = 25028
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 25028
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 25028
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 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 = 72189 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '25028' 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 = '25028' 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 = '25028' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0166  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 = 72189 WHERE rp.league_id = 72189 AND rp.teamId = 25028 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.0157  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 = 72189 WHERE rp.league_id = 72189 AND rp.teamId = 25028 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 72189 WHERE rp.league_id = 72189 AND rp.teamId = 25028 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 25028 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151  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 = 72189 AND t.round = 28 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 = 68107 AND t.round = 30 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 = 63444 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 15806 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 `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 = 12479 AND t.round = 10 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 `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 = 4829 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 24443 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 `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 = 14259 AND t.round = 33 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 `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 = 14260 AND t.round = 33 ORDER BY team.conference 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 `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 = 14261 AND t.round = 33 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 `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 = 14262 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 24486 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC