4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
CD Cortes - CD Itaroa Huarte
Jornada 3
FINALIZADO
71
20
55 Pts. Elo
12º

76 Pts. Elo
2º

0-2
Sábado, 23 Septiembre 2023, 16:00
0 - 1
 1' Pascual
0 - 2
 58' Txintxe

Eventos del partido

Goles

minuto 1' Pascual Gol de (p.p)
Pascual
minuto 58'TxintxeGol de Txintxe

Tarjetas

A. KessasT. Amarilla
A. Kessas
minuto 36'
PascualT. Amarilla
Pascual
minuto 44'
T. BouguettayaT. Amarilla
T. Bouguettaya
minuto 60'
Dani SalasT. Amarilla
Dani Salas
minuto 62'
A. Kessas2a Amarilla y Roja
A. Kessas
minuto 62'
D. BoteroT. Amarilla
D. Botero
minuto 66'
minuto 81'A. ArellanoT. Amarilla A. Arellano
minuto 86'AgramonteT. Amarilla Agramonte
Mikel GuiralT. Amarilla
Mikel Guiral
minuto 90'

Cambios

minuto 61'Fernando UrdanozEntra en el partido Fernando Urdanoz
minuto 61'MoraSale del partido Mora
H. FuentesEntra en el partido
H. Fuentes
minuto 63'
RobinhoSale del partido
Robinho
minuto 63'
Óscar ZubiriEntra en el partido
Óscar Zubiri
minuto 68'
minuto 68'Iñigo PuñalSale del partido Iñigo Puñal
minuto 68'Lisandro MasokoEntra en el partido Lisandro Masoko
minuto 68'GorkaSale del partido Gorka
Mikel GuiralEntra en el partido
Mikel Guiral
minuto 68'
T. BouguettayaSale del partido
T. Bouguettaya
minuto 68'
D. BoteroSale del partido
D. Botero
minuto 68'
minuto 68'Adrián ArangurenEntra en el partido Adrián Aranguren
minuto 80'MarcoSale del partido Marco
M. SokoEntra en el partido
M. Soko
minuto 80'
K. ReimondezEntra en el partido
K. Reimondez
minuto 80'
minuto 80'Asier RangelEntra en el partido Asier Rangel
minuto 80'I. OrozSale del partido I. Oroz
MagallonSale del partido
Magallon
minuto 80'
J. GadeaSale del partido
J. Gadea
minuto 80'
minuto 80'A. ArellanoEntra en el partido A. Arellano

Alineaciones

CD Cortes

CD Cortes

4-4-2
Alineación Inicial
Suplentes
CD Itaroa Huarte

CD Itaroa Huarte

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,929,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.4323
Total Execution Time  0.4333
  CADENA URL  
/partido/Cortes/Huarte
  GET DATOS  
$_GET['/partido/Cortes/Huarte']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0105  SELECT data1 FROM stats2024 t WHERE league_id = 72275 AND teamId = 6586383 and type = 33
0.0105  SELECT data1 FROM stats2024 t WHERE league_id = 72275 AND teamId = 6586384 and type = 33
0.0107  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '444922' 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 = 444922 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 444922 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='444922' AND `active` = 1 AND year = 2024
0.0118  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='72275' AND relp.team_id=6586383 WHERE relp.in_squad=1 and mp.`match_id` = '444922' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0119  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='72275' AND relp.team_id=6586384 WHERE relp.in_squad=1 and mp.`match_id` = '444922' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0107  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=444922 AND extraId = 72275 AND type_rel = 4
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 444922 AND league_id = 72275 AND year = 2024