4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
B. Dortmund - Barcelona
Final
FINALIZADO
10
10
3175 Pts. Elo

3351 Pts. Elo

1-1
Miércoles, 11 Marzo 1998, 20:00
0 - 1
 8' Giovanni
Jörg Heinrich 64'
1 - 1
B. Dortmund
Barcelona
Gol
Entra en el partido
Sale del partido
T. Amarilla
Entra en el partido
Sale del partido
Gol
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
T. Amarilla
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido

Eventos del partido

Goles

minuto 8'GiovanniGol de Giovanni
Jörg HeinrichGol de
Jörg Heinrich
minuto 64'

Tarjetas

Jürgen KohlerT. Amarilla
Jürgen Kohler
minuto 28'
minuto 79'ÒscarT. Amarilla Òscar

Cambios

B. MehnertEntra en el partido
B. Mehnert
minuto 20'
Steffen FreundSale del partido
Steffen Freund
minuto 20'
B. GamboEntra en el partido
B. Gambo
minuto 45'
S. ChapuisatSale del partido
S. Chapuisat
minuto 45'
minuto 71'ÒscarEntra en el partido Òscar
minuto 71'Sonny AndersonSale del partido Sonny Anderson
Jovan KirovskiEntra en el partido
Jovan Kirovski
minuto 73'
Jürgen KohlerSale del partido
Jürgen Kohler
minuto 73'
minuto 79'G. AmorEntra en el partido G. Amor
minuto 79'CeladesSale del partido Celades
minuto 89'D. CiricEntra en el partido D. Ciric
minuto 89'Luis EnriqueSale del partido Luis Enrique
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
5,644,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.4158
Total Execution Time  0.4168
  CADENA URL  
/partido/Borussia-Dortmund/Barcelona/1998
  GET DATOS  
$_GET['/partido/Borussia-Dortmund/Barcelona/1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0125  SELECT data1 FROM stats1998 t WHERE league_id = 11891 AND teamId = 178759 and type = 33
0.0125  SELECT data1 FROM stats1998 t WHERE league_id = 11891 AND teamId = 178757 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 = '19027' and rp.type = 1998 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 = 19027 AND year = 1998 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 19027 AND year = 1998 AND channel = 'Footters' LIMIT 1
0.0125  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='19027' AND `active` = 1 AND year = 1998
0.0163  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='11891' AND relp.team_id=178759 WHERE relp.in_squad=1 and mp.`match_id` = '19027' AND mp.year='1998' ORDER BY mp.`team` ASC, p.`role` ASC
0.0169  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='11891' AND relp.team_id=178757 WHERE relp.in_squad=1 and mp.`match_id` = '19027' AND mp.year='1998' ORDER BY mp.`team` ASC, p.`role` ASC
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19027 AND extraId = 11891 AND type_rel = 4
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=133 AND type_rel = 3
0.0135  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 133 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1301072,1297561,230216,1281325,1273932) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT position FROM tables1998 WHERE team=178759 AND league_id=11891 AND round=1
0.0125  SELECT position FROM tables1998 WHERE team=178757 AND league_id=11891 AND round=1
0.0124  SELECT * FROM futbol.calendars_lineups WHERE id = 19027 AND league_id = 11891 AND year = 1998