4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
24 Oct 19 Qabala Sub 19Qabala 0 - 1 APOEL Sub 19APOEL 4
02 Oct 19 APOEL Sub 19APOEL 1 - 1 Qabala Sub 19Qabala ...
09 Oct 19 Zaragoza Sub 19Zaragoza 1 - 0 Korona Kielce Sub 19Korona 33
23 Oct 19 Korona Kielce Sub 19Korona 1 - 4 Zaragoza Sub 19Zaragoza 48
02 Oct 19 FC Minsk Sub 19Minsk 0 - 2 Derby County Sub 19Derby ...
22 Oct 19 Derby County Sub 19Derby 7 - 2 FC Minsk Sub 19Minsk 6
02 Oct 19 Sogndal Sub 19Sogndal 3 - 1 FC Honka Sub 19Honka ...
24 Oct 19 FC Honka Sub 19Honka 1 - 1 Sogndal Sub 19Sogndal 4
02 Oct 19 ÍA Akranes Sub 19Akranes 4 - 0 Levadia Sub 19Levadia ...
23 Oct 19 Levadia Sub 19Levadia 1 - 12 ÍA Akranes Sub 19Akranes 5
02 Oct 19 Bohemian FC Sub 19Bohemian 1 - 1 PAOK Sub 19PAOK ...
23 Oct 19 PAOK Sub 19PAOK 1 - 0 Bohemian FC Sub 19Bohemian ...
02 Oct 19 Stade Rennais Sub 19Stade 2 - 1 Brodarac Sub 19Brodarac ...
23 Oct 19 Brodarac Sub 19Brodarac 0 - 0 Stade Rennais Sub 19Stade ...
03 Oct 19 Young Boys Sub 19Young Boys 3 - 3 Rangers FC Sub 19Rangers 4
23 Oct 19 Rangers FC Sub 19Rangers 2 - 2 Young Boys Sub 19Young Boys ...
02 Oct 19 Porto Sub 19Porto 4 - 2 FK Liepāja Sub 19Liepāja ...
23 Oct 19 FK Liepāja Sub 19Liepāja 0 - 3 Porto Sub 19Porto 6
02 Oct 19 Viitorul Sub 19Viitorul 0 - 0 Domžale Sub 19Domžale ...
22 Oct 19 Domžale Sub 19Domžale 2 - 0 Viitorul Sub 19Viitorul 1
23 Oct 19 Ludogorets Sub 19Ludogorets 1 - 0 Slovan Bratislava Sub 19Slovan ...
02 Oct 19 Slovan Bratislava Sub 19Slovan 1 - 0 Ludogorets Sub 19Ludogorets ...
02 Oct 19 Dinamo Kiev Sub 19Dinamo Kiev 8 - 0 Shkëndija Sub 19Shkëndija ...
23 Oct 19 Shkëndija Sub 19Shkëndija 2 - 2 Dinamo Kiev Sub 19Dinamo Kiev ...
05 Oct 19 Astana Sub 19Astana 1 - 0 Maccabi Petah Tikva Sub 19Maccabi ...
23 Oct 19 Maccabi Petah Tikva Sub 19Maccabi 4 - 0 Astana Sub 19Astana ...
02 Oct 19 Shkëndija Tiranë Sub 19Shkëndija 1 - 2 Sheriff Sub 19Sheriff 1
23 Oct 19 Sheriff Sub 19Sheriff 1 - 0 Shkëndija Tiranë Sub 19Shkëndija ...
02 Oct 19 MTK Budapest Sub 19Budapest 1 - 1 Zrinjski Mostar Sub 19Zrinjski ...
23 Oct 19 Zrinjski Mostar Sub 19Zrinjski 2 - 0 MTK Budapest Sub 19Budapest ...
02 Oct 19 Elfsborg Sub 19Elfsborg 1 - 2 Midtjylland Sub 19Midtjylland ...
23 Oct 19 Midtjylland Sub 19Midtjylland 1 - 0 Elfsborg Sub 19Elfsborg 1
Ver jornada
Jornada 2
06 Nov 19 Sheriff Sub 19Sheriff 2 - 0 Sogndal Sub 19Sogndal ...
27 Nov 19 Sogndal Sub 19Sogndal 3 - 1 Sheriff Sub 19Sheriff ...
06 Nov 19 Zaragoza Sub 19Zaragoza 5 - 0 APOEL Sub 19APOEL 75
27 Nov 19 APOEL Sub 19APOEL 0 - 4 Zaragoza Sub 19Zaragoza 35
04 Nov 19 Midtjylland Sub 19Midtjylland 3 - 1 Zrinjski Mostar Sub 19Zrinjski 5
26 Nov 19 Zrinjski Mostar Sub 19Zrinjski 0 - 0 Midtjylland Sub 19Midtjylland 6
06 Nov 19 ÍA Akranes Sub 19Akranes 1 - 2 Derby County Sub 19Derby ...
27 Nov 19 Derby County Sub 19Derby 4 - 1 ÍA Akranes Sub 19Akranes ...
06 Nov 19 Porto Sub 19Porto 2 - 2 Domžale Sub 19Domžale 21
27 Nov 19 Domžale Sub 19Domžale 0 - 3 Porto Sub 19Porto 4
06 Nov 19 Dinamo Kiev Sub 19Dinamo Kiev 3 - 0 PAOK Sub 19PAOK 2
27 Nov 19 PAOK Sub 19PAOK 2 - 2 Dinamo Kiev Sub 19Dinamo Kiev 6
06 Nov 19 Rangers FC Sub 19Rangers 2 - 0 Slovan Bratislava Sub 19Slovan ...
27 Nov 19 Slovan Bratislava Sub 19Slovan 1 - 2 Rangers FC Sub 19Rangers 2
06 Nov 19 Stade Rennais Sub 19Stade 2 - 0 Maccabi Petah Tikva Sub 19Maccabi ...
04 Dic 19 Maccabi Petah Tikva Sub 19Maccabi 0 - 1 Stade Rennais Sub 19Stade 1
Ver jornada
Jornada 3
11 Feb 20 Derby County Sub 19Derby 3 - 1 B. Dortmund Sub 19Dortmund 12
12 Feb 20 Porto Sub 19Porto 1 - 1 Salzburg Sub 19Salzburg 11
12 Feb 20 Zaragoza Sub 19Zaragoza 1 - 3 Olympique Lyonnais Sub 19Olympique 51
12 Feb 20 Dinamo Kiev Sub 19Dinamo Kiev 0 - 0 Dinamo Zagreb Sub 19Dinamo 8
12 Feb 20 Sheriff Sub 19Sheriff 0 - 0 Crvena Zvezda Sub 19Crvena 1
12 Feb 20 Rangers FC Sub 19Rangers 0 - 4 Atlético Sub 19Atlético 10
12 Feb 20 Midtjylland Sub 19Midtjylland 1 - 1 Lille Sub 19Lille 5
12 Feb 20 Stade Rennais Sub 19Stade 1 - 1 Club Brugge Sub 19Club Brugge 1
Ver jornada
Jornada 4
04 Mar 20 Bayern München Sub 19Bayern 2 - 2 Dinamo Zagreb Sub 19Dinamo 13
03 Mar 20 Ajax Sub 19Ajax 0 - 0 Atlético Sub 19Atlético 27
10 Mar 20 Atalanta Sub 19Atalanta 3 - 3 Olympique Lyonnais Sub 19Olympique 5
16 Ago 20 Inter Sub 19Inter 1 - 0 Stade Rennais Sub 19Stade 7
04 Mar 20 Salzburg Sub 19Salzburg 4 - 1 Derby County Sub 19Derby 3
03 Mar 20 Benfica Sub 19Benfica 4 - 1 Liverpool Sub 19Liverpool 5
04 Mar 20 Crvena Zvezda Sub 19Crvena 0 - 3 Midtjylland Sub 19Midtjylland 5
16 Ago 20 Juventus Sub 19Juventus 1 - 3 Real Madrid Sub 19Real Madrid 64
Ver jornada
Jornada 5
18 Ago 20 Midtjylland Sub 19Midtjylland 1 - 3 Ajax Sub 19Ajax 26
18 Ago 20 Dinamo Zagreb Sub 19Dinamo 1 - 3 Benfica Sub 19Benfica 14
19 Ago 20 Salzburg Sub 19Salzburg 4 - 3 Olympique Lyonnais Sub 19Olympique 25
19 Ago 20 Inter Sub 19Inter 0 - 3 Real Madrid Sub 19Real Madrid 79
Ver jornada
Jornada 6
22 Ago 20 Ajax Sub 19Ajax 0 - 3 Benfica Sub 19Benfica 29
22 Ago 20 Salzburg Sub 19Salzburg 1 - 2 Real Madrid Sub 19Real Madrid 73
Ver jornada
Jornada 7
25 Ago 20 Benfica Sub 19Benfica 2 - 3 Real Madrid Sub 19Real Madrid 161

  USO DE MEMORIA  
4,755,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0814
Total Execution Time  0.0833
  CADENA URL  
/uefa_youth_league2020/grupo0/calendario
  GET DATOS  
$_GET['/uefa_youth_league2020/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'uefa_youth_league2020'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'uefa_youth_league' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  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 = 51242 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 51242 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-05-06 23:21:27' 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-05-06 23:21:27' 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-05-06 23:21:27' 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=3 AND last_update > '2024-05-06 23:21:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 529 AND l.year = 2020
0.0028  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (51242,51243,51244,51245,51246,51247,51248,51249,51250) 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.0025  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 (51242,51243,51244,51245,51246,51247,51248,51249,51250) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (677933,693526,428828,453979,769329,426835,427688,427721,696596,776733) ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 529 AND l.year = 2020
0.0030  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (51242,51243,51244,51245,51246,51247,51248,51249,51250) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0028  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 (51242,51243,51244,51245,51246,51247,51248,51249,51250) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (661999,677931,346760,374532,429348,776278,776624,798690,342393,343318) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 529 AND l.year = 2020
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (51242,51243,51244,51245,51246,51247,51248,51249,51250) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0023  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 (51242,51243,51244,51245,51246,51247,51248,51249,51250) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (342273,343318,374521,426907,427165,427510,427599,427904,454006,622200) ORDER BY rp.in_squad = 1 DESC