4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Liptovsky Mikulas
TEMPORADA 2023/2024
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Komárno Komárno 27 57 21 64
2 Tatran Prešov Tatran 27 49 19 57
3 FC Petržalka Petržalka 26 53 25 54
4 Považská Bystrica Považská 26 42 31 43
5 Humenné Humenné 26 38 29 43
6 Púchov Púchov 27 47 45 42
7 Žilina II Žilina II 26 52 50 39
8 Spartak Myjava Spartak 26 35 38 36
9 Pohronie Pohronie 27 40 46 35
10 Liptovsky Mikulas Liptovsky 26 43 43 33
11 Slavoj Trebišov Slavoj 27 32 43 33
12 Slovan Bratislava II Slovan 26 39 47 32
13 Šamorín Šamorín 27 43 53 31
14 Malženice Malženice 26 32 44 23
15 Dolný Kubín Dolný 27 22 60 17
16 Spišská Nová Ves Spišská 27 18 48 10
TEMPORADA 2022/2023
LIGA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 DAC DAC 22 39 17 48
2 Slovan Bratislava Slovan 22 47 23 47
3 Spartak Trnava Spartak 22 39 26 40
4 Podbrezová Podbrezová 22 32 24 35
5 Žilina Žilina 22 34 33 31
6 MFK Dukla MFK Dukla 22 34 37 31
7 Ruzomberok Ruzomberok 22 24 22 30
8 Zemplin Michalovce Zemplin 22 22 34 23
9 Zlaté Moravce Zlaté 22 28 35 23
10 Trenčín Trenčín 22 20 33 22
11 Skalica Skalica 22 19 31 19
12 Liptovsky Mikulas Liptovsky 22 17 40 9
TEMPORADA 2021/2022
LIGA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Trenčín Trenčín 32 58 43 48
2 Liptovsky Mikulas Liptovsky 32 42 57 40
3 Zemplin Michalovce Zemplin 32 32 42 40
4 Senica Senica 32 29 51 34
5 Zlaté Moravce Zlaté 32 33 50 30
6 Pohronie Pohronie 32 27 59 18
TEMPORADA 2020/2021
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Liptovsky Mikulas Liptovsky 28 55 26 60
2 MFK Dukla MFK Dukla 28 70 38 56
3 Skalica Skalica 28 55 32 55
4 Podbrezová Podbrezová 28 57 25 54
5 FK Košice FK Košice 28 40 27 49
6 Šamorín Šamorín 28 41 34 41
7 Púchov Púchov 28 40 45 38
8 Komárno Komárno 28 31 42 38
9 FC Petržalka Petržalka 28 37 41 37
10 Slavoj Trebišov Slavoj 28 47 48 35
11 Žilina II Žilina II 28 56 47 33
12 Dubnica Dubnica 28 28 37 33
13 Bardejov Bardejov 28 27 41 28
14 Slovan Bratislava II Slovan 28 32 70 21
15 Poprad Poprad 28 25 88 4
TEMPORADA 2019/2020
SEGUNDA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 MFK Dukla MFK Dukla 18 41 20 41
2 Dubnica Dubnica 18 39 24 38
3 Skalica Skalica 18 33 19 35
4 Poprad Poprad 17 26 16 31
5 Žilina II Žilina II 18 38 29 31
6 Podbrezová Podbrezová 18 26 26 28
7 Liptovsky Mikulas Liptovsky 18 28 30 26
8 Púchov Púchov 18 22 24 24
9 Ružomberok II Ružomberok 18 23 36 22
10 FK Košice FK Košice 17 22 18 21
11 Bardejov Bardejov 18 19 23 21
12 Šamorín Šamorín 18 24 31 21
13 Komárno Komárno 18 19 28 20
14 FC Petržalka Petržalka 18 24 34 17
15 Slovan Bratislava II Slovan 18 16 31 17
16 Slavoj Trebišov Slavoj 18 23 34 15
TEMPORADA 2018/2019
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Pohronie Pohronie 30 48 25 61
2 Poprad Poprad 30 52 36 58
3 Skalica Skalica 30 47 32 53
4 Liptovsky Mikulas Liptovsky 30 56 41 50
5 MFK Dukla MFK Dukla 30 49 35 46
6 Komárno Komárno 30 48 38 46
7 Dubnica Dubnica 30 55 42 45
8 FC Petržalka Petržalka 30 41 38 45
9 Žilina II Žilina II 30 54 59 41
10 Bardejov Bardejov 30 41 46 39
11 Lokomotíva Košice Lokomotíva 30 38 44 38
12 Šamorín Šamorín 30 46 48 37
13 Slavoj Trebišov Slavoj 30 24 44 30
14 Inter Bratislava Inter 30 37 56 29
15 Tatran Prešov Tatran 30 30 41 27
16 Odeva Lipany Odeva Lipany 30 23 64 24
TEMPORADA 2017/2018
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Sered Sered 30 73 25 66
2 Skalica Skalica 30 46 27 62
3 Poprad Poprad 30 45 25 52
4 Lokomotíva Košice Lokomotíva 30 50 35 51
5 Žilina II Žilina II 30 71 41 49
6 Komárno Komárno 30 49 58 43
7 Šamorín Šamorín 30 38 34 42
8 Inter Bratislava Inter 30 45 46 41
9 Pohronie Pohronie 30 41 35 38
10 Slavoj Trebišov Slavoj 30 27 44 37
11 Liptovsky Mikulas Liptovsky 30 38 39 36
12 Bardejov Bardejov 30 39 47 35
13 Nove Mesto Nad Vahom Nove Mesto. 30 33 57 32
14 Spišská Nová Ves Spišská 30 32 60 30
15 Lokomotiva Zvolen Lokomotiva 30 26 53 28
16 Podbrezová II Podbrezová 30 24 51 26
TEMPORADA 2016/2017
SEGUNDA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 FC VSS Kosice Kosice 12 12 20 61
2 Nitra Nitra 12 23 6 59
3 Skalica Skalica 12 19 9 58
4 Šamorín Šamorín 12 17 10 55
5 Žilina II Žilina II 12 37 20 51
6 Sered Sered 12 18 15 48
7 Lokomotíva Košice Lokomotíva 12 15 17 47
8 Pohronie Pohronie 12 20 16 46
9 Bardejov Bardejov 12 20 22 46
10 Liptovsky Mikulas Liptovsky 12 15 19 45
11 Lokomotiva Zvolen Lokomotiva 12 12 22 35
12 Spišská Nová Ves Spišská 12 2 34 28
TEMPORADA 2015/2016
SEGUNDA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Tatran Prešov Tatran 10 15 8 58
2 Liptovsky Mikulas Liptovsky 10 20 11 56
3 FC VSS Kosice Kosice 10 12 8 56
4 Lokomotíva Košice Lokomotíva 10 22 12 54
5 Bardejov Bardejov 10 19 10 53
6 Pohronie Pohronie 12 9 15 51
7 Nitra Nitra 12 16 13 46
8 Žilina II Žilina II 12 13 14 41
9 Lokomotiva Zvolen Lokomotiva 10 5 12 39
10 Sered Sered 12 15 20 38
11 Slovan Bratislava II Slovan 12 8 31 31
12 Borčice Borčice 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
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Podbrezová Podbrezová 33 64 16 82
2 Bardejov Bardejov 33 49 25 61
3 Zemplin Michalovce Zemplin 33 55 28 61
4 Tatran Prešov Tatran 33 56 28 60
5 Senec Senec 33 39 32 49
6 Spartak Trnava II Spartak 33 57 64 39
7 Sobota Sobota 33 32 39 38
8 Dubnica Dubnica 33 30 64 35
9 Pohronie Pohronie 33 38 60 34
10 Slovan Duslo Sala Slovan Duslo 33 30 45 32
11 FC ŠTK 1914 ŠTK 1914 33 33 55 31
12 Liptovsky Mikulas Liptovsky 33 25 52 28
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

  USO DE MEMORIA  
6,593,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1388
Total Execution Time  0.1400
  CADENA URL  
/historico/Liptovsky-Mikulas
  GET DATOS  
$_GET['/historico/Liptovsky-Mikulas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0064  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 = 'Liptovsky-Mikulas' 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.0020  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=13513 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=13513 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=13513 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=13513 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13513 AND type_rel = 2
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 = '13513' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '13513' 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 = 72189 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=13513 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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,71170) 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 = 71170 AND teamId = 13513
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72189 AND teamId = 13513
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 13513
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13513
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 `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 = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0034  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 = 13513 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.0036  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 = 13513 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 13513 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 13513 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 = 72189 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.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 `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 = 71170 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.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 `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 = 67953 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 `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 = 63076 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 `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 = 66879 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.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 = 57040 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.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 `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 = 50117 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 `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 = 44175 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 `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 = 39124 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 `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 = 33684 AND t.round = 18 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 = 38660 AND t.round = 12 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 = 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.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 = 23886 AND t.round = 12 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 = 12462 AND t.round = 12 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 = 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.0048  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 = 2873 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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.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 = 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.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 `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.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 `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