4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Novelda CF - Villajoyosa
Jornada 24
FINALIZADO
50
50
154 Pts. Elo
5º

155 Pts. Elo
12º

2-1
Domingo, 07 Abril 2024, 17:00
0 - 1
 14' José Bernardo
A. Boyer 40'
1 - 1
A. Lakhdar 90'
2 - 1

Eventos del partido

Goles

minuto 14'José BernardoGol de José Bernardo
A. BoyerGol de
A. Boyer
minuto 40'
A. LakhdarGol de
A. Lakhdar
minuto 90'

Tarjetas

minuto 5'M. HernanT. Amarilla M. Hernan
J. HerreraT. Amarilla
J. Herrera
minuto 11'
minuto 28'B. QuirozT. Amarilla B. Quiroz
minuto 53'José BernardoT. Amarilla José Bernardo
minuto 65'H. El HantaquiT. Amarilla H. El Hantaqui
I. GarciaT. Amarilla
I. Garcia
minuto 86'
minuto 87'J. ArielT. Amarilla J. Ariel
A. MondéjarT. Amarilla
A. Mondéjar
minuto 88'
A. BentilT. Amarilla
A. Bentil
minuto 90'
BeldaT. Amarilla
Belda
minuto 90'

Cambios

minuto 51'A. LeonelEntra en el partido A. Leonel
minuto 51'FuentesSale del partido Fuentes
A. PuertoSale del partido
A. Puerto
minuto 60'
A. BentilEntra en el partido
A. Bentil
minuto 60'
A. FajardoEntra en el partido
A. Fajardo
minuto 66'
A. BoyerSale del partido
A. Boyer
minuto 66'
minuto 68'A. LópezEntra en el partido A. López
minuto 68'H. El HantaquiSale del partido H. El Hantaqui
A. MondéjarEntra en el partido
A. Mondéjar
minuto 88'
A. GonzalezSale del partido
A. Gonzalez
minuto 88'
minuto 89'Z. ShabanajEntra en el partido Z. Shabanaj
minuto 89'J. ErosSale del partido J. Eros

Alineaciones

Novelda CF

Novelda CF

4-4-2
Alineación Inicial
Suplentes
Villajoyosa

Villajoyosa

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,026,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.5210
Total Execution Time  0.5220
  CADENA URL  
/partido/Novelda-Cf/Villajoyosa-Cf/2021?section=legal
  GET DATOS  
$_GET['/partido/Novelda-Cf/Villajoyosa-Cf/2021']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0106  SELECT data1 FROM stats2024 t WHERE league_id = 73772 AND teamId = 6608063 and type = 33
0.0104  SELECT data1 FROM stats2024 t WHERE league_id = 73772 AND teamId = 6608067 and type = 33
0.0106  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '538605' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 538605 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0106  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 538605 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='538605' AND `active` = 1 AND year = 2024
0.0124  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='73772' AND relp.team_id=6608063 WHERE relp.in_squad=1 and mp.`match_id` = '538605' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0123  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='73772' AND relp.team_id=6608067 WHERE relp.in_squad=1 and mp.`match_id` = '538605' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0104  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=538605 AND extraId = 73772 AND type_rel = 4
0.0105  SELECT rating1, rating2 FROM calendars_elo WHERE id=538605 AND league_id=73772 AND year=2024
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 538605 AND league_id = 73772 AND year = 2024