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 Ene 24 España Sub 17España 3 - 3 Italia Sub 17Italia ...
16 Ene 24 Chipre Sub 17Chipre 1 - 1 Georgia Sub 17Georgia ...
23 Ene 24 Portugal Sub 17Portugal 2 - 2 Finlandia Sub 17Finlandia ...
22 Ene 24 Túnez Sub 17Túnez 3 - 1 Jordania Sub 17Jordania ...
29 Ene 24 Kuwait Sub 17Kuwait 0 - 0 Kirguistán Sub 17Kirguistán ...
Ver jornada
Jornada 2
25 Ene 24 España Sub 17España 1 - 2 Italia Sub 17Italia ...
18 Ene 24 Chipre Sub 17Chipre 1 - 2 Georgia Sub 17Georgia ...
25 Ene 24 Portugal Sub 17Portugal 0 - 1 Finlandia Sub 17Finlandia ...
14 Feb 24 Suiza Sub 17Suiza 0 - 4 Dinamarca Sub 17Dinamarca ...
17 Feb 24 Dinamarca Sub 17Dinamarca 5 - 1 Irlanda Sub 17Irlanda ...
16 Feb 24 Suiza Sub 17Suiza 3 - 1 Hungría Sub 17Hungría ...
06 Feb 24 Noruega Sub 17Noruega 1 - 3 República Checa Sub 17República ...
06 Feb 24 Suecia Sub 17Suecia 0 - 4 Polonia Sub 17Polonia ...
08 Feb 24 Polonia Sub 17Polonia 3 - 4 República Checa Sub 17República ...
08 Feb 24 Noruega Sub 17Noruega 0 - 1 Suecia Sub 17Suecia ...
10 Feb 24 República Checa Sub 17República 0 - 1 Suecia Sub 17Suecia ...
10 Feb 24 Polonia Sub 17Polonia 3 - 0 Noruega Sub 17Noruega ...
25 Ene 24 Túnez Sub 17Túnez 2 - 1 Jordania Sub 17Jordania ...
09 Feb 24 Bulgaria Sub 17Bulgaria 1 - 1 Turquía Sub 17Turquía ...
09 Feb 24 Croacia Sub 17Croacia 1 - 0 Grecia Sub 17Grecia ...
12 Feb 24 Grecia Sub 17Grecia 1 - 1 Bulgaria Sub 17Bulgaria ...
12 Feb 24 Croacia Sub 17Croacia 4 - 2 Turquía Sub 17Turquía ...
15 Feb 24 Croacia Sub 17Croacia 0 - 0 Bulgaria Sub 17Bulgaria ...
15 Feb 24 Turquía Sub 17Turquía 3 - 1 Grecia Sub 17Grecia ...
06 Feb 24 Bosnia Sub 17Bosnia 0 - 3 Eslovenia Sub 17Eslovenia ...
13 Feb 24 Italia Sub 17Italia 0 - 1 Francia Sub 17Francia ...
13 Feb 24 Bosnia Sub 17Bosnia 2 - 2 Gales Sub 17Gales ...
14 Feb 24 Irlanda Sub 17Irlanda 0 - 2 Hungría Sub 17Hungría ...
10 Feb 24 Rumanía Sub 17Rumanía 4 - 1 Moldavia Sub 17Moldavia ...
13 Feb 24 Chipre Sub 17Chipre 0 - 1 Eslovaquia Sub 17Eslovaquia ...
18 Feb 24 Rusia Sub 16Rusia 2 - 2 Uzbekistán Sub 17Uzbekistán ...
18 Feb 24 Rusia Sub 17Rusia 3 - 1 Kazajistán Sub 17Kazajistán ...
18 Feb 24 Bielorrusia Sub 17Bielorrusia 2 - 0 Azerbaiyán Sub 17Azerbaiyán ...
20 Feb 24 Rusia Sub 16Rusia 1 - 0 Azerbaiyán Sub 17Azerbaiyán ...
20 Feb 24 Rusia Sub 17Rusia 6 - 1 Tayikistán Sub 16Tayikistán ...
20 Feb 24 Bielorrusia Sub 16Bielorrusia 4 - 0 Kazajistán Sub 17Kazajistán ...
20 Feb 24 Bielorrusia Sub 17Bielorrusia 1 - 1 Uzbekistán Sub 17Uzbekistán ...
22 Feb 24 Uzbekistán Sub 17Uzbekistán 2 - 0 Azerbaiyán Sub 17Azerbaiyán ...
22 Feb 24 Kazajistán Sub 17Kazajistán 2 - 0 Tayikistán Sub 16Tayikistán ...
22 Feb 24 Bielorrusia Sub 16Bielorrusia 1 - 3 Rusia Sub 17Rusia ...
22 Feb 24 Bielorrusia Sub 17Bielorrusia 3 - 1 Rusia Sub 16Rusia ...
24 Feb 24 Azerbaiyán Sub 17Azerbaiyán 1 - 3 Tayikistán Sub 16Tayikistán ...
24 Feb 24 Rusia Sub 16Rusia 1 - 1 Kazajistán Sub 17Kazajistán ...
24 Feb 24 Uzbekistán Sub 17Uzbekistán 1 - 1 Bielorrusia Sub 16Bielorrusia ...
24 Feb 24 Bielorrusia Sub 17Bielorrusia 2 - 1 Rusia Sub 17Rusia ...
28 Feb 24 Finlandia Sub 17Finlandia 1 - 2 Islandia Sub 17Islandia ...
Ver jornada
Jornada 3
15 Feb 24 Italia Sub 17Italia 2 - 2 Francia Sub 17Francia ...
08 Feb 24 Bosnia Sub 17Bosnia 1 - 1 Eslovenia Sub 17Eslovenia ...
16 Feb 24 Bosnia Sub 17Bosnia 0 - 4 Gales Sub 17Gales ...
12 Feb 24 Rumanía Sub 17Rumanía 2 - 0 Moldavia Sub 17Moldavia ...
15 Feb 24 Chipre Sub 17Chipre 2 - 2 Eslovaquia Sub 17Eslovaquia ...
01 Mar 24 Finlandia Sub 17Finlandia 4 - 1 Islandia Sub 17Islandia ...
02 Mar 24 Jordania Sub 17Jordania 1 - 1 Uzbekistán Sub 17Uzbekistán ...
05 Mar 24 Serbia Sub 17Serbia 1 - 2 Eslovenia Sub 17Eslovenia ...
14 Mar 24 Lituania Sub 16Lituania 5 - 0 Islas Feroe Sub 17Islas Feroe ...
16 Mar 24 Islas Feroe Sub 17Islas Feroe Apl Islandia Sub 16Islandia ...
19 Mar 24 Gibraltar Sub 16Gibraltar 0 - 4 Islas Feroe Sub 17Islas Feroe ...
07 Mar 24 Montenegro Sub 17Montenegro Apl Serbia Sub 17Serbia ...
22 Mar 24 Túnez Sub 17Túnez 0 - 1 Marruecos Sub 17Marruecos ...
22 Mar 24 Rusia Sub 16Rusia 1 - 0 Burkina Faso Sub 17Burkina ...
Ver jornada
Jornada 4
04 Mar 24 Jordania Sub 17Jordania 0 - 2 Uzbekistán Sub 17Uzbekistán ...
07 Mar 24 Serbia Sub 17Serbia 2 - 2 Eslovenia Sub 17Eslovenia ...
20 Abr 24 Túnez Sub 17Túnez 1 - 2 Marruecos Sub 17Marruecos ...
24 Mar 24 Rusia Sub 16Rusia 3 - 1 Burkina Faso Sub 17Burkina ...
09 Abr 24 Chipre Sub 17Chipre 0 - 2 Ucrania Sub 17Ucrania ...
03 Abr 24 Georgia Sub 17Georgia 1 - 0 Liechtenstein Sub 17Liechtenste ...
05 Abr 24 Malta Sub 17Malta 4 - 1 Liechtenstein Sub 17Liechtenste ...
08 Abr 24 Liechtenstein Sub 17Liechtenste 0 - 2 Andorra Sub 17Andorra ...
16 Abr 24 Chipre Sub 17Chipre 2 - 1 Montenegro Sub 17Montenegro ...
18 Abr 24 Egipto Sub 17Egipto 1 - 1 Túnez Sub 17Túnez ...
18 Abr 24 Marruecos Sub 17Marruecos 1 - 1 Argelia Sub 17Argelia ...
20 Abr 24 Egipto Sub 17Egipto 2 - 1 Libia Sub 17Libia ...
22 Abr 24 Libia Sub 17Libia 1 - 1 Marruecos Sub 17Marruecos ...
22 Abr 24 Argelia Sub 17Argelia 1 - 1 Túnez Sub 17Túnez ...
24 Abr 24 Libia Sub 17Libia 0 - 2 Argelia Sub 17Argelia ...
24 Abr 24 Marruecos Sub 17Marruecos 1 - 3 Egipto Sub 17Egipto ...
26 Abr 24 Túnez Sub 17Túnez 1 - 1 Libia Sub 17Libia ...
26 Abr 24 Argelia Sub 17Argelia 1 - 1 Egipto Sub 17Egipto ...
Ver jornada
Jornada 5
11 Abr 24 Chipre Sub 17Chipre 2 - 1 Ucrania Sub 17Ucrania ...

  USO DE MEMORIA  
4,843,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4066
Total Execution Time  0.4085
  CADENA URL  
/amistosos_selecciones_sub172024/grupo1/calendario
  GET DATOS  
$_GET['/amistosos_selecciones_sub172024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0124  SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub172024'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub17' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1991 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1991 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1279115,1185480,1129476,883585,791361) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1991 ORDER BY order_id ASC
0.0131  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 = 75055 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 75055 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-04-27 21:40:16' 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-04-27 21:40:16' 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-04-27 21:40:16' 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-04-27 21:40:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub17' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 2024
0.0131  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75055) 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.0133  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 (75055) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3411945,3269292,3358693,3491188,3189306,3239356,3481343,3481587,3222173,3244934) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 2024
0.0128  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75055) AND (e.action = 4 or e.action = 5) 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 (75055) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3269229,3356168,3356264,3356592,3394328,3419421,3435042,3471521,3481638,3491189) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 2024
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75055) 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 (75055) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3356264,3383059,3435042,3435293,3504772,3532236) ORDER BY rp.in_squad = 1 DESC