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 2012

Temporada Siguiente »

2011/2012

Segunda Ronda

Eliminatoria

Fase Previa Europa League 2012 G 2

Fase Previa Europa League

Europa League:

Ver jornada

Jornada 1

Equipos de esta liga

USO DE MEMORIA

4,866,192 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.0884
Total Execution Time	0.0905

CADENA URL

/previa_europa_league2012/grupo2/calendario

GET DATOS

$_GET['/previa_europa_league2012/grupo2/calendario']

POST DATOS

No hay datos POST existentes

CONSULTAS (18)

0.0018	SELECT type FROM routes WHERE alias = 'previa_europa_league2012'
0.0038	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 = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 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 = 42900 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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 calendars2012 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 42900 ORDER BY round ASC
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 07:28:44' 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-04-28 07:28:44' 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=4 AND last_update > '2024-04-28 07:28:44' 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-04-28 07:28:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023	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 = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0023	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 2012
0.0033	SELECT e.action, count(e.action) as total, e.player_id FROM events2012 e WHERE e.league_id IN (42900,42899,42901,42902) 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.0024	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 (42900,42899,42901,42902) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (24145,17978,491094,21666,155793,217820,10509,21491,29813,139245) ORDER BY rp.in_squad = 1 DESC
0.0022	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 2012
0.0035	SELECT e.action, count(e.action) as total, e.player_id FROM events2012 e WHERE e.league_id IN (42900,42899,42901,42902) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0024	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 (42900,42899,42901,42902) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (33505,76539,153964,210023,5378,14199,21053,23165,27054,42251) ORDER BY rp.in_squad = 1 DESC
0.0022	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 2012
0.0021	SELECT e.action, count(e.action) as total, e.player_id FROM events2012 e WHERE e.league_id IN (42900,42899,42901,42902) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0023	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 (42900,42899,42901,42902) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (210023,1408,1955,3050,3262,4594,14199,21053,23165,27054) 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

14 Jul 11	Shakhter	Shakhter - Patrick's 2011-07-14T15:00:00 Stadion Shakhter 2 - 1	Patrick's	...
21 Jul 11	Patrick's	Patrick's - Shakhter 2011-07-21T20:45:00 Richmond Park 2 - 0	Shakhter	...
14 Jul 11	FC Rustavi	FC Rustavi - Irtysh 2011-07-14T16:00:00 Poladi Stadium 1 - 1	Irtysh	...
21 Jul 11	Irtysh	Irtysh - FC Rustavi 2011-07-21T15:00:00 No disponible 0 - 2	FC Rustavi	...
14 Jul 11	Śląsk	Śląsk - Dundee 2011-07-14T16:45:00 Stadion Miejski 1 - 0	Dundee	...
21 Jul 11	Dundee	Dundee - Śląsk 2011-07-21T20:45:00 Tannadice Park 3 - 2	Śląsk	...
14 Jul 11	Beograd	Beograd - Olympiakos 2011-07-14T17:00:00 Stadion FK Rad 0 - 1	Olympiakos	...
21 Jul 11	Olympiakos	Olympiakos - Beograd 2011-07-21T20:00:00 Panthessaliko Stadio 1 - 1	Beograd	...
14 Jul 11	KuPS Kuopio	KuPS Kuopio - Gaz Metan 2011-07-14T17:30:00 Savon Sanomat Areena 1 - 0	Gaz Metan	...
21 Jul 11	Gaz Metan	Gaz Metan - KuPS Kuopio 2011-07-21T17:00:00 Gaz Metan 2 - 0	KuPS Kuopio	...
14 Jul 11	Flamurtari	Flamurtari - Jablonec 2011-07-14T17:30:00 Stadiumi Flamurtari 0 - 2	Jablonec	...
21 Jul 11	Jablonec	Jablonec - Flamurtari 2011-07-21T20:00:00 Chance Aréna 5 - 1	Flamurtari	...
14 Jul 11	Iskra	Iskra - Varazdin 2011-07-14T18:00:00 No disponible 1 - 1	Varazdin	...
21 Jul 11	Varazdin	Varazdin - Iskra 2011-07-21T19:00:00 Stadion Anđelko Herjavec 3 - 1	Iskra	...
14 Jul 11	Tauras	Tauras - Haag 2011-07-14T18:00:00 No disponible 2 - 3	Haag	...
21 Jul 11	Haag	Haag - Tauras 2011-07-21T20:00:00 Kyocera Stadion 2 - 0	Tauras	...
14 Jul 11	TPS	TPS - Westerlo 2011-07-14T18:00:00 Veritas 0 - 1	Westerlo	...
21 Jul 11	Westerlo	Westerlo - TPS 2011-07-21T20:00:00 Het Kuipje 0 - 0	TPS	...
14 Jul 11	Rudar	Rudar - Austria 2011-07-14T18:00:00 Ob jezeru 0 - 3	Austria	...
21 Jul 11	Austria	Austria - Rudar 2011-07-21T21:05:00 Generali Arena 2 - 0	Rudar	...
14 Jul 11	Sant Julià	Sant Julià - Bnei Yehuda 2011-07-14T18:30:00 Estadi Comunal de Aixovall 0 - 2	Bnei Yehuda	...
21 Jul 11	Bnei Yehuda	Bnei Yehuda - Sant Julià 2011-07-21T19:00:00 HaMoshava Stadium 2 - 0	Sant Julià	...
14 Jul 11	Valerenga	Valerenga - Mika 2011-07-14T19:00:00 Ulleval Stadion 1 - 0	Mika	...
21 Jul 11	Mika	Mika - Valerenga 2011-07-21T15:00:00 No disponible 0 - 1	Valerenga	...
14 Jul 11	Shakhtyor	Shakhtyor - Ventspils 2011-07-14T19:00:00 Stadyen Budaŭnik 0 - 1	Ventspils	...
21 Jul 11	Ventspils	Ventspils - Shakhtyor 2011-07-21T17:30:00 Ventspils Olimpiskais Stadions 3 - 2	Shakhtyor	...
14 Jul 11	Häcken	Häcken - FC Honka 2011-07-14T19:00:00 Rambergsvallen 1 - 0	FC Honka	...
21 Jul 11	FC Honka	FC Honka - Häcken 2011-07-21T18:00:00 Tapiolan Urheilupuisto 0 - 2	Häcken	...
14 Jul 11	Orebro SK	Orebro SK - Sarajevo 2011-07-14T19:00:00 Behrn Arena 0 - 0	Sarajevo	...
21 Jul 11	Sarajevo	Sarajevo - Orebro SK 2011-07-21T19:00:00 Olimpijski Stadion Asim Ferhatović Hase 2 - 0	Orebro SK	...
14 Jul 11	Ferencváro	Ferencváro - Aalesunds 2011-07-14T19:00:00 Puskás Ferenc Stadion 2 - 1	Aalesunds	...
21 Jul 11	Aalesunds	Aalesunds - Ferencváro 2011-07-21T19:00:00 Color Line Stadion 3 - 1	Ferencváro	...
14 Jul 11	Anorthosis	Anorthosis - Gagra 2011-07-14T19:00:00 Antonis Papadopoulos 3 - 0	Gagra	...
21 Jul 11	Gagra	Gagra - Anorthosis 2011-07-21T19:00:00 No disponible 2 - 0	Anorthosis	...
14 Jul 11	Dinamo	Dinamo - Gaziantepsp 2011-07-14T19:00:00 Stadyen Dynama 1 - 1	Gaziantepsp	...
21 Jul 11	Gaziantepsp	Gaziantepsp - Dinamo 2011-07-21T20:00:00 Kamil Ocak Stadyumu 4 - 1	Dinamo	...
14 Jul 11	Maccabi	Maccabi - Khazar 2011-07-14T19:30:00 Bloomfield Stadium 3 - 1	Khazar	...
21 Jul 11	Khazar	Khazar - Maccabi 2011-07-21T17:30:00 Xəzər Lənkəran Mərkəzi stadionu 0 - 0	Maccabi	...
14 Jul 11	Floriana	Floriana - Larnaca 2011-07-14T19:30:00 Independence Arena, Florina 0 - 8	Larnaca	...
21 Jul 11	Larnaca	Larnaca - Floriana 2011-07-21T19:00:00 Neo GSZ Stadium 1 - 0	Floriana	...
14 Jul 11	Llanelli	Llanelli - Dinamo 2011-07-14T19:50:00 No disponible 2 - 1	Dinamo	...
21 Jul 11	Dinamo	Dinamo - Llanelli 2011-07-21T19:00:00 Boris Paichadze Dinamo Arena 5 - 0	Llanelli	...
14 Jul 11	FC Vaduz	FC Vaduz - Vojvodina 2011-07-14T20:00:00 Rheinpark Stadion 0 - 2	Vojvodina	...
21 Jul 11	Vojvodina	Vojvodina - FC Vaduz 2011-07-21T17:00:00 Stadion Karadjordje 1 - 3	FC Vaduz	...
14 Jul 11	Differdange	Differdange - Levadia 2011-07-14T20:00:00 Stade Parc des Sports 0 - 0	Levadia	...
21 Jul 11	Levadia	Levadia - Differdange 2011-07-21T17:45:00 Kadrioru Staadion 0 - 1	Differdange	...
14 Jul 11	Sūduva	Sūduva - Elfsborg 2011-07-14T20:00:00 Marijampoles sporto centro stadione 1 - 1	Elfsborg	...
21 Jul 11	Elfsborg	Elfsborg - Sūduva 2011-07-21T18:00:00 Borås Arena 3 - 0	Sūduva	...
14 Jul 11	Streymur	Streymur - Qarabağ 2011-07-14T20:00:00 Við Margáir 1 - 1	Qarabağ	...
21 Jul 11	Qarabağ	Qarabağ - Streymur 2011-07-21T18:00:00 Tofiq Bəhramov adına Respublika stadionu 0 - 0	Streymur	...
14 Jul 11	KF Tirana	KF Tirana - Spartak 2011-07-14T20:00:00 Selman Stermasi 0 - 0	Spartak	...
21 Jul 11	Spartak	Spartak - KF Tirana 2011-07-21T19:00:00 Štadión Antona Malatinského 3 - 1	KF Tirana	...
14 Jul 11	Paksi SE	Paksi SE - Tromsø IL 2011-07-14T20:00:00 PSE Parks 1 - 1	Tromsø IL	...
21 Jul 11	Tromsø IL	Tromsø IL - Paksi SE 2011-07-21T19:00:00 Alfheim Stadion 0 - 3	Paksi SE	...
14 Jul 11	Saints	Saints - Midtjylland 2011-07-14T20:00:00 Park Hall Stadium 1 - 3	Midtjylland	...
21 Jul 11	Midtjylland	Midtjylland - Saints 2011-07-21T19:15:00 MCH Arena 5 - 2	Saints	...
14 Jul 11	Olimpija	Olimpija - Bohemian 2011-07-14T20:00:00 Stožice Stadium 2 - 0	Bohemian	...
21 Jul 11	Bohemian	Bohemian - Olimpija 2011-07-21T20:45:00 Dalymount Park 1 - 1	Olimpija	...
14 Jul 11	Kecskemét	Kecskemét - FC Aktobe 2011-07-14T20:15:00 Széktói Stadion 1 - 1	FC Aktobe	...
21 Jul 11	FC Aktobe	FC Aktobe - Kecskemét 2011-07-21T18:00:00 Aktobe Central Stadium 0 - 0	Kecskemét	...
14 Jul 11	Željeznica	Željeznica - Sheriff 2011-07-14T20:30:00 Stadion Grbavica 1 - 0	Sheriff	...
21 Jul 11	Sheriff	Sheriff - Željeznica 2011-07-21T18:00:00 Bolshaya Sportivnaya Arena 0 - 0	Željeznica	...
14 Jul 11	Liepājas	Liepājas - Salzburg 2011-07-14T20:30:00 No disponible 1 - 4	Salzburg	...
21 Jul 11	Salzburg	Salzburg - Liepājas 2011-07-21T19:00:00 Red Bull Arena 0 - 0	Liepājas	...
14 Jul 11	Vllaznia	Vllaznia - Thun 2011-07-14T20:30:00 Loro Boriçi Stadium 0 - 0	Thun	...
21 Jul 11	Thun	Thun - Vllaznia 2011-07-21T19:30:00 Stockhorn Arena 2 - 1	Vllaznia	...
14 Jul 11	Juvenes	Juvenes - Rabotnički 2011-07-14T20:30:00 Stadio Olimpico Serravalle 0 - 1	Rabotnički	...
21 Jul 11	Rabotnički	Rabotnički - Juvenes 2011-07-21T20:00:00 Nacionalna Arena Filip II Makedonski 3 - 0	Juvenes	...
14 Jul 11	Glentoran	Glentoran - Vorskla 2011-07-14T20:45:00 The Oval 0 - 2	Vorskla	...
21 Jul 11	Vorskla	Vorskla - Glentoran 2011-07-21T19:00:00 Stadion Vorskla im. Oleksiya Butov'skogo 3 - 0	Glentoran	...
14 Jul 11	Metalurg	Metalurg - Lokomotiv 2011-07-14T20:45:00 Trening centar Petar Miloševski 0 - 0	Lokomotiv	...
21 Jul 11	Lokomotiv	Lokomotiv - Metalurg 2011-07-21T19:30:00 Stadion Lokomotiv 3 - 2	Metalurg	...
14 Jul 11	Crusaders	Crusaders - Fulham 2011-07-14T20:45:00 Seaview 1 - 3	Fulham	...
21 Jul 11	Fulham	Fulham - Crusaders 2011-07-21T20:30:00 Craven Cottage 4 - 0	Crusaders	...
14 Jul 11	Domžale	Domžale - Split 2011-07-14T20:45:00 Sports Park 1 - 2	Split	...
21 Jul 11	Split	Split - Domžale 2011-07-21T20:30:00 Stadion Park mladeži 3 - 1	Domžale	...
14 Jul 11	Reykjavík	Reykjavík - Žilina 2011-07-14T21:15:00 KR-Völlur 3 - 0	Žilina	...
21 Jul 11	Žilina	Žilina - Reykjavík 2011-07-21T19:30:00 Štadión Pod Dubňom 2 - 0	Reykjavík	...
14 Jul 11	Hafnarfjord	Hafnarfjord - Nacional 2011-07-14T21:15:00 Kaplakrikavöllur 1 - 1	Nacional	...
21 Jul 11	Nacional	Nacional - Hafnarfjord 2011-07-21T20:45:00 Estádio da Madeira 2 - 0	Hafnarfjord	...