4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Grorud II
TEMPORADA 2022/2023
CUARTA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Lysekloster Lysekloster 26 72 23 70
2 Frigg Frigg 26 98 45 56
3 Fana Fana 26 69 40 51
4 Os Turn Os Turn 26 69 46 48
5 Sandviken Sandviken 26 63 42 44
6 Gjelleråsen Gjelleråsen 26 57 41 42
7 Skjetten Skjetten 26 36 47 38
8 Stabæk II Stabæk II 26 50 55 34
9 Lillestrom II Lillestrom 26 47 68 29
10 Lokomotiv Oslo Lokomotiv 26 31 38 28
11 Skedsmo Skedsmo 26 40 58 25
12 Gneist Gneist 26 19 63 22
13 Ullern II Ullern II 26 36 80 16
14 Grorud II Grorud II 26 32 73 15
TEMPORADA 2021/2022
CUARTA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Lyn 1896 FK Lyn 1896 FK 26 88 24 70
2 Nordstrand Nordstrand 26 60 26 62
3 Os Turn Os Turn 26 72 54 44
4 Grorud II Grorud II 26 57 49 43
5 Lokomotiv Oslo Lokomotiv 26 40 42 40
6 Skeid II Skeid II 26 55 58 39
7 Sandviken Sandviken 26 53 60 36
8 Fyllingsdalen Fyllingsdale 26 51 55 35
9 Stabæk II Stabæk II 26 53 53 32
10 Frøya Frøya 26 38 54 32
11 Oppsal Oppsal 26 38 49 27
12 Kjelsås II Kjelsås II 26 30 41 22
13 SF Grei SF Grei 26 35 74 17
14 IF Ready IF Ready 26 32 63 15
TEMPORADA 2020/2021
CUARTA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Gjøvik-Lyn Gjøvik-Lyn 13 49 9 39
2 Gjelleråsen Gjelleråsen 13 37 18 26
3 Elverum Elverum 13 27 18 25
4 Lillestrom II Lillestrom 13 31 23 24
5 Kongsvinger II Kongsvinger 13 32 24 22
6 Brumunddal Brumunddal 13 33 19 21
7 Lorenskog IF Lorenskog 13 18 17 18
8 Grorud II Grorud II 13 21 22 16
9 Raufoss II Raufoss II 13 19 30 14
10 Toten Toten 13 21 42 14
11 Funnefoss / Vormsund Funnefoss 13 18 30 11
12 Nybergsund IL-Trysil Nybergsund 13 11 23 11
13 Ullensaker/Kisa II Ullensaker/K 13 11 32 8
14 Rommen SK Rommen SK 13 12 33 6
TEMPORADA 2019/2020
CUARTA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Brumunddal Brumunddal 0 0 0 0
2 Elverum Elverum 0 0 0 0
3 Funnefoss / Vormsund Funnefoss 0 0 0 0
4 Gjelleråsen Gjelleråsen 0 0 0 0
5 Gjøvik-Lyn Gjøvik-Lyn 0 0 0 0
6 Grorud II Grorud II 0 0 0 0
7 Kongsvinger II Kongsvinger 0 0 0 0
8 Lillestrom II Lillestrom 0 0 0 0
9 Lorenskog IF Lorenskog 0 0 0 0
10 Nybergsund IL-Trysil Nybergsund 0 0 0 0
11 Raufoss II Raufoss II 0 0 0 0
12 Rommen SK Rommen SK 0 0 0 0
13 Toten Toten 0 0 0 0
14 Ullensaker/Kisa II Ullensaker/K 0 0 0 0
TEMPORADA 2015/2016
CUARTA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Lyn 1896 FK Lyn 1896 FK 26 69 20 65
2 Skjetten Skjetten 26 72 28 50
3 Korsvoll IL Korsvoll IL 26 66 43 46
4 Lokomotiv Oslo Lokomotiv 26 51 31 43
5 Kjelsås II Kjelsås II 26 42 39 40
6 Rilindja Rilindja 26 60 55 37
7 Grorud II Grorud II 26 59 54 37
8 SF Grei SF Grei 26 47 47 35
9 Lommedalen Lommedalen 26 47 45 34
10 Strømmen II Strømmen 26 50 65 31
11 Lørenskog II Lørenskog 26 43 71 30
12 Manglerud Star Manglerud 26 29 53 24
13 Skeid II Skeid II 26 38 74 22
14 Hasle-Løren Hasle-Løren 26 31 79 14
TEMPORADA 2014/2015
CUARTA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Oppsal Oppsal 26 74 28 58
2 Kråkerøy Kråkerøy 26 79 28 57
3 Follo II Follo II 26 66 43 42
4 Sarpsborg 08 II Sarpsborg 26 57 39 40
5 Trosvik IF Trosvik IF 26 50 47 38
6 Grorud II Grorud II 26 47 49 38
7 Østsiden Østsiden 26 46 47 37
8 Drøbak / Frogn Drøbak 26 57 59 37
9 Fredrikstad II Fredrikstad 26 54 63 37
10 Ås IL Ås IL 26 49 49 36
11 Skeid II Skeid II 26 52 53 36
12 Borgar Borgar 26 38 61 31
13 Nesodden Nesodden 26 53 76 25
14 Selbak Turn og IF Selbak Turn 26 19 99 7
TEMPORADA 2013/2014
CUARTA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Sprint-Jeløy Sprint-Jelø 26 78 22 61
2 Kråkerøy Kråkerøy 26 80 30 58
3 Oppsal Oppsal 26 81 37 55
4 Fredrikstad II Fredrikstad 26 62 54 44
5 Trosvik IF Trosvik IF 26 69 53 43
6 Follo II Follo II 26 48 41 41
7 Sarpsborg 08 II Sarpsborg 26 58 52 41
8 Grorud II Grorud II 26 53 50 34
9 Nesodden Nesodden 26 52 53 33
10 Selbak Turn og IF Selbak Turn 26 41 67 31
11 Østsiden Østsiden 26 54 52 30
12 Sparta Sarpsborg Sparta 26 39 52 28
13 Rustad Rustad 26 41 77 21
14 Kolbotn Kolbotn 26 24 140 1
TEMPORADA 2012/2013
CUARTA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Stabæk II Stabæk II 26 80 28 62
2 Flisa Flisa 26 59 36 49
3 Hasle-Løren Hasle-Løren 26 53 37 48
4 Funnefoss / Vormsund Funnefoss 26 71 55 41
5 Lyn II Lyn II 26 78 53 40
6 Hauerseter Hauerseter 26 66 55 38
7 Fjellhamar FK Fjellhamar 26 45 49 35
8 Korsvoll IL Korsvoll IL 26 43 48 35
9 Grorud II Grorud II 26 47 44 34
10 Sander IL Sander IL 26 42 47 32
11 Lørenskog II Lørenskog 26 48 47 31
12 Gjerdrum Gjerdrum 26 39 64 31
13 Kongsvinger II Kongsvinger 26 33 74 21
14 Holmlia Holmlia 26 25 92 13

  USO DE MEMORIA  
5,476,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1077
Total Execution Time  0.1090
  CADENA URL  
/historico/Grorud-Idrettslag-Ii
  GET DATOS  
$_GET['/historico/Grorud-Idrettslag-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0023  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 = 'Grorud-Idrettslag-Ii' 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.0029  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 = 'Grorud-Idrettslag-Ii' 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.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119464 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119464 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119464 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119464 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119464 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119464 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119464 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119464 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119464 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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 = 70820
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=119464 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1937 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1937 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 (694715,651476,517291) ORDER BY n.cover_points DESC, update_date DESC
0.0021  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 = '119464' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0019  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 = '119464' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = '119464' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 70820 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=119464 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0018  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (70820) 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 = 70820 AND teamId = 119464
0.0029  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 70820 WHERE rp.league_id = 70820 AND rp.teamId = 119464 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.0029  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 70820 WHERE rp.league_id = 70820 AND rp.teamId = 119464 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 events2023 e ON e.player_id = p.id AND e.league_id = 70820 WHERE rp.league_id = 70820 AND rp.teamId = 119464 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 119464 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 70820 AND t.round = 26 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 = 66284 AND t.round = 26 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 `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 = 63569 AND t.round = 13 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 = 53745 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 48757 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 48809 AND t.round = 26 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 = 48827 AND t.round = 26 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 `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 = 48840 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC