4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Países Bajos Países
Datos equipo
Nombre Países Bajos
Nombre completo Selección de Países Bajos
Nombre corto NLD
País
Año fundación 1889
Total plantilla 29
Estadio
Nombre estadio Amsterdam ArenA
Capacidad estadio 52960
Año construcción 1996
Tipo césped Cesped natural
Dimensiones campo 105 x 68 metros
Internet
Sitio web http://www.knvb.nl
Twitter del equipo @OnsOranje
Información
Dirección Woudenbergseweg 56-58 3700 AM Zeist
Teléfono +31-343/499 201
Fax +31-343/499 189
Alemania Alemania
Datos equipo
Nombre Alemania
Nombre completo Selección de Alemania
Nombre corto DEU
País
Año fundación 1900
Total plantilla 24
Estadio
Nombre estadio Olympiastadion Berlin
Capacidad estadio 76065
Año construcción 1936
Tipo césped Cesped
Dimensiones campo 105 x 68 m
Internet
Sitio web http://www.dfb.de
Twitter del equipo @DFB_Team
Información
Dirección Otto-Fleck-Schneise 6 Postfach 71 02 65 Frankfurt 60528
Teléfono +49-69/678 80
Fax +49-69/678 8266
Otros datos
Marca de ropa Adidas
Irlanda del Norte Irlanda
Datos equipo
Nombre Irlanda del Norte
Nombre completo Selección de Irlanda del Norte
Nombre corto NIR
País
Año fundación 1880
Total plantilla 25
Estadio
Nombre estadio Windsor Park
Capacidad estadio 12950
Año construcción 1905
Tipo césped Cesped Natural
Dimensiones campo 110x75
Internet
Sitio web http://www.irishfa.com
Twitter del equipo @NorthernIreland
Información
Dirección 20 Windsor Avenue BT9 6EG Belfast
Teléfono +44(28)90669458
Fax +44(28)90667620
Estonia Estonia
Datos equipo
Nombre Estonia
Nombre completo Selección de Estonia
Nombre corto EST
País
Año fundación 1921
Total plantilla 24
Estadio
Nombre estadio Eesti Jalgpalli Liit
Capacidad estadio 9700
Tipo césped Hierba natural
Internet
Sitio web http://www.jalgpall.ee
Twitter del equipo @eestijalgpall
Información
Dirección Asula 4c, Tallin
Teléfono +372-627-9960
Fax +372-627-9969
Bielorrusia Bielorrusia
Datos equipo
Nombre Bielorrusia
Nombre completo Selección de Bielorrusia
Nombre corto BLR
País
Año fundación 1989
Total plantilla 23
Estadio
Nombre estadio Stadyen Dynama
Capacidad estadio 41000
Internet
Sitio web http://www.bff.by
Información
Dirección Prospekt Pobeditelei 20/3 220020 Minsk
Teléfono +375(17)2545600
Fax +375(17)2544483

Clasificación

Equipo PJ GF GC Puntos
1 Alemania Alemania 8 30 7 21
2 Países Bajos Países 8 24 7 19
3 Irlanda del Norte Irlanda 8 9 13 13
4 Bielorrusia Bielorrusia 8 4 16 4
5 Estonia Estonia 8 2 26 1

  USO DE MEMORIA  
4,511,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1197
Total Execution Time  0.1217
  CADENA URL  
/clasificacion_eurocopa2018/grupo3/equipos
  GET DATOS  
$_GET['/clasificacion_eurocopa2018/grupo3/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0028  SELECT type FROM routes WHERE alias = 'clasificacion_eurocopa2018'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_eurocopa' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=142 AND type_rel = 3
0.0102  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 142 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0053  SELECT /*53 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 (903768,1308187,1308144,1308131,1308060) ORDER BY n.cover_points DESC, update_date DESC
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 = 48335 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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 = 48335 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 16:15:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 16:15:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 16:15:06' 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-05-05 16:15:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_eurocopa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 142 AND l.year = 2018
0.0053  SELECT e.action, count(e.action) as total, e.player_id FROM events2018 e WHERE e.league_id IN (48333,48334,48335,48336,48337,48338,48339,48340,48341,48342,51902) 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.0053  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 (48333,48334,48335,48336,48337,48338,48339,48340,48341,48342,51902) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (120815,28185,41038,27618,185513,22795,1652,106034,159815,37669) ORDER BY rp.in_squad = 1 DESC
0.0023  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 142 AND l.year = 2018
0.0034  SELECT e.action, count(e.action) as total, e.player_id FROM events2018 e WHERE e.league_id IN (48333,48334,48335,48336,48337,48338,48339,48340,48341,48342,51902) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0026  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 (48333,48334,48335,48336,48337,48338,48339,48340,48341,48342,51902) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (191473,76099,101066,159571,168467,217184,100585,123845,139115,152859) ORDER BY rp.in_squad = 1 DESC
0.0031  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 142 AND l.year = 2018
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events2018 e WHERE e.league_id IN (48333,48334,48335,48336,48337,48338,48339,48340,48341,48342,51902) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0035  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 (48333,48334,48335,48336,48337,48338,48339,48340,48341,48342,51902) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3270,16137,71141,100140,100585,115131,115651,120035,139115,141779) ORDER BY rp.in_squad = 1 DESC
0.0035  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 48335 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC