4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del B. Dortmund II

B. Dortmund II

Entrenador: Jan Zimmermann

Temporada 2023/2024

Estadísticas

ASISTENCIAS
O. Pohlmann10
Julian Hettwer6
Franz Roggow3
Ayman Azhil3
A. Aidonis2
P. Göbel2
P. Besong2
Guillermo Bueno1
Falko Michel1
A. Papadopoulos1
T. Tattermusch1
Mario Suver1
ENTRA
T. Tattermusch17
Samuel Bamba16
Jermain Nischalke11
Moses Otuali10
Falko Michel10
Franz Roggow9
A. Kamara9
Justin Butler8
F. Pfanne7
P. Göbel7
Lion Semic7
B. Pudel6
Mario Suver5
Prince Aning4
M. Eberwein4
D. Lütke-Frie3
Ayman Azhil3
P. Besong3
Julian Hettwer3
R. Elongo2
Guillermo Bueno2
O. Pohlmann1
Mateu Morey1
D. Krevsun1
A. Aidonis1
SALE
Julian Hettwer25
O. Pohlmann15
Falko Michel10
Ayman Azhil10
R. Elongo10
P. Besong10
M. Eberwein8
Franz Roggow7
Justin Butler7
Guillermo Bueno5
A. Aidonis5
F. Pfanne5
Mateu Morey5
A. Kamara4
Lion Semic4
T. Tattermusch4
B. Pudel3
A. Papadopoulos3
Samuel Bamba2
P. Göbel2
Thomas Meunier1
Jermain Nischalke1
Moses Otuali1
Hendry Blank1
Prince Aning1
Paris Brunner1

  USO DE MEMORIA  
5,018,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.2644
Total Execution Time  0.2660
  CADENA URL  
/estadisticas/Borussia-Dortm-Ii
  GET DATOS  
$_GET['/estadisticas/Borussia-Dortm-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0255  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 = 72129
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5670 AND type_rel = 2
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5670 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0132  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (97643,97966,244023,292138,422349) ORDER BY n.cover_points DESC, update_date DESC
0.0136  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 = '5670' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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 = 72129 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  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 = 72129 AND t.round = 35 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0189  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 = 72129 WHERE rp.league_id = 72129 AND rp.teamId = 5670 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0209  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 = 72129 WHERE rp.league_id = 72129 AND rp.teamId = 5670 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0214  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 = 72129 WHERE rp.league_id = 72129 AND rp.teamId = 5670 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30