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

RM Castilla

Entrenador: Raúl

Temporada 2021/2022

Estadísticas

ASISTENCIAS
Sergio Arribas9
Miguel Gutiérrez6
Peter6
Álvaro4
Sergio Santos4
David González3
Marvin Park3
Jaume Jardí2
Óscar Aranda2
Latasa2
Mario Martín2
Carlos Dotor2
Iván Morante1
ENTRA
A. Gudjohnsen17
Theo Zidane16
David González14
Jaume Jardí14
Álvaro10
Óscar Aranda9
Mario Martín9
Peter7
Álvaro Carrillo7
Marvin Park7
Nico Paz6
Carlos Dotor6
Sergio Santos5
Iván Morante4
Javi Villar3
Miguel Gutiérrez2
Sergio Arribas2
Rafa Marín2
Gonzalo García2
Vinicius Tobias2
Edgar Pujol2
Latasa2
Pau Ferrer1
Retu1
Pablo Ramón1
Sala1
SALE
Peter22
Óscar Aranda17
Latasa14
Carlos Dotor12
Sergio Arribas10
Iván Morante9
Marvin Park9
Mario Martín7
Álvaro Carrillo6
Álvaro6
Pablo Ramón6
Sergio Santos5
Theo Zidane5
Mario Gila5
Jaume Jardí4
Retu4
Miguel Gutiérrez3
A. Gudjohnsen3
Rafa Marín2
David González2
Javi Villar1

  USO DE MEMORIA  
5,318,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4737
Total Execution Time  0.4757
  CADENA URL  
/estadisticas/Rm-Castilla/2022
  GET DATOS  
$_GET['/estadisticas/Rm-Castilla/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0294  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 = 62379
0.0156  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 = '2170' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152  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 = 62379 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0170  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=2170 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0159  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 (71840,67959,67320,62372,61722,58612) 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.0180  SELECT count(id) as num_players from rel_players WHERE league_id = 67959 AND teamId = 2170
0.0182  SELECT count(id) as num_players from rel_players WHERE league_id = 58612 AND teamId = 2170
0.0174  SELECT count(id) as num_players from rel_players WHERE league_id = 62372 AND teamId = 2170
0.0178  SELECT count(id) as num_players from rel_players WHERE league_id = 71840 AND teamId = 2170
0.0186  SELECT count(id) as num_players from rel_players WHERE league_id = 61722 AND teamId = 2170
0.0557  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 2170
0.0156  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2022` 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 = 62379 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0173  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 events2022 e ON e.player_id = p.id AND e.league_id = 62379 WHERE rp.league_id = 62379 AND rp.teamId = 2170 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.0165  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 events2022 e ON e.player_id = p.id AND e.league_id = 62379 WHERE rp.league_id = 62379 AND rp.teamId = 2170 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0162  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 events2022 e ON e.player_id = p.id AND e.league_id = 62379 WHERE rp.league_id = 62379 AND rp.teamId = 2170 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0169  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 events2022 e ON e.player_id = p.id AND e.league_id = 62379 WHERE rp.league_id = 62379 AND rp.teamId = 2170 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0186  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 events2022 e ON e.player_id = p.id AND e.league_id = 62379 WHERE rp.league_id = 62379 AND rp.teamId = 2170 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165  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 events2022 e ON e.player_id = p.id AND e.league_id = 62379 WHERE rp.league_id = 62379 AND rp.teamId = 2170 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30