4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Manchester United Manchester
Datos equipo
Nombre Manchester United
Nombre completo Manchester United Football Club
Nombre corto MUD
País
Año fundación 1878
Total plantilla 30
Estadio
Nombre estadio Old Trafford
Capacidad estadio 76212
Año construcción 1909
Tipo césped Natural
Dimensiones campo 105x68
Internet
Sitio web http://www.manutd.com/
Twitter del equipo @manutd
Información
Dirección Sir Matt Busby Way
Teléfono 087 04 42 19 94
Fax 087 04 42 19 94
Otros datos
Socios 152000
Patrocinador TeamViewer
Marca de ropa Adidas
Datos equipo
Nombre PSG
Nombre completo París Saint-Germain Football Club
Nombre corto PSG
País
Año fundación 1970
Total plantilla 32
Estadio
Nombre estadio Parc des Princes
Capacidad estadio 49691
Año construcción 1897
Tipo césped Natural
Dimensiones campo 105 x 68 metros
Internet
Sitio web http://www.psg.fr/
Twitter del equipo @PSG_inside
Información
Dirección 24, rue du Commandant Guilbaud 75016 Paris
Teléfono +33 (1) 474 37171
Fax +33 (1) 423 05027
Otros datos
Patrocinador Accor Live Limitless
Marca de ropa Nike, Air Jordan
İstanbul Başakşehir İstanbul
Datos equipo
Nombre İstanbul Başakşehir
Nombre completo İstanbul Başakşehir Futbol Kulübü
Nombre corto IST
País
Año fundación 1990
Total plantilla 32
Estadio
Nombre estadio Başakşehir Fatih Terim Stadyumu
Capacidad estadio 17319
Internet
Sitio web https://www.ibfk.com.tr/
Twitter del equipo @ibfk2014
Información
Dirección Turgut Özal Caddesi 109, Çapa, Fatih 34200 Istanbul
Teléfono +90 (212) 587 4549
Fax +90 (212) 587 9866
Otros datos
Patrocinador Decovita
Marca de ropa Bilcee
RB Leipzig RB Leipzig
Datos equipo
Nombre RB Leipzig
Nombre completo RasenBallsport Leipzig e.V.
Nombre corto RBL
País
Año fundación 2009
Total plantilla 30
Estadio
Nombre estadio Red Bull Arena
Capacidad estadio 44345
Año construcción 2004
Tipo césped Natural
Internet
Sitio web http://www.dierotenbullen.com/
Twitter del equipo @RBLeipzig
Información
Dirección Am Sportforum 3
Teléfono +49 (341) 124 7970
Fax +49 (341) 124 79711
Otros datos
Patrocinador Red Bull
Marca de ropa Nike

Clasificación

Equipo PJ GF GC Puntos
1 PSG PSG 6 13 6 12
2 RB Leipzig RB Leipzig 6 11 12 12
3 Manchester United Manchester 6 15 10 9
4 İstanbul Başakşehir İstanbul 6 7 18 3

  USO DE MEMORIA  
4,458,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0727
Total Execution Time  0.0746
  CADENA URL  
/champions2021/grupo8/equipos
  GET DATOS  
$_GET['/champions2021/grupo8/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'champions' AND (l.group_code = 8 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=8 DESC LIMIT 1
0.0019  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 = 59182 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 = 59182 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-16 22:10:09' 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=2 AND last_update > '2024-04-16 22:10:09' 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-04-16 22:10:09' 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=3 AND last_update > '2024-04-16 22:10:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 107 AND l.year = 2021
0.0027  SELECT e.action, count(e.action) as total, e.player_id FROM events2021 e WHERE e.league_id IN (59175,59176,59177,59178,59179,59180,59181,59182,60337) 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.0030  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 (59175,59176,59177,59178,59179,59180,59181,59182,60337) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (326208,234474,3318,24691,40603,64511,139027,284437,323688,23569) ORDER BY rp.in_squad = 1 DESC
0.0028  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 107 AND l.year = 2021
0.0027  SELECT e.action, count(e.action) as total, e.player_id FROM events2021 e WHERE e.league_id IN (59175,59176,59177,59178,59179,59180,59181,59182,60337) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0030  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 (59175,59176,59177,59178,59179,59180,59181,59182,60337) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (52664,61471,81606,92909,143311,147311,186705,307334,320446,240) ORDER BY rp.in_squad = 1 DESC
0.0032  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 107 AND l.year = 2021
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2021 e WHERE e.league_id IN (59175,59176,59177,59178,59179,59180,59181,59182,60337) AND (e.action = 3 or e.action = 4) 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 (59175,59176,59177,59178,59179,59180,59181,59182,60337) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (52664,23560,27050,61471,63294,66475,75798,101098,139415,170511) ORDER BY rp.in_squad = 1 DESC
0.0028  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 59182 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