4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Anguiano - Haro Deportivo
Jornada 18
FINALIZADO
40
80
108 Pts. Elo
6º

63 Pts. Elo
13º

2-2
Domingo, 28 Enero 2024, 16:00
M. Padín 18'
1 - 0
1 - 1
 26' A. Marcos
1 - 2
 51' Andres Lopez
M. Voltarel 78'
2 - 2

Eventos del partido

Goles

M. PadínGol de
M. Padín
minuto 18'
minuto 26'A. MarcosGol de A. Marcos
minuto 51'Andres LopezGol de Andres Lopez
M. VoltarelGol de
M. Voltarel
minuto 78'

Tarjetas

minuto 16'G. PerezT. Amarilla G. Perez
minuto 16'Y. KeitaT. Amarilla Y. Keita
minuto 30'AnderT. Amarilla Ander
J. OlarteT. Amarilla
J. Olarte
minuto 40'
minuto 43'A. SanturdeT. Amarilla A. Santurde
minuto 60'Del CampoT. Amarilla Del Campo
minuto 63'Andres LopezT. Amarilla Andres Lopez
minuto 69'A. MarcosT. Amarilla A. Marcos
MohaT. Amarilla
Moha
minuto 72'
Adrià MollunaT. Amarilla
Adrià Molluna
minuto 74'
minuto 77'M. EssiamT. Amarilla M. Essiam
S. AzofraT. Amarilla
S. Azofra
minuto 89'

Cambios

M. VoltarelEntra en el partido
M. Voltarel
minuto 32'
HéctorSale del partido
Héctor
minuto 32'
minuto 46'AnderSale del partido Ander
minuto 46'GonzaloEntra en el partido Gonzalo
minuto 57'ZunzuSale del partido Zunzu
minuto 57'Xabier HidalgoEntra en el partido Xabier Hidalgo
M. PadínSale del partido
M. Padín
minuto 60'
J. OlarteSale del partido
J. Olarte
minuto 60'
ÁlexSale del partido
Álex
minuto 60'
N. HamoudiEntra en el partido
N. Hamoudi
minuto 60'
Mario MuroEntra en el partido
Mario Muro
minuto 60'
S. AzofraEntra en el partido
S. Azofra
minuto 60'
minuto 68'J. PachecoEntra en el partido J. Pacheco
minuto 68'A. MarcosSale del partido A. Marcos
CaimanEntra en el partido
Caiman
minuto 72'
Alejandro MartínezSale del partido
Alejandro Martínez
minuto 72'
minuto 81'A. SanturdeSale del partido A. Santurde
minuto 81'E. MoisésEntra en el partido E. Moisés
minuto 81'Del CampoSale del partido Del Campo
minuto 81'AyusoEntra en el partido Ayuso

Otros

minuto 26'M. EssiamAsistencia M. Essiam

Alineaciones

Anguiano

Anguiano

4-4-2
Alineación Inicial
Suplentes
Haro Deportivo

Haro Deportivo

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,036,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.5329
Total Execution Time  0.5340
  CADENA URL  
/partido/Anguiano/Haro-Deportivo/2018?section=legal
  GET DATOS  
$_GET['/partido/Anguiano/Haro-Deportivo/2018']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0124  SELECT data1 FROM stats2024 t WHERE league_id = 72276 AND teamId = 6586405 and type = 33
0.0124  SELECT data1 FROM stats2024 t WHERE league_id = 72276 AND teamId = 6586415 and type = 33
0.0126  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '489655' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 489655 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 489655 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0125  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='489655' AND `active` = 1 AND year = 2024
0.0162  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='72276' AND relp.team_id=6586405 WHERE relp.in_squad=1 and mp.`match_id` = '489655' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0149  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='72276' AND relp.team_id=6586415 WHERE relp.in_squad=1 and mp.`match_id` = '489655' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=489655 AND extraId = 72276 AND type_rel = 4
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 489655 AND league_id = 72276 AND year = 2024