4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver equipo
Ajax Ajax
Datos equipo
Nombre Ajax
Nombre completo Amsterdamsche Football Club Ajax
Nombre corto AJA
País
Año fundación 1900
Total plantilla 14
Presupuesto anual 31500000
Estadio
Nombre estadio Johan Cruyff Arena
Capacidad estadio 53052
Año construcción 1996
Tipo césped Natural
Dimensiones campo 105 x 69 metros
Internet
Sitio web http://www.ajax.nl/
Twitter del equipo @AFCAjax
Información
Dirección ArenA Boulevard 1
Teléfono +31-203111444
Fax +31-203111480
Otros datos
Patrocinador Ziggo
Equipo filial Jong Ajax
Marca de ropa Adidas
Ver equipo
PSV PSV
Datos equipo
Nombre PSV
Nombre completo Philips Sport Vereniging
Nombre corto PSV
País
Año fundación 1913
Total plantilla 14
Presupuesto anual 20000000
Estadio
Nombre estadio Philips Stadion
Capacidad estadio 35119
Año construcción 1913
Tipo césped Natural
Dimensiones campo 105x67 metros
Internet
Sitio web http://www.psv.nl/
Twitter del equipo @PSV
Información
Dirección Fredriklaan 10a 5616 NH Eindhoven
Teléfono +31 40 2505 505
Fax +31 40 2505 639
Otros datos
Socios 15000
Patrocinador Metropoolregio Eindhoven
Equipo filial Jong PSV
Marca de ropa Puma

Equipos de esta liga

2

  USO DE MEMORIA  
4,239,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.0872
Total Execution Time  0.0894
  CADENA URL  
/supercopa_holanda2003/grupo0/equipos
  GET DATOS  
$_GET['/supercopa_holanda2003/grupo0/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0021  SELECT type FROM routes WHERE alias = 'supercopa_holanda2003'
0.0053  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa_holanda' 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.0024  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=298 AND type_rel = 3
0.0032  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 298 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0032  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 (1271603,1168754,1168680,1167983,1028543) ORDER BY n.cover_points DESC, update_date DESC
0.0029  SELECT id,name,alias,stepParent FROM categories WHERE parentId=298 ORDER BY order_id ASC
0.0025  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 298 GROUP BY l.categoryId
0.0028  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=298 GROUP BY l.year ORDER BY l.year DESC
0.0028  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 = 25245 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0040  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 = 25245 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 17:11:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 17:11:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 17:11:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 17:11:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0036  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 298 AND l.year = 2003
0.0026  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (25245) 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.0030  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 (25245) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (2179,5708,27212) ORDER BY rp.in_squad = 1 DESC
0.0027  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 298 AND l.year = 2003
0.0026  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (25245) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0029  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 (25245) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (476,823,2066,5708,30091) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 298 AND l.year = 2003
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (25245) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10