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

Emiratos Árabes

Entrenador: Paulo Bento

Información
Otros Datos
  • Año de Fundación 1971
Internet
  • Correo electrónico info@uaefa.ae
  • Twitter principal @UAEFNT

Información sobre el estadio

  • Nombre del estadio Zayed Sports City Stadium
  • Capacidad 49500
  • Dirección PO Box 961 Abu zabi(Abu Dhabi)
  • Teléfono +971 (2) 444 5600
  • Fax +971 (2) 444 8558
  • Año de construcción 1979
Zayed Sports City Stadium

Partidos del Emiratos Árabes

Ir al LIVESCORE
02 Dic 05  Finalizado Emiratos Árabes
1 - 1
Libia 0
16 Nov 05  Finalizado Siria
0 - 3
Emiratos Árabes 0
12 Nov 05  Finalizado Emiratos Árabes
0 - 8
Brasil 0
11 Oct 05  Finalizado Emiratos Árabes
2 - 2
Omán 0
23 Sep 05  Finalizado Emiratos Árabes
0 - 0
Benín 0
31 Jul 05  Finalizado Egipto
5 - 4
Emiratos Árabes 0
29 Jul 05  Finalizado Kuwait
6 - 7
Emiratos Árabes 0
27 May 05  Finalizado Japón
0 - 1
Emiratos Árabes 0
24 May 05  Finalizado Emiratos Árabes
0 - 0
Perú 0
09 Feb 05  Finalizado Emiratos Árabes
1 - 2
Suiza 0
17 Nov 04  Finalizado Emiratos Árabes
1 - 0
Corea del Norte 0
13 Oct 04  Finalizado Tailandia
3 - 0
Emiratos Árabes 0
08 Sep 04  Finalizado Yemen
3 - 1
Emiratos ÁrabesTarjeta Roja 0
09 Jun 04  Finalizado Emiratos Árabes
3 - 0
Yemen 0
31 Mar 04  Finalizado Corea del Norte
0 - 0
Emiratos Árabes 0
18 Feb 04  Finalizado Emiratos Árabes
1 - 0
Tailandia 0
27 May 05  Finalizado Emiratos Árabes
1 - 0
Japón 0
24 May 05  Finalizado Perú
0 - 0
Emiratos Árabes 0

Noticias del Emiratos Árabes

Ver últimas noticias

Las 12 selecciones asiáticas que sueñan con ir al Mundial de Rusia

La fase de clasificación para el próximo Mundial llega a su tercera fase en el continente asiático. 12 países han sobrevivido a las dos rondas anteriores y se jugarán las cinco plazas que recibe Asia para dicho torneo.

Australia, Irán, Uzbekistán, Iraq, Siria, China y Emiratos pasan a la tercera ronda

Las selecciones de Australia, Irán y Uzbekistán, como campeones, más Iraq, Siria, Emiratos Árabes y China, como las cuatro mejores segundas de los ocho grupos, alcanzaron sellaron el pase para la tercera ronda de la fase de clasificación de la zona asiática para el Mundial de Rusia 2018.

El penalti tirado de tacón que... sí fue considerado una falta de respeto

Su autor, Theyab Awana Diab. Era un amistoso entre Emiratos Árabes y Líbano de 2011. El jugador de Emiratos decidió girarse y golpear de una forma sorprendente. Acabó marcando, pero sus rivales se sintieron verdaderamente ofendidos.

Condenado a prisión... ¡por criticar a su seleccionador!

El jugador del internacional de Emiratos Árabes Abdullah Qassem ha sido condenado a tres meses de prisión por insultar al seleccionador de su país.

La Liga ayudará a formar futbolistas en los Emiratos Árabes

La Liga colaborará en la organización de torneos juveniles en los Emiratos Árabes Unidos para formar en el fútbol a cerca 8000 chicos y chicas emiratíes de entre 11 y 17 años.




  USO DE MEMORIA  
5,231,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.4367
Total Execution Time  0.4388
  CADENA URL  
/Seleccion-Emiratos/2005
  GET DATOS  
$_GET['/Seleccion-Emiratos/2005']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0259  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 = 30675
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3805 AND type_rel = 2
0.0134  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3805 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0143  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 (14537,18720,42707,55442,59300) ORDER BY n.cover_points DESC, update_date DESC
0.0183  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 = '3805' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  (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 calendars2005 as c ON c.league_id = l.id WHERE (c.datateam1 = 3805 or c.datateam2 = 3805) AND l.year = 2005 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0134  (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 calendars2005 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 = 3805 or c.datateam2 = 3805) AND l.year = 2005 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0134  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2005 as c ON c.league_id = l.id INNER JOIN events2005 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 = 3805 or c.datateam2 = 3805) AND l.year = 2005)
0.0136  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=3805 AND l.year in (2004,2005,2006) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (51669,39679,39422,39394,30675,12285) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 39394 AND teamId = 3805
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 12285 AND teamId = 3805
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 39679 AND teamId = 3805
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 30675 AND teamId = 3805
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 51669 AND teamId = 3805
0.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 39422 AND teamId = 3805
0.0140  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 events2005 e ON e.player_id = p.id AND e.league_id = 39421 WHERE rp.league_id = 39421 AND rp.teamId = 3805 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.0138  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 events2005 e ON e.player_id = p.id AND e.league_id = 39421 WHERE rp.league_id = 39421 AND rp.teamId = 3805 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 events2005 e ON e.player_id = p.id AND e.league_id = 39421 WHERE rp.league_id = 39421 AND rp.teamId = 3805 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141  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 = 3805 AND rp.league_id = 39421 AND l.year= 2005 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0132  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 = 3805 AND rp.league_id = 39421 AND l.year= 2005 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0133  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 = 3805 AND rp.league_id = 39421 AND l.year= 2005 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1