4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Villarreal - Cádiz
Jornada 23
FINALIZADO
30
10
2732 Pts. Elo
59%
14º

1667 Pts. Elo
40%
18º

0-0
Domingo, 04 Febrero 2024, 14:00
  • Estadio: Estadio de la Cerámica

Villarreal

4-4-2
Alineación Inicial
Suplentes

Cádiz

4-4-2
Alineación Inicial
Suplentes

Eventos del partido

Tarjetas

T. Amarilla
F. Coquelin
minuto 47'
T. Amarilla
Santi Comesaña
minuto 67'
minuto 69'T. Amarilla Iza
T. Amarilla
Álex Baena
minuto 94'

Cambios

Entra en el partido
Morales
minuto 46'
Sale del partido
Ilias Akhomach
minuto 46'
Entra en el partido
Gonçalo Guedes
minuto 46'
Sale del partido
A. Sørloth
minuto 46'
Entra en el partido
É. Capoue
minuto 70'
Sale del partido
Santi Comesaña
minuto 70'
minuto 75'Entra en el partido Juanmi
minuto 75'Sale del partido Iván Alejo
minuto 82'Sale del partido Robert Navarro
minuto 82'Entra en el partido Maxi Gómez
minuto 82'Sale del partido Chris Ramos
minuto 82'Entra en el partido B. Ocampo
Entra en el partido
Manu Trigueros
minuto 89'
Sale del partido
F. Coquelin
minuto 89'
minuto 93'Sale del partido Rubén Sobrino
minuto 93'Entra en el partido R. Kouamé
minuto 93'Entra en el partido J. Zaldua
minuto 93'Sale del partido G. Escalante

Otros

Lesionado
F. Coquelin
minuto 88'

Estadísticas del partido

Villarreal Villarreal Cádiz Cádiz
59%
Posesión del balón
 40%
0
Goles
 0
4
Tiros a puerta
 2
11
Tiros fuera
 5
19
Total tiros
 8
2
Paradas del portero
 4
13
Saques de esquina
 2
3
Fueras de juego
 2
0
Tarjetas Rojas
 0
1
Lesiones
 0
3
Sustituciones
 3
14
Faltas
 14
1 Comentarios
  • penetreitor
    Hace 2 meses penetreitor dice: El Villarreal estará con el subidón. 2-0

Partido televisado en...
Canal Medio Idioma País
DAZN TV Castellano
DAZN LaLiga TV Castellano
LaLiga TV Bar TV Castellano
SKY Sports TV -
SKY Sports TV -
SKY Sports TV -
DSports TV Latino
DGO TV Latino
SKY Sports TV -
DGO TV -
DSports TV -
DGO TV -
DSports TV -
DSports TV -
SKY Sports TV -

  USO DE MEMORIA  
7,458,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.6120
Total Execution Time  0.6131
  CADENA URL  
/partido/Villarreal/Cadiz/2024
  GET DATOS  
$_GET['/partido/Villarreal/Cadiz/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0005   SELECT c.comment_id, COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`league_id` = '72116' AND c.`match_id` = '30473' AND c.comment_id IN (69132526) GROUP BY c.comment_id
0.0147  SELECT data1 FROM stats2024 t WHERE league_id = 72116 AND teamId = 6583651 and type = 33
0.0148  SELECT data1 FROM stats2024 t WHERE league_id = 72116 AND teamId = 6583633 and type = 33
0.0146  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '30473' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 30473 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0148  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 30473 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0149   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '69132526' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0145  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='30473' AND `active` = 1 AND year = 2024
0.0281  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='72116' AND relp.team_id=6583651 WHERE relp.in_squad=1 and mp.`match_id` = '30473' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0477  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='72116' AND relp.team_id=6583633 WHERE relp.in_squad=1 and mp.`match_id` = '30473' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0144  SELECT * FROM futbol.calendars_lineups WHERE id = 30473 AND league_id = 72116 AND year = 2024