4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Finnentrop/Bamenohl

Estadísticas

ASISTENCIAS
J. Scheppe3
B. Lennemann3
P. Hennes1
Tim Schrage1
Gordon Meyer1
Maurice Werlein1
ENTRA
G. Mavroudis13
Felix Antonio Schmitt8
F. Kremer7
Tim Schrage7
N. Herrmann6
I. Alushi5
Maurice Werlein5
D. Tews4
J. Scheppe4
Marvin Schulz4
B. Lennemann4
L. Dettmer3
A. Santana3
L. Künchen3
Daniel Jung2
Lamine Kaurouma2
M. Kümhof2
Tim Zachary1
C. Hennes1
SALE
P. Hennes10
Marvin Schulz9
B. Lennemann9
Maurice Werlein8
J. Scheppe7
L. Dettmer7
Daniel Jung7
C. Hennes6
Gordon Meyer5
Tim Schrage4
D. Tews4
Felix Antonio Schmitt4
G. Mavroudis2
M. Kümhof2
A. Santana1
Lamine Kaurouma1
M. Humberg1

  USO DE MEMORIA  
4,795,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1678
Total Execution Time  0.1690
  CADENA URL  
/estadisticas/Sg-Finnentrop-Bamenohl
  GET DATOS  
$_GET['/estadisticas/Sg-Finnentrop-Bamenohl']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (6)  
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=138022 AND type_rel = 2
0.0128  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 = '138022' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 72710 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 138022 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 138022 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 138022 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30