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

Villarreal Fem

Entrenador: Sara Monforte

Presidente: Fernando Roig

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Nerea4
Fatou3
Raquel2
Lucía Gómez2
K. McKenna2
F. Lara1
Soldevila1
ENTRA
T. Morató13
Lucía Romero13
Lucía Gómez9
F. Lara9
V. Torrecilla7
M. Romero7
Thais Reiss7
Vera Rico6
R. García5
Queralt4
M. Imbergamo3
María Llompart3
C. Salvador3
Y. Giménez2
Raquel1
Ainoa1
Fatou1
Nerea1
Cristina Cubedo1
K. McKenna1
SALE
K. McKenna15
María Llompart13
Fatou13
Lucía Gómez12
F. Lara9
Nerea7
Bicho5
T. Morató4
Y. Giménez4
Soldevila3
Raquel3
Cristina Cubedo3
M. Romero2
Lucía Romero1
V. Torrecilla1
Ainoa1
Queralt1

  USO DE MEMORIA  
5,022,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2213
Total Execution Time  0.2234
  CADENA URL  
/estadisticas/Villareal-Cf-Femenino
  GET DATOS  
$_GET['/estadisticas/Villareal-Cf-Femenino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12398 AND type_rel = 2
0.0177  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12398 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  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 (98604,341611,406172,420780,586222) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '12398' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0153  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 = 72467 WHERE rp.league_id = 72467 AND rp.teamId = 12398 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 72467 WHERE rp.league_id = 72467 AND rp.teamId = 12398 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 72467 WHERE rp.league_id = 72467 AND rp.teamId = 12398 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30