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

Estadísticas

ASISTENCIAS
M. Piossek3
Y. Regäsel1
A. Dej1
D. Wöstmann1
I. Algan1
L. Ortmann1
Angelos Kerasidis1
S. Reinholz1
Arbnor Murati1
N. Thier1
U. Yildiz1
J. Al-Hazaimeh1
ENTRA
E. Ćatić15
L. Ortmann11
B. Fadika11
I. Algan8
J. Tomczak7
Phil Britscho6
I. Diallo5
Oluremi Martins Williams5
U. Yildiz4
A. Dej4
Arbnor Murati3
Y. Regäsel3
Moritz3
Gordon Wild2
N. Thier2
S. Reinholz2
D. Francis2
B. Osmani2
Angelos Kerasidis2
D. Wöstmann1
N. Kartal1
A. Hodza1
M. Piossek1
Albin Thaqi1
M. Vuković1
Dino Dzaferoski1
A. Petejchuk1
SALE
U. Yildiz13
A. Dej10
D. Wöstmann9
I. Algan7
Gordon Wild7
Y. Regäsel7
M. Piossek6
N. Thier5
M. Schmeling4
Angelos Kerasidis4
Dino Dzaferoski4
Albin Thaqi4
L. Ortmann3
Oluremi Martins Williams2
B. Fadika2
A. Sener2
I. Diallo2
Arbnor Murati2
E. Nguimba1
Moritz1
L. Jusufi1
M. Heller1
D. Francis1
E. Ćatić1
S. Kuroda1
J. Al-Hazaimeh1
C. Ngali1
Benedict Mbuku1

  USO DE MEMORIA  
4,986,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3418
Total Execution Time  0.3438
  CADENA URL  
/estadisticas/Tus-Bovinghausen
  GET DATOS  
$_GET['/estadisticas/Tus-Bovinghausen']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=137869 AND type_rel = 2
0.0147  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 = '137869' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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.0147  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=137869 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72710,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 72710 AND teamId = 137869
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 137869
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72710 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0156  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 = 137869 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  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 = 137869 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  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 = 137869 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0210  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 = 137869 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0177  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 = 137869 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0212  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 = 137869 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30