4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
23 Mar 19 BosniaBosnia 2 - 1 ArmeniaArmenia 63
23 Mar 19 ItaliaItalia 2 - 0 FinlandiaFinlandia 119
23 Mar 19 LiechtensteinLiechtenste 0 - 2 GreciaGrecia 114
Ver jornada
Jornada 2
26 Mar 19 ArmeniaArmenia 0 - 2 FinlandiaFinlandia 167
26 Mar 19 BosniaBosnia 2 - 2 GreciaGrecia 152
26 Mar 19 ItaliaItalia 6 - 0 LiechtensteinLiechtenste 147
Ver jornada
Jornada 3
08 Jun 19 ArmeniaArmenia 3 - 0 LiechtensteinLiechtenste 24
08 Jun 19 FinlandiaFinlandia 2 - 0 BosniaBosnia 83
08 Jun 19 GreciaGrecia 0 - 3 ItaliaItalia 85
Ver jornada
Jornada 4
11 Jun 19 GreciaGrecia 2 - 3 ArmeniaArmenia 162
11 Jun 19 ItaliaItalia 2 - 1 BosniaBosnia 242
11 Jun 19 LiechtensteinLiechtenste 0 - 2 FinlandiaFinlandia 31
Ver jornada
Jornada 5
05 Sep 19 ArmeniaArmenia 1 - 3 ItaliaItalia 359
05 Sep 19 BosniaBosnia 5 - 0 LiechtensteinLiechtenste 65
05 Sep 19 FinlandiaFinlandia 1 - 0 GreciaGrecia 129
Ver jornada
Jornada 6
08 Sep 19 ArmeniaArmenia 4 - 2 BosniaBosnia 161
08 Sep 19 FinlandiaFinlandia 1 - 2 ItaliaItalia 228
08 Sep 19 GreciaGrecia 1 - 1 LiechtensteinLiechtenste 51
Ver jornada
Jornada 7
12 Oct 19 BosniaBosnia 4 - 1 FinlandiaFinlandia 33
12 Oct 19 ItaliaItalia 2 - 0 GreciaGrecia 129
12 Oct 19 LiechtensteinLiechtenste 1 - 1 ArmeniaArmenia 76
Ver jornada
Jornada 8
15 Oct 19 FinlandiaFinlandia 3 - 0 ArmeniaArmenia 131
15 Oct 19 GreciaGrecia 2 - 1 BosniaBosnia 62
15 Oct 19 LiechtensteinLiechtenste 0 - 5 ItaliaItalia 50
Ver jornada
Jornada 9
15 Nov 19 ArmeniaArmenia 0 - 1 GreciaGrecia 117
15 Nov 19 FinlandiaFinlandia 3 - 0 LiechtensteinLiechtenste 50
15 Nov 19 BosniaBosnia 0 - 3 ItaliaItalia 127
Ver jornada
Jornada 10
18 Nov 19 GreciaGrecia 2 - 1 FinlandiaFinlandia 64
18 Nov 19 ItaliaItalia 9 - 1 ArmeniaArmenia 80
18 Nov 19 LiechtensteinLiechtenste 0 - 3 BosniaBosnia 51

Clasificación

Equipo PJ GF GC Puntos
1 Italia Italia 10 37 4 30
2 Finlandia Finlandia 10 16 10 18
3 Grecia Grecia 10 12 14 14
4 Bosnia Bosnia 10 20 17 13
5 Armenia Armenia 10 14 25 10
6 Liechtenstein Liechtenstei 10 2 31 2

  USO DE MEMORIA  
4,621,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2127
Total Execution Time  0.2146
  CADENA URL  
/clasificacion_eurocopa2018/grupo10/calendario
  GET DATOS  
$_GET['/clasificacion_eurocopa2018/grupo10/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0125  SELECT type FROM routes WHERE alias = 'clasificacion_eurocopa2018'
0.0131  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2018 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 48342 ORDER BY round ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 06:00:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 06:00:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 06:00:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 06:00:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0255  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.0133  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 = 48342 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC