4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Al-Wahda Al-Wahda
Datos equipo
Nombre Al-Wahda
Nombre completo Al-Wahda Football Club
Nombre corto WAH
País
Año fundación 1974
Total plantilla 18
Estadio
Nombre estadio Al-Nahyan Stadium
Capacidad estadio 11842
Tipo césped Natural
Internet
Sitio web http://www.alwahdaclub.net/
Información
Dirección Old Airport Road
Teléfono +971(2)443-3000
Fax +971(2)443-3001
Al-Ahli SFC Al-Ahli SFC
Datos equipo
Nombre Al-Ahli SFC
Nombre completo Al-Ahli Saudi Football Club
Nombre corto ALA
País
Año fundación 1937
Total plantilla 34
Estadio
Nombre estadio Prince Abdullah al-Faisal Stadium
Capacidad estadio 62241
Año construcción 1973
Tipo césped Natural
Internet
Sitio web https://www.alahlifc.sa/
Twitter del equipo @ALAHLI_FC
Información
Dirección King Abdullah Sports City, Jeddah, Arabia Saudita
Teléfono +966 (55) 166 4455
Otros datos
Patrocinador Qatar Airways
FC Esteghlal Esteghlal
Datos equipo
Nombre FC Esteghlal
Nombre completo Esteghlal Tehran Football Club
Nombre corto EST
País
Año fundación 1945
Total plantilla 26
Estadio
Nombre estadio Azadi Stadium
Capacidad estadio 91600
Año construcción 1974
Tipo césped Natural
Internet
Sitio web http://www.fcesteghlal.ir/
Información
Dirección West 38th Street 16, Sa'adat Abad Tehran
Teléfono +98 (21) 886 92155
Fax +98 (21) 886 92158
Al Shorta Al Shorta
Datos equipo
Nombre Al Shorta
Nombre corto ALS
País
Total plantilla 35
Clasificación
Equipo PJ GF GC Puntos
1 Al-Ahli SFC Al-Ahli SFC 5 5 7 7
2 FC Esteghlal Esteghlal 4 6 4 5
3 Al Shorta Al Shorta 5 4 5 5
4 Al-Wahda Al-Wahda 2 2 1 4
Equipos de esta liga
4
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
4,425,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0789
Total Execution Time  0.0809
  CADENA URL  
/afc_champions_league2020/grupo1/equipos
  GET DATOS  
$_GET['/afc_champions_league2020/grupo1/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0018  SELECT type FROM routes WHERE alias = 'afc_champions_league2020'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'afc_champions_league' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=265 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 = 55316 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 55316 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 07:12:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 07:12:20' 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-03-29 07:12:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 07:12:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'afc_champions_league' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0029  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 265 AND l.year = 2020
0.0025  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (55316,55317,55318,55319,55320,55321,55322,55323,58994) 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.0031  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (55316,55317,55318,55319,55320,55321,55322,55323,58994) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (176225,230245,125950,233226,311583,17978,287751,288231,365230,712) ORDER BY rp.in_squad = 1 DESC
0.0036  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 265 AND l.year = 2020
0.0028  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (55316,55317,55318,55319,55320,55321,55322,55323,58994) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0036  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (55316,55317,55318,55319,55320,55321,55322,55323,58994) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (215274,67001,75455,233226,277184,300732,303635,315043,426608,511773) ORDER BY rp.in_squad = 1 DESC
0.0048  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 265 AND l.year = 2020
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (55316,55317,55318,55319,55320,55321,55322,55323,58994) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0029  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (55316,55317,55318,55319,55320,55321,55322,55323,58994) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (2986,159438,178185,181890,183594,198307,214840,245240,302054,303635) ORDER BY rp.in_squad = 1 DESC
0.0026  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 55316 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC