4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2019
Temporada Siguiente »
Publicidad 600x120.gif
UEFA Youth League 2019
2018/2019

UEFA Youth League 2019

Resultados
 
F. Previas
Jornada Siguiente »
 
03 Oct 18
18:00 Finalizado 		Anderlecht Sub 19 Anderlecht Sub 19 0-0 Admira Wacker Sub 19 Admira Wacker Sub 19 más información ...
 
23 Oct 18
18:00 Finalizado 		Admira Wacker Sub 19 Admira Wacker Sub 19 1-1 Anderlecht Sub 19 Anderlecht Sub 19 más información Jugadas destacadas 1
30' D. Weber 1-0
1-1 89' S. Dewaele
Global
Anderlecht 1 - 1 Admira
 
03 Oct 18
19:00 Finalizado 		Hertha BSC Sub 19 Hertha BSC Sub 19 2-0 Lech Poznań Sub 19 Lech Poznań Sub 19 más información Jugadas destacadas 2
31' R. Werthmüller 1-0
89' J. Ngankam 2-0
 
24 Oct 18
16:00 Finalizado 		Lech Poznań Sub 19 Lech Poznań Sub 19 2-3 Hertha BSC Sub 19 Hertha BSC Sub 19 más información Jugadas destacadas ...
0-1 16' J. Ngankam
0-2 38' Jonas Michelbrink
43' D. Jastrzembski
57' Hubert Sobol 1-2
1-3 58' J. Albrecht
76' M. Skrzypczak 2-3
Global
Hertha 5 - 2 Lech Poznań
 
03 Oct 18
16:30 Finalizado 		Anzhi Sub 19 Anzhi Sub 19 3-2 Maccabi Tel Aviv Sub 19 Maccabi Tel Aviv Sub 19 más información Jugadas destacadas 3
0-1 36' E. Guerrero
49' M. Yagyaev 1-1
1-2 52' M. Shlaata
70' A. Saidov 2-2
83' G. Agalarov 3-2
 
24 Oct 18
16:00 Finalizado 		Maccabi Tel Aviv Sub 19 Maccabi Tel Aviv Sub 19 3-0 Anzhi Sub 19 Anzhi Sub 19 más información Jugadas destacadas ...
7' E. Guerrero 1-0
92' E. Guerrero 2-0
94' E. Guerrero 3-0
Global
Anzhi 3 - 5 Maccabi Aviv
 
03 Oct 18
14:00 Finalizado 		Chelsea Sub 19 Chelsea Sub 19 10-1 Molde FK Sub 19 Molde FK Sub 19 más información Jugadas destacadas 27
14' Charlie Brown 1-0
23' T. Moe
25' Billy Gilmour 3-0
26' Daishawn Redan 4-0
37' Billy Gilmour 5-0
39' Daishawn Redan 6-0
43' Charlie Brown 7-0
50' Daishawn Redan 8-0
57' Billy Gilmour 9-0
65' George Mceachran 10-0
10-1 72' Anders Iversen
 
24 Oct 18
18:00 Finalizado 		Molde FK Sub 19 Molde FK Sub 19 0-4 Chelsea Sub 19 Chelsea Sub 19 más información Jugadas destacadas ...
0-1 32' Tino Anjorin
0-2 81' Charlie Brown
0-3 83' Charlie Brown
0-4 90' Charlie Brown
Global
Chelsea 14 - 1 Molde
 
02 Oct 18
17:00 Finalizado 		Viitorul Sub 19 Viitorul Sub 19 0-1 Dinamo Zagreb Sub 19 Dinamo Zagreb Sub 19 más información Jugadas destacadas 3
0-1 37' Mario Čuže
 
23 Oct 18
15:00 Finalizado 		Dinamo Zagreb Sub 19 Dinamo Zagreb Sub 19 2-0 Viitorul Sub 19 Viitorul Sub 19 más información Jugadas destacadas 2
28' M. Leca
82' Mario Čuže 2-0
Global
Viitorul 0 - 3 Dinamo
 
03 Oct 18
16:00 Finalizado 		FC Basel Sub 19 FC Basel Sub 19 2-2 Hamilton Academical Sub 19 Hamilton Academical más información Jugadas destacadas 1
0-1 7' A. Douglas
13' Julian Von Moos 1-1
50' Yannick Marchand 2-1
2-2 76' A. Douglas
90' Yves Jankowski
 
24 Oct 18
20:00 Finalizado 		Hamilton Academical Sub 19 Hamilton Academical (3) 2-2 (2) FC Basel Sub 19 FC Basel Sub 19 más información Jugadas destacadas ...
19' A. Winter 1-0
1-1 35' Tician Tushi
1-2 85' Leandro Gaudiano
90' S. Slaven 2-2
Global Pen. (2-3) Pr.
 Basel 4 - 4 Hamilton
 
03 Oct 18
16:00 Finalizado 		Dinamo Kiev Sub 19 Dinamo Kiev Sub 19 1-0 Septemvri Sofia Sub 19 Septemvri Sofia Sub 19 más información Jugadas destacadas 1
41' V. Voloshyn 1-0
72' S. Kosov
 
24 Oct 18
16:00 Finalizado 		Septemvri Sofia Sub 19 Septemvri Sofia Sub 19 1-5 Dinamo Kiev Sub 19 Dinamo Kiev Sub 19 más información Jugadas destacadas ...
6' Dimitar Kostadinov 1-0
1-1 26' S. Buletsa
1-2 38' V. Voloshyn
1-3 49' G. Tsitaishvili
1-4 51' V. Voloshyn
1-5 88' Denys Popov
Global
Dinamo Kiev 6 - 1 Septemvri
 
03 Oct 18
19:00 Finalizado 		Žilina Sub 19 Žilina Sub 19 1-5 Montpellier Sub 19 Montpellier Sub 19 más información Jugadas destacadas 1
0-1 14' Y. Ammour
0-2 42' J. Vercruysse
0-3 44' A. Adouyev
0-4 53' Y. Ammour
63' J. Bernat 1-4
1-5 81' T. Vargas
90' Adam Kopas
 
24 Oct 18
15:00 Finalizado 		Montpellier Sub 19 Montpellier Sub 19 2-0 Žilina Sub 19 Žilina Sub 19 más información Jugadas destacadas 8
55' Y. Ammour 1-0
90' D. Scordato 2-0
Global
Žilina 1 - 7 Montpellier
 
03 Oct 18
18:00 Finalizado 		AEL Limassol Sub 19 AEL Limassol Sub 19 1-2 PAOK Sub 19 PAOK Sub 19 más información Jugadas destacadas 5
29' G. Gerolemou 1-0
31' E. Andreou
2-1 51' Theodoros Pournaras
85' E. Andreou
 
24 Oct 18
18:00 Finalizado 		PAOK Sub 19 PAOK Sub 19 2-0 AEL Limassol Sub 19 AEL Limassol Sub 19 más información Jugadas destacadas ...
45' A. Gaitanidis 1-0
50' A. Gaitanidis 2-0
Global
Limassol 1 - 4 PAOK Sub 19
 
03 Oct 18
17:00 Finalizado 		Sigma Olomouc Sub 19 Sigma Olomouc Sub 19 4-1 Maribor Sub 19 Maribor Sub 19 más información Jugadas destacadas 19
37' M. Galus 1-0
1-1 42' N. Zugelj
55' O. Zmrzly 2-1
61' J. Matousek 3-1
62' T. Zlatohlavek 4-1
 
24 Oct 18
18:00 Finalizado 		Maribor Sub 19 Maribor Sub 19 2-3 Sigma Olomouc Sub 19 Sigma Olomouc Sub 19 más información Jugadas destacadas 1
0-1 1' T. Zlatohlavek
36' Aljoša Matko 1-1
48' Aljoša Matko 2-1
2-2 54' T. Zlatohlavek
2-3 59' T. Zlatohlavek
63' D. Grygar
74' O. Zmrzly
Global
Sigma 7 - 3 Maribor
 
03 Oct 18
18:00 Finalizado 		Altinordu Sub 19 Altinordu Sub 19 1-1 HJK Helsinki Sub 19 HJK Helsinki Sub 19 más información Jugadas destacadas ...
56' B. Gormez 1-0
66' A. Colakoglu
1-1 86' T. Jantti
 
24 Oct 18
18:00 Finalizado 		HJK Helsinki Sub 19 HJK Helsinki Sub 19 1-2 Altinordu Sub 19 Altinordu Sub 19 más información Jugadas destacadas 2
0-1 67' K. Yurttadur
81' Enoch Banza 1-1
1-2 88' K. Yurttadur
Global
Altinordu 3 - 2 Helsinki
 
03 Oct 18
14:00 Finalizado 		FC Minsk Sub 19 FC Minsk Sub 19 1-0 Illés Akadémia Sub 19 Illés Akadémia Sub 19 más información Jugadas destacadas ...
44' H. Zherdzeu 1-0
 
24 Oct 18
16:30 Finalizado 		Illés Akadémia Sub 19 Illés Akadémia Sub 19 3-3 FC Minsk Sub 19 FC Minsk Sub 19 más información Jugadas destacadas ...
14' Máté Kovalovszki 1-0
15' M. Horváth 2-0
2-1 22' H. Zherdzeu
32' K. Toth-Gabor 3-1
53' D. Gruzhevskiy
3-2 70' D. Prishchepa
86' K. Toth-Gabor
3-3 90' D. Krapiunitski
Global
Minsk 4 - 3 Illés
 
03 Oct 18
17:00 Finalizado 		KR Reykjavík Sub 19 KR Reykjavík Sub 19 1-2 Elfsborg Sub 19 Elfsborg Sub 19 más información Jugadas destacadas ...
0-1 39' T. Stalheden
44' D. Kristinsson K. 1-1
70' H. Sigurdsson
 
24 Oct 18
18:00 Finalizado 		Elfsborg Sub 19 Elfsborg Sub 19 1-0 KR Reykjavík Sub 19 KR Reykjavík Sub 19 más información Jugadas destacadas ...
63' J. Sandberg Hesselgren 1-0
Global
Reykjavík 1 - 3 Elfsborg
 
03 Oct 18
18:30 Finalizado 		Midtjylland Sub 19 Midtjylland Sub 19 2-1 Bohemian FC Sub 19 Bohemian FC Sub 19 más información Jugadas destacadas 1
27' O. Sørensen 1-0
75' C. Tengstedt 2-0
2-1 77' S. Nolan
 
24 Oct 18
20:00 Finalizado 		Bohemian FC Sub 19 Bohemian FC Sub 19 1-2 Midtjylland Sub 19 Midtjylland Sub 19 más información Jugadas destacadas 1
43' A. Reghba 1-0
1-1 55' C. Tengstedt
77' M. Byrne
Global
Midtjylland 4 - 2 Bohemian
 
03 Oct 18
16:00 Finalizado 		Qabala Sub 19 Qabala Sub 19 1-1 Sheriff Sub 19 Sheriff Sub 19 más información Jugadas destacadas 2
0-1 31' D. Ignatov
57' A. Sadikhov 1-1
 
24 Oct 18
14:00 Finalizado 		Sheriff Sub 19 Sheriff Sub 19 1-3 Qabala Sub 19 Qabala Sub 19 más información Jugadas destacadas 3
0-1 43' S. Qurbanov
53' V. Nihaev 1-1
1-2 62' S. Qurbanov
63' V. Dijinari
Global
Qabala 4 - 2 Sheriff
 
04 Oct 18
09:00 Finalizado 		Astana Sub 19 Astana Sub 19 3-1 Vllaznia Shkodër Sub 19 Vllaznia Shkodër más información Jugadas destacadas ...
2' V. Prokopenko 1-0
10' V. Prokopenko 2-0
53' Madi Zhakipbayev 3-0
86' E. Lekaj
3-1 90' E. Qardaku
 
24 Oct 18
17:00 Finalizado 		Vllaznia Shkodër Sub 19 Vllaznia Shkodër 0-4 Astana Sub 19 Astana Sub 19 más información Jugadas destacadas 1
0-1 37' Z. Zhumadilov
0-2 61' S. Sagnayev
0-3 78' S. Sagnayev
0-4 89' S. Sagnayev
Global
Astana 7 - 1 Vllaznia


  USO DE MEMORIA  
5,804,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1208
Total Execution Time  0.1227
  CADENA URL  
/uefa_youth_league2019/grupo0/jornada1
  GET DATOS  
$_GET['/uefa_youth_league2019/grupo0/jornada1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0018  SELECT type FROM routes WHERE alias = 'uefa_youth_league2019'
0.0037  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 = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=529 AND type_rel = 3
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 529 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 (1312351,1312141,1311677,1306283,1301430) ORDER BY n.cover_points DESC, update_date DESC
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 = 45189 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2019' WHERE c.parentId=529 GROUP BY c.id ORDER BY c.order_id ASC
0.0017  SELECT type,rule FROM rules WHERE categoryId = 529 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 21:19:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0017  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 21:19:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0017  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 21:19:46' 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-04 21:19:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=45189 AND rel.round=1
0.0022  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 45189 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0018  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 45189 AND esl.points > 0
0.0017  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-04-04" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 45189 ORDER BY creation_date DESC LIMIT 0, 10
0.0025  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-04-04" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 45189
0.0051  SELECT c.isVideo, c.id,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,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2019` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 45189 AND c.`round` = 1 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200
0.0036  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2019 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2019 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 45189 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (191120,191121,191108,191109,191104,191105,191116,191117,191102,191103,191094,191095,191122,191123,191096,191097,191114,191115,191112,191113,191098,191099,191100,191101,191093,191092,191118,191119,191110,191111,191106,191107) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0019  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2019` e INNER JOIN calendars2019 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 1 AND e.real_date IS NOT NULL AND e.league_id = 45189 ORDER BY total DESC LIMIT 40
0.0019  SELECT distinct(shedule), round FROM `calendars2019` as c WHERE c.`league_id` = 45189 AND shedule >= '2018/10/01' AND shedule < '2018/11/01' ORDER BY shedule ASC
0.0017  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-05-04 00:00:00' AND c.`shedule` < '2024-05-08 23:59:59' AND l.id = 45189 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0029  SELECT data1, data2 FROM services_tags WHERE categoryId=529
0.0029  SELECT group_code, extraName from `leagues` WHERE categoryId=529 AND year=2019