4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Berliner AK 07

Berliner AK 07

Entrenador: Volkan Uluç

Temporada 2023/2024

Estadísticas

ENTRA
Antonio Lubaki11
M. Bremer8
S. Gündüz7
J. Rogero6
Aleksandar Bilbija6
U. Satici6
S. Kayan6
S. Osse6
A. Kargbo6
C. Mvondo6
Irfan Brando5
U. Osawe5
Joel Bustamante4
Ali Akdag4
O. Schindler4
N. Mayivanga3
P. Abé3
Moussa Belaid3
F. Pilger3
P. Höffler3
Omar Hajjaj3
Hamid Sen2
K. Söylemez2
P. Ernesto2
Hendrik Wurr1
C. Ucar1
A. Rmieh1
Kento Teranuma1
N. Avellino1
SALE
U. Osawe17
A. Rmieh9
F. Pilger9
M. Bremer9
O. Schindler9
Irfan Brando8
Omar Hajjaj8
Antonio Lubaki6
J. Rogero5
Shinji Yamada4
M. Buyuksakarya4
U. Satici4
P. Ernesto4
Kento Teranuma3
C. Ucar3
S. Osse2
A. Kargbo2
Hamid Sen2
S. Gündüz2
N. Avellino1
N. Mayivanga1
R. Ivanković1
Hendrik Wurr1
J. Waldeck1
Aleksandar Bilbija1

  USO DE MEMORIA  
4,883,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.2422
Total Execution Time  0.2439
  CADENA URL  
/estadisticas/Bak-07
  GET DATOS  
$_GET['/estadisticas/Bak-07']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0140  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Bak-07' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9749 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9749 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9749 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9749 AND type_rel = 2
0.0129  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 = '9749' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '9749' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '9749' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0130  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 = 72583 WHERE rp.league_id = 72583 AND rp.teamId = 9749 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142  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 = 72583 WHERE rp.league_id = 72583 AND rp.teamId = 9749 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0145  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 = 72583 WHERE rp.league_id = 72583 AND rp.teamId = 9749 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30