Ver jornada
Jornada 1
05 Oct 22 Finlandia Sub 17Finlandia 2 - 1 Grecia Sub 17Grecia ...
05 Oct 22 Italia Sub 17Italia 5 - 2 Kosovo Sub 17Kosovo 2
08 Oct 22 Grecia Sub 17Grecia 5 - 0 Kosovo Sub 17Kosovo ...
08 Oct 22 Italia Sub 17Italia 4 - 0 Finlandia Sub 17Finlandia 1
11 Oct 22 Kosovo Sub 17Kosovo 1 - 1 Finlandia Sub 17Finlandia 1
11 Oct 22 Grecia Sub 17Grecia 0 - 2 Italia Sub 17Italia ...
13 Oct 22 Bulgaria Sub 17Bulgaria 0 - 2 Suiza Sub 17Suiza ...
13 Oct 22 Turquía Sub 17Turquía 5 - 1 San Marino Sub 17Marino ...
16 Oct 22 Suiza Sub 17Suiza 7 - 0 San Marino Sub 17Marino ...
16 Oct 22 Turquía Sub 17Turquía 3 - 2 Bulgaria Sub 17Bulgaria ...
Ver jornada
Jornada 2
19 Oct 22 Irlanda del Norte Sub 17Irlanda 1 - 1 República Checa Sub 17República ...
19 Oct 22 Escocia Sub 17Escocia 6 - 0 Malta Sub 17Malta ...
19 Oct 22 Letonia Sub 17Letonia 1 - 0 Eslovaquia Sub 17Eslovaquia 1
19 Oct 22 Alemania Sub 17Alemania 4 - 0 Moldavia Sub 17Moldavia 1
19 Oct 22 San Marino Sub 17Marino 0 - 4 Bulgaria Sub 17Bulgaria ...
19 Oct 22 Suiza Sub 17Suiza 3 - 3 Turquía Sub 17Turquía ...
20 Oct 22 Montenegro Sub 17Montenegro 2 - 0 Polonia Sub 17Polonia ...
20 Oct 22 Austria Sub 17Austria 2 - 0 Andorra Sub 17Andorra ...
20 Oct 22 Gales Sub 17Gales 2 - 0 Croacia Sub 17Croacia ...
20 Oct 22 Suecia Sub 17Suecia 1 - 3 Albania Sub 17Albania ...
Ver jornada
Jornada 3
20 Oct 22 Bielorrusia Sub 17Bielorrusia 0 - 4 Noruega Sub 17Noruega ...
20 Oct 22 Irlanda Sub 17Irlanda 4 - 0 Armenia Sub 17Armenia ...
22 Oct 22 República Checa Sub 17República 5 - 0 Malta Sub 17Malta ...
22 Oct 22 Escocia Sub 17Escocia 3 - 0 Irlanda del Norte Sub 17Irlanda ...
22 Oct 22 Eslovaquia Sub 17Eslovaquia 1 - 1 Moldavia Sub 17Moldavia ...
22 Oct 22 Alemania Sub 17Alemania 2 - 0 Letonia Sub 17Letonia ...
23 Oct 22 Polonia Sub 17Polonia 6 - 1 Andorra Sub 17Andorra ...
23 Oct 22 Austria Sub 17Austria 0 - 1 Montenegro Sub 17Montenegro ...
23 Oct 22 Croacia Sub 17Croacia 1 - 0 Albania Sub 17Albania ...
23 Oct 22 Suecia Sub 17Suecia 3 - 3 Gales Sub 17Gales ...
Ver jornada
Jornada 4
23 Oct 22 Noruega Sub 17Noruega 7 - 0 Armenia Sub 17Armenia ...
23 Oct 22 Irlanda Sub 17Irlanda 2 - 2 Bielorrusia Sub 17Bielorrusia ...
24 Oct 22 Azerbaiyán Sub 17Azerbaiyán 2 - 5 Ucrania Sub 17Ucrania 2
24 Oct 22 Bosnia Sub 17Bosnia 2 - 0 Liechtenstein Sub 17Liechtenste 1
25 Oct 22 Georgia Sub 17Georgia 1 - 3 Israel Sub 17Israel ...
25 Oct 22 Inglaterra Sub 17Inglaterra 3 - 1 Lituania Sub 17Lituania ...
25 Oct 22 Malta Sub 17Malta 1 - 2 Irlanda del Norte Sub 17Irlanda ...
25 Oct 22 República Checa Sub 17República 5 - 1 Escocia Sub 17Escocia ...
25 Oct 22 Macedonia del Norte Sub 17Macedonia 0 - 3 Islandia Sub 17Islandia ...
25 Oct 22 Francia Sub 17Francia 4 - 0 Luxemburgo Sub 17Luxemburgo ...
Ver jornada
Jornada 5
25 Oct 22 Moldavia Sub 17Moldavia 2 - 3 Letonia Sub 17Letonia ...
25 Oct 22 Eslovaquia Sub 17Eslovaquia 1 - 0 Alemania Sub 17Alemania ...
26 Oct 22 Andorra Sub 17Andorra 1 - 1 Montenegro Sub 17Montenegro 4
26 Oct 22 Polonia Sub 17Polonia 4 - 2 Austria Sub 17Austria 2
26 Oct 22 Rumanía Sub 17Rumanía 0 - 3 Dinamarca Sub 17Dinamarca 3
26 Oct 22 Bélgica Sub 17Bélgica 4 - 1 Estonia Sub 17Estonia 1
26 Oct 22 Albania Sub 17Albania 0 - 0 Gales Sub 17Gales 3
26 Oct 22 Croacia Sub 17Croacia 2 - 2 Suecia Sub 17Suecia 1
26 Oct 22 Armenia Sub 17Armenia 2 - 5 Bielorrusia Sub 17Bielorrusia ...
26 Oct 22 Noruega Sub 17Noruega 1 - 1 Irlanda Sub 17Irlanda 1
Ver jornada
Jornada 6
27 Oct 22 Ucrania Sub 17Ucrania 7 - 0 Liechtenstein Sub 17Liechtenste 1
27 Oct 22 Bosnia Sub 17Bosnia 1 - 0 Azerbaiyán Sub 17Azerbaiyán 2
28 Oct 22 Israel Sub 17Israel 1 - 1 Lituania Sub 17Lituania 2
28 Oct 22 Inglaterra Sub 17Inglaterra 6 - 2 Georgia Sub 17Georgia 1
28 Oct 22 Islandia Sub 17Islandia 3 - 1 Luxemburgo Sub 17Luxemburgo ...
28 Oct 22 Francia Sub 17Francia 4 - 0 Macedonia del Norte Sub 17Macedonia 7
29 Oct 22 Dinamarca Sub 17Dinamarca 8 - 0 Estonia Sub 17Estonia ...
29 Oct 22 Bélgica Sub 17Bélgica 3 - 0 Rumanía Sub 17Rumanía ...
30 Oct 22 Liechtenstein Sub 17Liechtenste 0 - 8 Azerbaiyán Sub 17Azerbaiyán 2
30 Oct 22 Ucrania Sub 17Ucrania 1 - 1 Bosnia Sub 17Bosnia ...
Ver jornada
Jornada 7
31 Oct 22 Lituania Sub 17Lituania 0 - 3 Georgia Sub 17Georgia 2
31 Oct 22 Israel Sub 17Israel 1 - 1 Inglaterra Sub 17Inglaterra 3
31 Oct 22 Luxemburgo Sub 17Luxemburgo 3 - 2 Macedonia del Norte Sub 17Macedonia 4
31 Oct 22 Islandia Sub 17Islandia 0 - 4 Francia Sub 17Francia 3
01 Nov 22 Estonia Sub 17Estonia 2 - 4 Rumanía Sub 17Rumanía ...
01 Nov 22 Dinamarca Sub 17Dinamarca 2 - 3 Bélgica Sub 17Bélgica 1
01 Nov 22 Chipre Sub 17Chipre Apl Rusia Sub 17Rusia 1
04 Nov 22 Serbia Sub 17Serbia 12 - 0 Gibraltar Sub 17Gibraltar 18
04 Nov 22 Rusia Sub 17Rusia Apl Gibraltar Sub 17Gibraltar 2
07 Nov 22 Chipre Sub 17Chipre 1 - 3 Serbia Sub 17Serbia 3
Ver jornada
Jornada 8
01 Nov 22 Gibraltar Sub 17Gibraltar 0 - 2 Chipre Sub 17Chipre ...
07 Nov 22 Rusia Sub 17Rusia Apl Serbia Sub 17Serbia ...
16 Nov 22 Islas Feroe Sub 17Islas Feroe 0 - 2 Eslovenia Sub 17Eslovenia ...
16 Nov 22 Portugal Sub 17Portugal 6 - 1 Kazajistán Sub 17Kazajistán ...
19 Nov 22 Eslovenia Sub 17Eslovenia 0 - 0 Kazajistán Sub 17Kazajistán ...
19 Nov 22 Portugal Sub 17Portugal 3 - 0 Islas Feroe Sub 17Islas Feroe 2
22 Nov 22 Kazajistán Sub 17Kazajistán 3 - 0 Islas Feroe Sub 17Islas Feroe ...
22 Nov 22 Eslovenia Sub 17Eslovenia 0 - 2 Portugal Sub 17Portugal 2

Clasificación

Equipo PJ GF GC Puntos
1 Portugal Sub 17 Portugal 3 11 1 9
2 Eslovenia Sub 17 Eslovenia 3 2 2 4
3 Kazajistán Sub 17 Kazajistán 3 4 6 4
4 Islas Feroe Sub 17 Islas Feroe 3 0 8 0
5 Ucrania Sub 17 Ucrania 3 13 3 7
6 Bosnia Sub 17 Bosnia 3 4 1 7
7 Azerbaiyán Sub 17 Azerbaiyán 3 10 6 3
8 Liechtenstein Sub 17 Liechtenstei 3 0 17 0
9 Inglaterra Sub 17 Inglaterra 3 10 4 7
10 Israel Sub 17 Israel 3 5 3 5
11 Georgia Sub 17 Georgia 3 6 9 3
12 Lituania Sub 17 Lituania 3 2 7 1
13 República Checa Sub 17 República 3 11 2 7
14 Escocia Sub 17 Escocia 3 10 5 6
15 Irlanda del Norte Sub 17 Irlanda 3 3 5 4
16 Malta Sub 17 Malta 3 1 13 0
17 Montenegro Sub 17 Montenegro 3 4 1 7
18 Polonia Sub 17 Polonia 3 10 5 6
19 Austria Sub 17 Austria 3 4 5 3
20 Andorra Sub 17 Andorra 3 2 9 1
21 Bélgica Sub 17 Bélgica 3 10 3 9
22 Dinamarca Sub 17 Dinamarca 3 13 3 6
23 Rumanía Sub 17 Rumanía 3 4 8 3
24 Estonia Sub 17 Estonia 3 3 16 0
25 Gales Sub 17 Gales 3 5 3 5
26 Albania Sub 17 Albania 3 3 2 4
27 Croacia Sub 17 Croacia 3 3 4 4
28 Suecia Sub 17 Suecia 3 6 8 2
29 Italia Sub 17 Italia 3 11 2 9
30 Finlandia Sub 17 Finlandia 3 3 6 4
31 Grecia Sub 17 Grecia 3 6 4 3
32 Kosovo Sub 17 Kosovo 3 3 11 1
33 Francia Sub 17 Francia 3 12 0 9
34 Islandia Sub 17 Islandia 3 6 5 6
35 Luxemburgo Sub 17 Luxemburgo 3 4 9 3
36 Macedonia del Norte Sub 17 Macedonia 3 2 10 0
37 Noruega Sub 17 Noruega 3 12 1 7
38 Irlanda Sub 17 Irlanda 3 7 3 5
39 Bielorrusia Sub 17 Bielorrusia 3 7 8 4
40 Armenia Sub 17 Armenia 3 2 16 0
41 Serbia Sub 17 Serbia 2 15 1 6
42 Chipre Sub 17 Chipre 2 3 3 3
43 Rusia Sub 17 Rusia 0 0 0 0
44 Gibraltar Sub 17 Gibraltar 2 0 14 0
45 Alemania Sub 17 Alemania 3 6 1 6
46 Letonia Sub 17 Letonia 3 4 4 6
47 Eslovaquia Sub 17 Eslovaquia 3 2 2 4
48 Moldavia Sub 17 Moldavia 3 3 8 1
49 Suiza Sub 17 Suiza 3 12 3 7
50 Turquía Sub 17 Turquía 3 11 6 7
51 Bulgaria Sub 17 Bulgaria 3 6 5 3
52 San Marino Sub 17 Marino 3 1 16 0

  USO DE MEMORIA  
6,764,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1271
Total Execution Time  0.1290
  CADENA URL  
/clasificacion_europeo_sub_172023/grupo1/calendario
  GET DATOS  
$_GET['/clasificacion_europeo_sub_172023/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0018  SELECT type FROM routes WHERE alias = 'clasificacion_europeo_sub_172023'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_europeo_sub_17' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1861 AND type_rel = 3
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1861 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1307751,1241421,1240622,1120790,1119720) ORDER BY n.cover_points DESC, update_date DESC
0.0033  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=1785 ORDER BY l.group_code ASC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1785 ORDER BY order_id ASC
0.0022  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 = 66166 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 calendars2023 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 66166 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 02:20:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 02:20:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 02:20:30' 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-04-19 02:20:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_europeo_sub_17' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0027  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1861 AND l.year = 2023
0.0025  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (66166,70713) 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.0022  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 (66166,70713) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3333400,971030,3178249,3190721,3216175,940620,3235061,3167336,3174887,3186638) ORDER BY rp.in_squad = 1 DESC
0.0025  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1861 AND l.year = 2023
0.0025  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (66166,70713) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0022  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 (66166,70713) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3168510,3275230,3142312,3196671,3273184,3333400,3339813,3340533,3346673,940660) ORDER BY rp.in_squad = 1 DESC
0.0027  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1861 AND l.year = 2023
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (66166,70713) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0021  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 (66166,70713) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (601801,3142312,3189542,3196671,3197596,3204898,3239371,3266153,3266167,3266543) ORDER BY rp.in_squad = 1 DESC
0.0058  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 66166 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC