4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver equipo
Rapid Wien Rapid Wien
Datos equipo
Nombre Rapid Wien
Nombre completo SK Rapid Wien
Nombre corto RAP
País
Año fundación 1899
Estadio
Nombre estadio Allianz Stadion
Capacidad estadio 28345
Año construcción 2016
Tipo césped Natural
Dimensiones campo 105x68
Internet
Sitio web http://www.skrapid.at/
Twitter del equipo @skrapid
Información
Dirección Allianz-Stadion Gerhard-Hanappi-Platz 1 1140 Wien, Austria
Teléfono +43 1 727430
Fax +43 (1) 9111906
Otros datos
Socios 16205
Patrocinador Allianz
Marca de ropa Puma
Ver equipo
Swarovski Tirol Swarovski
Datos equipo
Nombre Swarovski Tirol
Nombre completo Swarovski Tirol
Nombre corto SWA
País

Equipos de esta liga

2

  USO DE MEMORIA  
4,217,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3007
Total Execution Time  0.3027
  CADENA URL  
/supercopa_austria1987/grupo0/equipos
  GET DATOS  
$_GET['/supercopa_austria1987/grupo0/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0125  SELECT type FROM routes WHERE alias = 'supercopa_austria1987'
0.0255  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa_austria' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1987 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2328 AND type_rel = 3
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2328 ORDER BY order_id ASC
0.0126  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 = 56370 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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 = 56370 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 12:13:23' 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-27 12:13:23' 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-27 12:13:23' 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-27 12:13:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2328 AND l.year = 1987
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1987 e WHERE e.league_id IN (56370) 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.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2328 AND l.year = 1987
0.0128  SELECT e.action, count(e.action) as total, e.player_id FROM events1987 e WHERE e.league_id IN (56370) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2328 AND l.year = 1987
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1987 e WHERE e.league_id IN (56370) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10