4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver equipo
Vanlose Sub 21 Vanlose
Datos equipo
Nombre Vanlose Sub 21
Nombre completo Vanlose Sub 21
Nombre corto VAN
País
Ver equipo
Frederikssund Sub 21 Frederikssun
Datos equipo
Nombre Frederikssund Sub 21
Nombre completo Frederikssund IK Sub 21
Nombre corto FIK
País
Ver equipo
LSF Sub 21 LSF Sub 21
Datos equipo
Nombre LSF Sub 21
Nombre completo LSF Sub 21
Nombre corto LSF
País
Ver equipo
Skjold Sub 21 Skjold
Datos equipo
Nombre Skjold Sub 21
Nombre completo Skjold Sub 21
Nombre corto SKJ
País
Ver equipo
Holbæk B & I Sub 21 Holbæk
Datos equipo
Nombre Holbæk B & I Sub 21
Nombre completo Holbæk B & I Sub 21
Nombre corto HOL
País
Ver equipo
Brønshøj Sub 21 Brønshøj
Datos equipo
Nombre Brønshøj Sub 21
Nombre completo Brønshøj Sub 21
Nombre corto BRO
País

Clasificación

Equipo PJ GF GC Puntos
1 Vanlose Sub 21 Vanlose 4 23 6 12
2 Frederikssund Sub 21 Frederikssun 4 10 7 7
3 LSF Sub 21 LSF Sub 21 5 10 14 7
4 Brønshøj Sub 21 Brønshøj 4 7 7 6
5 Skjold Sub 21 Skjold 5 8 12 6
6 Holbæk B & I Sub 21 Holbæk 4 1 13 0

  USO DE MEMORIA  
4,535,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0596
Total Execution Time  0.0617
  CADENA URL  
/liga_dinamarca_sub_212023/grupo1/equipos
  GET DATOS  
$_GET['/liga_dinamarca_sub_212023/grupo1/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_dinamarca_sub_212023'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_dinamarca_sub_21' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1755 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1755 ORDER BY order_id ASC
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1755 GROUP BY l.categoryId
0.0020  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1755 GROUP BY l.year ORDER BY l.year DESC
0.0019  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 68357 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT t.id,t.teamId,t.total_players,dt.* FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 68357 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:26:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 21:26:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 21:26:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 21:26:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_dinamarca_sub_21' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 68357 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68357 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0022  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 68357 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68357 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 68357 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68357 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  SELECT *,(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 = 68357 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