4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
25 Ago 00 Rot-Weiss ErfurtRot-Weiss 0 - 2 UlmUlm ...
25 Ago 00 VfL OsnabrückOsnabrück 0 - 1 Hannover 96Hannover ...
25 Ago 00 SC Halberg BrebachHalberg 0 - 5 NürnbergNürnberg ...
25 Ago 00 B. Leverkusen IILeverkusen 1 - 2 FC St PauliPauli ...
25 Ago 00 Karlsruher SCKarlsruher 2 - 1 ChemnitzerChemnitzer ...
25 Ago 00 BSV Kickers EmdenKickers 0 - 1 Mainz 05Mainz 05 ...
25 Ago 00 Tennis BorussiaTennis 1 - 3 Arminia BielefeldArminia ...
26 Ago 00 DassendorfDassendorf 0 - 5 UnterhachingUnterhachin ...
26 Ago 00 ReutlingenReutlingen 2 - 3 Hertha BSCHertha BSC ...
26 Ago 00 Karlsruher SC IIKarlsruher 0 - 2 Alemannia AachenAlemannia ...
26 Ago 00 SV Babelsberg 03Babelsberg 1 - 6 VfL BochumVfL Bochum ...
26 Ago 00 Werder Bremen IIWerder 0 - 1 WolfsburgWolfsburg ...
26 Ago 00 Wuppertaler SVWuppertaler 1 - 3 StuttgartStuttgart ...
26 Ago 00 SchönbergSchönberg 0 - 4 Bayern MünchenBayern ...
26 Ago 00 Tennis Borussia IITennis 0 - 2 Werder BremenWerder ...
26 Ago 00 IsmaningIsmaning 0 - 4 B. DortmundDortmund ...
26 Ago 00 Stuttgart IIStuttgart 6 - 1 Eintracht FrankfurtEintracht ...
26 Ago 00 1. FC SaarbrückenSaarbrücke 0 - 1 Greuther FürthGreuther ...
26 Ago 00 Rot Weiss AhlenWeiss Ahlen 1 - 2 B. MönchengladbachMönchengla ...
26 Ago 00 Union BerlinUnion 2 - 0 Rot-Weiß OberhausenRot-Weiß ...
26 Ago 00 FC TeningenTeningen 0 - 3 MSV DuisburgDuisburg ...
26 Ago 00 Wehen WiesbadenWehen 2 - 1 Stuttgarter KickersStuttgarter ...
27 Ago 00 Rain / LechRain Lech 0 - 7 Schalke 04Schalke 04 ...
27 Ago 00 MagdeburgMagdeburg 5 - 2 KölnKöln ...
27 Ago 00 VfB LübeckLübeck 2 - 2 Waldhof MannheimWaldhof ...
27 Ago 00 Hamm / SiegHamm Sieg 0 - 6 Energie CottbusEnergie ...
27 Ago 00 PaderbornPaderborn 1 - 2 Hansa RostockHansa ...
27 Ago 00 PfullendorfPfullendorf 1 - 3 SC FreiburgFreiburg ...
27 Ago 00 Erzgebirge AueErzgebirge 0 - 3 Hamburger SVHamburger ...
27 Ago 00 PfeddersheimPfeddershei 0 - 7 1860 München1860 ...
27 Ago 00 Fortuna KölnFortuna 0 - 4 B. LeverkusenLeverkusen ...
28 Ago 00 Kickers Offenbach FCKickers 0 - 4 KaiserslauternKaiserslaut ...
Ver jornada
Jornada 2
31 Oct 00 SC FreiburgFreiburg 1 - 0 Werder BremenWerder ...
31 Oct 00 Arminia BielefeldArminia 0 - 4 VfL BochumVfL Bochum ...
31 Oct 00 Alemannia AachenAlemannia 1 - 2 B. LeverkusenLeverkusen ...
31 Oct 00 Wehen WiesbadenWehen 0 - 1 B. DortmundDortmund ...
31 Oct 00 Karlsruher SCKarlsruher 1 - 0 Hamburger SVHamburger ...
31 Oct 00 NürnbergNürnberg 4 - 0 Mainz 05Mainz 05 ...
01 Nov 00 Union BerlinUnion 1 - 0 Greuther FürthGreuther ...
01 Nov 00 Stuttgart IIStuttgart 0 - 3 StuttgartStuttgart ...
01 Nov 00 Hannover 96Hannover 2 - 1 Hansa RostockHansa ...
01 Nov 00 B. MönchengladbachMönchengla 5 - 1 KaiserslauternKaiserslaut ...
01 Nov 00 UlmUlm 2 - 0 Energie CottbusEnergie ...
01 Nov 00 VfB LübeckLübeck 1 - 1 MSV DuisburgDuisburg ...
01 Nov 00 UnterhachingUnterhachin 1 - 2 1860 München1860 ...
01 Nov 00 WolfsburgWolfsburg 3 - 1 Hertha BSCHertha BSC ...
01 Nov 00 FC St PauliPauli 1 - 3 Schalke 04Schalke 04 ...
01 Nov 00 MagdeburgMagdeburg 1 - 1 Bayern MünchenBayern ...
Ver jornada
Jornada 3
28 Nov 00 Union BerlinUnion 4 - 2 UlmUlm ...
28 Nov 00 WolfsburgWolfsburg 1 - 1 MSV DuisburgDuisburg ...
28 Nov 00 MagdeburgMagdeburg 5 - 3 Karlsruher SCKarlsruher ...
29 Nov 00 SC FreiburgFreiburg 3 - 2 B. LeverkusenLeverkusen ...
29 Nov 00 1860 München1860 0 - 5 VfL BochumVfL Bochum ...
29 Nov 00 StuttgartStuttgart 2 - 1 Hannover 96Hannover ...
29 Nov 00 B. MönchengladbachMönchengla 1 - 0 NürnbergNürnberg ...
29 Nov 00 Schalke 04Schalke 04 2 - 1 B. DortmundDortmund ...
Ver jornada
Jornada 4
20 Dic 00 StuttgartStuttgart 2 - 1 SC FreiburgFreiburg ...
20 Dic 00 Union BerlinUnion 1 - 0 VfL BochumVfL Bochum ...
20 Dic 00 MSV DuisburgDuisburg 0 - 1 B. MönchengladbachMönchengla ...
20 Dic 00 MagdeburgMagdeburg 0 - 1 Schalke 04Schalke 04 ...
Ver jornada
Jornada 5
06 Feb 01 Union BerlinUnion 2 - 2 B. MönchengladbachMönchengla ...
07 Feb 01 StuttgartStuttgart 0 - 3 Schalke 04Schalke 04 ...
Ver jornada
Jornada 6
26 May 01 Union BerlinUnion 0 - 2 Schalke 04Schalke 04 ...

  USO DE MEMORIA  
4,732,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4701
Total Execution Time  0.4721
  CADENA URL  
/dfb_pokal2001/grupo0/calendario
  GET DATOS  
$_GET['/dfb_pokal2001/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0148  SELECT type FROM routes WHERE alias = 'dfb_pokal2001'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'dfb_pokal' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=140 AND type_rel = 3
0.0158  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 140 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0152  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 (1310601,1309252,1309022,1308925,1305952) ORDER BY n.cover_points DESC, update_date DESC
0.0148  SELECT id,name,alias,stepParent FROM categories WHERE parentId=140 ORDER BY order_id ASC
0.0161  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 = 16407 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0172  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 calendars2001 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 16407 ORDER BY round ASC
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 22:27:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 22:27:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 22:27:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 22:27:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0152  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 140 AND l.year = 2001
0.0176  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (16407) 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.0154  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 (16407) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (266323,2032,2201,4323,266306,459371,2025,2200,259677,266420) ORDER BY rp.in_squad = 1 DESC
0.0156  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 140 AND l.year = 2001
0.0193  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (16407) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0163  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 (16407) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (266362,266376,1964,2201,2204,4621,5110,7765,50964,58880) ORDER BY rp.in_squad = 1 DESC
0.0156  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 140 AND l.year = 2001
0.0200  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (16407) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0166  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 (16407) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (2204,5110,7765,20544,50964,266451,266685,266710,558360,558399) ORDER BY rp.in_squad = 1 DESC