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

SV Lafnitz

Entrenador: Robert Weinstabl

Temporada 2021/2022

Estadísticas

ASISTENCIAS
P. Wendler8
M. Kröpfl7
D. Gremsl4
Nicolas Meister4
M. Grosse3
L. Fadinger3
S. Golles2
C. Lichtenberger2
G. Grasser2
F. Sittsam2
T. Schriebl2
P. Scheucher1
P. Siegl1
S. Umjenovic1
ENTRA
Marvin Hernaus13
F. Sittsam13
Nicolas Meister12
P. Wendler11
Christoph Halper8
M. Grosse7
Marco Fuchshofer7
F. Prohart6
C. Lichtenberger6
S. Feyrer5
D. Gremsl5
L. Fadinger5
T. Schriebl5
J. Lema4
M. Pfeifer4
C. Gschiel3
P. Scheucher3
G. Grasser2
S. Golles2
S. Umjenovic2
E. Neubauer1
P. Siegl1
Stefan Binder1
M. Kröpfl1
F. Wohlmuth1
Elias Scherf1
SALE
C. Lichtenberger16
D. Gremsl13
Christoph Halper10
P. Wendler10
G. Grasser9
M. Grosse8
L. Fadinger7
M. Pfeifer6
F. Prohart6
M. Kröpfl6
T. Schriebl6
Nicolas Meister5
F. Sittsam5
P. Siegl4
Marco Fuchshofer4
S. Feyrer3
J. Lema3
C. Gschiel2
P. Scheucher2
S. Golles2
E. Neubauer1
F. Wohlmuth1
A. Zingl1

  USO DE MEMORIA  
5,190,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0587
Total Execution Time  0.0600
  CADENA URL  
/estadisticas/Sv-Lafnitz/2022
  GET DATOS  
$_GET['/estadisticas/Sv-Lafnitz/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (5)  
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12414 AND type_rel = 2
0.0040  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 = '12414' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0061  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 events2022 e ON e.player_id = p.id AND e.league_id = 63139 WHERE rp.league_id = 63139 AND rp.teamId = 12414 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0080  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 events2022 e ON e.player_id = p.id AND e.league_id = 63139 WHERE rp.league_id = 63139 AND rp.teamId = 12414 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0072  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 events2022 e ON e.player_id = p.id AND e.league_id = 63139 WHERE rp.league_id = 63139 AND rp.teamId = 12414 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30