4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Singapur

Singapur

Entrenador: Tsutomu Ogura

Información
  • Nombre del equipo Singapur
  • Nombre completo Selección de Singapur
  • Nombre corto SGP
  • País Singapur
  • Ciudad Kallang
  • Entrenador Tsutomu Ogura
  • URL del equipo en RF testing.resultados-futbol.com/Singapur
Internet

Información sobre el estadio

  • Nombre del estadio National Stadium
  • Capacidad 55000
  • Dirección 1 Stadium Dr, Singapur 397629
  • Teléfono +65 6653 8900
  • Año de construcción 2014
National Stadium

Partidos del Singapur

Ir al LIVESCORE

Estadísticas

Noticias del Singapur

Ver últimas noticias

Las 10 selecciones más antiguas del mundo

Aprovechamos el parón de las Ligas para los compromisos internacionales para traerte esta lista con las 10 selecciones más antiguas que existen. Y es que el amor por el fútbol no es actual...

Paseo argentino en Singapur

El equipo de Sampaoli firmó su segunda victoria consecutiva ante un rival muy inferior que nunca inquietó.

¡Gabriel Quak se llevó la camiseta de Icardi en Singapur!

Gabriel Quak protagonizó la anécdota del partido entre Singapur y Argentina tras llevarse la camiseta de Mauro Icardi. Su equipo cayó derrotado por 0-6.

Así seguimos el directo del Singapur-Argentina

Vive con nosotros el encuentro amistoso que disputarán la Selección de Singapur y la Selección Argentina en el estadio Nacional de Singapur.

Sampaoli probará con una Argentina ultraofensiva ante Singapur

El seleccionador de Argentina, Jorge Sampaoli, alineará este martes en Ciudad de Singapur, en el partido amistoso ante esta selección asiática, un equipo ultra ofensivo y con varias caras nuevas respecto al que venció por la mínima el viernes pasado a Brasil.




  USO DE MEMORIA  
4,749,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2535
Total Execution Time  0.2556
  CADENA URL  
/singapur
  GET DATOS  
$_GET['/singapur']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5427 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5427 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131  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 (54371,241795,242191,242256,242419) ORDER BY n.cover_points DESC, update_date DESC
0.0141  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 = '5427' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  (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 calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 5427 or c.datateam2 = 5427) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0128  (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 calendars2024 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 = 5427 or c.datateam2 = 5427) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0127  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 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 = 5427 or c.datateam2 = 5427) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0127  (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 calendars2024_base as c ON c.league_id = l.id WHERE (c.datateam1 = 5427 or c.datateam2 = 5427) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0145  (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 calendars2024_base 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 = 5427 or c.datateam2 = 5427) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0127  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024_base as c ON c.league_id = l.id INNER JOIN events2024_base as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players_base 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 = 5427 or c.datateam2 = 5427) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)