4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del IF Grótta
TEMPORADA 2023/2024
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Afturelding Afturelding 0 0 0 0
2 Dalvík / Reynir Dalvík 0 0 0 0
3 Fjölnir Fjölnir 0 0 0 0
4 Grindavík Grindavík 0 0 0 0
5 ÍBV ÍBV 0 0 0 0
6 IF Grótta IF Grótta 0 0 0 0
7 ÍR Reykjavík Reykjavík 0 0 0 0
8 Keflavik Keflavik 0 0 0 0
9 Leiknir Reykjavik Leiknir 0 0 0 0
10 Thór Thór 0 0 0 0
11 Throttur Throttur 0 0 0 0
12 UMF Njardvík Njardvík 0 0 0 0
TEMPORADA 2022/2023
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 ÍA Akranes ÍA Akranes 22 54 31 49
2 Afturelding Afturelding 22 60 33 43
3 Fjölnir Fjölnir 22 55 32 42
4 Vestri Vestri 22 37 26 39
5 Leiknir Reykjavik Leiknir 22 47 37 35
6 Grindavík Grindavík 22 27 38 28
7 Thór Thór 22 27 39 27
8 Throttur Throttur 22 45 46 26
9 IF Grótta IF Grótta 22 34 37 26
10 UMF Njardvík Njardvík 22 36 47 23
11 Selfoss Selfoss 22 37 49 23
12 Ægir Ægir 22 23 67 9
TEMPORADA 2021/2022
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Fylkir Fylkir 22 63 23 51
2 HK Kopavogur Kopavogur 22 46 30 46
3 IF Grótta IF Grótta 22 42 33 37
4 Fjölnir Fjölnir 22 51 37 36
5 Kórdrengir Kórdrengir 22 36 30 33
6 Selfoss Selfoss 22 41 39 32
7 Thór Thór 22 31 35 30
8 Afturelding Afturelding 22 39 39 29
9 Vestri Vestri 22 36 44 28
10 Grindavík Grindavík 22 43 45 27
11 KV Reykjavík Reykjavík 22 27 52 18
12 Thróttur Vogar Thróttur 22 8 56 6
TEMPORADA 2020/2021
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Fram Fram 22 58 17 58
2 ÍBV ÍBV 22 43 22 47
3 Fjölnir Fjölnir 22 38 21 42
4 Kórdrengir Kórdrengir 22 39 28 39
5 Vestri Vestri 22 38 39 36
6 IF Grótta IF Grótta 22 52 40 35
7 Grindavík Grindavík 22 38 45 26
8 Selfoss Selfoss 22 35 44 24
9 Thór Thór 22 33 37 23
10 Afturelding Afturelding 22 37 54 23
11 Throttur Throttur 22 39 53 14
12 Víkingur Ólafsvík Víkingur 22 28 78 8
TEMPORADA 2019/2020
LIGA ISLANDIA
Equipo PJ GF GC Puntos
1 Valur Reykjavík Valur 18 50 17 44
2 FH Hafnarfjordur Hafnarfjordu 18 37 23 36
3 Stjarnan Stjarnan 17 27 20 31
4 Breidablik Breidablik 18 37 27 31
5 KR Reykjavík Reykjavík 17 30 21 28
6 Fylkir Fylkir 18 27 30 28
7 KA Akureyri KA Akureyri 18 20 21 21
8 ÍA Akranes ÍA Akranes 18 39 43 21
9 HK Kopavogur Kopavogur 18 29 36 20
10 Víkingur Reykjavík Víkingur 18 25 30 17
11 IF Grótta IF Grótta 18 15 43 8
12 Fjölnir Fjölnir 18 15 40 6
TEMPORADA 2018/2019
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 IF Grótta IF Grótta 22 45 31 43
2 Fjölnir Fjölnir 22 49 22 42
3 Leiknir Reykjavik Leiknir 22 37 28 40
4 Víkingur Ólafsvík Víkingur 22 28 20 34
5 Keflavik Keflavik 22 31 27 34
6 Thór Thór 22 31 30 34
7 Fram Fram 22 33 32 33
8 Afturelding Afturelding 22 30 37 23
9 IF Magni IF Magni 22 27 49 23
10 Throttur Throttur 22 36 40 22
11 Haukar Haukar 22 31 41 22
12 UMF Njardvík Njardvík 22 23 44 15
TEMPORADA 2017/2018
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Afturelding Afturelding 22 58 27 45
2 IF Grótta IF Grótta 22 54 28 45
3 Vestri Vestri 22 42 17 44
4 Völsungur Völsungur 22 45 31 40
5 Kári Kári 22 46 44 38
6 Thróttur Vogar Thróttur 22 36 31 33
7 Fjardabyggd Fjardabyggd 22 27 32 28
8 Tindastoll Tindastoll 22 28 53 24
9 KF Vídir KF Vídir 22 28 36 23
10 Leiknir Fáskrúðsfjörður Leiknir 22 31 36 22
11 IF Höttur IF Höttur 22 31 49 21
12 Huginn Huginn 22 13 55 6
TEMPORADA 2016/2017
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Fylkir Fylkir 22 50 19 48
2 Keflavik Keflavik 22 43 24 46
3 Throttur Throttur 22 37 21 42
4 HK Kopavogur Kopavogur 22 36 28 42
5 Leiknir Reykjavik Leiknir 22 38 31 36
6 Thór Thór 22 35 31 34
7 Haukar Haukar 22 34 39 33
8 Selfoss Selfoss 22 27 29 28
9 Fram Fram 22 32 39 27
10 ÍR Reykjavík Reykjavík 22 27 38 19
11 Leiknir Fáskrúðsfjörður Leiknir 22 23 53 10
12 IF Grótta IF Grótta 22 16 46 9
TEMPORADA 2015/2016
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 ÍR Reykjavík Reykjavík 22 47 19 54
2 IF Grótta IF Grótta 22 34 16 43
3 Afturelding Afturelding 22 45 26 41
4 Sindri Sindri 22 41 29 32
5 IF Magni IF Magni 22 36 32 31
6 Vestri Vestri 22 41 40 29
7 UMF Njardvík Njardvík 22 30 31 27
8 IF Höttur IF Höttur 22 31 39 27
9 Völsungur Völsungur 22 29 37 24
10 Ægir Ægir 22 27 44 23
11 KV Reykjavík Reykjavík 22 31 44 20
12 KF Fjallabyggdar Fjallabyggda 22 13 48 12
TEMPORADA 2014/2015
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Víkingur Ólafsvík Víkingur 22 53 14 54
2 Throttur Throttur 22 45 21 44
3 KA Akureyri KA Akureyri 22 42 22 41
4 Thór Thór 22 40 34 38
5 Grindavík Grindavík 22 41 30 36
6 Haukar Haukar 22 32 28 34
7 Fjardabyggd Fjardabyggd 22 35 37 31
8 HK Kopavogur Kopavogur 22 26 33 31
9 Fram Fram 22 34 45 21
10 Selfoss Selfoss 22 20 38 20
11 IF Grótta IF Grótta 22 10 39 15
12 BI/Bolungarvik BI/Bolungarv 22 22 59 10
TEMPORADA 2013/2014
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Fjardabyggd Fjardabyggd 22 53 20 51
2 IF Grótta IF Grótta 22 49 36 44
3 ÍR Reykjavík Reykjavík 22 41 24 40
4 Huginn Huginn 22 47 37 37
5 Sindri Sindri 22 34 37 30
6 Dalvík / Reynir Dalvík 22 28 33 27
7 KF Fjallabyggdar Fjallabyggda 22 29 39 27
8 UMF Njardvík Njardvík 22 36 42 24
9 Ægir Ægir 22 22 35 24
10 Afturelding Afturelding 22 35 36 22
11 Völsungur Völsungur 22 35 51 22
12 Reynir Reynir 22 30 49 22
TEMPORADA 2012/2013
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 HK Kopavogur Kopavogur 22 50 30 40
2 KV Reykjavík Reykjavík 22 45 30 40
3 Afturelding Afturelding 22 49 32 39
4 ÍR Reykjavík Reykjavík 22 42 32 39
5 IF Grótta IF Grótta 22 30 21 38
6 UMF Njardvík Njardvík 22 43 35 31
7 Dalvík / Reynir Dalvík 22 32 37 30
8 Reynir Reynir 22 34 41 27
9 Sindri Sindri 22 31 38 26
10 Ægir Ægir 22 25 40 23
11 IF Höttur IF Höttur 22 25 39 19
12 Hamar Hveragerdi Hamar 22 17 48 13
TEMPORADA 2011/2012
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Völsungur Völsungur 22 36 21 46
2 KF Fjallabyggdar Fjallabyggda 22 51 23 43
3 HK Kopavogur Kopavogur 22 43 27 43
4 KV Reykjavík Reykjavík 22 43 26 40
5 Afturelding Afturelding 22 50 46 40
6 Dalvík / Reynir Dalvík 22 38 25 36
7 Reynir Reynir 22 35 41 31
8 UMF Njardvík Njardvík 22 31 35 30
9 Hamar Hveragerdi Hamar 22 36 41 21
10 IF Grótta IF Grótta 22 31 41 20
11 Fjardabyggd Fjardabyggd 22 31 48 15
12 KFR KFR 22 20 71 6
TEMPORADA 2010/2011
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 ÍA Akranes ÍA Akranes 22 53 17 51
2 Selfoss Selfoss 22 44 22 47
3 Haukar Haukar 22 33 23 36
4 Víkingur Ólafsvík Víkingur 22 35 26 34
5 Fjölnir Fjölnir 22 34 38 32
6 BI/Bolungarvik BI/Bolungarv 22 27 37 31
7 Throttur Throttur 22 34 45 30
8 KA Akureyri KA Akureyri 22 32 40 29
9 ÍR Reykjavík Reykjavík 22 27 42 22
10 Leiknir Reykjavik Leiknir 22 31 32 20
11 IF Grótta IF Grótta 22 16 29 20
12 HK Kopavogur Kopavogur 22 23 38 16
TEMPORADA 2009/2010
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Víkingur Reykjavík Víkingur 22 46 23 48
2 Thór Thór 22 53 23 43
3 Leiknir Reykjavik Leiknir 22 32 19 43
4 Fjölnir Fjölnir 22 42 28 40
5 ÍA Akranes ÍA Akranes 22 44 28 35
6 ÍR Reykjavík Reykjavík 22 31 38 30
7 Throttur Throttur 22 32 37 29
8 HK Kopavogur Kopavogur 22 30 38 25
9 KA Akureyri KA Akureyri 22 29 43 24
10 IF Grótta IF Grótta 22 29 47 18
11 Fjardabyggd Fjardabyggd 22 26 47 17
12 UMF Njardvík Njardvík 22 14 37 13
TEMPORADA 2008/2009
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 IF Grótta IF Grótta 22 53 26 45
2 UMF Njardvík Njardvík 22 40 21 40
3 Reynir Reynir 22 52 42 39
4 Hvöt Blönduós Hvöt 22 58 49 35
5 BI/Bolungarvik BI/Bolungarv 22 42 36 33
6 ÍH / Hamrarnir / Vinir Hamrarnir 22 37 47 29
7 IF Höttur IF Höttur 22 32 31 27
8 KF Fjallabyggdar Fjallabyggda 22 43 44 27
9 KF Vídir KF Vídir 22 27 37 27
10 Hamar Hveragerdi Hamar 22 28 54 23
11 Tindastoll Tindastoll 22 24 38 20
12 IF Magni IF Magni 22 37 48 19
TEMPORADA 2007/2008
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 ÍR Reykjavík Reykjavík 22 63 27 57
2 Afturelding Afturelding 22 48 25 40
3 KF Vídir KF Vídir 22 52 40 36
4 Hvöt Blönduós Hvöt 22 46 38 36
5 IF Magni IF Magni 22 39 44 30
6 Tindastoll Tindastoll 22 36 37 27
7 IF Grótta IF Grótta 22 39 45 27
8 Reynir Reynir 22 45 56 25
9 IF Höttur IF Höttur 22 34 41 24
10 Hamar Hveragerdi Hamar 22 37 49 22
11 ÍH ÍH 22 37 59 21
12 Völsungur Völsungur 22 32 47 18

  USO DE MEMORIA  
6,597,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1270
Total Execution Time  0.1282
  CADENA URL  
/historico/If-Grotta
  GET DATOS  
$_GET['/historico/If-Grotta']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0039  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 = 74854
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 = 74825
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61443 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=345 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 345 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0020  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 (1052452,823653,522785,94982) 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 = '61443' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '61443' 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 = 75316 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 = 74825 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 74854 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=61443 AND l.year in (2023,2024,2025) 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 (75316,74854,74825) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74854 AND teamId = 61443
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 75316 AND teamId = 61443
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 74825 AND teamId = 61443
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 = '61443' 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 = '61443' 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 = '61443' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  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 = 74854 WHERE rp.league_id = 74854 AND rp.teamId = 61443 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.0019  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 = 74854 WHERE rp.league_id = 74854 AND rp.teamId = 61443 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 74854 WHERE rp.league_id = 74854 AND rp.teamId = 61443 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 61443 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 = 74854 AND t.round = 1 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 = 70789 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.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 `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 = 66301 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.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 `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 = 61448 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 `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 = 55072 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 `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 = 42884 AND t.round = 22 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 = 37967 AND t.round = 22 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 = 21151 AND t.round = 22 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 = 9816 AND t.round = 22 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 `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 = 11813 AND t.round = 22 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 = 24051 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 24052 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 10558 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 = 21175 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 24057 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 24055 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC