4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver equipo
Ferencvárosi Ferencváros
Datos equipo
Nombre Ferencvárosi
Nombre completo Ferencvárosi Torna Club
Nombre corto FTC
País
Año fundación 1899
Estadio
Nombre estadio Puskás Ferenc Stadion
Capacidad estadio 56000
Año construcción 1953
Tipo césped Natural
Internet
Sitio web http://www.FTC.hu
Twitter del equipo @Fradi_HU
Información
Dirección 1091 Budapest; Üllői út 129.
Teléfono +36 (1) 215 6023
Fax +36 (1) 215 3698
Ver equipo
MTK Budapest Budapest
Datos equipo
Nombre MTK Budapest
Nombre completo MTK Hungária FC
Nombre corto MTK
País
Año fundación 1888
Estadio
Nombre estadio Hidegkuti Nándor Stadion
Capacidad estadio 12700
Año construcción 1912
Tipo césped Natural
Internet
Sitio web http://mtkbudapest.hu/
Twitter del equipo @MTK_Labdarugas
Información
Dirección Salgótarjáni út 12-14., VIII. ker.

Equipos de esta liga

2

  USO DE MEMORIA  
4,218,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3519
Total Execution Time  0.3539
  CADENA URL  
/super_copa_hungria2003/grupo0/equipos
  GET DATOS  
$_GET['/super_copa_hungria2003/grupo0/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0144  SELECT type FROM routes WHERE alias = 'super_copa_hungria2003'
0.0292  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_copa_hungria' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1679 AND type_rel = 3
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1679 ORDER BY order_id ASC
0.0145  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 = 26207 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  SELECT t.id,t.teamId,t.total_players,dt.* FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 26207 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 14:26:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 14:26:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 14:26:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 14:26:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1679 AND l.year = 2003
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (26207) 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.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1679 AND l.year = 2003
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (26207) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0147  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1679 AND l.year = 2003
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (26207) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10