4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
17 Ene 18 Argelia Sub 21Argelia 1 - 1 Túnez Sub 21Túnez ...
22 Ene 18 Azerbaiyán Sub 21Azerbaiyán 1 - 1 Georgia Sub 21Georgia ...
Ver jornada
Jornada 2
27 Feb 18 Argelia Sub 21Argelia 0 - 1 Palestina Sub 21Palestina ...
Ver jornada
Jornada 3
22 Mar 18 Austria Sub 21Austria 0 - 5 Dinamarca Sub 21Dinamarca 6
22 Mar 18 Italia Sub 21Italia 1 - 1 Noruega Sub 21Noruega 29
27 Mar 18 Serbia Sub 21Serbia 0 - 1 Italia Sub 21Italia 2
22 Mar 18 Irlanda Sub 21Irlanda 3 - 1 Islandia Sub 21Islandia 4
24 Mar 18 Inglaterra Sub 21Inglaterra 2 - 1 Rumanía Sub 21Rumanía 1
22 Mar 18 Moldavia Sub 21Moldavia 1 - 1 Letonia Sub 21Letonia 7
22 Mar 18 Eslovenia Sub 21Eslovenia 2 - 3 Ucrania Sub 21Ucrania 12
22 Mar 18 Países Bajos Sub 21Países 1 - 4 Bélgica Sub 21Bélgica 16
23 Mar 18 Paraguay Sub 21Paraguay 1 - 1 Chile Sub 21Chile ...
24 Mar 18 China Sub 21China 0 - 0 Tailandia Sub 21Tailandia ...
26 Mar 18 Paraguay Sub 21Paraguay 2 - 1 Japón Sub 21Japón ...
21 Mar 18 China Sub 21China 2 - 1 Tayikistán Sub 21Tayikistán ...
27 Mar 18 China Sub 21China 0 - 1 Siria Sub 21Siria ...
Ver jornada
Jornada 4
23 Abr 18 Brunei Sub 21Brunei 0 - 1 Timor Oriental Sub 21Timor ...
24 Abr 18 Myanmar Sub 21Myanmar 1 - 1 Tailandia Sub 21Tailandia ...
25 Abr 18 Laos Sub 21Laos 1 - 5 Singapur Sub 21Singapur ...
27 Abr 18 Brunei Sub 21Brunei 2 - 1 Tailandia Sub 21Tailandia ...
27 Abr 18 Timor Oriental Sub 21Timor 0 - 2 Myanmar Sub 21Myanmar ...
28 Abr 18 Camboya Sub 21Camboya 1 - 2 Laos Sub 21Laos ...
29 Abr 18 Tailandia Sub 21Tailandia 1 - 1 Timor Oriental Sub 21Timor ...
30 Abr 18 Singapur Sub 21Singapur 0 - 1 Camboya Sub 21Camboya ...
30 Abr 18 Brunei Sub 21Brunei 0 - 1 Myanmar Sub 21Myanmar ...
Ver jornada
Jornada 5
25 May 18 Suiza Sub 21Suiza 2 - 1 Francia Sub 21Francia 37
25 May 18 Bolivia Sub 21Bolivia 1 - 4 Países Bajos Sub 21Países 40
29 May 18 Paraguay Sub 21Paraguay 1 - 2 Países Bajos Sub 21Países 48
25 May 18 Portugal Sub 21Portugal 3 - 2 Italia Sub 21Italia 17
31 May 18 Austria Sub 21Austria 0 - 3 República Checa Sub 21República ...
02 May 18 Singapur Sub 21Singapur 1 - 2 Timor Oriental Sub 21Timor ...
02 May 18 Myanmar Sub 21Myanmar 1 - 2 Camboya Sub 21Camboya ...
05 May 18 Timor Oriental Sub 21Timor 1 - 0 Camboya Sub 21Camboya ...
28 May 18 Albania Sub 21Albania 0 - 2 Bosnia Sub 21Bosnia ...
29 May 18 Eslovenia Sub 21Eslovenia 3 - 1 Grecia Sub 21Grecia ...
29 May 18 Ucrania Sub 21Ucrania 0 - 1 Israel Sub 21Israel ...
29 May 18 Estonia Sub 21Estonia 1 - 1 Lituania Sub 21Lituania ...
31 May 18 Eslovenia Sub 21Eslovenia 3 - 0 Israel Sub 21Israel ...
29 May 18 Francia Sub 21Francia 1 - 1 Italia Sub 21Italia ...
20 May 18 Rusia Sub 21Rusia 3 - 0 Chipre Sub 21Chipre ...
Ver jornada
Jornada 6
04 Jun 18 Kazajistán Sub 21Kazajistán 1 - 1 Azerbaiyán Sub 21Azerbaiyán 7
06 Jun 18 Georgia Sub 21Georgia 1 - 1 Gales Sub 21Gales 24
08 Jun 18 Azerbaiyán Sub 21Azerbaiyán 3 - 3 Hungría Sub 21Hungría ...
08 Jun 18 Albania Sub 21Albania 1 - 1 Bielorrusia Sub 21Bielorrusia 7
03 Jun 18 Austria Sub 21Austria 2 - 3 República Checa Sub 21República ...
01 Jun 18 Letonia Sub 21Letonia 2 - 0 Estonia Sub 21Estonia ...
04 Jun 18 Lituania Sub 21Lituania 1 - 0 Letonia Sub 21Letonia ...
03 Jun 18 Gales Sub 21Gales 2 - 2 Georgia Sub 21Georgia ...
05 Jun 18 Catar Sub 21Catar 1 - 2 Corea del Sur Sub 21Corea ...
05 Jun 18 Portugal Sub 21Portugal 2 - 0 China Sub 21China ...
05 Jun 18 Bielorrusia Sub 21Bielorrusia 2 - 3 Albania Sub 21Albania ...
07 Jun 18 Japón Sub 21Japón 1 - 0 Togo Sub 21Togo ...
07 Jun 18 Francia Sub 21Francia 2 - 1 Canadá Sub 21Canadá ...
Ver jornada
Jornada 7
20 Jul 18 Honduras Sub 21Honduras 2 - 0 Trinidad y Tobago Sub 21Trinidad ...
21 Jul 18 Colombia Sub 21Colombia 1 - 0 Costa Rica Sub 21Costa Rica ...
21 Jul 18 El Salvador Sub 21Salvador 0 - 1 Haití Sub 21Haití ...
22 Jul 18 México Sub 21México 1 - 2 Venezuela Sub 21Venezuela ...
22 Jul 18 Costa Rica Sub 21Costa Rica 3 - 2 Trinidad y Tobago Sub 21Trinidad ...
23 Jul 18 Colombia Sub 21Colombia 1 - 1 Honduras Sub 21Honduras ...
17 Jul 18 Venezuela Sub 21Venezuela 2 - 0 Haití Sub 21Haití ...
24 Jul 18 México Sub 21México 0 - 1 El Salvador Sub 21Salvador ...
24 Jul 18 Costa Rica Sub 21Costa Rica 1 - 2 Honduras Sub 21Honduras ...
25 Jul 18 Trinidad y Tobago Sub 21Trinidad 1 - 5 Colombia Sub 21Colombia ...
25 Jul 18 Venezuela Sub 21Venezuela 3 - 0 El Salvador Sub 21Salvador ...
26 Jul 18 Haití Sub 21Haití 1 - 1 México Sub 21México ...
28 Jul 18 Venezuela Sub 21Venezuela 1 - 0 Honduras Sub 21Honduras ...
29 Jul 18 Colombia Sub 21Colombia 3 - 2 Haití Sub 21Haití ...
31 Jul 18 Honduras Sub 21Honduras 0 - 3 Haití Sub 21Haití ...
Ver jornada
Jornada 8
01 Ago 18 Venezuela Sub 21Venezuela 1 - 2 Colombia Sub 21Colombia ...
15 Ago 18 Moldavia Sub 21Moldavia 1 - 0 Armenia Sub 21Armenia ...
Ver jornada
Jornada 9
11 Sep 18 Italia Sub 21Italia 3 - 1 Albania Sub 21Albania ...
06 Sep 18 Eslovaquia Sub 21Eslovaquia 3 - 0 Italia Sub 21Italia ...
07 Sep 18 Alemania Sub 21Alemania 3 - 0 México Sub 21México ...
07 Sep 18 Rusia Sub 21Rusia 1 - 1 Egipto Sub 23Egipto ...
04 Sep 18 Uzbekistan Sub 21Uzbekistan 1 - 0 Tayikistán Sub 21Tayikistán ...
04 Sep 18 China Sub 21China 1 - 0 Myanmar Sub 21Myanmar ...
06 Sep 18 Uzbekistan Sub 21Uzbekistan 2 - 0 Myanmar Sub 21Myanmar ...
06 Sep 18 China Sub 21China 1 - 1 Tayikistán Sub 21Tayikistán ...
06 Sep 18 Luxemburgo Sub 21Luxemburgo 0 - 1 Irlanda del Norte Sub 21Irlanda ...
08 Sep 18 Tayikistán Sub 21Tayikistán 0 - 0 Myanmar Sub 21Myanmar ...
08 Sep 18 China Sub 21China 1 - 1 Uzbekistan Sub 21Uzbekistan ...
11 Sep 18 Malta Sub 21Malta 2 - 5 Georgia Sub 21Georgia ...
Ver jornada
Jornada 10
12 Oct 18 Francia Sub 21Francia 1 - 0 Turquía Sub 21Turquía 11
11 Oct 18 Italia Sub 21Italia 0 - 1 Bélgica Sub 21Bélgica ...
15 Oct 18 Italia Sub 21Italia 2 - 0 Túnez Sub 21Túnez ...
Ver jornada
Jornada 11
14 Nov 18 España Sub 21España 4 - 1 Dinamarca Sub 21Dinamarca 73
19 Nov 18 Francia Sub 21Francia 1 - 1 España Sub 21España 60
15 Nov 18 Italia Sub 21Italia 1 - 2 Inglaterra Sub 21Inglaterra 7
19 Nov 18 Italia Sub 21Italia 1 - 2 Alemania Sub 21Alemania 20
20 Nov 18 Dinamarca Sub 21Dinamarca 1 - 5 Inglaterra Sub 21Inglaterra ...
16 Nov 18 Alemania Sub 21Alemania 3 - 0 Países Bajos Sub 21Países ...
15 Nov 18 Francia Sub 21Francia 2 - 2 Croacia Sub 21Croacia ...
15 Nov 18 México Sub 21México 2 - 0 Islandia Sub 21Islandia ...
15 Nov 18 China Sub 21China 1 - 0 Tailandia Sub 21Tailandia ...
15 Nov 18 Rumanía Sub 21Rumanía 3 - 3 Bélgica Sub 21Bélgica ...
17 Nov 18 China Sub 21China 1 - 1 Islandia Sub 21Islandia ...
19 Nov 18 Islandia Sub 21Islandia 1 - 1 Tailandia Sub 21Tailandia ...
17 Nov 18 Tailandia Sub 21Tailandia 0 - 6 México Sub 21México ...
16 Nov 18 Serbia Sub 21Serbia 1 - 0 Macedonia del Norte Sub 21Macedonia ...
16 Nov 18 Ucrania Sub 21Ucrania 3 - 3 Georgia Sub 21Georgia ...
16 Nov 18 Malta Sub 21Malta 0 - 2 Albania Sub 21Albania ...
19 Nov 18 Albania Sub 21Albania 3 - 2 Malta Sub 21Malta ...
17 Nov 18 Escocia Sub 21Escocia 0 - 2 Turquía Sub 21Turquía ...
19 Nov 18 China Sub 21China 1 - 1 México Sub 21México ...
19 Nov 18 Montenegro Sub 21Montenegro 0 - 2 Macedonia del Norte Sub 21Macedonia ...
19 Nov 18 Bosnia Sub 21Bosnia 2 - 0 Azerbaiyán Sub 21Azerbaiyán ...
19 Nov 18 Arabia Saudí Sub 21Arabia 4 - 0 Palestina Sub 21Palestina ...
15 Nov 18 Montenegro Sub 21Montenegro 1 - 0 Serbia Sub 21Serbia ...
16 Nov 18 Suiza Sub 21Suiza 1 - 1 Francia Sub 21Francia ...
Ver jornada
Jornada 12
12 Dic 18 Vietnam Sub 21Vietnam 5 - 2 Myanmar Sub 21Myanmar ...
14 Dic 18 Vietnam Sub 21Vietnam 2 - 1 Malasia Sub 21Malasia ...
16 Dic 18 Myanmar Sub 21Myanmar 3 - 0 Malasia Sub 21Malasia ...
18 Dic 18 Myanmar Sub 21Myanmar 5 - 3 Vietnam Sub 21Vietnam ...

  USO DE MEMORIA  
5,081,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.4013
Total Execution Time  0.4034
  CADENA URL  
/amistosos_selecciones_sub212018/grupo1/calendario
  GET DATOS  
$_GET['/amistosos_selecciones_sub212018/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0124  SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub212018'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub21' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0167  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 = 42237 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0144  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 = 42237 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 04:36:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 04:36:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 04:36:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 04:36:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub21' 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.0125  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1975 AND l.year = 2018
0.0128  SELECT e.action, count(e.action) as total, e.player_id FROM events2018 e WHERE e.league_id IN (42237) 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.0129  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 (42237) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (197925,206955,234630,309791,185538,197830,211954,216524,219848,225552) ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1975 AND l.year = 2018
0.0128  SELECT e.action, count(e.action) as total, e.player_id FROM events2018 e WHERE e.league_id IN (42237) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128  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 (42237) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (201147,282098,344068,279952,283614,287089,297325,307156,318936,326361) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1975 AND l.year = 2018
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2018 e WHERE e.league_id IN (42237) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128  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 (42237) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (201147,278433,279064,283614,297325,316579,330956,344176,433667,451531) ORDER BY rp.in_squad = 1 DESC