4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del İstanbul Başakşehir

İstanbul Başakşehir

Entrenador: Çagdas Atan

Información
  • Nombre del equipo İstanbul Başakşehir
  • Nombre completo İstanbul Başakşehir Futbol Kulübü
  • Nombre corto IST
  • País Turquía
  • Ciudad İstanbul
  • Entrenador Çagdas Atan
  • URL del equipo en RF testing.resultados-futbol.com/Istanbul-Bb
Otros Datos
  • Año de Fundación 1990
  • Patrocinador Decovita
  • Marca de Ropa Bilcee
Internet

Información sobre el estadio

  • Nombre del estadio Başakşehir Fatih Terim Stadyumu
  • Capacidad 17319
  • Dirección Turgut Özal Caddesi 109, Çapa, Fatih 34200 Istanbul
  • Teléfono +90 (212) 587 4549
  • Fax +90 (212) 587 9866
Başakşehir Fatih Terim Stadyumu

Partidos del İstanbul Başakşehir

Ir al LIVESCORE
12 May 96  Finalizado İstanbul Başakşehir
2 - 0
Beykozspor 0
05 May 96  Finalizado Çaycumaspor
1 - 4
İstanbul Başakşehir 0
28 Abr 96  Finalizado İstanbul Başakşehir
1 - 1
Eyupspor 0
21 Abr 96  Finalizado Erdemir Ereğlispor
0 - 2
İstanbul Başakşehir 0
13 Abr 96  Finalizado İstanbul Başakşehir
1 - 1
Beylerbeyispor 0
07 Abr 96  Finalizado Çengelköyspor
0 - 0
İstanbul Başakşehir 0
31 Mar 96  Finalizado Maltepespor
1 - 1
İstanbul Başakşehir 0
24 Mar 96  Finalizado İstanbul Başakşehir
5 - 0
Kozlu Belediyespor 0
17 Mar 96  Finalizado Kilimli Belediyespor
2 - 4
İstanbul Başakşehir 0
10 Mar 96  Finalizado İstanbul Başakşehir
1 - 1
Fatih Karagümrük 0
03 Mar 96  Finalizado Karadeniz Ereğli
0 - 1
İstanbul Başakşehir 0
24 Feb 96  Finalizado Üsküdar Anadolu
3 - 1
İstanbul Başakşehir 0
18 Feb 96  Finalizado Kasımpaşa
0 - 1
İstanbul Başakşehir 0
10 Dic 95  Finalizado Beykozspor
0 - 0
İstanbul Başakşehir 0
03 Dic 95  Finalizado İstanbul Başakşehir
3 - 0
Çaycumaspor 0
25 Nov 95  Finalizado Eyupspor
2 - 0
İstanbul Başakşehir 0
19 Nov 95  Finalizado İstanbul Başakşehir
1 - 1
Erdemir Ereğlispor 0
12 Nov 95  Finalizado Beylerbeyispor
4 - 2
İstanbul Başakşehir 0
04 Nov 95  Finalizado İstanbul Başakşehir
5 - 0
Çengelköyspor 0
28 Oct 95  Finalizado İstanbul Başakşehir
3 - 1
Maltepespor 0
21 Oct 95  Finalizado Kozlu Belediyespor
1 - 0
İstanbul Başakşehir 0
15 Oct 95  Finalizado İstanbul Başakşehir
2 - 0
Kilimli Belediyespor 0
07 Oct 95  Finalizado Fatih Karagümrük
1 - 2
İstanbul Başakşehir 0
30 Sep 95  Finalizado İstanbul Başakşehir
4 - 0
Karadeniz Ereğli 0
23 Sep 95  Finalizado İstanbul Başakşehir
2 - 1
Üsküdar Anadolu 0
17 Sep 95  Finalizado İstanbul Başakşehir
1 - 1
Kasımpaşa 0

Noticias del İstanbul Başakşehir

Ver últimas noticias

Los 'imitadores' del Leicester en Europa

Te traemos una lista en la que repasamos los equipos modestos que han tenido un inicio de temporada que invita a pensar en el 'milagro' del Leicester en esta 2016-17.

Napoleoni salva al Istanbul a última hora

El Istanbul seguirá líder de la Liga Turca gracias a una genialidad a última hora de Napoleoni.

El Espanyol, a la caza de una joyita del fútbol turco

El Espanyol ha lanzado una suculenta oferta por el extremo diestro Edin Visca.

Edin Visca, el próximo objetivo de Monchi

El Sevilla, que ya planea la plantilla para la próxima temporada, ha puesto su objetivo en el extremo derecho Edin VIsca. El jugador, internacional con la selección de Bosnia, milita en el Basaksehir turco.

No te pierdas los dos golazos de Eto'o en su debut en Turquía

El camerunés no ha necesitado más de un partido para estrenarse en Turquía. Vaya dos golazos anotó en su estreno con el Antalyaspor.




  USO DE MEMORIA  
4,963,112 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.4688
Total Execution Time  0.4710
  CADENA URL  
/Istanbul-Bb/1996
  GET DATOS  
$_GET['/Istanbul-Bb/1996']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0293  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 50809
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1394 AND type_rel = 2
0.0150  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1394 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  SELECT /*35 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 (6725,65281,86062,113745,127880) ORDER BY n.cover_points DESC, update_date DESC
0.0156  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '1394' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 50809 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0285  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars1996 as c ON c.league_id = l.id WHERE (c.datateam1 = 1394 or c.datateam2 = 1394) AND l.year = 1996 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0291  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars1996 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 1394 or c.datateam2 = 1394) AND l.year = 1996 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0286  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1996 as c ON c.league_id = l.id INNER JOIN events1996 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 1394 or c.datateam2 = 1394) AND l.year = 1996)
0.0152  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=1394 AND l.year in (1995,1996,1997) ORDER BY l.id DESC, l.year DESC ;
0.0145  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (50809,50357,49292) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 50357 AND teamId = 1394
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 50809 AND teamId = 1394
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 49292 AND teamId = 1394
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1996` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50809 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1996 e ON e.player_id = p.id AND e.league_id = 50809 WHERE rp.league_id = 50809 AND rp.teamId = 1394 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1996 e ON e.player_id = p.id AND e.league_id = 50809 WHERE rp.league_id = 50809 AND rp.teamId = 1394 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1996 e ON e.player_id = p.id AND e.league_id = 50809 WHERE rp.league_id = 50809 AND rp.teamId = 1394 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0145  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1394 AND rp.league_id = 50809 AND l.year= 1996 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1