4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
17 Jul 08 Shakhter KaragandyShakhter 1 - 1 Debreceni VSCDebreceni ...
31 Jul 08 Debreceni VSCDebreceni 1 - 0 Shakhter KaragandyShakhter ...
17 Jul 08 Ararat YerevanArarat 0 - 1 AC BellinzonaBellinzona ...
31 Jul 08 AC BellinzonaBellinzona 3 - 1 Ararat YerevanArarat ...
17 Jul 08 Tobol KostanayTobol 1 - 0 Austria WienAustria ...
31 Jul 08 Austria WienAustria 2 - 0 Tobol KostanayTobol ...
17 Jul 08 Partizan MinskPartizan 2 - 2 ŽilinaŽilina ...
31 Jul 08 ŽilinaŽilina 1 - 0 Partizan MinskPartizan ...
17 Jul 08 JFK OlimpsJFK Olimps 0 - 1 St Patrick'sPatrick's ...
31 Jul 08 St Patrick'sPatrick's 2 - 0 JFK OlimpsJFK Olimps ...
17 Jul 08 FC TVMKFC TVMK 0 - 3 NordsjaellandNordsjaella ...
29 Jul 08 NordsjaellandNordsjaella 5 - 0 FC TVMKFC TVMK ...
17 Jul 08 FC HonkaFC Honka 3 - 0 ÍA AkranesAkranes ...
31 Jul 08 ÍA AkranesAkranes 2 - 1 FC HonkaFC Honka ...
17 Jul 08 Vojvodina Novi SadVojvodina 1 - 0 AZAL PFC BakuAZAL Baku ...
31 Jul 08 AZAL PFC BakuAZAL Baku 1 - 1 Vojvodina Novi SadVojvodina ...
17 Jul 08 Ironi Kiryat ShmonaIroni 1 - 1 MogrenMogren ...
31 Jul 08 MogrenMogren 0 - 3 Ironi Kiryat ShmonaIroni ...
17 Jul 08 VetraVetra 1 - 0 Víkingur ÓlafsvíkVíkingur ...
31 Jul 08 Víkingur ÓlafsvíkVíkingur 2 - 0 VetraVetra ...
17 Jul 08 PelisterPelister 0 - 0 APOELAPOEL ...
31 Jul 08 APOELAPOEL 1 - 0 PelisterPelister ...
17 Jul 08 SūduvaSūduva 1 - 0 The New SaintsSaints ...
31 Jul 08 The New SaintsSaints 0 - 1 SūduvaSūduva ...
17 Jul 08 Hapoel Tel AvivHapoel Aviv 3 - 0 Juvenes / DoganaJuvenes ...
31 Jul 08 Juvenes / DoganaJuvenes 0 - 2 Hapoel Tel AvivHapoel Aviv ...
17 Jul 08 Khazar LankaranKhazar 0 - 1 Lech PoznańLech 1
31 Jul 08 Lech PoznańLech 4 - 1 Khazar LankaranKhazar ...
17 Jul 08 Dacia ChişinăuDacia 1 - 1 Borac ČačakBorac ...
31 Jul 08 Borac ČačakBorac 3 - 1 Dacia ChişinăuDacia ...
17 Jul 08 Omonia NicosiaOmonia 2 - 0 FK Milano KumanovoMilano ...
31 Jul 08 FK Milano KumanovoMilano 1 - 2 Omonia NicosiaOmonia ...
17 Jul 08 Djurgårdens IFDjurgården 0 - 0 FC FloraFC Flora ...
31 Jul 08 FC FloraFC Flora 2 - 2 Djurgårdens IFDjurgården ...
17 Jul 08 Racing UnionRacing 0 - 3 Kalmar FFKalmar FF ...
31 Jul 08 Kalmar FFKalmar FF 7 - 1 Racing UnionRacing ...
17 Jul 08 Cherno More VarnaCherno More 4 - 0 Sant JuliàSant Julià ...
31 Jul 08 Sant JuliàSant Julià 0 - 5 Cherno More VarnaCherno More ...
17 Jul 08 Györi ETOGyöri ETO 1 - 1 ZestafoniZestafoni ...
31 Jul 08 ZestafoniZestafoni 1 - 2 Györi ETOGyöri ETO ...
17 Jul 08 Brøndby IFBrøndby 1 - 0 B36 TorshavnTorshavn ...
31 Jul 08 B36 TorshavnTorshavn 0 - 2 Brøndby IFBrøndby ...
17 Jul 08 Marsaxlokk FCMarsaxlokk 0 - 4 NK Slaven BelupoSlaven ...
31 Jul 08 NK Slaven BelupoSlaven 4 - 0 Marsaxlokk FCMarsaxlokk ...
17 Jul 08 FC VaduzFC Vaduz 1 - 2 ZrinjskiZrinjski ...
31 Jul 08 ZrinjskiZrinjski 3 - 0 FC VaduzFC Vaduz ...
17 Jul 08 EB / StreymurStreymur 0 - 2 Manchester CityManchester ...
31 Jul 08 Manchester CityManchester 2 - 0 EB / StreymurStreymur ...
17 Jul 08 Spartak TrnavaSpartak 2 - 2 WIT GeorgiaGeorgia ...
31 Jul 08 WIT GeorgiaGeorgia 1 - 0 Spartak TrnavaSpartak ...
17 Jul 08 Hertha BSCHertha BSC 8 - 1 Nistru OtaciNistru ...
31 Jul 08 Nistru OtaciNistru 0 - 0 Hertha BSCHertha BSC ...
17 Jul 08 Siroki BrijegSiroki 0 - 0 Partizani TiranaPartizani ...
31 Jul 08 Partizani TiranaPartizani 1 - 3 Siroki BrijegSiroki ...
17 Jul 08 SalzburgSalzburg 7 - 0 FC UrartuFC Urartu ...
31 Jul 08 FC UrartuFC Urartu 0 - 3 SalzburgSalzburg ...
17 Jul 08 Bangor CityBangor City 1 - 6 MidtjyllandMidtjylland ...
31 Jul 08 MidtjyllandMidtjylland 4 - 0 Bangor CityBangor City ...
17 Jul 08 FC KoperFC Koper 1 - 2 Vllaznia ShkodërVllaznia ...
31 Jul 08 Vllaznia ShkodërVllaznia 0 - 0 FC KoperFC Koper ...
17 Jul 08 ZetaZeta 1 - 1 NK Interblock LjubljanaInterblock ...
31 Jul 08 NK Interblock LjubljanaInterblock 1 - 0 ZetaZeta ...
17 Jul 08 GlentoranGlentoran 1 - 1 Liepājas MetalurgsLiepājas ...
31 Jul 08 Liepājas MetalurgsLiepājas 2 - 0 GlentoranGlentoran ...
17 Jul 08 Legia WarszawaLegia 0 - 0 GomelGomel ...
31 Jul 08 GomelGomel 1 - 4 Legia WarszawaLegia ...
17 Jul 08 Cork CityCork City 2 - 2 FC HakaFC Haka ...
31 Jul 08 FC HakaFC Haka 4 - 0 Cork CityCork City ...
17 Jul 08 CliftonvilleCliftonvill 0 - 4 KobenhavnKobenhavn ...
31 Jul 08 KobenhavnKobenhavn 7 - 0 CliftonvilleCliftonvill ...
17 Jul 08 HNK Hajduk SplitHajduk 4 - 0 BirkirkaraBirkirkara ...
31 Jul 08 BirkirkaraBirkirkara 0 - 3 HNK Hajduk SplitHajduk ...
17 Jul 08 FH HafnarfjordurHafnarfjord 3 - 2 GrevenmacherGrevenmache ...
31 Jul 08 GrevenmacherGrevenmache 1 - 5 FH HafnarfjordurHafnarfjord ...

  USO DE MEMORIA  
4,825,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0993
Total Execution Time  0.1012
  CADENA URL  
/previa_europa_league2009/grupo1/calendario
  GET DATOS  
$_GET['/previa_europa_league2009/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0018  SELECT type FROM routes WHERE alias = 'previa_europa_league2009'
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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  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 = 41765 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 calendars2009 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 41765 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 01:20:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 01:20:15' 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 01:20:15' 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 01:20:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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 = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 2009
0.0044  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (41765,41766) 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.0025  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 (41765,41766) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (5176,355252,2306,34212,76540,185043,211708,351523,2277,10136) ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 2009
0.0047  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (41765,41766) AND (e.action = 4 or e.action = 5) 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 (41765,41766) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (19637,450399,3425,7380,13817,14812,26943,33616,34481,44969) ORDER BY rp.in_squad = 1 DESC
0.0027  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 674 AND l.year = 2009
0.0062  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (41765,41766) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0025  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 (41765,41766) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (7380,19637,33616,34611,45123,47715,59121,75442,122439,153047) ORDER BY rp.in_squad = 1 DESC