4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Galatasaray SK Galatasaray
Datos equipo
Nombre Galatasaray SK
Nombre completo Galatasaray Spor Kulübü
Nombre corto GAL
País
Año fundación 1905
Estadio
Nombre estadio Türk Telekom Arena
Capacidad estadio 52695
Año construcción 2011
Tipo césped Natural
Dimensiones campo 105 x 68
Internet
Sitio web http://www.galatasaray.org
Twitter del equipo @GalatasaraySK
Información
Dirección Akinci Bayiri Sokak 8, Mecidiyeköy 34394 Istanbul
Teléfono +90 (212) 273 2850
Fax +90 (212) 251 1212
Otros datos
Socios 14698
Patrocinador Sixt
Otro patrocinador Avea, Ülker, Opel
Marca de ropa Nike
Ankaragücü Ankaragücü
Datos equipo
Nombre Ankaragücü
Nombre completo Makina ve Kimya Endüstrisi Ankaragücü
Nombre corto ANK
País
Año fundación 1910
Estadio
Nombre estadio Ankara Ondokuz Mayıs Stadyumu
Capacidad estadio 19209
Año construcción 1936
Tipo césped Césped Artificial
Internet
Sitio web http://www.ankaragucu.org.tr/
Twitter del equipo @Ankaragucu
Información
Dirección 19 Mayıs Stadyumu, Ulus
Teléfono +90 (312) 215 8794
Fax +90 (312) 212 0611
Otros datos
Patrocinador Velux Ankara
Marca de ropa Joma

Equipos de esta liga

2

  USO DE MEMORIA  
4,231,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.9496
Total Execution Time  0.9530
  CADENA URL  
/supercopa-turquia1972/grupo0/equipos
  GET DATOS  
$_GET['/supercopa-turquia1972/grupo0/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'supercopa-turquia1972'
0.0301  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa-turquia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1972 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0202  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=527 AND type_rel = 3
0.2170  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 527 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0820  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 (1310509,1309852,1309841,1295798,1227696) ORDER BY n.cover_points DESC, update_date DESC
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 = 43661 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0119  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 = 43661 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0095  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 14:35:46' 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=2 AND last_update > '2024-04-28 14:35:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0202  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 14:35:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0077  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 14:35:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0980  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 527 AND l.year = 1972
0.0192  SELECT e.action, count(e.action) as total, e.player_id FROM events1972 e WHERE e.league_id IN (43661) 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.1920  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 527 AND l.year = 1972
0.0328  SELECT e.action, count(e.action) as total, e.player_id FROM events1972 e WHERE e.league_id IN (43661) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.1098  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 527 AND l.year = 1972
0.0416  SELECT e.action, count(e.action) as total, e.player_id FROM events1972 e WHERE e.league_id IN (43661) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10