4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
21 Sep 22 República Checa Sub 19República 3 - 0 Andorra Sub 19Andorra 7
21 Sep 22 Suiza Sub 19Suiza 0 - 2 Grecia Sub 19Grecia 38
21 Sep 22 Azerbaiyán Sub 19Azerbaiyán 0 - 1 Bulgaria Sub 19Bulgaria 55
21 Sep 22 Turquia Sub 19Turquia 4 - 4 Luxemburgo Sub 19Luxemburgo 26
17 Nov 22 Chipre Sub 19Chipre 0 - 0 Suecia Sub 19Suecia 37
17 Nov 22 Ucrania Sub 19Ucrania 1 - 0 Kosovo Sub 19Kosovo 1
21 Sep 22 Irlanda Sub 19Irlanda 6 - 0 Gibraltar Sub 19Gibraltar 16
21 Sep 22 Gales Sub 19Gales 0 - 0 Hungria Sub 19Hungria 15
21 Sep 22 Bosnia Sub 19Bosnia 0 - 2 Polonia Sub 19Polonia 31
21 Sep 22 Italia Sub 19Italia 0 - 2 Estonia Sub 19Estonia 41
21 Sep 22 Austria Sub 19Austria 2 - 0 Lituania Sub 19Lituania 12
21 Sep 22 Letonia Sub 19Letonia 0 - 0 Rumanía Sub 19Rumanía 35
24 Sep 22 España Sub 19España 5 - 0 Albania Sub 19Albania 11
16 Nov 22 Francia Sub 19Francia 7 - 0 Kazajistán Sub 19Kazajistán 25
16 Nov 22 Islandia Sub 19Islandia 1 - 0 Escocia Sub 19Escocia 41
21 Sep 22 Inglaterra Sub 19Inglaterra 2 - 0 Montenegro Sub 19Montenegro 39
21 Sep 22 Georgia Sub 19Georgia 1 - 3 Dinamarca Sub 19Dinamarca 14
17 Nov 22 Macedonia del Norte Sub 19Macedonia 1 - 2 Serbia Sub 19Serbia 16
17 Nov 22 Noruega Sub 19Noruega 2 - 0 San Marino Sub 19Marino 9
16 Nov 22 Croacia Sub 19Croacia 6 - 0 Islas Feroe Sub 19Islas Feroe 18
16 Nov 22 Finlandia Sub 19Finlandia 0 - 4 Israel Sub 19Israel 5
21 Sep 22 Alemania Sub 19Alemania 5 - 0 Armenia Sub 19Armenia 8
21 Sep 22 Bielorrusia Sub 19Bielorrusia 1 - 1 Eslovaquia Sub 19Eslovaquia 33
21 Sep 22 Países Bajos Sub 19Países 2 - 0 Moldavia Sub 19Moldavia 4
21 Sep 22 Irlanda del Norte Sub 19Irlanda 2 - 2 Eslovenia Sub 19Eslovenia 2
21 Sep 22 Albania Sub 19Albania 1 - 3 Bélgica Sub 19Bélgica 10
Ver jornada
Jornada 2
24 Sep 22 República Checa Sub 19República 3 - 2 Suiza Sub 19Suiza 1
24 Sep 22 Grecia Sub 19Grecia 3 - 0 Andorra Sub 19Andorra ...
24 Sep 22 Bulgaria Sub 19Bulgaria 0 - 0 Luxemburgo Sub 19Luxemburgo 23
24 Sep 22 Turquia Sub 19Turquia 5 - 1 Azerbaiyán Sub 19Azerbaiyán 3
20 Nov 22 Suecia Sub 19Suecia 3 - 0 Kosovo Sub 19Kosovo 16
20 Nov 22 Ucrania Sub 19Ucrania 4 - 1 Chipre Sub 19Chipre 32
24 Sep 22 Hungria Sub 19Hungria 8 - 0 Gibraltar Sub 19Gibraltar 2
24 Sep 22 Irlanda Sub 19Irlanda 2 - 0 Gales Sub 19Gales 10
24 Sep 22 Italia Sub 19Italia 3 - 2 Bosnia Sub 19Bosnia 19
24 Sep 22 Polonia Sub 19Polonia 2 - 0 Estonia Sub 19Estonia 11
24 Sep 22 Austria Sub 19Austria 0 - 0 Letonia Sub 19Letonia 52
24 Sep 22 Rumanía Sub 19Rumanía 0 - 0 Lituania Sub 19Lituania 34
19 Nov 22 Francia Sub 19Francia 2 - 0 Islandia Sub 19Islandia 25
19 Nov 22 Escocia Sub 19Escocia 5 - 2 Kazajistán Sub 19Kazajistán 9
24 Sep 22 Dinamarca Sub 19Dinamarca 6 - 1 Montenegro Sub 19Montenegro 1
24 Sep 22 Inglaterra Sub 19Inglaterra 6 - 0 Georgia Sub 19Georgia 1
20 Nov 22 Noruega Sub 19Noruega 6 - 2 Macedonia del Norte Sub 19Macedonia 22
20 Nov 22 Serbia Sub 19Serbia 4 - 0 San Marino Sub 19Marino 3
19 Nov 22 Croacia Sub 19Croacia 1 - 2 Finlandia Sub 19Finlandia 22
19 Nov 22 Israel Sub 19Israel 2 - 0 Islas Feroe Sub 19Islas Feroe 16
24 Sep 22 Alemania Sub 19Alemania 5 - 1 Bielorrusia Sub 19Bielorrusia 9
24 Sep 22 Eslovaquia Sub 19Eslovaquia 2 - 0 Armenia Sub 19Armenia 17
24 Sep 22 Países Bajos Sub 19Países 0 - 0 Irlanda del Norte Sub 19Irlanda 18
24 Sep 22 Eslovenia Sub 19Eslovenia 4 - 0 Moldavia Sub 19Moldavia ...
Ver jornada
Jornada 3
27 Sep 22 Andorra Sub 19Andorra 0 - 2 Suiza Sub 19Suiza 1
27 Sep 22 Grecia Sub 19Grecia 1 - 1 República Checa Sub 19República 15
27 Sep 22 Bulgaria Sub 19Bulgaria 1 - 1 Turquia Sub 19Turquia 7
27 Sep 22 Luxemburgo Sub 19Luxemburgo 1 - 0 Azerbaiyán Sub 19Azerbaiyán ...
23 Nov 22 Kosovo Sub 19Kosovo 0 - 0 Chipre Sub 19Chipre ...
23 Nov 22 Suecia Sub 19Suecia 0 - 2 Ucrania Sub 19Ucrania ...
27 Sep 22 Gibraltar Sub 19Gibraltar 2 - 9 Gales Sub 19Gales 1
27 Sep 22 Hungria Sub 19Hungria 0 - 1 Irlanda Sub 19Irlanda 1
27 Sep 22 Estonia Sub 19Estonia 3 - 2 Bosnia Sub 19Bosnia 9
27 Sep 22 Polonia Sub 19Polonia 0 - 1 Italia Sub 19Italia 61
27 Sep 22 Lituania Sub 19Lituania 0 - 1 Letonia Sub 19Letonia 6
27 Sep 22 Rumanía Sub 19Rumanía 2 - 0 Austria Sub 19Austria 13
27 Sep 22 Bélgica Sub 19Bélgica 0 - 0 España Sub 19España 44
22 Nov 22 Kazajistán Sub 19Kazajistán 1 - 4 Islandia Sub 19Islandia 10
22 Nov 22 Escocia Sub 19Escocia 1 - 3 Francia Sub 19Francia 15
27 Sep 22 Dinamarca Sub 19Dinamarca 2 - 4 Inglaterra Sub 19Inglaterra 16
27 Sep 22 Montenegro Sub 19Montenegro 3 - 1 Georgia Sub 19Georgia ...
23 Nov 22 San Marino Sub 19Marino 0 - 2 Macedonia del Norte Sub 19Macedonia ...
23 Nov 22 Serbia Sub 19Serbia 2 - 0 Noruega Sub 19Noruega ...
22 Nov 22 Islas Feroe Sub 19Islas Feroe 1 - 5 Finlandia Sub 19Finlandia 3
22 Nov 22 Israel Sub 19Israel 0 - 3 Croacia Sub 19Croacia 11
27 Sep 22 Eslovaquia Sub 19Eslovaquia 0 - 1 Alemania Sub 19Alemania 21
27 Sep 22 Armenia Sub 19Armenia 1 - 1 Bielorrusia Sub 19Bielorrusia 10
27 Sep 22 Moldavia Sub 19Moldavia 0 - 2 Irlanda del Norte Sub 19Irlanda 1
27 Sep 22 Eslovenia Sub 19Eslovenia 0 - 0 Países Bajos Sub 19Países 17

Clasificación

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

  USO DE MEMORIA  
6,683,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4120
Total Execution Time  0.4139
  CADENA URL  
/clasificacion_europeo_sub_192023/grupo1/calendario
  GET DATOS  
$_GET['/clasificacion_europeo_sub_192023/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0105  SELECT type FROM routes WHERE alias = 'clasificacion_europeo_sub_192023'
0.0214  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_19' 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.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1841 AND type_rel = 3
0.0108  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1841 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  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 (1308149,1308075,1307769,1307757,1306188) ORDER BY n.cover_points DESC, update_date DESC
0.0113  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=199 ORDER BY l.group_code ASC
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=199 ORDER BY order_id ASC
0.0108  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1841 GROUP BY l.categoryId
0.0109  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1841 GROUP BY l.year ORDER BY l.year DESC
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 = 66164 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111  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 = 66164 ORDER BY round ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 03:14:34' 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-04-27 03:14:34' 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=4 AND last_update > '2024-04-27 03:14:34' 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-04-27 03:14:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  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_19' 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.0116  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1841 AND l.year = 2023
0.0111  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (66164,70720) 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.0110  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 (66164,70720) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (851053,892674,983318,886071,886529,964306,901811,908006,976159,3149614) ORDER BY rp.in_squad = 1 DESC
0.0116  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1841 AND l.year = 2023
0.0113  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (66164,70720) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0111  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 (66164,70720) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (822199,879410,955000,996539,886713,888415,888974,895024,906400,907159) ORDER BY rp.in_squad = 1 DESC
0.0116  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1841 AND l.year = 2023
0.0107  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (66164,70720) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0110  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 (66164,70720) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (879410,882916,886121,886713,887350,895148,900606,906400,918999,965038) ORDER BY rp.in_squad = 1 DESC
0.0129  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 = 66164 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC