4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Altona 93

Plantilla del Altona 93 Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
33 19 de - - - - -
1 31 de 184 - - 1 -
24 33 de - - - - -
Defensa
22 27 de 184 - 3 - -
20 22 de - - 1 - -
4 28 de - - 2 - -
31 31 de 189 - - - -
Centrocampista
3 21 de - - 1 1 1
5 25 de 183 - 7 - -
27 26 de 175 - - - -
26 19 de - - 1 - -
6 26 de 185 - - - -
27 24 de 185 - 9 - -
23 24 de - - 5 1 1
19 de - - - - -
16 26 de 175 - - - -
2 24 de - - - - -
8 26 de - - 2 - -
13 24 de - - 1 - -
21 27 de 176 - - - -
7 31 de 177 - 15 - -
10 30 de - - 1 - -
Delantero
18 23 ci 180 - 3 - -
15 24 de - - - - -
19 19 de - - 6 - -
14 23 de - - - - -
22 de 188 - 3 - -
17 26 de 186 - 14 - -
9 23 de - - 5 - -
17 26 al - - 7 - -
- de - - - - -

  USO DE MEMORIA  
4,900,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1862
Total Execution Time  0.1874
  CADENA URL  
/plantilla/Altona-93
  GET DATOS  
$_GET['/plantilla/Altona-93']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0139  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 = 'Altona-93' 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.0127  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=17095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=17095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=17095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17095 AND type_rel = 2
0.0136  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17095 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0154  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 = '17095' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020