4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
29 Ene 12 Rusia Sub 21Rusia 2 - 0 Bielorrusia Sub 21Bielorrusia ...
29 Ene 12 Lituania Sub 21Lituania 0 - 4 Irán Sub 21Irán ...
29 Ene 12 Kazajistán Sub 21Kazajistán 5 - 4 Moldavia Sub 21Moldavia ...
28 Ene 12 Estonia Sub 21Estonia 0 - 2 Kirguistán Sub 21Kirguistán ...
28 Ene 12 Turkmenistán Sub 21Turkmenist 1 - 1 Tayikistán Sub 21Tayikistán ...
27 Ene 12 Letonia Sub 21Letonia 1 - 2 Rusia Sub 21Rusia ...
27 Ene 12 Ucrania Sub 21Ucrania 1 - 1 Bielorrusia Sub 21Bielorrusia ...
27 Ene 12 Irán Sub 21Irán 3 - 0 Moldavia Sub 21Moldavia ...
27 Ene 12 Lituania Sub 21Lituania 0 - 0 Kazajistán Sub 21Kazajistán ...
26 Ene 12 Kirguistán Sub 21Kirguistán 3 - 1 Tayikistán Sub 21Tayikistán ...
25 Ene 12 Rusia Sub 21Rusia 2 - 1 Moldavia Sub 21Moldavia ...
25 Ene 12 Ucrania Sub 21Ucrania 1 - 1 Lituania Sub 21Lituania ...
25 Ene 12 Irán Sub 21Irán 1 - 4 Letonia Sub 21Letonia ...
25 Ene 12 Bielorrusia Sub 21Bielorrusia 3 - 2 Kazajistán Sub 21Kazajistán ...
24 Ene 12 Tayikistán Sub 21Tayikistán 1 - 1 Estonia Sub 21Estonia ...
24 Ene 12 Turkmenistán Sub 21Turkmenist 1 - 3 Kirguistán Sub 21Kirguistán ...
23 Ene 12 Irán Sub 21Irán 5 - 0 Tayikistán Sub 21Tayikistán ...
23 Ene 12 Bielorrusia Sub 21Bielorrusia 0 - 1 Lituania Sub 21Lituania ...
22 Ene 12 Rusia Sub 21Rusia 0 - 0 Turkmenistán Sub 21Turkmenist ...
22 Ene 12 Kazajistán Sub 21Kazajistán 3 - 1 Estonia Sub 21Estonia ...
22 Ene 12 Moldavia Sub 21Moldavia 2 - 1 Kirguistán Sub 21Kirguistán ...
22 Ene 12 Ucrania Sub 21Ucrania 2 - 0 Letonia Sub 21Letonia ...
21 Ene 12 Irán Sub 21Irán 3 - 0 Lituania Sub 21Lituania ...
21 Ene 12 Bielorrusia Sub 21Bielorrusia 2 - 0 Tayikistán Sub 21Tayikistán ...
21 Ene 12 Moldavia Sub 21Moldavia 0 - 0 Letonia Sub 21Letonia ...
21 Ene 12 Ucrania Sub 21Ucrania 4 - 0 Kirguistán Sub 21Kirguistán ...
20 Ene 12 Rusia Sub 21Rusia 1 - 0 Estonia Sub 21Estonia ...
20 Ene 12 Kazajistán Sub 21Kazajistán 3 - 1 Turkmenistán Sub 21Turkmenist ...
20 Ene 12 Tayikistán Sub 21Tayikistán 0 - 0 Lituania Sub 21Lituania ...
20 Ene 12 Bielorrusia Sub 21Bielorrusia 0 - 0 Irán Sub 21Irán ...
19 Ene 12 Ucrania Sub 21Ucrania 1 - 0 Moldavia Sub 21Moldavia ...
19 Ene 12 Rusia Sub 21Rusia 1 - 0 Kazajistán Sub 21Kazajistán ...
19 Ene 12 Estonia Sub 21Estonia 0 - 1 Turkmenistán Sub 21Turkmenist ...
19 Ene 12 Kirguistán Sub 21Kirguistán 2 - 3 Letonia Sub 21Letonia ...
Ver jornada
Jornada 2
29 Feb 12 Suiza Sub 21Suiza 1 - 2 Austria Sub 21Austria ...
29 Feb 12 Rusia Sub 21Rusia 4 - 1 Suecia Sub 21Suecia ...
29 Feb 12 Portugal Sub 21Portugal 2 - 0 Ucrania Sub 21Ucrania ...
29 Feb 12 Eslovaquia Sub 21Eslovaquia 4 - 1 Montenegro Sub 21Montenegro ...
29 Feb 12 Eslovenia Sub 21Eslovenia 2 - 2 Noruega Sub 21Noruega ...
29 Feb 12 Israel Sub 21Israel 4 - 0 Ucrania Sub 21Ucrania ...
29 Feb 12 Malta Sub 21Malta 1 - 3 Hungría Sub 21Hungría ...
29 Feb 12 Bulgaria Sub 21Bulgaria 1 - 0 Polonia Sub 21Polonia ...
29 Feb 12 Serbia Sub 21Serbia 2 - 0 Bosnia Sub 21Bosnia ...
29 Feb 12 Timor Oriental Sub 21Timor 1 - 0 Camboya Sub 21Camboya ...
29 Feb 12 Brunei Sub 21Brunei 1 - 2 Vietnam Sub 21Vietnam ...
29 Feb 12 Turquía Sub 21Turquía 0 - 0 Dinamarca Sub 21Dinamarca ...
28 Feb 12 Francia Sub 21Francia 1 - 1 Italia Sub 21Italia ...
28 Feb 12 Singapur Sub 21Singapur 0 - 2 Laos Sub 21Laos ...
28 Feb 12 Myanmar Sub 21Myanmar 3 - 1 Indonesia Sub 21Indonesia ...
27 Feb 12 Timor Oriental Sub 21Timor 2 - 0 Malasia Sub 21Malasia ...
27 Feb 12 Camboya Sub 21Camboya 1 - 2 Vietnam Sub 21Vietnam ...
26 Feb 12 Singapur Sub 21Singapur 1 - 1 Indonesia Sub 21Indonesia ...
26 Feb 12 Laos Sub 21Laos 3 - 1 Filipinas Sub 21Filipinas ...
25 Feb 12 Brunei Sub 21Brunei 3 - 2 Camboya Sub 21Camboya ...
25 Feb 12 Malasia Sub 21Malasia 0 - 0 Vietnam Sub 21Vietnam ...
24 Feb 12 Indonesia Sub 21Indonesia 2 - 0 Laos Sub 21Laos ...
24 Feb 12 Filipinas Sub 21Filipinas 2 - 8 Myanmar Sub 21Myanmar ...
29 Feb 12 Rumanía Sub 21Rumanía 0 - 3 República Checa Sub 21República ...
28 Feb 12 Gales Sub 21Gales 4 - 0 Andorra Sub 21Andorra ...
Ver jornada
Jornada 3
09 Mar 12 Brunei Sub 21Brunei 2 - 0 Indonesia Sub 21Indonesia ...
07 Mar 12 Brunei Sub 21Brunei 3 - 2 Myanmar Sub 21Myanmar ...
07 Mar 12 Vietnam Sub 21Vietnam 0 - 2 Indonesia Sub 21Indonesia ...
05 Mar 12 Malasia Sub 21Malasia 3 - 1 Camboya Sub 21Camboya ...
05 Mar 12 Brunei Sub 21Brunei 1 - 0 Timor Oriental Sub 21Timor ...
04 Mar 12 Singapur Sub 21Singapur 0 - 0 Myanmar Sub 21Myanmar ...
04 Mar 12 Indonesia Sub 21Indonesia 3 - 0 Filipinas Sub 21Filipinas ...
03 Mar 12 Vietnam Sub 21Vietnam 2 - 0 Timor Oriental Sub 21Timor ...
03 Mar 12 Brunei Sub 21Brunei 3 - 0 Malasia Sub 21Malasia ...
02 Mar 12 Filipinas Sub 21Filipinas 1 - 2 Singapur Sub 21Singapur ...
02 Mar 12 Laos Sub 21Laos 0 - 2 Myanmar Sub 21Myanmar ...
Ver jornada
Jornada 4
25 Abr 12 Escocia Sub 21Escocia 1 - 4 Italia Sub 21Italia ...
25 Abr 12 Eslovaquia Sub 21Eslovaquia 1 - 2 República Checa Sub 21República ...
04 Abr 12 Finlandia Sub 21Finlandia 0 - 1 Azerbaiyán Sub 21Azerbaiyán ...
Ver jornada
Jornada 5
28 May 12 Irlanda Sub 21Irlanda 1 - 2 Dinamarca Sub 21Dinamarca ...
25 May 12 Países Bajos Sub 21Países 0 - 0 Ucrania Sub 21Ucrania ...
25 May 12 Macedonia del Norte Sub 21Macedonia 2 - 2 Albania Sub 21Albania ...
22 May 12 Países Bajos Sub 21Países 0 - 1 Macedonia del Norte Sub 21Macedonia ...
22 May 12 Ucrania Sub 21Ucrania 3 - 0 Albania Sub 21Albania ...
Ver jornada
Jornada 8
10 Ago 11 Chipre Sub 21Chipre 3 - 2 MoldaviaMoldavia ...
15 Ago 12 Rusia Sub 21Rusia 2 - 2 Israel Sub 21Israel ...
15 Ago 12 Grecia Sub 21Grecia 2 - 0 Polonia Sub 21Polonia ...
15 Ago 12 Suecia Sub 21Suecia 0 - 2 Rumanía Sub 21Rumanía ...
15 Ago 12 Hungría Sub 21Hungría 3 - 2 Irlanda del Norte Sub 21Irlanda ...
15 Ago 12 Países Bajos Sub 21Países 0 - 3 Italia Sub 21Italia ...
15 Ago 12 Azerbaiyán Sub 21Azerbaiyán 2 - 0 Estonia Sub 21Estonia ...
15 Ago 12 Eslovaquia Sub 21Eslovaquia 1 - 1 Montenegro Sub 21Montenegro ...
14 Ago 12 Escocia Sub 21Escocia 0 - 1 Bélgica Sub 21Bélgica ...
14 Ago 12 Alemania Sub 21Alemania 6 - 1 Argentina Sub 21Argentina ...
14 Ago 12 Malta Sub 21Malta 4 - 1 Liechtenstein Sub 21Liechtenste ...
14 Ago 12 Portugal Sub 21Portugal 2 - 1 Macedonia del Norte Sub 21Macedonia ...
14 Ago 12 Noruega Sub 21Noruega 2 - 2 Austria Sub 21Austria ...
14 Ago 12 Bielorrusia Sub 21Bielorrusia 1 - 2 Montenegro Sub 21Montenegro ...
14 Ago 12 Serbia Sub 21Serbia 2 - 0 Moldavia Sub 21Moldavia ...
15 Ago 12 Gales Sub 21Gales 0 - 1 Armenia Sub 21Armenia ...
Ver jornada
Jornada 9
17 Sep 12 Jordania Sub 21Jordania 0 - 2 Iraq Sub 21Iraq ...
08 Sep 12 Turquía Sub 21Turquía 2 - 1 Países Bajos Sub 20Países ...
10 Sep 12 Francia Sub 21Francia 4 - 0 Chile Sub 21Chile ...
Ver jornada
Jornada 10
15 Oct 12 Estonia Sub 21Estonia 2 - 1 Letonia Sub 21Letonia ...
15 Oct 12 Austria Sub 21Austria 3 - 1 Hungría Sub 21Hungría ...
15 Oct 12 Finlandia Sub 21Finlandia 1 - 0 Lituania Sub 21Lituania ...
15 Oct 12 Singapur Sub 21Singapur 0 - 0 Tailandia Sub 21Tailandia ...
14 Oct 12 Israel Sub 21Israel 4 - 1 Bélgica Sub 21Bélgica ...
13 Oct 12 Letonia Sub 21Letonia 0 - 1 Lituania Sub 21Lituania ...
13 Oct 12 Vietnam Sub 21Vietnam 6 - 1 Singapur Sub 21Singapur ...
13 Oct 12 Estonia Sub 21Estonia 0 - 3 Finlandia Sub 21Finlandia ...
13 Oct 12 Malasia Sub 21Malasia 4 - 2 Laos Sub 21Laos ...
12 Oct 12 Austria Sub 21Austria 5 - 1 RD Congo Sub 21Congo ...
12 Oct 12 Grecia Sub 21Grecia 3 - 1 Bélgica Sub 21Bélgica ...
11 Oct 12 Hungría Sub 21Hungría 3 - 1 Moldavia Sub 21Moldavia ...
15 Oct 12 Portugal Sub 21Portugal 0 - 1 Ucrania Sub 21Ucrania ...
17 Oct 12 Vietnam Sub 21Vietnam 2 - 0 Tailandia Sub 21Tailandia ...
17 Oct 12 Macedonia del Norte Sub 21Macedonia 1 - 0 Montenegro Sub 21Montenegro ...
19 Oct 12 Malasia Sub 21Malasia 1 - 0 Tailandia Sub 21Tailandia ...
21 Oct 12 Vietnam Sub 21Vietnam 0 - 1 Malasia Sub 21Malasia ...
Ver jornada
Jornada 11
13 Nov 11 Italia Sub 21Italia Apl Liechtenstein Sub 21Liechtenste ...
13 Nov 11 España Sub 21España Apl Croacia Sub 21Croacia ...
13 Nov 12 Italia Sub 21Italia 1 - 3 España Sub 21España ...
13 Nov 12 Chipre Sub 21Chipre 1 - 1 Rumanía Sub 21Rumanía ...
13 Nov 12 Inglaterra Sub 21Inglaterra 2 - 0 Irlanda del Norte Sub 21Irlanda ...
14 Nov 12 Moldavia Sub 21Moldavia 1 - 1 Azerbaiyán Sub 21Azerbaiyán ...
14 Nov 12 Bulgaria Sub 21Bulgaria 1 - 1 Macedonia del Norte Sub 21Macedonia ...
14 Nov 12 Grecia Sub 21Grecia 1 - 1 Austria Sub 21Austria ...
14 Nov 12 Hungría Sub 21Hungría 0 - 0 Montenegro Sub 21Montenegro ...
14 Nov 12 República Checa Sub 21República 1 - 1 Suecia Sub 21Suecia ...
14 Nov 12 Bosnia Sub 21Bosnia 0 - 0 Polonia Sub 21Polonia ...
14 Nov 12 Israel Sub 21Israel 2 - 0 Bielorrusia Sub 21Bielorrusia ...
14 Nov 12 Alemania Sub 21Alemania 1 - 1 Turquía Sub 21Turquía ...
14 Nov 12 Portugal Sub 21Portugal 3 - 2 Escocia Sub 21Escocia ...
14 Nov 12 Rusia Sub 21Rusia 2 - 1 Eslovaquia Sub 21Eslovaquia ...
Ver jornada
Jornada 12
05 Dic 12 Montenegro Sub 21Montenegro 2 - 0 Serbia Sub 21Serbia ...

  USO DE MEMORIA  
5,200,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3640
Total Execution Time  0.3660
  CADENA URL  
/amistosos_selecciones_sub212012/grupo1/calendario
  GET DATOS  
$_GET['/amistosos_selecciones_sub212012/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0105  SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub212012'
0.0212  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 = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1975 AND type_rel = 3
0.0111  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1975 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0109  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 (1307533,1307508,1307361,1306837,1306579) ORDER BY n.cover_points DESC, update_date DESC
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1975 ORDER BY order_id ASC
0.0109  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 = 39577 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0114  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 calendars2012 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 39577 ORDER BY round ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 18:02:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 18:02:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 18:02:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 18:02:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  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 = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0111  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1975 AND l.year = 2012
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events2012 e WHERE e.league_id IN (39577) 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.0109  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 (39577) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (66696,132366,192240,24980,30659,38251,46474,53114,65589,70867) ORDER BY rp.in_squad = 1 DESC
0.0113  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1975 AND l.year = 2012
0.0108  SELECT e.action, count(e.action) as total, e.player_id FROM events2012 e WHERE e.league_id IN (39577) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0108  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 (39577) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (210112,66591,191371,268293,62002,69137,78188,102221,105113,138536) ORDER BY rp.in_squad = 1 DESC
0.0109  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1975 AND l.year = 2012
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events2012 e WHERE e.league_id IN (39577) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0108  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 (39577) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (67111,73160,78188,101042,102221,138536,139086,179541,210112,210202) ORDER BY rp.in_squad = 1 DESC