4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
 
Temporada 1980
Temporada Siguiente »
Supercopa Grecia 1980
1979/1980

supercopa griega, copa de la amistad y la solidaridad

Supercopa Grecia 1980

Ver equipo
Olympiacos Piraeus Olympiacos
Datos equipo
Nombre Olympiacos Piraeus
Nombre completo Olympiacos Club of Fans of Piraeus F.C.
Nombre corto OLP
País
Año fundación 1925
Estadio
Nombre estadio Stadio Georgios Karaiskáki
Capacidad estadio 33296
Año construcción 2004
Tipo césped Natural
Internet
Sitio web https://www.olympiacos.org/es/
Twitter del equipo @olympiacosfc
Información
Dirección Poseidonos Avenue, Faliro
Teléfono +30 (210) 414 3000
Fax +30 (210) 414 3113
Otros datos
Patrocinador Stoiximan
Marca de ropa Adidas
Ver equipo
Kastoria Kastoria
Datos equipo
Nombre Kastoria
Nombre corto KAS
País
Año fundación 1963
Internet
Sitio web http://www.kastoria-fc.com/

Equipos de esta liga

2

  USO DE MEMORIA  
4,211,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0555
Total Execution Time  0.0576
  CADENA URL  
/supercopa_grecia1980/grupo0/equipos
  GET DATOS  
$_GET['/supercopa_grecia1980/grupo0/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0018  SELECT type FROM routes WHERE alias = 'supercopa_grecia1980'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa_grecia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1980 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1734 AND type_rel = 3
0.0020  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1734 ORDER BY order_id ASC
0.0020  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 = 23082 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 23082 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 22:51:59' 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=2 AND last_update > '2024-04-27 22:51:59' 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-27 22:51:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0017  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 22:51:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1734 AND l.year = 1980
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1980 e WHERE e.league_id IN (23082) 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.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1734 AND l.year = 1980
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1980 e WHERE e.league_id IN (23082) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1734 AND l.year = 1980
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events1980 e WHERE e.league_id IN (23082) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10