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

CF Talavera

Entrenador: Luis Ayllón

Temporada 2023/2024

Estadísticas

ASISTENCIAS
A. Szymanowski2
Abeledo2
C. Ruane2
Tass1
Pipo1
Lolo Plá1
J. Fontán1
ENTRA
Edu Gallardo16
Dago14
Tass14
M. Lapeña12
Pipo12
Caio Emerson8
Lolo Plá6
C. Dorado6
S. Loukou6
J. Aguirre4
Hugo Anglada4
Sergio Blázquez3
Josema Gallego3
Abeledo3
U. Rementería3
J. Fontán3
D. Morante2
A. Fernández2
A. Szymanowski2
C. Ruane2
Dani Ramos1
SALE
A. Szymanowski14
Pipo13
Abeledo12
Tass11
J. Aguirre11
Edu Gallardo11
U. Rementería7
M. Lapeña7
Lolo Plá7
Caio Emerson6
J. Fontán6
Javi Rey6
S. Loukou4
Josema Gallego3
D. Morante2
Hugo Anglada2
Biel Ribas1
Dani Ramos1
Dago1

  USO DE MEMORIA  
5,462,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1752
Total Execution Time  0.1772
  CADENA URL  
/estadisticas/Cf-Talavera-Reina
  GET DATOS  
$_GET['/estadisticas/Cf-Talavera-Reina']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0111  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 = '6159' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 72366 WHERE rp.league_id = 72366 AND rp.teamId = 6159 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 = 72366 WHERE rp.league_id = 72366 AND rp.teamId = 6159 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 = 72366 WHERE rp.league_id = 72366 AND rp.teamId = 6159 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30