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

Zamora

Entrenador: David Movilla

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Carlos Ramos4
J. Castañeda3
Roger Marcé3
A. Etxaburu2
Víctor López2
Carlos Parra2
A. Morales1
S. Baldrich1
Mancebo1
Bolo1
Markel Goñi1
Pito Camacho1
ENTRA
Luís Rivas19
A. Morales16
S. Baldrich14
A. Etxaburu13
Pito Camacho12
Markel Goñi12
Carlos Parra11
Roger Marcé10
Nicolás Delmonte8
Dani Hernández7
Mancebo7
D. Aguirre6
Joel Priego6
Carlos Ramos4
Cañizo4
Jesús Muñoz3
Theo García3
Bolo3
Víctor López3
Kun2
Javi Barrio2
J. Castañeda1
David Troya1
SALE
Mancebo17
Joel Priego12
Juanan12
Dani Hernández11
Cañizo10
Víctor López10
S. Baldrich10
Pito Camacho9
A. Etxaburu9
Roger Marcé8
Luís Rivas8
Carlos Ramos7
D. Aguirre6
Kun6
J. Castañeda5
Markel Goñi5
Bolo3
Carlos Parra3
A. Morales3
Luismi Luengo2
Nicolás Delmonte2
Theo García1
Javi Barrio1
Jesús Muñoz1

  USO DE MEMORIA  
5,615,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  9.1610
Total Execution Time  9.1622
  CADENA URL  
/estadisticas/Zamora
  GET DATOS  
$_GET['/estadisticas/Zamora']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2785 AND type_rel = 2
0.1612  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2785 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.1331  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 (5685,35250,65065,70823,75296) ORDER BY n.cover_points DESC, update_date DESC
0.7351  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 = '2785' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.6835  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=2785 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0461  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (75887,75879,72362,71432,69379,68343) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.6723  SELECT count(id) as num_players from rel_players WHERE league_id = 72362 AND teamId = 2785
0.0706  SELECT count(id) as num_players from rel_players WHERE league_id = 75879 AND teamId = 2785
0.0613  SELECT count(id) as num_players from rel_players WHERE league_id = 75887 AND teamId = 2785
0.5434  SELECT count(id) as num_players from rel_players WHERE league_id = 69379 AND teamId = 2785
0.3211  SELECT count(id) as num_players from rel_players WHERE league_id = 68343 AND teamId = 2785
0.6066  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2785
0.2544  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 = '2785' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0424  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2785' and rp.type = 4
0.2984  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 = '2785' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2785' and rp.type = 4
0.6327  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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 2785 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.6757  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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 2785 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.6028  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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 2785 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.5686  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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 2785 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.6493  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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 2785 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.6546  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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 2785 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30