4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Valencia Mestalla - Villarreal B
Jornada 15
FINALIZADO
40
40
644 Pts. Elo
20º

911 Pts. Elo
6º

1-1
Domingo, 21 Febrero 2021, 12:00
S. Emaná 45'
1 - 0
1 - 1
 70' Sergio Lozano

Eventos del partido

Goles

S. EmanáGol de
S. Emaná
minuto 45'
minuto 70'Sergio LozanoGol de Sergio Lozano

Tarjetas

Kevin SibilleT. Amarilla
Kevin Sibille
minuto 20'
minuto 21'Carlos BeitiaT. Amarilla Carlos Beitia
minuto 34'Antonio PachecoT. Amarilla Antonio Pacheco
S. EmanáT. Amarilla
S. Emaná
minuto 55'
minuto 77'Sergio LozanoT. Amarilla Sergio Lozano
minuto 84'DelaT. Amarilla Dela
JosedaT. Amarilla
Joseda
minuto 88'
Adri GómezT. Amarilla
Adri Gómez
minuto 90'

Cambios

minuto 62'H. HassanEntra en el partido H. Hassan
minuto 62'Antonio PachecoSale del partido Antonio Pacheco
minuto 62'June-Hyuk AhnEntra en el partido June-Hyuk Ahn
minuto 62'Juan AgüeroSale del partido Juan Agüero
minuto 73'AranaEntra en el partido Arana
minuto 73'Jack HarperSale del partido Jack Harper
Hugo GonzálezEntra en el partido
Hugo González
minuto 76'
Koba LeinSale del partido
Koba Lein
minuto 76'
S. EmanáSale del partido
S. Emaná
minuto 79'
Carlos GonzálezEntra en el partido
Carlos González
minuto 79'
minuto 85'Álex MillánSale del partido Álex Millán
minuto 85'Carlo AdrianoEntra en el partido Carlo Adriano
minuto 85'Carlos BeitiaSale del partido Carlos Beitia
minuto 85'Víctor NarroEntra en el partido Víctor Narro

Alineaciones

Valencia Mestalla

Valencia Mestalla

4-4-2
Alineación Inicial
Suplentes
Villarreal B

Villarreal B

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,033,152 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Match / Index )  0.5381
Total Execution Time  0.5397
  CADENA URL  
/partido/Valencia-Mestalla/Villarreal-B/2013?section=legal
  GET DATOS  
$_GET['/partido/Valencia-Mestalla/Villarreal-B/2013']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0151   SELECT c.*, c.stadium as real_stadium, 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Valencia-Mestalla' AND dt2.basealias = 'Villarreal-B'
0.0187   SELECT c.*, c.stadium as real_stadium, 2025 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2025 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Valencia-Mestalla' AND dt2.basealias = 'Villarreal-B'
0.0153   SELECT c.*, c.stadium as real_stadium, 2023 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2023 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Valencia-Mestalla' AND dt2.basealias = 'Villarreal-B'
0.0158   SELECT c.*, c.stadium as real_stadium, 2022 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2022 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Valencia-Mestalla' AND dt2.basealias = 'Villarreal-B'
0.0145  SELECT data1 FROM stats2021 t WHERE league_id = 58610 AND teamId = 6393440 and type = 33
0.0146  SELECT data1 FROM stats2021 t WHERE league_id = 58610 AND teamId = 6393441 and type = 33
0.0149  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '108184' and rp.type = 2021 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 108184 AND year = 2021 AND channel = 'Footters' LIMIT 1
0.0147  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 108184 AND year = 2021 AND channel = 'Footters' LIMIT 1
0.0147  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='108184' AND `active` = 1 AND year = 2021
0.0175  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='58610' AND relp.team_id=6393440 WHERE relp.in_squad=1 and mp.`match_id` = '108184' AND mp.year='2021' ORDER BY mp.`team` ASC, p.`role` ASC
0.0168  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='58610' AND relp.team_id=6393441 WHERE relp.in_squad=1 and mp.`match_id` = '108184' AND mp.year='2021' ORDER BY mp.`team` ASC, p.`role` ASC
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=108184 AND extraId = 58610 AND type_rel = 4
0.0147  SELECT * FROM futbol.calendars_lineups WHERE id = 108184 AND league_id = 58610 AND year = 2021