Publicidad 600x120.gif
Fase Previa Europa League 1998
1997/1998

Fase Previa Europa League 1998

 
12 Ago 97
16:30 Finalizado
Jablonec Jablonec 1-1 Orebro SK Orebro SK más información Jugadas destacadas ...
20' R. Hromádko 1-0
1-1 66' D. Sahlin
 
26 Ago 97
18:00 Finalizado
Orebro SK Orebro SK 0-0 Jablonec Jablonec más información ...
Global
Jablonec 1 - 1 Orebro SK
 
12 Ago 97
20:00 Finalizado
Neuchâtel Xamax Neuchâtel Xamax 3-0 Viking Stavanger Viking Stavanger más información Jugadas destacadas ...
53' Liazid Sandjak 1-0
58' Erik Fuglestad
80' Liazid Sandjak 3-0
 
26 Ago 97
19:00 Finalizado
Viking Stavanger Viking Stavanger 2-1 Neuchâtel Xamax Neuchâtel Xamax más información Jugadas destacadas ...
0-1 48' A. Kunz
54' V. Skogheim 1-1
83' Jerry Månsson 2-1
Global
Neuchâtel 4 - 2 Viking
 
12 Ago 97
17:00 Finalizado
Dinamo Minsk Dinamo Minsk 0-2 Lillestrom SK Lillestrom SK más información Jugadas destacadas ...
0-1 39' Diallo
0-2 74' Diallo
 
26 Ago 97
18:00 Finalizado
Lillestrom SK Lillestrom SK 1-0 Dinamo Minsk Dinamo Minsk más información Jugadas destacadas ...
40' Diallo 1-0
Global
Dinamo Minsk 0 - 3 Lillestrom
 
12 Ago 97
19:30 Finalizado
Grasshopper Grasshopper 3-0 SK Brann SK Brann más información Jugadas destacadas ...
50' Joël Magnin 1-0
65' Türkyilmaz 2-0
83' P. Thüler 3-0
 
26 Ago 97
19:00 Finalizado
SK Brann SK Brann 2-0 Grasshopper Grasshopper más información Jugadas destacadas ...
41' Stefan Paldan 1-0
44' Stefan Paldan 2-0
Global
Grasshopper 3 - 2 SK Brann
 
12 Ago 97
17:00 Finalizado
Rotor Volgograd Rotor Volgograd 2-0 Odra Wodzislaw Slaski Odra Wodzislaw Slaski más información Jugadas destacadas ...
75' Vladimir Niederhaus 1-0
89' O. Veretennikov 2-0
 
26 Ago 97
17:00 Finalizado
Odra Wodzislaw Slaski Odra Wodzislaw Slaski 3-4 Rotor Volgograd Rotor Volgograd más información Jugadas destacadas ...
0-1 5' Aleksandr Berketov
35' Mirosław Staniek 1-1
43' Krzysztof Zagórski 2-1
44' Piotr Brzoza 3-1
3-2 50' Vitaliy Abramov
60' Vitaliy Abramov
3-3 70' O. Veretennikov
3-4 72' O. Veretennikov
Global
Rotor 6 - 3 Odra
 
12 Ago 97
17:00 Finalizado
Alaniya Vladikavkaz Alaniya Vladikavkaz 2-1 Dnipro Dnipropetrovsk Dnipro Dnipropetrovsk más información Jugadas destacadas ...
0-1 7' Olexandr Palianytsia
18' R. Žutautas 1-1
56' M. Ashvetia 2-1
 
26 Ago 97
17:00 Finalizado
Dnipro Dnipropetrovsk Dnipro Dnipropetrovsk 1-4 Alaniya Vladikavkaz Alaniya Vladikavkaz más información Jugadas destacadas ...
0-1 3' Giorgi Gakhokidze
23' Volodymyr Sharan 1-1
1-2 28' Giorgi Gakhokidze
1-3 33' Igor Yanovski
1-4 44' L. Kobiashvili
Global
Alaniya 6 - 2 Dnipro
 
12 Ago 97
19:45 Finalizado
PAOK PAOK 5-3 Spartak Trnava Spartak Trnava más información Jugadas destacadas ...
0-1 21' M. Ujlaky
0-2 23' L. Luhový
0-3 26' M. Ujlaky
31' M. Ujlaky
31' T. Zagorakis 1-3
34' S. Marangos 2-3
45' S. Marangos 3-3
52' K. Frantzeskos 4-3
68' S. Marangos
80' Percy Olivares 5-3
 
26 Ago 97
19:00 Finalizado
Spartak Trnava Spartak Trnava 0-1 PAOK PAOK más información Jugadas destacadas ...
0-1 79' T. Zagorakis
Global
PAOK 6 - 3 Spartak
 
12 Ago 97
20:00 Finalizado
Vejle BK Vejle BK 0-0 Hapoel Petah Tikva Hapoel Petah Tikva más información ...
 
26 Ago 97
18:00 Finalizado
Hapoel Petah Tikva Hapoel Petah Tikva 1-0 Vejle BK Vejle BK más información Jugadas destacadas ...
33' Moti Kakun 1-0
88' Beni Kozoshvili
Global
Vejle BK 0 - 1 Hapoel Petah
 
12 Ago 97
17:30 Finalizado
ND Gorica ND Gorica 3-5 Club Brugge Club Brugge más información Jugadas destacadas ...
0-1 10' G. Claessens
0-2 12' Lorenzo Staelens
0-3 20' Lorenzo Staelens
0-4 25' G. Claessens
0-5 42' Lorenzo Staelens
61' Osterc 1-5
63' Osterc 2-5
75' Florijan Debenjak
80' Osterc 3-5
 
26 Ago 97
20:00 Finalizado
Club Brugge Club Brugge 3-0 ND Gorica ND Gorica más información Jugadas destacadas ...
4' N. Jbari 1-0
80' Tjörven De Brul 2-0
82' F. Van Der Elst 3-0
Global
ND Gorica 3 - 8 Club Brugge
 
12 Ago 97
19:00 Finalizado
Újpest FC Újpest FC 0-0 AGF Aarhus AGF Aarhus más información ...
 
26 Ago 97
19:00 Finalizado
AGF Aarhus AGF Aarhus 3-2 Újpest FC Újpest FC más información Jugadas destacadas ...
28' Mads Rieper 1-0
1-1 31' Vilmos Sebők
53' Carsten Hallum 2-1
55' Jesper Sørensen 3-1
3-2 65' Zoltán Kovács
Global
Újpest FC 2 - 3 AGF Aarhus
 
12 Ago 97
19:15 Finalizado
Rapid Wien Rapid Wien 6-1 Zbrojovka Brno Zbrojovka Brno más información Jugadas destacadas ...
36' S. Ipoua 1-0
45' P. Stöger 2-0
2-1 53' R. Dostálek
62' S. Ipoua 3-1
78' C. Prosenik 4-1
80' Christian Stumpf 5-1
86' P. Stöger 6-1
 
26 Ago 97
18:15 Finalizado
Zbrojovka Brno Zbrojovka Brno 2-0 Rapid Wien Rapid Wien más información Jugadas destacadas ...
3' Milan Pacanda 1-0
45' Zdeněk Valnoha 2-0
Global
Rapid Wien 6 - 3 Zbrojovka
 
12 Ago 97
20:00 Finalizado
Anderlecht Anderlecht 2-0 Vorskla Poltava Vorskla Poltava más información Jugadas destacadas ...
18' Dan Petersen 1-0
89' Alin Stoica 2-0
 
26 Ago 97
18:00 Finalizado
Vorskla Poltava Vorskla Poltava 0-2 Anderlecht Anderlecht más información Jugadas destacadas ...
0-1 31' P. Zetterberg
0-2 42' E. Scifo
83' G. De Boeck
Global
Anderlecht 4 - 0 Vorskla
 
12 Ago 97
20:00 Finalizado
Apollon Limassol Apollon Limassol 0-0 Excelsior Mouscron Excelsior Mouscron más información ...
 
26 Ago 97
20:00 Finalizado
Excelsior Mouscron Excelsior Mouscron 3-0 Apollon Limassol Apollon Limassol más información Jugadas destacadas ...
32' F. Pierre 1-0
53' G. Vidović 2-0
66' F. Pierre 3-0
73' Chrysostomos Christofi
Global
Apollon 0 - 3 Excelsior
 
12 Ago 97
19:00 Finalizado
Trabzonspor Trabzonspor 1-0 Dundee United Dundee United más información Jugadas destacadas ...
78' H. Mandirali 1-0
 
26 Ago 97
20:30 Finalizado
Dundee United Dundee United 1-1 Trabzonspor Trabzonspor más información Jugadas destacadas ...
55' Andy Mclaren 1-0
1-1 80' H. Mandirali
Global
Trabzonspor 2 - 1 Dundee
 
12 Ago 97
20:00 Finalizado
HNK Hajduk Split HNK Hajduk Split 3-2 Malmö FF Malmö FF más información Jugadas destacadas ...
0-1 11' Jonas Wirmola
0-2 59' Gudmundsson
77' J. Skoko 1-2
79' Goce Sedloski 2-2
89' Mass Sarr Jr 3-2
 
26 Ago 97
19:30 Finalizado
Malmö FF Malmö FF 0-2 HNK Hajduk Split HNK Hajduk Split más información Jugadas destacadas ...
13' Jonas Wirmola
0-1 45' J. Vucko
0-2 90' T. Erceg
Global
Hajduk Split 5 - 2 Malmö FF
 
12 Ago 97
19:00 Finalizado
Helsingborgs IF Helsingborgs IF 0-1 Ferencvárosi Ferencvárosi más información Jugadas destacadas ...
0-1 41' O. Vincze
 
26 Ago 97
19:00 Finalizado
Ferencvárosi Ferencvárosi 0-1 Helsingborgs IF Helsingborgs IF más información Jugadas destacadas ...
0-1 42' A. Jakobsson
Global
Helsingborgs 1 - 1 Ferencváros
 
12 Ago 97
21:00 Finalizado
Tirol Innsbruck Tirol Innsbruck 2-1 Celtic Celtic más información Jugadas destacadas ...
22' C. Mayrleb 1-0
28' C. Mayrleb 2-0
2-1 82' A. Stubbs
 
26 Ago 97
21:00 Finalizado
Celtic Celtic 6-3 Tirol Innsbruck Tirol Innsbruck más información Jugadas destacadas ...
34' Simon Donnelly 1-0
1-1 39' C. Mayrleb
45' H. Larsson
45' A. Thom 3-1
69' Simon Donnelly 4-1
70' C. Burley 5-1
5-2 82' Gernot Krinner
88' M. Wieghorst 6-2
90' C. Burley 7-2
Global
Tirol 5 - 7 Celtic
 
12 Ago 97
22:00 Finalizado
KR Reykjavík KR Reykjavík 0-0 OFI OFI más información ...
 
26 Ago 97
20:30 Finalizado
OFI OFI 3-1 KR Reykjavík KR Reykjavík más información Jugadas destacadas ...
10' Y. Anastasiou 1-0
1-1 41' H. Björnsson
65' Pedrag Mitić 2-1
82' Nikolaos Papadopoulos 3-1
Global
Reykjavík 1 - 3 OFI
JUGADORES DESTACADOS

Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,305,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1069
Total Execution Time  0.1088
  CADENA URL  
/previa_europa_league1998
  GET DATOS  
$_GET['/previa_europa_league1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0017  SELECT type FROM routes WHERE alias = 'previa_europa_league1998'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'previa_europa_league' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0023  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 42392 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=117 ORDER BY l.group_code ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 05:20:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 05:20:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 05:20:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 05:20:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'previa_europa_league' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0026  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=42392 AND rel.round=2
0.0018  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 42392 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0018  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 42392 AND esl.points > 0
0.0018  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-02-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 42392 ORDER BY creation_date DESC LIMIT 0, 10
0.0030  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-02-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 42392
0.0075  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars1998` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 42392 AND c.`round` = 2 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200
0.0067  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events1998 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1998 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 42392 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (42379,42421,42392,42424,42381,42422,42388,42426,42380,42417,42382,42418,42389,42428,42393,42420,42383,42430,42386,42427,42387,42423,42390,42419,42394,42431,42384,42432,42391,42429,42385,42425,42395,42434,42396,42433) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0020  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1998` e INNER JOIN calendars1998 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 2 AND e.real_date IS NOT NULL AND e.league_id = 42392 ORDER BY total DESC LIMIT 40
0.0019  SELECT distinct(shedule), round FROM `calendars1998` as c WHERE c.`league_id` = 42392 AND shedule >= '1997/08/01' AND shedule < '1997/09/01' ORDER BY shedule ASC
0.0017  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-03-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 42392 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0024  SELECT data1, data2 FROM services_tags WHERE categoryId=674
0.0024  SELECT group_code, extraName from `leagues` WHERE categoryId=674 AND year=1998