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

Clermont

Entrenador: Pascal Gastien

Temporada 2023/2024

Estadísticas

ASISTENCIAS
M. Cham4
S. Nicholson3
Neto Borges1
J. Jacquet1
B. Boutobba1
Florent Ogier1
M. Caufriez1
Jim Allevinah1
Alan Virginius1
G. Kyei1
Alidu Seidu1
C. Matsima1
C. Konaté1
ENTRA
G. Kyei16
B. Boutobba16
Yohann Magnin14
Habib Keita13
E. Rashani10
J. Béla10
S. Nicholson8
Mehdi Zeffane8
C. Konaté7
Jim Allevinah6
Alidu Seidu5
Aïman Maurer5
K. Andrić5
M. Cham4
C. Matsima4
J. Jacquet4
M. Gonalons4
Florent Ogier3
Alan Virginius3
Y. Armougom3
A. Baallal1
I. Mbahia1
Andy Pelmard1
SALE
Jim Allevinah16
M. Gonalons15
M. Cham14
Johan Gastien12
S. Nicholson12
Mehdi Zeffane11
Alan Virginius10
E. Rashani9
B. Boutobba9
Habib Keita8
G. Kyei8
C. Konaté7
Yohann Magnin5
M. Caufriez3
Alidu Seidu3
Florent Ogier1
C. Matsima1
M. Wieteska1
Neto Borges1
K. Andrić1

  USO DE MEMORIA  
5,173,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.2339
Total Execution Time  0.2354
  CADENA URL  
/estadisticas/Clermont-Foot
  GET DATOS  
$_GET['/estadisticas/Clermont-Foot']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=788 AND type_rel = 2
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 788 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (1312974,83663,104652,126012,139012) ORDER BY n.cover_points DESC, update_date DESC
0.0135  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 = '788' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 788 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.0140  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 = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 788 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 788 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 788 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 788 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141  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 = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 788 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30