4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Plantilla del B. Leverkusen Temporada 1971/1972

No tenemos aún datos de la plantilla del equipo

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas

  USO DE MEMORIA  
5,039,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1081
Total Execution Time  0.1093
  CADENA URL  
/plantilla/Bayer-Leverkusen/1972
  GET DATOS  
$_GET['/plantilla/Bayer-Leverkusen/1972']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (3)  
0.0126  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 = '3668' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 3668 AND rp.league_id = 22746 AND l.year= 1972 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0106  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 3668 AND rp.league_id = 22746 AND l.year= 1972 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1