4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Skála ÍF

Skála ÍF

Entrenador: Pauli Poulsen

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Víkingur Víkingur 7 21 3 21
2 HB Tórshavn Tórshavn 7 15 5 18
3 Kí Klaksvík Klaksvík 7 15 6 15
4 NSÍ Runavík NSÍ 7 14 10 12
5 B36 Torshavn Torshavn 7 14 11 11
6 07 Vestur 07 Vestur 7 10 11 11
7 Skála ÍF Skála ÍF 7 11 13 7
8 EB / Streymur Streymur 7 9 13 4
9 B68 Toftir B68 Toftir 7 3 15 1
10 ÍF Fuglafjørdur Fuglafjørdu 7 6 31 1
TEMPORADA 2022/2023
SEGUNDA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Skála ÍF Skála ÍF 27 83 20 70
2 NSÍ Runavík NSÍ 27 67 29 57
3 KÍ II KÍ II 27 63 40 47
4 Vikingur II Vikingur II 27 61 42 47
5 B71 Sandoy B71 Sandoy 27 58 39 47
6 FC Hoyvík FC Hoyvík 27 48 53 37
7 B36 II B36 II 27 56 50 33
8 HB II HB II 27 42 65 27
9 B68 II B68 II 27 26 82 17
10 EB / Streymur II Streymur 27 23 107 9
TEMPORADA 2021/2022
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Kí Klaksvík Klaksvík 27 78 7 77
2 Víkingur Víkingur 27 69 24 58
3 HB Tórshavn Tórshavn 27 56 27 55
4 B36 Torshavn Torshavn 27 48 29 38
5 EB / Streymur Streymur 27 31 54 35
6 B68 Toftir B68 Toftir 27 37 50 30
7 07 Vestur 07 Vestur 27 34 61 29
8 AB Argir AB Argir 27 33 63 29
9 NSÍ Runavík NSÍ 27 31 59 21
10 Skála ÍF Skála ÍF 27 25 68 10
TEMPORADA 2020/2021
SEGUNDA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Skála ÍF Skála ÍF 27 59 31 53
2 Vikingur II Vikingur II 27 68 42 46
3 AB Argir AB Argir 27 53 37 44
4 B71 Sandoy B71 Sandoy 27 56 48 42
5 HB II HB II 27 52 55 41
6 NSÍ II NSÍ II 27 57 60 40
7 KÍ II KÍ II 27 43 47 33
8 B36 II B36 II 27 42 60 30
9 Suduroy Suduroy 27 40 61 26
10 EB / Streymur II Streymur 27 40 69 25
TEMPORADA 2019/2020
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 HB Tórshavn Tórshavn 27 81 23 69
2 NSÍ Runavík NSÍ 27 58 26 63
3 Kí Klaksvík Klaksvík 27 72 25 62
4 B36 Torshavn Torshavn 27 77 37 59
5 Víkingur Víkingur 27 55 44 47
6 ÍF Fuglafjørdur Fuglafjørdu 27 34 59 26
7 EB / Streymur Streymur 27 26 65 24
8 TB Tvøroyri Tvøroyri 27 20 42 18
9 AB Argir AB Argir 27 21 73 10
10 Skála ÍF Skála ÍF 27 22 72 7
TEMPORADA 2018/2019
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Kí Klaksvík Klaksvík 26 59 18 63
2 B36 Torshavn Torshavn 27 53 23 63
3 NSÍ Runavík NSÍ 27 65 31 57
4 HB Tórshavn Tórshavn 27 62 28 51
5 Víkingur Víkingur 26 50 32 51
6 Skála ÍF Skála ÍF 27 38 32 37
7 AB Argir AB Argir 27 32 66 21
8 TB Tvøroyri Tvøroyri 27 20 57 19
9 EB / Streymur Streymur 27 25 63 18
10 ÍF Fuglafjørdur Fuglafjørdu 27 27 81 6
TEMPORADA 2017/2018
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 HB Tórshavn Tórshavn 27 58 18 73
2 NSÍ Runavík NSÍ 27 64 25 55
3 B36 Torshavn Torshavn 27 58 33 53
4 Kí Klaksvík Klaksvík 27 48 25 51
5 Víkingur Víkingur 27 39 37 39
6 Skála ÍF Skála ÍF 27 31 42 29
7 TB Tvøroyri Tvøroyri 27 27 42 28
8 EB / Streymur Streymur 27 30 53 21
9 AB Argir AB Argir 27 16 55 18
10 07 Vestur 07 Vestur 27 30 71 17
TEMPORADA 2016/2017
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Víkingur Víkingur 27 62 33 52
2 Kí Klaksvík Klaksvík 27 50 26 52
3 B36 Torshavn Torshavn 27 62 39 48
4 NSÍ Runavík NSÍ 27 57 35 46
5 HB Tórshavn Tórshavn 27 43 31 39
6 Skála ÍF Skála ÍF 27 31 40 33
7 EB / Streymur Streymur 27 34 49 32
8 TB Tvøroyri Tvøroyri 27 31 45 29
9 07 Vestur 07 Vestur 27 37 59 28
10 ÍF Fuglafjørdur Fuglafjørdu 27 23 73 12
TEMPORADA 2015/2016
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Víkingur Víkingur 27 59 25 61
2 Kí Klaksvík Klaksvík 27 64 26 60
3 NSÍ Runavík NSÍ 27 60 36 55
4 B36 Torshavn Torshavn 27 46 28 49
5 HB Tórshavn Tórshavn 27 44 30 43
6 ÍF Fuglafjørdur Fuglafjørdu 27 42 59 32
7 TB Tvøroyri Tvøroyri 27 31 48 27
8 Skála ÍF Skála ÍF 27 25 41 26
9 AB Argir AB Argir 27 31 49 18
10 B68 Toftir B68 Toftir 27 20 80 7
TEMPORADA 2014/2015
SEGUNDA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Skála ÍF Skála ÍF 27 96 17 70
2 B68 Toftir B68 Toftir 27 61 27 56
3 07 Vestur 07 Vestur 27 66 36 48
4 AB II AB II 27 50 41 46
5 KÍ II KÍ II 27 65 50 38
6 Vikingur II Vikingur II 27 39 43 33
7 B71 Sandoy B71 Sandoy 27 47 56 33
8 NSÍ II NSÍ II 27 54 54 31
9 B36 II B36 II 27 32 71 20
10 Midvágur Midvágur 27 18 133 5
TEMPORADA 2013/2014
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 B36 Torshavn Torshavn 27 53 25 61
2 HB Tórshavn Tórshavn 27 59 20 60
3 Víkingur Víkingur 27 60 30 49
4 NSÍ Runavík NSÍ 27 53 42 40
5 EB / Streymur Streymur 27 41 33 40
6 Kí Klaksvík Klaksvík 27 41 38 36
7 ÍF Fuglafjørdur Fuglafjørdu 27 36 52 28
8 AB Argir AB Argir 27 30 61 25
9 Skála ÍF Skála ÍF 27 19 54 17
10 B68 Toftir B68 Toftir 27 23 60 17
TEMPORADA 2012/2013
SEGUNDA ISLAS FEROE
Equipo PJ GF GC Puntos
1 B68 Toftir B68 Toftir 27 75 31 56
2 Skála ÍF Skála ÍF 27 74 41 48
3 HB II HB II 27 64 42 48
4 Suduroy Suduroy 27 64 50 43
5 B36 II B36 II 27 63 49 43
6 Vikingur II Vikingur II 27 47 55 34
7 EB / Streymur II Streymur 27 45 63 32
8 KÍ II KÍ II 27 50 56 30
9 TB II TB II 27 42 75 28
10 B71 Sandoy B71 Sandoy 27 23 85 21
TEMPORADA 2011/2012
SEGUNDA ISLAS FEROE
Equipo PJ GF GC Puntos
1 07 Vestur 07 Vestur 27 68 19 68
2 AB Argir AB Argir 27 82 25 61
3 Skála ÍF Skála ÍF 27 58 29 54
4 HB II HB II 27 53 34 47
5 KÍ II KÍ II 27 57 58 38
6 Vikingur II Vikingur II 27 53 52 36
7 EB / Streymur II Streymur 27 36 59 30
8 B71 Sandoy B71 Sandoy 27 48 72 27
9 B68 II B68 II 27 29 80 14
10 NSÍ II NSÍ II 27 30 86 14
TEMPORADA 2010/2011
SEGUNDA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Suduroy Suduroy 27 88 23 70
2 TB Tvøroyri Tvøroyri 27 81 26 61
3 AB Argir AB Argir 27 80 25 61
4 Skála ÍF Skála ÍF 27 54 43 40
5 NSÍ II NSÍ II 27 61 68 38
6 HB II HB II 27 43 56 33
7 Vikingur II Vikingur II 27 48 58 31
8 EB / Streymur II Streymur 27 44 73 31
9 FC Hoyvík FC Hoyvík 27 40 66 26
10 07 Vestur II Vestur 27 16 117 0
TEMPORADA 2009/2010
TERCERA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Skála ÍF Skála ÍF 18 67 17 41
2 FC Hoyvík II Hoyvík 18 49 29 40
3 07 Vestur II Vestur 18 60 31 36
4 B36 II B36 II 18 47 18 35
5 KÍ II KÍ II 18 46 47 26
6 Suduroy II Suduroy II 18 38 39 25
7 TB II TB II 18 36 55 17
8 IF II IF II 18 26 63 14
9 Vikingur III Vikingur 18 24 55 12
10 Midvágur Midvágur 18 22 61 11
TEMPORADA 2008/2009
SEGUNDA ISLAS FEROE
Equipo PJ GF GC Puntos
1 Suduroy Suduroy 27 67 40 52
2 B71 Sandoy B71 Sandoy 27 63 36 52
3 TB Tvøroyri Tvøroyri 27 58 48 47
4 HB II HB II 27 56 39 46
5 Vikingur II Vikingur II 27 46 39 37
6 B68 II B68 II 27 68 59 36
7 FC Hoyvík FC Hoyvík 27 36 53 34
8 NSÍ II NSÍ II 27 45 57 33
9 Skála ÍF Skála ÍF 27 38 41 32
10 Midvágur Midvágur 27 27 92 8
TEMPORADA 2007/2008
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 EB / Streymur Streymur 27 54 33 55
2 HB Tórshavn Tórshavn 27 57 22 49
3 B36 Torshavn Torshavn 27 34 25 48
4 NSÍ Runavík NSÍ 27 41 33 47
5 Víkingur Víkingur 27 43 33 42
6 B68 Toftir B68 Toftir 27 24 38 36
7 ÍF Fuglafjørdur Fuglafjørdu 27 32 46 31
8 Kí Klaksvík Klaksvík 27 31 39 28
9 B71 Sandoy B71 Sandoy 27 26 47 23
10 Skála ÍF Skála ÍF 27 22 48 19
TEMPORADA 2006/2007
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 NSÍ Runavík NSÍ 27 52 24 61
2 EB / Streymur Streymur 27 58 33 54
3 B36 Torshavn Torshavn 27 46 22 52
4 HB Tórshavn Tórshavn 27 59 34 49
5 GÍ Gøta GÍ Gøta 27 45 53 38
6 Skála ÍF Skála ÍF 27 26 39 34
7 Kí Klaksvík Klaksvík 27 44 47 33
8 B71 Sandoy B71 Sandoy 27 39 49 32
9 AB Argir AB Argir 27 30 55 17
10 VB / Sumba VB / Sumba 27 27 70 11
TEMPORADA 2005/2006
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 HB Tórshavn Tórshavn 27 61 36 55
2 EB / Streymur Streymur 27 63 30 54
3 B36 Torshavn Torshavn 27 45 32 47
4 Kí Klaksvík Klaksvík 27 54 39 45
5 NSÍ Runavík NSÍ 27 50 39 42
6 GÍ Gøta GÍ Gøta 27 39 34 41
7 Skála ÍF Skála ÍF 27 33 29 31
8 VB / Sumba VB / Sumba 27 24 73 20
9 B68 Toftir B68 Toftir 27 34 58 18
10 ÍF Fuglafjørdur Fuglafjørdu 27 29 62 16
TEMPORADA 2004/2005
LIGA ISLAS FEROE
Equipo PJ GF GC Puntos
1 B36 Torshavn Torshavn 27 38 17 54
2 HB Tórshavn Tórshavn 27 66 35 50
3 Skála ÍF Skála ÍF 27 55 30 50
4 NSÍ Runavík NSÍ 27 58 44 50
5 EB / Streymur Streymur 27 48 35 43
6 ÍF Fuglafjørdur Fuglafjørdu 27 32 57 27
7 Kí Klaksvík Klaksvík 27 40 52 25
8 VB / Sumba VB / Sumba 27 36 57 24
9 GÍ Gøta GÍ Gøta 27 35 58 23
10 TB Tvøroyri Tvøroyri 27 26 49 22

  USO DE MEMORIA  
6,424,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7405
Total Execution Time  0.7416
  CADENA URL  
/historico/Skala-If
  GET DATOS  
$_GET['/historico/Skala-If']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
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 = 'Skala-If' 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.0146  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=30648 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=30648 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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=30648 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0306  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 = 75759
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30648 AND type_rel = 2
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 = '30648' 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 = '30648' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 75759 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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 = 74850 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  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=30648 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (75759,74850,70884) 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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 74850 AND teamId = 30648
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 70884 AND teamId = 30648
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 75759 AND teamId = 30648
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 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 = 74850 AND t.round = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0152  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 = 74850 WHERE rp.league_id = 74850 AND rp.teamId = 30648 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.0153  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 = 74850 WHERE rp.league_id = 74850 AND rp.teamId = 30648 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 74850 WHERE rp.league_id = 74850 AND rp.teamId = 30648 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 30648 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74850 AND t.round = 8 ORDER BY team.conference ASC,t.position 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 `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 = 70884 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.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 `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 = 66692 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.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 `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 = 61749 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.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 `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 = 55312 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.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 `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 = 48715 AND t.round = 27 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 `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 = 42591 AND t.round = 27 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 `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 = 37849 AND t.round = 27 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 `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 = 20307 AND t.round = 27 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 = 9477 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 5257 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 16189 AND t.round = 27 ORDER BY team.conference 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 `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 = 16188 AND t.round = 27 ORDER BY team.conference 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 `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 = 16187 AND t.round = 27 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 = 16192 AND t.round = 18 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 `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 = 16185 AND t.round = 27 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 `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 = 10562 AND t.round = 27 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 `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 = 10561 AND t.round = 27 ORDER BY team.conference 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 `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 = 10560 AND t.round = 27 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 `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 = 10559 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 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 = 74850 ORDER BY nameShow LIMIT 100