Escudo del US Mondorf les Bains

US Mondorf les Bains

Entrenador: Manuel Correia

Temporada 2023/2024

Estadísticas

ASISTENCIAS
A. Bourigeaud5
O. Gassama4
B. Abdelkadous4
M. Benamra3
J. Kumbi3
B. Schmit2
Y. Cervellera1
Dwayn Holter1
Dany De Sousa1
D. Fernandes Lopes1
Ahmed1
F. Taarimte1
P. Simon1
André Oliveira1
ENTRA
D. Fernandes Lopes13
Sulayman Foufoué11
M. Benamra9
B. Abdelkadous9
F. Taarimte9
Y. Cervellera6
M. Mendes6
Dany De Sousa5
O. Gassama5
André Oliveira5
Cedric Steinmetz4
A. Bourigeaud3
J. Kumbi3
B. Schmit3
Ahmed2
Alessio Ubaldini2
Y. Cruz1
Dwayn Holter1
P. Simon1
SALE
S. Bekkouche11
A. Bourigeaud10
B. Abdelkadous10
O. Gassama9
J. Kumbi9
F. Taarimte8
B. Schmit6
Dwayn Holter6
D. Fernandes Lopes5
M. Benamra4
Thierno Millimono4
M. Mendes3
Cedric Steinmetz3
Ahmed3
I. Aucoin2
Y. Cervellera2
Sulayman Foufoué1
Alessio Ubaldini1
P. Simon1
Costinha1

  USO DE MEMORIA  
5,095,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1838
Total Execution Time  0.1858
  CADENA URL  
/estadisticas/Us-Mondorf-Les-Bains
  GET DATOS  
$_GET['/estadisticas/Us-Mondorf-Les-Bains']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0217  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 = 71432
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12709 AND type_rel = 2
0.0108  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12709 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0107  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 (734448) ORDER BY n.cover_points DESC, update_date DESC
0.0114  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 = '12709' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0123  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 = 72206 WHERE rp.league_id = 72206 AND rp.teamId = 12709 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0116  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 = 72206 WHERE rp.league_id = 72206 AND rp.teamId = 12709 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0115  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 = 72206 WHERE rp.league_id = 72206 AND rp.teamId = 12709 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30