4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Madriz - UNAN Managua
Jornada 7
FINALIZADO
40
41
180 Pts. Elo
3º

346 Pts. Elo
5º

3-0
Domingo, 11 Septiembre 2016, 19:00
E. Morillo 24'
1 - 0
M. Alvarez 73'
2 - 0
L. Valladares 89'
3 - 0

Eventos del partido

Goles

E. MorilloGol de
E. Morillo
minuto 24'
M. AlvarezGol de
M. Alvarez
minuto 73'
L. ValladaresGol de
L. Valladares
minuto 89'

Tarjetas

A. BermudezT. Amarilla
A. Bermudez
minuto 19'
minuto 22'F. RodríguezT. Amarilla F. Rodríguez
minuto 57'M. MontielT. Amarilla M. Montiel
M. AlvarezT. Amarilla
M. Alvarez
minuto 62'
minuto 66'J. RosalesT. Amarilla J. Rosales
minuto 72'R. LeguíasT. Amarilla R. Leguías
minuto 74'K. VanegasTarjeta Roja a K. Vanegas
L. ValladaresT. Amarilla
L. Valladares
minuto 79'
S. EspinozaT. Amarilla
S. Espinoza
minuto 84'

Cambios

minuto 46'R. BaquedanoEntra en el partido R. Baquedano
minuto 46'J. HernándezSale del partido J. Hernández
minuto 63'J. DonadoSale del partido J. Donado
minuto 63'J. RosalesEntra en el partido J. Rosales
B. HerreraSale del partido
B. Herrera
minuto 66'
L. ValladaresEntra en el partido
L. Valladares
minuto 66'
E. CorralesEntra en el partido
E. Corrales
minuto 86'
A. BermudezSale del partido
A. Bermudez
minuto 86'
L. HerreraSale del partido
L. Herrera
minuto 90'
S. EspinozaEntra en el partido
S. Espinoza
minuto 90'

Alineaciones

Real Madriz

Real Madriz

4-4-2
Alineación Inicial
Suplentes
UNAN Managua

UNAN Managua

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,871,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Match / Index )  0.1910
Total Execution Time  0.1926
  CADENA URL  
/partido/Real-Madriz/Unan-Managua/2017
  GET DATOS  
$_GET['/partido/Real-Madriz/Unan-Managua/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0020  SELECT data1 FROM stats2017 t WHERE league_id = 34139 AND teamId = 722706 and type = 33
0.0020  SELECT data1 FROM stats2017 t WHERE league_id = 34139 AND teamId = 722707 and type = 33
0.0032  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '222372' and rp.type = 2017 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 222372 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0025  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 222372 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='222372' AND `active` = 1 AND year = 2017
0.0030  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='34139' AND relp.team_id=722706 WHERE relp.in_squad=1 and mp.`match_id` = '222372' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0027  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='34139' AND relp.team_id=722707 WHERE relp.in_squad=1 and mp.`match_id` = '222372' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=222372 AND extraId = 34139 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 222372 AND league_id = 34139 AND year = 2017