4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Haukar
TEMPORADA 2023/2024
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Haukar Haukar 0 0 0 0
2 Höttur / Huginn Höttur 0 0 0 0
3 KF Fjallabyggdar Fjallabyggda 0 0 0 0
4 KFA KFA 0 0 0 0
5 KFG Gardabaer Gardabaer 0 0 0 0
6 Kormákur / Hvöt Kormákur 0 0 0 0
7 Reynir Reynir 0 0 0 0
8 Selfoss Selfoss 0 0 0 0
9 Thróttur Vogar Thróttur 0 0 0 0
10 Víkingur Ólafsvík Víkingur 0 0 0 0
11 Völsungur Völsungur 0 0 0 0
12 Ægir Ægir 0 0 0 0
TEMPORADA 2022/2023
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Dalvík / Reynir Dalvík 22 45 23 45
2 ÍR Reykjavík Reykjavík 22 55 28 41
3 KFA KFA 22 45 24 41
4 Thróttur Vogar Thróttur 22 42 30 38
5 Víkingur Ólafsvík Víkingur 22 42 34 38
6 Höttur / Huginn Höttur 22 34 38 33
7 Haukar Haukar 22 36 36 31
8 KFG Gardabaer Gardabaer 22 41 40 30
9 Völsungur Völsungur 22 33 38 25
10 KF Fjallabyggdar Fjallabyggda 22 36 49 25
11 Sindri Sindri 22 25 53 17
12 KV Reykjavík Reykjavík 22 18 59 9
TEMPORADA 2021/2022
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 UMF Njardvík Njardvík 22 63 22 55
2 Throttur Throttur 22 49 27 49
3 Ægir Ægir 22 37 35 37
4 Völsungur Völsungur 22 42 35 33
5 Höttur / Huginn Höttur 22 36 32 30
6 ÍR Reykjavík Reykjavík 22 35 36 30
7 Víkingur Ólafsvík Víkingur 22 43 41 28
8 KF Fjallabyggdar Fjallabyggda 22 49 50 26
9 Haukar Haukar 22 27 33 24
10 KFA KFA 22 32 54 19
11 Reynir Reynir 22 24 47 17
12 IF Magni IF Magni 22 24 49 17
TEMPORADA 2020/2021
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Thróttur Vogar Thróttur 22 43 22 42
2 KV Reykjavík Reykjavík 22 40 29 41
3 Völsungur Völsungur 22 44 35 40
4 IF Magni IF Magni 22 45 36 37
5 KF Fjallabyggdar Fjallabyggda 22 42 33 35
6 UMF Njardvík Njardvík 22 45 29 32
7 Reynir Reynir 22 49 45 32
8 ÍR Reykjavík Reykjavík 22 40 36 31
9 Haukar Haukar 22 46 41 29
10 Leiknir Fáskrúðsfjörður Leiknir 22 31 45 24
11 Fjardabyggd Fjardabyggd 22 17 62 11
12 Kári Kári 22 27 56 9
TEMPORADA 2019/2020
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Kórdrengir Kórdrengir 20 45 13 46
2 Selfoss Selfoss 20 36 25 43
3 Thróttur Vogar Thróttur 20 39 19 41
4 UMF Njardvík Njardvík 20 39 26 40
5 Haukar Haukar 20 43 28 36
6 KF Fjallabyggdar Fjallabyggda 20 33 39 26
7 Kári Kári 20 33 31 25
8 Fjardabyggd Fjardabyggd 20 30 36 24
9 ÍR Reykjavík Reykjavík 20 31 39 19
10 Völsungur Völsungur 20 25 49 17
11 Vidir Gardur Vidir Gardur 20 24 52 16
12 Dalvík / Reynir Dalvík 20 25 46 11
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
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 ÍA Akranes ÍA Akranes 22 42 16 48
2 HK Kopavogur Kopavogur 22 38 13 48
3 Thór Thór 22 46 37 43
4 Víkingur Ólafsvík Víkingur 22 38 22 42
5 Throttur Throttur 22 52 40 36
6 UMF Njardvík Njardvík 22 24 34 27
7 Leiknir Reykjavik Leiknir 22 23 29 25
8 Haukar Haukar 22 33 45 25
9 Fram Fram 22 37 38 24
10 IF Magni IF Magni 22 27 48 19
11 ÍR Reykjavík Reykjavík 22 23 48 18
12 Selfoss Selfoss 22 35 48 15
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
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 KA Akureyri KA Akureyri 22 42 16 51
2 Grindavík Grindavík 22 50 21 42
3 Keflavik Keflavik 22 31 20 35
4 Thór Thór 22 34 38 33
5 Haukar Haukar 22 31 35 31
6 Fram Fram 22 25 29 30
7 Leiknir Reykjavik Leiknir 22 21 28 29
8 Selfoss Selfoss 22 28 25 28
9 HK Kopavogur Kopavogur 22 32 45 22
10 Leiknir Fáskrúðsfjörður Leiknir 22 32 45 21
11 Huginn Huginn 22 20 34 21
12 Fjardabyggd Fjardabyggd 22 26 36 17
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
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Leiknir Reykjavik Leiknir 22 43 19 48
2 ÍA Akranes ÍA Akranes 22 46 24 43
3 Throttur Throttur 22 35 27 37
4 Víkingur Ólafsvík Víkingur 22 38 32 36
5 Grindavík Grindavík 22 39 24 35
6 HK Kopavogur Kopavogur 22 34 28 34
7 Haukar Haukar 22 37 32 32
8 KA Akureyri KA Akureyri 22 42 33 31
9 Selfoss Selfoss 22 24 33 26
10 BI/Bolungarvik BI/Bolungarv 22 34 45 25
11 KV Reykjavík Reykjavík 22 34 53 18
12 Tindastoll Tindastoll 22 15 71 4
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
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
LIGA ISLANDIA
Equipo PJ GF GC Puntos
1 Breidablik Breidablik 22 47 23 44
2 FH Hafnarfjordur Hafnarfjordu 22 48 31 44
3 ÍBV ÍBV 22 36 27 42
4 KR Reykjavík Reykjavík 22 45 31 38
5 Fram Fram 22 35 35 32
6 Keflavik Keflavik 22 30 32 30
7 Valur Reykjavík Valur 22 34 41 28
8 Stjarnan Stjarnan 22 39 42 25
9 Fylkir Fylkir 22 36 42 24
10 Grindavík Grindavík 22 28 39 21
11 Haukar Haukar 22 29 45 20
12 Selfoss Selfoss 22 32 51 17
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
TERCERA ISLANDIA
Equipo PJ GF GC Puntos
1 Haukar Haukar 18 46 16 42
2 Selfoss Selfoss 18 39 17 36
3 KF Fjallabyggdar Fjallabyggda 18 36 17 36
4 ÍR Reykjavík Reykjavík 18 40 19 32
5 Afturelding Afturelding 18 26 23 26
6 IF Höttur IF Höttur 18 25 28 23
7 Völsungur Völsungur 18 22 26 23
8 ÍH ÍH 18 23 38 13
9 IF Magni IF Magni 18 15 44 11
10 Sindri Sindri 18 20 64 10
TEMPORADA 2005/2006
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Fram Fram 18 32 14 41
2 HK Kopavogur Kopavogur 18 30 18 32
3 Fjölnir Fjölnir 18 23 15 29
4 Throttur Throttur 18 21 18 29
5 Stjarnan Stjarnan 18 26 23 24
6 KA Akureyri KA Akureyri 18 22 25 21
7 Víkingur Ólafsvík Víkingur 18 16 22 19
8 Thór Thór 18 16 38 19
9 Leiknir Reykjavik Leiknir 18 21 25 18
10 Haukar Haukar 18 20 29 17
TEMPORADA 2004/2005
SEGUNDA ISLANDIA
Equipo PJ GF GC Puntos
1 Breidablik Breidablik 18 32 13 44
2 Víkingur Reykjavík Víkingur 18 41 9 37
3 KA Akureyri KA Akureyri 18 40 20 34
4 Fjölnir Fjölnir 18 29 34 22
5 Víkingur Ólafsvík Víkingur 18 15 30 22
6 Thór Thór 18 25 34 21
7 HK Kopavogur Kopavogur 18 18 21 20
8 Haukar Haukar 18 23 33 17
9 Völsungur Völsungur 18 17 25 16
10 KS Siglafjordur Siglafjordur 18 14 35 13

  USO DE MEMORIA  
6,714,128 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1673
Total Execution Time  0.1685
  CADENA URL  
/historico/Haukar
  GET DATOS  
$_GET['/historico/Haukar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (46)  
0.0079  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 = 'Haukar' 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.0023  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=12664 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=12664 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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=12664 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0055  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 = 74948
0.0045  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 = 75316
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12664 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1621 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1621 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 (95788) ORDER BY n.cover_points DESC, update_date DESC
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 = '12664' ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '12664' AND l.year = 2024 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 = '12664' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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.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 = 74948 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=12664 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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,74948) 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 = 74948 AND teamId = 12664
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 75316 AND teamId = 12664
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 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 = 74948 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025  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 = '12664' 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 = '12664' and rp.type = 4
0.0021  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 = '12664' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 74948 WHERE rp.league_id = 74948 AND rp.teamId = 12664 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.0022  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 = 74948 WHERE rp.league_id = 74948 AND rp.teamId = 12664 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 74948 WHERE rp.league_id = 74948 AND rp.teamId = 12664 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 12664 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 = 74948 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.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 `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 = 71029 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.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 `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 = 66302 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.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 `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 = 61449 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.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 `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 = 55074 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.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 `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 = 48623 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 42426 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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.0032  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 = 20270 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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.0027  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 = 3755 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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.0029  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.0028  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.0029  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.0029  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.0029  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 = 24053 AND t.round = 18 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 `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 = 21171 AND t.round = 18 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 `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 = 21170 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC