4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Union Berlin Sub 19

Union Berlin Sub 19

Entrenador: Marco Grote

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Julien Friedrich2
Leon Prosche2
ENTRA
Kelvin Ojo4
Baris Kalayci3
Leonit Ibrahimi2
Tim Schleinitz2
Linus Jurschik2
Musa Alkan2
Ion Ciobanu2
Timon Kramer2
Andrik Markgraf2
Stephen Tabuaa1
Finn Hoffmann1
Valon Aliji1
Tom Ackermann1
Julien Friedrich1
Jerome Kortebusch1
SALE
Julien Friedrich3
Leon Prosche3
Baris Kalayci3
Timon Kramer2
Finn Hoffmann2
Julius Grunwald2
Ion Ciobanu2
Tom Ackermann2
O. Ogbemudia1
Linus Jurschik1
Jerome Scholz1
Valon Aliji1
Tim Schleinitz1
Leonit Ibrahimi1
Noah Engelbreth1
Levis Asanji1

  USO DE MEMORIA  
4,674,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.0738
Total Execution Time  0.0750
  CADENA URL  
/estadisticas/Union-Berlin-U19
  GET DATOS  
$_GET['/estadisticas/Union-Berlin-U19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0063  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 = 73970
0.0052  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 = 72757
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=86524 AND type_rel = 2
0.0056  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 = '86524' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0031  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 = 72757 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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 = 73970 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0047  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 events2024 e ON e.player_id = p.id AND e.league_id = 73970 WHERE rp.league_id = 73970 AND rp.teamId = 86524 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109  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 events2024 e ON e.player_id = p.id AND e.league_id = 73970 WHERE rp.league_id = 73970 AND rp.teamId = 86524 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0054  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 events2024 e ON e.player_id = p.id AND e.league_id = 73970 WHERE rp.league_id = 73970 AND rp.teamId = 86524 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30