Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Resultados de Fútbol

« Temporada Anterior

Temporada 1997

Temporada Siguiente »

1996/1997

Primera y segunda ronda

Eliminatoria

Fase Previa Europa League 1997

Fase Previa Europa League

Europa League:

Ver jornada

Jornada 1

Ver jornada

Jornada 2

Equipos de esta liga

USO DE MEMORIA

5,048,440 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.4137
Total Execution Time	0.4156

CADENA URL

/previa_europa_league1997/grupo1/calendario

GET DATOS

$_GET['/previa_europa_league1997/grupo1/calendario']

POST DATOS

No hay datos POST existentes

CONSULTAS (22)

0.0124	SELECT type FROM routes WHERE alias = 'previa_europa_league1997'
0.0252	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 = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=674 AND type_rel = 3
0.0133	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 674 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128	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 (1275465,1275183,1273994,1273871,1272678) ORDER BY n.cover_points DESC, update_date DESC
0.0125	SELECT id,name,alias,stepParent FROM categories WHERE parentId=117 ORDER BY order_id ASC
0.0129	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 = 42395 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133	SELECT 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, dt1.stadium as stadium_name FROM calendars1997 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 42395 ORDER BY round ASC
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 01:25:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 01:25:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 01:25:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 01:25:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130	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 = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 1997
0.0141	SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (42395) AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0130	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (42395) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (354391,459,258387,266650,2266,7757,56576,258908,260266,265006) ORDER BY rp.in_squad = 1 DESC
0.0126	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 1997
0.0140	SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (42395) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (42395) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (512045,257928,330114,351376,351621,351635,351649,351665,351680,352627) ORDER BY rp.in_squad = 1 DESC
0.0127	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 1997
0.0139	SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (42395) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (42395) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (2768,4129,258164,264913,330229,330233,351496,351881,353792,353871) ORDER BY rp.in_squad = 1 DESC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

17 Jul 96	Pyunik	Pyunik - Helsinki 1996-07-17T15:00:00 Hanrapetakan 3 - 1	Helsinki	...
17 Jul 96	Neftçi	Neftçi - Lokomotiv 1996-07-17T15:30:00 Bakcell Arena 2 - 1	Lokomotiv	...
17 Jul 96	Maccabi	Maccabi - Partizan 1996-07-17T16:30:00 Sammy Ofer Stadium 0 - 1	Partizan	...
17 Jul 96	Hutnik	Hutnik - Khazri 1996-07-17T17:00:00 No disponible 9 - 0	Khazri	...
17 Jul 96	Lantana	Lantana - Vestmannaey 1996-07-17T17:00:00 No disponible 2 - 1	Vestmannaey	...
17 Jul 96	Dinamo 93	Dinamo 93 - Tiligul 1996-07-17T17:00:00 No disponible 3 - 1	Tiligul	...
17 Jul 96	Beitar	Beitar - Floriana 1996-07-17T17:30:00 Teddi Malcha Stadium 3 - 1	Floriana	...
17 Jul 96	Teuta	Teuta - Kosice 1996-07-17T17:30:00 Niko Dovana Stadium 1 - 4	Kosice	...
17 Jul 96	Slavia	Slavia - Inkaras 1996-07-17T17:30:00 Stadion Slavija 4 - 3	Inkaras	...
17 Jul 96	FK Becej	FK Becej - Mura 05 1996-07-17T17:30:00 No disponible 0 - 0	Mura 05	...
17 Jul 96	Zalgiris	Zalgiris - Crusaders 1996-07-17T17:30:00 Vilniaus LFF stadionas 2 - 0	Crusaders	...
17 Jul 96	Jazz Pori	Jazz Pori - GÍ Gøta 1996-07-17T17:30:00 No disponible 3 - 1	GÍ Gøta	...
17 Jul 96	FC Haka	FC Haka - FC Flora 1996-07-17T17:30:00 Tehtaankenttä 2 - 2	FC Flora	...
17 Jul 96	ND Gorica	ND Gorica - Vardar 1996-07-17T18:00:00 Športni Park 0 - 1	Vardar	...
17 Jul 96	Zimbru	Zimbru - Hajduk 1996-07-17T18:00:00 Stadionul Zimbru 0 - 4	Hajduk	...
17 Jul 96	Jeunesse	Jeunesse - Legia 1996-07-17T19:00:00 Stade de la Frontière 2 - 4	Legia	...
17 Jul 96	Anorthosis	Anorthosis - Shirak 1996-07-17T19:00:00 Antonis Papadopoulos 4 - 0	Shirak	...
17 Jul 96	Dinamo	Dinamo - KF Tirana 1996-07-17T20:00:00 Stadion Maksimir 4 - 0	KF Tirana	...
17 Jul 96	B71 Sandoy	B71 Sandoy - APOEL 1996-07-17T20:00:00 No disponible 1 - 5	APOEL	...
17 Jul 96	Sliema	Sliema - Margveti 1996-07-17T20:00:00 No disponible 1 - 3	Margveti	...
17 Jul 96	Newtown	Newtown - Skonto Riga 1996-07-17T20:00:00 No disponible 1 - 4	Skonto Riga	...
17 Jul 96	Dinamo	Dinamo - Grevenmache 1996-07-17T20:00:00 Boris Paichadze Dinamo Arena 4 - 0	Grevenmache	...
17 Jul 96	Portadown	Portadown - Vojvodina 1996-07-17T21:00:00 Shamrock Park 0 - 1	Vojvodina	...
17 Jul 96	Bohemian	Bohemian - Dinamo 1996-07-17T21:00:00 Dalymount Park 1 - 1	Dinamo	...
17 Jul 96	Akranes	Akranes - Sileks 1996-07-17T22:00:00 No disponible 2 - 0	Sileks	...
18 Jul 96	Barry Town	Barry Town - Dinaburg 1996-07-18T20:30:00 No disponible 0 - 0	Dinaburg	...
18 Jul 96	Patrick's	Patrick's - Slovan 1996-07-18T20:45:00 Richmond Park 3 - 4	Slovan	...
23 Jul 96	Dinaburg	Dinaburg - Barry Town 1996-07-23T17:00:00 No disponible 1 - 2	Barry Town	...
23 Jul 96	Grevenmache	Grevenmache - Dinamo 1996-07-23T19:30:00 Stade op Flohr 2 - 2	Dinamo	...
24 Jul 96	Khazri	Khazri - Hutnik 1996-07-24T15:00:00 No disponible 2 - 2	Hutnik	...
24 Jul 96	Margveti	Margveti - Sliema 1996-07-24T15:45:00 No disponible 0 - 3	Sliema	...
24 Jul 96	Shirak	Shirak - Anorthosis 1996-07-24T16:00:00 Gyumri 2 - 2	Anorthosis	...
24 Jul 96	Kosice	Kosice - Teuta 1996-07-24T17:00:00 Štadión Lokomotívy v Čermeli 2 - 1	Teuta	...
24 Jul 96	Dinamo	Dinamo - Bohemian 1996-07-24T17:00:00 Stadyen Dynama 0 - 0	Bohemian	...
24 Jul 96	FC Flora	FC Flora - FC Haka 1996-07-24T17:00:00 A. Le Coq Arena 0 - 1	FC Haka	...
24 Jul 96	Tiligul	Tiligul - Dinamo 93 1996-07-24T17:00:00 No disponible 1 - 1	Dinamo 93	...
24 Jul 96	Sileks	Sileks - Akranes 1996-07-24T17:00:00 Gradski Kratovo 1 - 0	Akranes	...
24 Jul 96	KF Tirana	KF Tirana - Dinamo 1996-07-24T17:30:00 Selman Stermasi 2 - 6	Dinamo	...
24 Jul 96	Helsinki	Helsinki - Pyunik 1996-07-24T17:30:00 Sonera Stadium 5 - 2	Pyunik	...
24 Jul 96	Inkaras	Inkaras - Slavia 1996-07-24T17:30:00 No disponible 1 - 1	Slavia	...
24 Jul 96	Mura 05	Mura 05 - FK Becej 1996-07-24T17:30:00 Fazanerija 2 - 0	FK Becej	...
24 Jul 96	Skonto Riga	Skonto Riga - Newtown 1996-07-24T17:30:00 Estadio Skonto 3 - 0	Newtown	...
24 Jul 96	Vojvodina	Vojvodina - Portadown 1996-07-24T17:30:00 Stadion Karadjordje 4 - 1	Portadown	...
24 Jul 96	Floriana	Floriana - Beitar 1996-07-24T18:00:00 Independence Arena, Florina 1 - 5	Beitar	...
24 Jul 96	Lokomotiv	Lokomotiv - Neftçi 1996-07-24T18:30:00 Stadion Lokomotiv 6 - 0	Neftçi	...
24 Jul 96	APOEL	APOEL - B71 Sandoy 1996-07-24T19:00:00 GSP Stadium 4 - 2	B71 Sandoy	...
24 Jul 96	Legia	Legia - Jeunesse 1996-07-24T19:00:00 Stadion Wojska Polskiego 3 - 0	Jeunesse	...
24 Jul 96	Partizan	Partizan - Maccabi 1996-07-24T19:00:00 Stadion Partizana 3 - 1	Maccabi	...
24 Jul 96	Slovan	Slovan - Patrick's 1996-07-24T19:00:00 Štadión Tehelné pole 1 - 0	Patrick's	...
24 Jul 96	Vardar	Vardar - ND Gorica 1996-07-24T20:00:00 Nacionalna Arena Filip II Makedonski 2 - 1	ND Gorica	...
24 Jul 96	Hajduk	Hajduk - Zimbru 1996-07-24T20:00:00 Estadio Poljud Split 2 - 1	Zimbru	...
24 Jul 96	GÍ Gøta	GÍ Gøta - Jazz Pori 1996-07-24T20:00:00 No disponible 0 - 1	Jazz Pori	...
24 Jul 96	Vestmannaey	Vestmannaey - Lantana 1996-07-24T20:00:00 No disponible 0 - 0	Lantana	...
24 Jul 96	Crusaders	Crusaders - Zalgiris 1996-07-24T20:30:00 Seaview 2 - 1	Zalgiris	...

06 Ago 96	Kosice	Kosice - Celtic 1996-08-06T17:00:00 Štadión Lokomotívy v Čermeli 0 - 0	Celtic	...
06 Ago 96	Rapid	Rapid - Lokomotiv 1996-08-06T17:00:00 Giulesti-Valentin Stanescu 1 - 0	Lokomotiv	...
06 Ago 96	Dinamo	Dinamo - Molde FK 1996-08-06T17:00:00 Boris Paichadze Dinamo Arena 2 - 1	Molde FK	...
06 Ago 96	Sigma	Sigma - Hutnik 1996-08-06T17:00:00 Andrův stadion 1 - 0	Hutnik	1
06 Ago 96	Slavia	Slavia - Tirol 1996-08-06T17:00:00 Stadion Slavija 1 - 1	Tirol	...
06 Ago 96	Beitar	Beitar - Bodo Glimt 1996-08-06T17:00:00 Teddi Malcha Stadium 1 - 5	Bodo Glimt	...
06 Ago 96	Dinamo	Dinamo - Jazz Pori 1996-08-06T17:30:00 Estadio Lev Yashin 1 - 1	Jazz Pori	...
06 Ago 96	Zalgiris	Zalgiris - Aberdeen 1996-08-06T17:30:00 Vilniaus LFF stadionas 1 - 4	Aberdeen	...
06 Ago 96	Helsinki	Helsinki - Chornomoret 1996-08-06T17:30:00 Sonera Stadium 2 - 2	Chornomoret	...
06 Ago 96	Skonto Riga	Skonto Riga - Malmö FF 1996-08-06T17:30:00 Estadio Skonto 0 - 3	Malmö FF	...
06 Ago 96	Dinamo	Dinamo - Beşiktaş 1996-08-06T18:15:00 Stadyen Dynama 2 - 1	Beşiktaş	...
06 Ago 96	Partizan	Partizan - Progresul 1996-08-06T18:30:00 Stadion Partizana 0 - 0	Progresul	...
06 Ago 96	Halmstads	Halmstads - Vardar 1996-08-06T18:30:00 Örjans Vall 0 - 0	Vardar	...
06 Ago 96	Legia	Legia - FC Haka 1996-08-06T19:00:00 Stadion Wojska Polskiego 3 - 0	FC Haka	...
06 Ago 96	Lyngby BK	Lyngby BK - Mura 05 1996-08-06T19:00:00 Lyngby Stadion 0 - 0	Mura 05	...
06 Ago 96	Helsingborg	Helsingborg - Dinamo 93 1996-08-06T19:00:00 Olympia 1 - 1	Dinamo 93	...
06 Ago 96	Anorthosis	Anorthosis - Neuchâtel 1996-08-06T19:00:00 Antonis Papadopoulos 1 - 2	Neuchâtel	...
06 Ago 96	Budapest	Budapest - Barry Town 1996-08-06T19:30:00 No disponible 3 - 1	Barry Town	...
06 Ago 96	Sliema	Sliema - Odense BK 1996-08-06T20:00:00 No disponible 0 - 2	Odense BK	...
06 Ago 96	Iraklis	Iraklis - APOEL 1996-08-06T20:00:00 Kaftanzoglio Stadio 0 - 1	APOEL	...
06 Ago 96	Dinamo	Dinamo - Spartak 1996-08-06T20:00:00 Stadion Maksimir 3 - 1	Spartak	...
06 Ago 96	Hajduk	Hajduk - Torpedo 1996-08-06T20:00:00 Estadio Poljud Split 1 - 0	Torpedo	...
06 Ago 96	Aarau	Aarau - Lantana 1996-08-06T20:00:00 Stadion Brügglifeld 4 - 0	Lantana	...
06 Ago 96	Grazer AK	Grazer AK - Vojvodina 1996-08-06T20:30:00 Merkur Arena 2 - 0	Vojvodina	...
06 Ago 96	Slovan	Slovan - Trabzonspor 1996-08-06T20:30:00 Štadión Tehelné pole 2 - 1	Trabzonspor	...
06 Ago 96	Akranes	Akranes - CSKA Moskva 1996-08-06T21:00:00 No disponible 0 - 2	CSKA Moskva	...
20 Ago 96	CSKA Moskva	CSKA Moskva - Akranes 1996-08-20T12:00:00 Arena CSKA 4 - 1	Akranes	...
20 Ago 96	Torpedo	Torpedo - Hajduk 1996-08-20T14:30:00 No disponible 2 - 0	Hajduk	...
20 Ago 96	FC Haka	FC Haka - Legia 1996-08-20T16:00:00 Tehtaankenttä 1 - 1	Legia	...
20 Ago 96	Progresul	Progresul - Partizan 1996-08-20T16:00:00 No disponible 1 - 0	Partizan	...
20 Ago 96	Hutnik	Hutnik - Sigma 1996-08-20T16:30:00 No disponible 3 - 1	Sigma	...
20 Ago 96	Jazz Pori	Jazz Pori - Dinamo 1996-08-20T16:30:00 No disponible 1 - 3	Dinamo	...
20 Ago 96	Spartak	Spartak - Dinamo 1996-08-20T17:00:00 Otkrytie Arena 2 - 0	Dinamo	...
20 Ago 96	Mura 05	Mura 05 - Lyngby BK 1996-08-20T17:00:00 Fazanerija 0 - 2	Lyngby BK	...
20 Ago 96	Lantana	Lantana - Aarau 1996-08-20T17:00:00 No disponible 2 - 0	Aarau	...
20 Ago 96	Trabzonspor	Trabzonspor - Slovan 1996-08-20T17:30:00 Akyazı Medical Park 4 - 1	Slovan	...
20 Ago 96	Lokomotiv	Lokomotiv - Rapid 1996-08-20T18:00:00 Stadion Lokomotiv 0 - 1	Rapid	...
20 Ago 96	Molde FK	Molde FK - Dinamo 1996-08-20T18:00:00 Aker Stadion 0 - 0	Dinamo	...
20 Ago 96	Vardar	Vardar - Halmstads 1996-08-20T18:00:00 Nacionalna Arena Filip II Makedonski 0 - 1	Halmstads	...
20 Ago 96	Chornomoret	Chornomoret - Helsinki 1996-08-20T18:00:00 Stadion Chornomorets 2 - 0	Helsinki	...
20 Ago 96	Bodo Glimt	Bodo Glimt - Beitar 1996-08-20T18:00:00 Aspmyra 2 - 1	Beitar	...
20 Ago 96	Dinamo 93	Dinamo 93 - Helsingborg 1996-08-20T18:30:00 No disponible 0 - 3	Helsingborg	...
20 Ago 96	Malmö FF	Malmö FF - Skonto Riga 1996-08-20T19:00:00 Swedbank Stadion 1 - 1	Skonto Riga	...
20 Ago 96	APOEL	APOEL - Iraklis 1996-08-20T19:30:00 GSP Stadium 2 - 1	Iraklis	...
20 Ago 96	Beşiktaş	Beşiktaş - Dinamo 1996-08-20T19:30:00 Vodafone Arena 2 - 0	Dinamo	...
20 Ago 96	Vojvodina	Vojvodina - Grazer AK 1996-08-20T19:30:00 Stadion Karadjordje 1 - 5	Grazer AK	...
20 Ago 96	Odense BK	Odense BK - Sliema 1996-08-20T20:00:00 Nature Energy Park 7 - 1	Sliema	...
20 Ago 96	Neuchâtel	Neuchâtel - Anorthosis 1996-08-20T20:00:00 No disponible 4 - 0	Anorthosis	...
20 Ago 96	Aberdeen	Aberdeen - Zalgiris 1996-08-20T20:30:00 Pittodrie Stadium 1 - 3	Zalgiris	...
20 Ago 96	Barry Town	Barry Town - Budapest 1996-08-20T20:30:00 No disponible 3 - 1	Budapest	...
20 Ago 96	Tirol	Tirol - Slavia 1996-08-20T20:30:00 No disponible 4 - 1	Slavia	...
20 Ago 96	Celtic	Celtic - Kosice 1996-08-20T20:45:00 Celtic Park 1 - 0	Kosice	...