4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Drogheda United - Finn Harps
Jornada 19
FINALIZADO
20
40
530 Pts. Elo
3º

394 Pts. Elo
4º

0-1
Viernes, 06 Julio 2018, 20:45
0 - 1
 90' J. O'flynn

Eventos del partido

Goles

minuto 90'J. O'flynnGol de J. O'flynn

Tarjetas

minuto 27'P. MccourtT. Amarilla P. Mccourt
S. BrennanT. Amarilla
S. Brennan
minuto 60'
C. LyonsT. Amarilla
C. Lyons
minuto 64'
minuto 70'S. ToddT. Amarilla S. Todd
minuto 84'N. BoyleT. Amarilla N. Boyle
minuto 86'K. CowanT. Amarilla K. Cowan

Cambios

minuto 30'N. McGinleyEntra en el partido N. McGinley
minuto 30'Mark CoyleSale del partido Mark Coyle
minuto 45'N. BoyleEntra en el partido N. Boyle
minuto 45'P. MccourtSale del partido P. Mccourt
L. DuffyEntra en el partido
L. Duffy
minuto 72'
G. MccaffreySale del partido
G. Mccaffrey
minuto 72'
minuto 87'J. O'flynnEntra en el partido J. O'flynn
minuto 87'J. DeversSale del partido J. Devers
R. ManleyEntra en el partido
R. Manley
minuto 87'
S. BrennanSale del partido
S. Brennan
minuto 87'

Alineaciones

Drogheda United

Drogheda United

4-4-2
Alineación Inicial
Suplentes
Finn Harps

Finn Harps

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,821,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.2765
Total Execution Time  0.2775
  CADENA URL  
/partido/Drogheda-United/Finn-Harps/2018
  GET DATOS  
$_GET['/partido/Drogheda-United/Finn-Harps/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0127  SELECT data1 FROM stats2018 t WHERE league_id = 42101 AND teamId = 854872 and type = 33
0.0127  SELECT data1 FROM stats2018 t WHERE league_id = 42101 AND teamId = 854873 and type = 33
0.0134  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '705926' and rp.type = 2018 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 = 705926 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 705926 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0125  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='705926' AND `active` = 1 AND year = 2018
0.0173  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='42101' AND relp.team_id=854872 WHERE relp.in_squad=1 and mp.`match_id` = '705926' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0214  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='42101' AND relp.team_id=854873 WHERE relp.in_squad=1 and mp.`match_id` = '705926' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0130  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=705926 AND extraId = 42101 AND type_rel = 4
0.0129  SELECT * FROM futbol.calendars_lineups WHERE id = 705926 AND league_id = 42101 AND year = 2018