4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Betis - Espanyol
Jornada 17
FINALIZADO
20
10
1781 Pts. Elo
3º

1833 Pts. Elo
7º

1-0
Sábado, 30 Diciembre 1989, 00:00
Mel 53'
1 - 0

Real Betis

4-4-2
Alineación Inicial
Suplentes

Espanyol

4-4-2
Alineación Inicial
Suplentes
Real Betis
Espanyol
T. Amarilla
T. Amarilla
Gol de penalti
Sale del partido
Entra en el partido
Entra en el partido
Entra en el partido
Sale del partido
Sale del partido
T. Amarilla
Sale del partido
Entra en el partido

Eventos del partido

Goles

Gol de penalti
Mel
minuto 53'

Tarjetas

T. Amarilla
Calderé
minuto 21'
minuto 52'T. Amarilla Golobart
T. Amarilla
Miguel Ángel II
minuto 88'

Cambios

Sale del partido
Job
minuto 64'
Entra en el partido
Zafra
minuto 64'
minuto 68'Entra en el partido Francis
minuto 68'Entra en el partido Zalazar
minuto 68'Sale del partido Gabino
minuto 68'Sale del partido Diego Orejuela
Sale del partido
Miguel Ángel II
minuto 89'
Entra en el partido
Miguel Ángel
minuto 89'
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
5,836,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3575
Total Execution Time  0.3586
  CADENA URL  
/partido/Betis/Espanyol/1990
  GET DATOS  
$_GET['/partido/Betis/Espanyol/1990']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0125  SELECT data1 FROM stats1990 t WHERE league_id = 5486 AND teamId = 95802 and type = 33
0.0125  SELECT data1 FROM stats1990 t WHERE league_id = 5486 AND teamId = 95799 and type = 33
0.0148  SELECT rdh.pos, rdh.playerId AS player_id, rdh.team, dp.alias, dp.role, dp.name, dp.nick, dp.last_name, '' AS num FROM rel_dreamteam_historical AS rdh INNER JOIN dataplayers AS dp ON rdh.playerId=dp.id WHERE rdh.match_id=541 AND rdh.league_id=5486 ORDER BY rdh.team ASC, rdh.pos ASC, dp.nick ASC
0.0127  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '541' and rp.type = 1990 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 = 541 AND year = 1990 AND channel = 'Footters' LIMIT 1
0.0128  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 541 AND year = 1990 AND channel = 'Footters' LIMIT 1
0.0128  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='541' AND `active` = 1 AND year = 1990
0.0202  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='5486' AND relp.team_id=95802 WHERE relp.in_squad=1 and mp.`match_id` = '541' AND mp.year='1990' ORDER BY mp.`team` ASC, p.`role` ASC
0.0166  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='5486' AND relp.team_id=95799 WHERE relp.in_squad=1 and mp.`match_id` = '541' AND mp.year='1990' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '5486' AND id_match = '541'
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=541 AND extraId = 5486 AND type_rel = 4
0.0134  SELECT * FROM futbol.calendars_lineups WHERE id = 541 AND league_id = 5486 AND year = 1990