4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Revilla - UC Cartes
Jornada 9
FINALIZADO
00
40
60 Pts. Elo
13º

62 Pts. Elo
14º

2-1
Sábado, 04 Noviembre 2023, 17:30
Laro 19'
1 - 0
Chani 53'
2 - 0
2 - 1
 89' Jairo

Eventos del partido

Goles

LaroGol de
Laro
minuto 19'
ChaniGol de
Chani
minuto 53'
minuto 89'JairoGol de Jairo

Tarjetas

minuto 25'Héctor CallejaT. Amarilla Héctor Calleja
minuto 57'RichiT. Amarilla Richi
minuto 84'NachoT. Amarilla Nacho
minuto 84'A. ÁlvarezT. Amarilla A. Álvarez

Cambios

minuto 46'RichiEntra en el partido Richi
minuto 46'Marcus OlivierSale del partido Marcus Olivier
LaroSale del partido
Laro
minuto 52'
C. SarabiaEntra en el partido
C. Sarabia
minuto 52'
minuto 57'RoberSale del partido Rober
minuto 57'DorronsoroEntra en el partido Dorronsoro
minuto 57'Borja DíazSale del partido Borja Díaz
minuto 57'A. ÁlvarezEntra en el partido A. Álvarez
ChaniSale del partido
Chani
minuto 63'
D. MandicuteEntra en el partido
D. Mandicute
minuto 63'
minuto 74'F. VaccaroSale del partido F. Vaccaro
minuto 74'R. GutiérrezSale del partido R. Gutiérrez
minuto 74'NachoEntra en el partido Nacho
minuto 74'L. CarreraEntra en el partido L. Carrera
M. SierraSale del partido
M. Sierra
minuto 80'
BrunoEntra en el partido
Bruno
minuto 80'
H. CastanedoSale del partido
H. Castanedo
minuto 80'
AllendeEntra en el partido
Allende
minuto 80'

Alineaciones

Revilla

Revilla

4-4-2
Alineación Inicial
Suplentes
UC Cartes

UC Cartes

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,816,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.4495
Total Execution Time  0.4504
  CADENA URL  
/partido/Revilla/Uc-Cartes/2024?section=legal
  GET DATOS  
$_GET['/partido/Revilla/Uc-Cartes/2024']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0125  SELECT data1 FROM stats2024 t WHERE league_id = 72262 AND teamId = 6586161 and type = 33
0.0124  SELECT data1 FROM stats2024 t WHERE league_id = 72262 AND teamId = 6586153 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 = '420640' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 420640 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0129  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 420640 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0129  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='420640' AND `active` = 1 AND year = 2024
0.0167  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='72262' AND relp.team_id=6586161 WHERE relp.in_squad=1 and mp.`match_id` = '420640' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0140  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='72262' AND relp.team_id=6586153 WHERE relp.in_squad=1 and mp.`match_id` = '420640' 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=420640 AND extraId = 72262 AND type_rel = 4
0.0126  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 = 420640 AND league_id = 72262 AND year = 2024