4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
CD La Haba - Madroñera Olimpia
Jornada 14
FINALIZADO
20
00
12 Pts. Elo
7º

3 Pts. Elo
12º

4-1
Domingo, 17 Diciembre 2023, 16:00
F. Tena 34'
1 - 0
J. Manzano 36'
2 - 0
M. Jimenez 73'
3 - 0
J. Donoso 81'
4 - 0
4 - 1
 83' P. Muñoz

Eventos del partido

Goles

F. TenaGol de
F. Tena
minuto 34'
J. ManzanoGol de
J. Manzano
minuto 36'
M. JimenezGol de
M. Jimenez
minuto 73'
J. DonosoGol de
J. Donoso
minuto 81'
minuto 83'P. MuñozGol de P. Muñoz

Tarjetas

D. GallardoT. Amarilla
D. Gallardo
minuto 18'
J. RodriguezT. Amarilla
J. Rodriguez
minuto 42'

Cambios

minuto 46'J. RojoSale del partido J. Rojo
minuto 46'J. FernandezEntra en el partido J. Fernandez
minuto 59'J. PalaciosEntra en el partido J. Palacios
minuto 59'I. BarradoSale del partido I. Barrado
A. RoblesEntra en el partido
A. Robles
minuto 63'
D. GallardoSale del partido
D. Gallardo
minuto 63'
minuto 70'J. GarciaSale del partido J. Garcia
minuto 70'J. DiazEntra en el partido J. Diaz
minuto 73'R. CostaEntra en el partido R. Costa
minuto 73'J. CanoSale del partido J. Cano
J. RodriguezSale del partido
J. Rodriguez
minuto 76'
J. RodriguezEntra en el partido
J. Rodriguez
minuto 76'
J. DeEntra en el partido
J. De
minuto 78'
J. ManzanoSale del partido
J. Manzano
minuto 78'
minuto 85'M. FernándezEntra en el partido M. Fernández
minuto 85'F. BarquillaSale del partido F. Barquilla

Alineaciones

CD La Haba

CD La Haba

4-4-2
Alineación Inicial
Suplentes
Madroñera Olimpia

Madroñera Olimpia

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,610,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.4643
Total Execution Time  0.4655
  CADENA URL  
/partido/Cd-La-Haba/Cd-Madronera-Olimpia-Senior/2024
  GET DATOS  
$_GET['/partido/Cd-La-Haba/Cd-Madronera-Olimpia-Senior/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0126  SELECT data1 FROM stats2024 t WHERE league_id = 73797 AND teamId = 6608383 and type = 33
0.0128  SELECT data1 FROM stats2024 t WHERE league_id = 73797 AND teamId = 6608382 and type = 33
0.0139  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '541512' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 541512 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0129  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 541512 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0131  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='541512' AND `active` = 1 AND year = 2024
0.0160  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='73797' AND relp.team_id=6608383 WHERE relp.in_squad=1 and mp.`match_id` = '541512' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0155  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='73797' AND relp.team_id=6608382 WHERE relp.in_squad=1 and mp.`match_id` = '541512' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=541512 AND extraId = 73797 AND type_rel = 4
0.0126  SELECT rating1, rating2 FROM calendars_elo WHERE id=541512 AND league_id=73797 AND year=2024
0.0128  SELECT * FROM futbol.calendars_lineups WHERE id = 541512 AND league_id = 73797 AND year = 2024