4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver equipo
Kalmar Sub 21 Kalmar
Datos equipo
Nombre Kalmar Sub 21
Nombre completo Kalmar Sub 21
Nombre corto KAL
País
Total plantilla 35
Ver equipo
Osters IF Sub 21 Osters
Datos equipo
Nombre Osters IF Sub 21
Nombre completo Osters IF Sub 21
Nombre corto OST
País
Total plantilla 33
Ver equipo
Jönköpings Sub 21 Jönköpings
Datos equipo
Nombre Jönköpings Sub 21
Nombre completo Jönköpings Södra If Sub 21
Nombre corto JON
País
Total plantilla 24
Ver equipo
Värnamo Sub 21 Värnamo
Datos equipo
Nombre Värnamo Sub 21
Nombre completo IFK Värnamo Sub 21
Nombre corto VAR
País
Total plantilla 35
Ver equipo
Mjallby Sub 21 Mjallby
Datos equipo
Nombre Mjallby Sub 21
Nombre completo Mjallby Sub 21
Nombre corto MJA
País
Total plantilla 38

Clasificación

Equipo PJ GF GC Puntos
1 Mjallby Sub 21 Mjallby 8 16 7 18
2 Värnamo Sub 21 Värnamo 6 12 9 12
3 Kalmar Sub 21 Kalmar 7 7 12 7
4 Osters IF Sub 21 Osters 7 10 13 6
5 Jönköpings Sub 21 Jönköpings 4 4 8 4

  USO DE MEMORIA  
4,587,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3699
Total Execution Time  0.3718
  CADENA URL  
/liga_suecia_sub_212023/grupo1/equipos
  GET DATOS  
$_GET['/liga_suecia_sub_212023/grupo1/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0146  SELECT type FROM routes WHERE alias = 'liga_suecia_sub_212023'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_suecia_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.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1711 AND type_rel = 3
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1711 ORDER BY order_id ASC
0.0155  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1711 GROUP BY l.categoryId
0.0154  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=1711 GROUP BY l.year ORDER BY l.year DESC
0.0147  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 = 71003 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  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 = 71003 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 08:51:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 08:51:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 08:51:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 08:51:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_suecia_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.0154  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 = 71003 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 71003 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.0152  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 = 71003 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 71003 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  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 = 71003 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 71003 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0152  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 = 71003 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC