4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA ISLANDIA
Equipo PJ GF GC Puntos
1 Víkingur Reykjavík Víkingur 3 7 1 9
2 ÍA Akranes ÍA Akranes 3 9 3 6
3 Breidablik Breidablik 3 7 4 6
4 KR Reykjavík Reykjavík 3 7 5 6
5 Fram Fram 3 3 1 6
6 FH Hafnarfjordur Hafnarfjordu 3 5 4 6
7 Valur Reykjavík Valur 3 2 1 4
8 Stjarnan Stjarnan 3 2 5 3
9 Vestri Vestri 3 1 6 3
10 KA Akureyri KA Akureyri 3 3 5 1
11 Fylkir Fylkir 3 4 9 1
12 HK Kopavogur Kopavogur 3 1 7 1
TEMPORADA 2022/2023
LIGA ISLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Víkingur Reykjavík Víkingur 27 76 30 66
2 Valur Reykjavík Valur 27 66 35 55
3 Stjarnan Stjarnan 27 55 29 46
4 Breidablik Breidablik 27 52 49 41
5 FH Hafnarfjordur Hafnarfjordu 27 49 54 40
6 KR Reykjavík Reykjavík 27 38 48 37
TEMPORADA 2021/2022
LIGA ISLANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Breidablik Breidablik 27 66 27 63
2 KA Akureyri KA Akureyri 27 54 30 53
3 Víkingur Reykjavík Víkingur 27 66 41 48
4 KR Reykjavík Reykjavík 27 42 40 38
5 Stjarnan Stjarnan 27 44 52 37
6 Valur Reykjavík Valur 27 46 44 35
TEMPORADA 2020/2021
LIGA ISLANDIA
Equipo PJ GF GC Puntos
1 Víkingur Reykjavík Víkingur 22 38 21 48
2 Breidablik Breidablik 22 55 21 47
3 KR Reykjavík Reykjavík 22 35 19 41
4 KA Akureyri KA Akureyri 22 36 20 40
5 Valur Reykjavík Valur 22 37 26 39
6 FH Hafnarfjordur Hafnarfjordu 22 39 26 33
7 Stjarnan Stjarnan 22 24 36 22
8 Leiknir Reykjavik Leiknir 22 18 32 22
9 ÍA Akranes ÍA Akranes 22 29 44 21
10 Keflavik Keflavik 22 23 38 21
11 HK Kopavogur Kopavogur 22 21 39 20
12 Fylkir Fylkir 22 18 51 16
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
LIGA ISLANDIA
Equipo PJ GF GC Puntos
1 KR Reykjavík Reykjavík 22 44 23 52
2 Breidablik Breidablik 22 45 31 38
3 FH Hafnarfjordur Hafnarfjordu 22 40 36 37
4 Stjarnan Stjarnan 22 40 34 35
5 KA Akureyri KA Akureyri 22 34 34 31
6 Valur Reykjavík Valur 22 38 34 29
7 Víkingur Reykjavík Víkingur 22 37 35 28
8 Fylkir Fylkir 22 38 44 28
9 HK Kopavogur Kopavogur 22 29 29 27
10 ÍA Akranes ÍA Akranes 22 27 32 27
11 Grindavík Grindavík 22 17 28 20
12 ÍBV ÍBV 22 23 52 10
TEMPORADA 2017/2018
LIGA ISLANDIA
Equipo PJ GF GC Puntos
1 Valur Reykjavík Valur 22 50 24 46
2 Breidablik Breidablik 22 39 17 44
3 Stjarnan Stjarnan 22 45 26 40
4 KR Reykjavík Reykjavík 22 36 25 37
5 FH Hafnarfjordur Hafnarfjordu 22 36 28 37
6 ÍB Vestmannaeyja Vestmannaeyj 22 29 31 29
7 KA Akureyri KA Akureyri 22 36 34 28
8 Fylkir Fylkir 22 31 37 26
9 Víkingur Reykjavík Víkingur 22 29 38 25
10 Grindavík Grindavík 22 26 37 25
11 Fjölnir Fjölnir 22 22 44 19
12 Keflavik Keflavik 22 11 49 4
TEMPORADA 2016/2017
LIGA ISLANDIA
Equipo PJ GF GC Puntos
1 Valur Reykjavík Valur 22 43 20 50
2 Stjarnan Stjarnan 22 46 25 38
3 FH Hafnarfjordur Hafnarfjordu 22 33 25 35
4 KR Reykjavík Reykjavík 22 31 29 31
5 Grindavík Grindavík 22 31 39 31
6 Breidablik Breidablik 22 34 35 30
7 KA Akureyri KA Akureyri 22 37 31 29
8 Víkingur Reykjavík Víkingur 22 32 36 27
9 ÍBV ÍBV 22 32 38 25
10 Fjölnir Fjölnir 22 32 40 25
11 Víkingur Ólafsvík Víkingur 22 24 44 22
12 ÍA Akranes ÍA Akranes 22 28 41 17
TEMPORADA 2015/2016
LIGA ISLANDIA
Equipo PJ GF GC Puntos
1 FH Hafnarfjordur Hafnarfjordu 22 32 17 43
2 Stjarnan Stjarnan 22 43 31 39
3 KR Reykjavík Reykjavík 22 29 20 38
4 Fjölnir Fjölnir 22 42 25 37
5 Valur Reykjavík Valur 22 41 28 35
6 Breidablik Breidablik 22 27 20 35
7 Víkingur Reykjavík Víkingur 22 29 32 32
8 ÍA Akranes ÍA Akranes 22 28 33 31
9 ÍBV ÍBV 22 23 27 23
10 Víkingur Ólafsvík Víkingur 22 23 38 21
11 Fylkir Fylkir 22 25 40 19
12 Throttur Throttur 22 19 50 14
TEMPORADA 2014/2015
LIGA ISLANDIA
Equipo PJ GF GC Puntos
1 FH Hafnarfjordur Hafnarfjordu 22 47 26 48
2 Breidablik Breidablik 22 34 13 46
3 KR Reykjavík Reykjavík 22 36 21 42
4 Stjarnan Stjarnan 22 32 24 33
5 Valur Reykjavík Valur 22 38 31 33
6 Fjölnir Fjölnir 22 36 35 33
7 ÍA Akranes ÍA Akranes 22 31 31 29
8 Fylkir Fylkir 22 26 31 29
9 Víkingur Reykjavík Víkingur 22 32 36 23
10 ÍBV ÍBV 22 26 37 19
11 Leiknir Reykjavik Leiknir 22 20 34 15
12 Keflavik Keflavik 22 22 61 10
TEMPORADA 2013/2014
LIGA ISLANDIA
Equipo PJ GF GC Puntos
1 Stjarnan Stjarnan 22 42 21 52
2 FH Hafnarfjordur Hafnarfjordu 22 46 17 51
3 KR Reykjavík Reykjavík 22 40 24 43
4 Víkingur Reykjavík Víkingur 22 25 29 30
5 Valur Reykjavík Valur 22 31 36 28
6 Fylkir Fylkir 22 34 40 28
7 Breidablik Breidablik 22 36 33 27
8 Keflavik Keflavik 22 29 32 25
9 Fjölnir Fjölnir 22 33 36 23
10 ÍBV ÍBV 22 28 38 22
11 Fram Fram 22 30 48 21
12 Thór Thór 22 24 44 12
TEMPORADA 2012/2013
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Fjölnir Fjölnir 22 38 24 43
2 Víkingur Reykjavík Víkingur 22 56 28 42
3 Haukar Haukar 22 49 29 42
4 Grindavík Grindavík 22 51 32 42
5 BI/Bolungarvik BI/Bolungarv 22 47 39 40
6 KA Akureyri KA Akureyri 22 38 31 32
7 Leiknir Reykjavik Leiknir 22 36 31 32
8 Selfoss Selfoss 22 44 38 27
9 Tindastoll Tindastoll 22 29 40 25
10 Throttur Throttur 22 26 36 23
11 KF Fjallabyggdar Fjallabyggda 22 25 41 21
12 Völsungur Völsungur 22 15 85 2
TEMPORADA 2011/2012
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Thór Thór 22 40 20 50
2 Víkingur Ólafsvík Víkingur 22 36 21 42
3 Throttur Throttur 22 34 26 33
4 KA Akureyri KA Akureyri 22 34 30 33
5 Haukar Haukar 22 23 25 33
6 Víkingur Reykjavík Víkingur 22 34 31 31
7 Fjölnir Fjölnir 22 39 26 29
8 Tindastoll Tindastoll 22 34 42 27
9 BI/Bolungarvik BI/Bolungarv 22 31 37 26
10 Leiknir Reykjavik Leiknir 22 33 36 25
11 IF Höttur IF Höttur 22 30 41 21
12 ÍR Reykjavík Reykjavík 22 19 52 14
TEMPORADA 2010/2011
LIGA ISLANDIA
Equipo PJ GF GC Puntos
1 KR Reykjavík Reykjavík 22 44 22 47
2 FH Hafnarfjordur Hafnarfjordu 22 48 31 44
3 ÍBV ÍBV 22 37 27 40
4 Stjarnan Stjarnan 22 51 35 37
5 Valur Reykjavík Valur 22 28 23 36
6 Breidablik Breidablik 22 34 42 27
7 Fylkir Fylkir 22 34 44 25
8 Keflavik Keflavik 22 27 32 24
9 Fram Fram 22 20 28 24
10 Grindavík Grindavík 22 26 37 23
11 Thór Thór 22 28 41 21
12 Víkingur Reykjavík Víkingur 22 24 39 15
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
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Selfoss Selfoss 22 53 26 47
2 Haukar Haukar 22 44 28 44
3 KA Akureyri KA Akureyri 23 35 26 38
4 HK Kopavogur Kopavogur 22 36 28 36
5 Fjardabyggd Fjardabyggd 21 29 31 33
6 Thór Thór 22 33 35 31
7 Leiknir Reykjavik Leiknir 22 32 33 29
8 ÍR Reykjavík Reykjavík 22 40 46 29
9 ÍA Akranes ÍA Akranes 22 26 27 28
10 Víkingur Reykjavík Víkingur 22 36 34 26
11 Afturelding Afturelding 22 25 45 16
12 Víkingur Ólafsvík Víkingur 22 24 54 13
TEMPORADA 2007/2008
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 ÍBV ÍBV 22 43 17 50
2 Stjarnan Stjarnan 22 47 22 47
3 Selfoss Selfoss 22 54 36 46
4 KA Akureyri KA Akureyri 22 31 27 32
5 Víkingur Reykjavík Víkingur 22 32 30 29
6 Haukar Haukar 22 36 42 28
7 Leiknir Reykjavik Leiknir 22 33 40 26
8 Thór Thór 22 31 42 25
9 Fjardabyggd Fjardabyggd 22 31 37 24
10 Víkingur Ólafsvík Víkingur 22 19 29 24
11 UMF Njardvík Njardvík 22 26 42 19
12 KF Fjallabyggdar Fjallabyggda 22 17 36 12
TEMPORADA 2006/2007
LIGA ISLANDIA
Equipo PJ GF GC Puntos
1 Valur Reykjavík Valur 18 41 20 38
2 FH Hafnarfjordur Hafnarfjordu 18 42 26 37
3 ÍA Akranes ÍA Akranes 18 34 27 30
4 Fylkir Fylkir 18 23 18 29
5 Breidablik Breidablik 18 29 20 24
6 Keflavik Keflavik 18 26 32 21
7 Fram Fram 18 25 31 16
8 KR Reykjavík Reykjavík 18 17 30 16
9 HK Kopavogur Kopavogur 18 17 35 16
10 Víkingur Reykjavík Víkingur 18 15 30 14

  USO DE MEMORIA  
7,237,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.9445
Total Execution Time  0.9457
  CADENA URL  
/historico/Vikingur-Reykjavik
  GET DATOS  
$_GET['/historico/Vikingur-Reykjavik']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (54)  
0.0163  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 = 'Vikingur-Reykjavik' 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=17870 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=17870 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=17870 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=17870 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=17870 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=17870 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=17870 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=17870 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0158  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 = 74950
0.0155  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 = 75229
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17870 AND type_rel = 2
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17870 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0150  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 (98934,138773,522785,871704,1142912) ORDER BY n.cover_points DESC, update_date DESC
0.0162  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 = '17870' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0163  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 = '17870' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 74950 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157  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 = 74853 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155  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=17870 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 (75316,75229,74950,74853,74828,72099,67749) 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.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 74853 AND teamId = 17870
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 67749 AND teamId = 17870
0.0173  SELECT count(id) as num_players from rel_players WHERE league_id = 72099 AND teamId = 17870
0.0177  SELECT count(id) as num_players from rel_players WHERE league_id = 75316 AND teamId = 17870
0.0169  SELECT count(id) as num_players from rel_players WHERE league_id = 74828 AND teamId = 17870
0.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 74950 AND teamId = 17870
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 75229 AND teamId = 17870
0.0148  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 = '17870' 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 = '17870' and rp.type = 4
0.0148  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 = '17870' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 74853 WHERE rp.league_id = 74853 AND rp.teamId = 17870 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 = 74853 WHERE rp.league_id = 74853 AND rp.teamId = 17870 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 74853 WHERE rp.league_id = 74853 AND rp.teamId = 17870 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 17870 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74853 AND t.round = 4 ORDER BY team.conference ASC,t.position 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 `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 = 70788 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.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 `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 = 73966 AND t.round = 5 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 `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 = 66300 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.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 `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 = 69617 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 61111 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.0162  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.0162  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 = 48622 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 `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 = 42425 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 `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 = 37857 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 `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 = 20269 AND t.round = 22 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 `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 = 9815 AND t.round = 22 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 `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 = 3713 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 `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 = 2783 AND t.round = 22 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 = 10557 AND t.round = 22 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 = 10538 AND t.round = 22 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 `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.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 `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 = 21174 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 `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 = 21173 AND t.round = 22 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 `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 = 10543 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC