PHP: 8.1.33 | MySQL: 8.0.34

Messi vs Ronaldo at the age of Erling Haaland in the group stage of the Champions League in 2025

Erling Haaland
25 years, 2 months, 8 days
(29/09/2025)

Lionel Messi
at 25 years, 2 months, 8 days
(01/09/2012)

Cristiano Ronaldo
at 25 years, 2 months, 8 days
(13/04/2010)

Goals at 25 years, 2 months, 8 days

Age	Lionel Messi	Cristiano Ronaldo	Erling Haaland
15	0	0	0
16	0	0	1
17	1	5	12
18	11	6	24
19	30	23	65
20	51	36	113
21	92	62	155
22	140	102	211
23	197	132	256
24	279	160	301
25	286	170	316

Assists at 25 years, 2 months, 8 days

Age	Lionel Messi	Cristiano Ronaldo	Erling Haaland
15	0	0	0
16	0	0	0
17	0	4	2
18	6	7	6
19	10	21	13
20	27	32	25
21	46	44	35
22	57	53	44
23	84	66	50
24	121	70	56
25	121	75	59

Titles at 25 years, 2 months, 8 days

UEFA Champions League
Lionel Messi	Cristiano Ronaldo	Erling Haaland
UEFA Champions League2006 UEFA Champions League2009 UEFA Champions League2011	UEFA Champions League2008	UEFA Champions League2023
UEFA Champions League (2006) UEFA Champions League (2009) UEFA Champions League (2011)	UEFA Champions League (2008)	UEFA Champions League (2023)

UEFA Super Cup
Lionel Messi	Cristiano Ronaldo	Erling Haaland
Supercopa de la UEFA2009 Supercopa de la UEFA2011		Supercopa de la UEFA2023
UEFA Super Cup (2009) UEFA Super Cup (2011)		UEFA Super Cup (2023)

FIFA Club World Cup
Lionel Messi	Cristiano Ronaldo	Erling Haaland
Copa Mundial de Clubes de la FIFA2009 Copa Mundial de Clubes de la FIFA2011	Copa Mundial de Clubes de la FIFA2008	Copa Mundial de Clubes de la FIFA2023
FIFA Club World Cup (2009) FIFA Club World Cup (2011)	FIFA Club World Cup (2008)	FIFA Club World Cup (2023)

Leagues
Lionel Messi	Cristiano Ronaldo	Erling Haaland
La Liga2005 La Liga2006 La Liga2009 La Liga2010 La Liga2011	Premier League2007 Premier League2008 Premier League2009	Bundesliga de Austria2019 Bundesliga de Austria2020 Premier League2023 Premier League2024
La Liga (2005) La Liga (2006) La Liga (2009) La Liga (2010) La Liga (2011)	English Premier League (2007) English Premier League (2008) English Premier League (2009)	Austrian Bundesliga (2019) Austrian Bundesliga (2020) English Premier League (2023) English Premier League (2024)

Cups
Lionel Messi	Cristiano Ronaldo	Erling Haaland
Copa del Rey2009 Copa del Rey2012	FA Cup2004 EFL Cup2006 EFL Cup2009	Copa de Austria2019 Copa de Austria2020 Copa de Alemania2021 FA Cup2023
Copa del Rey (2009) Copa del Rey (2012)	FA Cup (2004) EFL Cup (2006) EFL Cup (2009)	Austrian Cup (2019) Austrian Cup (2020) DFB Pokal (2021) FA Cup (2023)

Super Cups
Lionel Messi	Cristiano Ronaldo	Erling Haaland
Supercopa de España2005 Supercopa de España2006 Supercopa de España2009 Supercopa de España2010 Supercopa de España2011	Supertaça Cândido de Oliveira2002 FA Community Shield2007 FA Community Shield2008	FA Community Shield2024
Spanish Super Cup (2005) Spanish Super Cup (2006) Spanish Super Cup (2009) Spanish Super Cup (2010) Spanish Super Cup (2011)	Supertaça Cândido de Oliveira (2002) FA Community Shield (2007) FA Community Shield (2008)	FA Community Shield (2024)

Trophies with junior National Teams
Lionel Messi	Cristiano Ronaldo	Erling Haaland
Copa Mundial de Fútbol Sub-202005 Medalla de Oro Olímpica2008
FIFA U-20 World Cup (2005) Olympic Gold Medal (2008)

Awards at 25 years, 2 months, 8 days

Main awards for the best player in the world
Lionel Messi	Cristiano Ronaldo	Erling Haaland
Balón de Oro2009 2009 Balón de Oro2010 Balón de Oro2011	Balón de Oro2008 2008
France Football Ballon d'Or (2009) FIFA World Player (2009) FIFA Ballon d'Or (2010) FIFA Ballon d'Or (2011)	France Football Ballon d'Or (2008) FIFA World Player (2008)

Best Player in the Continent awards
Lionel Messi	Cristiano Ronaldo	Erling Haaland
2009 Onze d'Or de Onze Mondial2009 Jugador del Año de la UEFA2011 Onze d'Or de Onze Mondial2011	2008 Onze d'Or de Onze Mondial2008	Jugador del Año de la UEFA2023 Onze d'Or de Onze Mondial2023
UEFA Club Footballer of the Year (2009) Onze Mondial European Footballer of the Year (2009) UEFA Men's Player of the Year (2011) Onze Mondial European Footballer of the Year (2011)	UEFA Club Footballer of the Year (2008) Onze Mondial European Footballer of the Year (2008)	UEFA Men's Player of the Year (2023) Onze Mondial European Footballer of the Year (2023)

Best Player in his Country awards
Lionel Messi	Cristiano Ronaldo	Erling Haaland
2005 2007 2008 2009 2010 2011 2011	2007 2008 2009	2020 2021 2022 2023 2024
Olimpia de Plata - Argentine Player of the Year (2005) Olimpia de Plata - Argentine Player of the Year (2007) Olimpia de Plata - Argentine Player of the Year (2008) Olimpia de Plata - Argentine Player of the Year (2009) Olimpia de Plata - Argentine Player of the Year (2010) Olimpia de Oro - Argentine Sportsperson of the Year (2011) Olimpia de Plata - Argentine Player of the Year (2011)	CNID - Best Portuguese Athlete Abroad (2007) CNID - Best Portuguese Athlete Abroad (2008) CNID - Best Portuguese Athlete Abroad (2009)	(2020) (2021) (2022) (2023) (2024)

Player Of The Tournament awards
Lionel Messi	Cristiano Ronaldo	Erling Haaland
Mejor jugador del Mundial sub-202005 2007 Balón de Oro del Mundial de Clubes2009 2009 Jugador del Año de La Liga2009 Trofeo Alfredo Di Stefano2009 2010 Jugador del Año de La Liga2010 Trofeo Alfredo Di Stefano2010 Balón de Oro del Mundial de Clubes2011 2011 Jugador del Año de La Liga2011 Trofeo Alfredo Di Stefano2011 Jugador del Año de La Liga2012	Futbolista del año en Inglaterra (PFA)2007 Jugador del Año de la Premier League2007 2007 2007 Futbolista del año en Inglaterra (PFA)2008 Jugador del Año de la Premier League2008 2008 2008	Jugador del año en Austria2019 MVP Bundesliga2021 Jugador del Año de la Premier League2023
FIFA U-20 World Cup Best Player (2005) EFE Award - Best ibero-american player in La Liga (2007) FIFA Club World Cup Golden Ball (2009) EFE Award - Best ibero-american player in La Liga (2009) La Liga MVP (2009) Alfredo Di Stéfano Trophy - Best player in La Liga (2009) EFE Award - Best ibero-american player in La Liga (2010) La Liga MVP (2010) Alfredo Di Stéfano Trophy - Best player in La Liga (2010) FIFA Club World Cup Golden Ball (2011) EFE Award - Best ibero-american player in La Liga (2011) La Liga MVP (2011) Alfredo Di Stéfano Trophy - Best player in La Liga (2011) La Liga MVP (2012)	PFA Player of the Year in England (2007) Premier League Player of the Season (2007) FWA Footballer of the Year in England (2007) PFA Fans' Player of the Year in England (2007) PFA Player of the Year in England (2008) Premier League Player of the Season (2008) FWA Footballer of the Year in England (2008) PFA Fans' Player of the Year in England (2008)	(2019) (2021) Premier League Player of the Season (2023)

Top Goalscorer awards
Lionel Messi	Cristiano Ronaldo	Erling Haaland
Máximo goleador de la Champions League2009 Bota de Oro2010 Trofeo Pichichi de La Liga española2010 Máximo goleador de la Champions League2010 Máximo goleador de la Champions League2011 Bota de Oro2012 Trofeo Pichichi de La Liga española2012 Máximo goleador de la Champions League2012	Bota de Oro2008 Bota de Oro de la Premier League2008 Máximo goleador de la Champions League2008	Máximo goleador del Mundial Sub-202019 Máximo goleador de la Champions League2021 Bota de Oro2023 Bota de Oro de la Premier League2023 Trofeo Gerd Müller2023 Máximo goleador de la Champions League2023 Bota de Oro de la Premier League2024
UEFA Champions League Top Scorer (2009) European Golden Shoe (2010) Pichichi Trophy (2010) UEFA Champions League Top Scorer (2010) UEFA Champions League Top Scorer (2011) European Golden Shoe (2012) Pichichi Trophy (2012) UEFA Champions League Top Scorer (2012)	European Golden Shoe (2008) Premier League Golden Boot (2008) UEFA Champions League Top Scorer (2008)	FIFA U20 World Cup top scorer (2019) UEFA Champions League Top Scorer (2021) European Golden Shoe (2023) Premier League Golden Boot (2023) Gerd Müller Trophy (2023) UEFA Champions League Top Scorer (2023) Premier League Golden Boot (2024)

Best young player awards
Lionel Messi	Cristiano Ronaldo	Erling Haaland
Golden Boy de Tuttosport2005 FIFPro Jugador joven del año2006 Mejor jugador joven de la Copa América2007 Trofeo Bravo del Guerin Sportivo2007	Trofeo Bravo del Guerin Sportivo2004 2007	Mejor jugador joven de la Liga Noruega2018 Golden Boy de Tuttosport2020
Golden Boy (2005) FIFPro Young Player of the Year (2006) Copa America Best Young Player (2007) Bravo Award (2007)	Bravo Award (2004) PFA Young Player of the Year in England (2007)	Norwegian Eliteserien Best Young Player (2018) Golden Boy (2020)

IFFHS awards
Lionel Messi	Cristiano Ronaldo	Erling Haaland
2011		Mejor extremo zurdo2022 Mejor jugador del año2023 Mejor delantero centro2023 Mejor delantero centro2024
World's Best Top Division Goal Scorer (2011)		World's Best Football Men Left Winger (2022) Men's World Best Player (2023) World's Best Football Center Forward (2023) World's Best Football Center Forward (2024)

Best goal awards
Lionel Messi	Cristiano Ronaldo	Erling Haaland
	Premio Puskás de la FIFA2009
	FIFA Puskás Award (2009)

SELECT D.*, ( SELECT DATE_FORMAT(MAX(DateUpdated), '%d/%m/%Y') FROM VW_WHOSCORED2) LastUpdate FROM ( SELECT /* mc_partidos_new o mc_partidos_inferiores */ (SELECT COUNT(DISTINCT Temporada) FROM mc_partidos_new T WHERE idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) TemporadasMessi, (SELECT COUNT(DISTINCT Temporada) FROM mc_partidos_new T WHERE idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) TemporadasCristiano, (SELECT COUNT(*) FROM mc_partidos_new T WHERE idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) PartidosMessi, (SELECT COUNT(*) FROM mc_partidos_new T WHERE idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) PartidosCristiano, (SELECT SUM(GolesJugador) FROM mc_partidos_new T WHERE idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) GolesMessi, (SELECT SUM(GolesJugador) FROM mc_partidos_new T WHERE idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) GolesCristiano, (SELECT SUM(Asistencias) FROM mc_partidos_new T WHERE idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) AsistenciasMessi, (SELECT SUM(Asistencias) FROM mc_partidos_new T WHERE idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) AsistenciasCristiano, (SELECT SUM(A.Asistencias)+SUM(AsistenciasRebote)+SUM(AsistenciasPenalti)+SUM(AsistenciasPropiaPuerta)+SUM(AsistenciasPoste)+SUM(AsistenciasRebotePortero)+SUM(AsistenciasFalta)+SUM(AsistenciasOtras) FROM mc_asistencias A INNER JOIN mc_partidos_new T ON A.idPartido = T.id WHERE T.idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) AsistenciasIndirectasMessi, (SELECT SUM(A.Asistencias)+SUM(AsistenciasRebote)+SUM(AsistenciasPenalti)+SUM(AsistenciasPropiaPuerta)+SUM(AsistenciasPoste)+SUM(AsistenciasRebotePortero)+SUM(AsistenciasFalta)+SUM(AsistenciasOtras) FROM mc_asistencias A INNER JOIN mc_partidos_new T ON A.idPartido = T.id WHERE T.idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) AsistenciasIndirectasCristiano, (SELECT SUM(GolesJugador)/COUNT(*) FROM mc_partidos_new T WHERE idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) RatioMessi, (SELECT SUM(GolesJugador)/COUNT(*) FROM mc_partidos_new T WHERE idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) RatioCristiano, (SELECT SUM(Minutos)/SUM(GolesJugador) FROM mc_partidos_new T WHERE idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) MinutosMessi, (SELECT SUM(Minutos)/SUM(GolesJugador) FROM mc_partidos_new T WHERE idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) MinutosCristiano, (SELECT SUM(Minutos)/SUM(Asistencias) FROM mc_partidos_new T WHERE idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) MinutosAMessi, (SELECT SUM(Minutos)/SUM(Asistencias) FROM mc_partidos_new T WHERE idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) MinutosACristiano, (SELECT SUM(Minutos)/(SUM(GolesJugador)+SUM(Asistencias)) FROM mc_partidos_new T WHERE idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) MinutosIMessi, (SELECT SUM(Minutos)/(SUM(GolesJugador)+SUM(Asistencias)) FROM mc_partidos_new T WHERE idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) MinutosICristiano, (SELECT COUNT(DISTINCT Competicion, Temporada) FROM mc_partidos_new T WHERE idJugador = 1 AND Competicion NOT IN ('Fase previa de Champions League','Amistoso (Oficial) de Selecciones','Clasificación para Mundial','Clasificación para Eurocopa') AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) DisputadosMessi, (SELECT COUNT(DISTINCT Competicion, Temporada) FROM mc_partidos_new T WHERE idJugador = 2 AND Competicion NOT IN ('Fase previa de Champions League','Amistoso (Oficial) de Selecciones','Clasificación para Mundial','Clasificación para Eurocopa') AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) DisputadosCristiano, (SELECT SUM(GolesJugador)-SUM(DePenalti) FROM mc_partidos_new T WHERE idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) GolesMessiNoPen, (SELECT SUM(GolesJugador)-SUM(DePenalti) FROM mc_partidos_new T WHERE idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) GolesCristianoNoPen, (SELECT round((SELECT SUM(GolesJugador)-SUM(DePenalti) FROM mc_partidos_new T WHERE idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025)*100/(SELECT SUM(GolesJugador) FROM mc_partidos_new T WHERE idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025),2)) GolesMessiNoPenPerc, (SELECT round((SELECT SUM(GolesJugador)-SUM(DePenalti) FROM mc_partidos_new T WHERE idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025)*100/(SELECT SUM(GolesJugador) FROM mc_partidos_new T WHERE idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025),2)) GolesCristianoNoPenPerc, (SELECT sum(defalta) FROM mc_partidos_new T WHERE idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) GolesMessiFalta, (SELECT sum(defalta) FROM mc_partidos_new T WHERE idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) GolesCristianoFalta, /* mc_jugadores_titulos */ (SELECT COUNT(*) FROM ( SELECT T.*, TI.Nombre Competicion FROM mc_jugadores_titulos T INNER JOIN mc_titulos TI ON T.idTitulo = TI.idTitulo WHERE T.idJugador = 1 AND T.idTitulo IS NOT NULL and T.idTitulo NOT IN (39,41,42,43,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64)) T WHERE Competicion /* 1 */ IS NOT NULL AND YEAR(T.Fecha) = 2025) TitulosMessi, (SELECT COUNT(*) FROM ( SELECT T.*, TI.Nombre Competicion FROM mc_jugadores_titulos T INNER JOIN mc_titulos TI ON T.idTitulo = TI.idTitulo WHERE T.idJugador = 2 AND T.idTitulo IS NOT NULL and T.idTitulo NOT IN (39,41,42,43,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64)) T WHERE Competicion /* 1 */ IS NOT NULL AND YEAR(T.Fecha) = 2025) TitulosCristiano, (SELECT COUNT(*) FROM mc_jugadores_titulos T WHERE idJugador = 1 AND idGalardon IN (1,130)) BdOMessi, (SELECT COUNT(*) FROM mc_jugadores_titulos T WHERE idJugador = 2 AND idGalardon IN (1,130)) BdOCristiano, (SELECT COUNT(*) FROM mc_jugadores_titulos T WHERE idJugador = 1 AND idGalardon = 2) BtdOMessi, (SELECT COUNT(*) FROM mc_jugadores_titulos T WHERE idJugador = 2 AND idGalardon = 2) BtdOCristiano, /* VW_WHOSCORED2 */ (SELECT SUM(TirosDiestra+TirosZurda+TirosCabeza+TirosOtro) / SUM(GolesAreaPeq+GolesArea+GolesFueraArea) TirosPorGol FROM VW_WHOSCORED2 WHERE idJugador = 1) TirosPorGolMessi, (SELECT SUM(TirosDiestra+TirosZurda+TirosCabeza+TirosOtro) / SUM(GolesAreaPeq+GolesArea+GolesFueraArea) TirosPorGol FROM VW_WHOSCORED2 WHERE idJugador = 2) TirosPorGolCristiano, (SELECT SUM(GolesFueraArea) FROM VW_WHOSCORED2 WHERE idJugador = 1) FueraAreaMessi, (SELECT SUM(GolesFueraArea) FROM VW_WHOSCORED2 WHERE idJugador = 2) FueraAreaCristiano, (SELECT SUM(GolesArea) FROM VW_WHOSCORED2 WHERE idJugador = 1) GolesAreaMessi, (SELECT SUM(GolesArea) FROM VW_WHOSCORED2 WHERE idJugador = 2) GolesAreaCristiano, (SELECT SUM(GolesAreaPeq) FROM VW_WHOSCORED2 WHERE idJugador = 1) GolesAreaPeqMessi, (SELECT SUM(GolesAreaPeq) FROM VW_WHOSCORED2 WHERE idJugador = 2) GolesAreaPeqCristiano, (SELECT SUM(RegatesExitosos) FROM VW_WHOSCORED2 WHERE idJugador = 1) RegatesMessi, (SELECT SUM(RegatesExitosos) FROM VW_WHOSCORED2 WHERE idJugador = 2) RegatesCristiano, (SELECT round((SUM(RegatesExitosos)*100)/SUM(RegatesTotal),2) FROM VW_WHOSCORED2 WHERE idJugador = 1 and temporada not in ('2004/2005', '2005/2006', '2006/2007', '2007/2008', '2008/2009')) EfRegatesMessi, (SELECT round((SUM(RegatesExitosos)*100)/SUM(RegatesTotal),2) FROM VW_WHOSCORED2 WHERE idJugador = 2 and temporada not in ('2003/2004', '2004/2005', '2005/2006', '2006/2007', '2007/2008', '2008/2009')) EfRegatesCristiano, (SELECT SUM(PaseLargoPreciso)+SUM(PaseCortoPreciso) FROM VW_WHOSCORED2 WHERE idJugador = 1) PasesMessi, (SELECT SUM(PaseLargoPreciso)+SUM(PaseCortoPreciso) FROM VW_WHOSCORED2 WHERE idJugador = 2) PasesCristiano, (SELECT (SUM(PaseLargoPreciso)+SUM(PaseCortoPreciso)) * 100 / (SUM(PaseLargoPreciso)+SUM(PaseCortoPreciso)+SUM(PaseLargoImpreciso)+SUM(PaseCortoImpreciso)) FROM VW_WHOSCORED2 WHERE idJugador = 1) EfPasesMessi, (SELECT (SUM(PaseLargoPreciso)+SUM(PaseCortoPreciso)) * 100 / (SUM(PaseLargoPreciso)+SUM(PaseCortoPreciso)+SUM(PaseLargoImpreciso)+SUM(PaseCortoImpreciso)) FROM VW_WHOSCORED2 WHERE idJugador = 2) EfPasesCristiano, (SELECT (SUM(PaseLargoPreciso)) * 100 / (SUM(PaseLargoPreciso)+SUM(PaseLargoImpreciso)) FROM VW_WHOSCORED2 WHERE idJugador = 1) EfPaseLargoMessi, (SELECT (SUM(PaseLargoPreciso)) * 100 / (SUM(PaseLargoPreciso)+SUM(PaseLargoImpreciso)) FROM VW_WHOSCORED2 WHERE idJugador = 2) EfPaseLargoCristiano, (SELECT (SUM(PaseCortoPreciso)) * 100 / (SUM(PaseCortoPreciso)+SUM(PaseCortoImpreciso)) FROM VW_WHOSCORED2 WHERE idJugador = 1) EfPaseCortoMessi, (SELECT (SUM(PaseCortoPreciso)) * 100 / (SUM(PaseCortoPreciso)+SUM(PaseCortoImpreciso)) FROM VW_WHOSCORED2 WHERE idJugador = 2) EfPaseCortoCristiano, (SELECT SUM(PaseClave) FROM VW_WHOSCORED2 WHERE idJugador = 1) PasesClaveMessi, (SELECT SUM(PaseClave) FROM VW_WHOSCORED2 WHERE idJugador = 2) PasesClaveCristiano, /* vw_finales2 */ (SELECT sum(Victoria) FROM vw_finales2 T where idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) FinalesGanadasMessi, (SELECT sum(Victoria) FROM vw_finales2 T where idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) FinalesGanadasCristiano, (SELECT COUNT(*) FROM vw_finales2 T where Victoria = 0 and idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) FinalesPerdidasMessi, (SELECT COUNT(*) FROM vw_finales2 T where Victoria = 0 and idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) FinalesPerdidasCristiano, (SELECT sum(Goles) FROM vw_finales2 T where idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) GolesFinalesMessi, (SELECT sum(Goles) FROM vw_finales2 T where idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) GolesFinalesCristiano, (SELECT sum(Asistencias) FROM vw_finales2 T where idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) AsistenciasFinalesMessi, (SELECT sum(Asistencias) FROM vw_finales2 T where idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) AsistenciasFinalesCristiano, (SELECT count(*) FROM vw_finales2 T where idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) FinalesMessi, (SELECT count(*) FROM vw_finales2 T where idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) FinalesCristiano, (SELECT COALESCE(round(SUM(Goles)/SUM(Partidos),2), 0) FROM vw_finales2 T where idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) GolesPartidoMessiFinales, (SELECT COALESCE(round(SUM(Goles)/SUM(Partidos),2), 0) FROM vw_finales2 T where idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) GolesPartidoCristianoFinales, (SELECT COALESCE(round(SUM(Asistencias)/SUM(Partidos),2), 0) FROM vw_finales2 T where idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) AsistenciasPartidoMessiFinales, (SELECT COALESCE(round(SUM(Asistencias)/SUM(Partidos),2), 0) FROM vw_finales2 T where idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) AsistenciasPartidoCristianoFinales, (SELECT COALESCE(round((SUM(Goles)+SUM(Asistencias))/SUM(Partidos),2), 0) FROM vw_finales2 T where idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) ContribucionMessiFinales, (SELECT COALESCE(round((SUM(Goles)+SUM(Asistencias))/SUM(Partidos),2), 0) FROM vw_finales2 T where idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) ContribucionCristianoFinales, (SELECT COALESCE(round(SUM(Minutos)/(SUM(Goles)+SUM(Asistencias)),2), 0) FROM vw_finales2 T where idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) ContribucionMessiFinalesMin, (SELECT COALESCE(round(SUM(Minutos)/(SUM(Goles)+SUM(Asistencias)),2), 0) FROM vw_finales2 T where idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) ContribucionCristianoFinalesMin, (SELECT COALESCE(round(SUM(Minutos)/(SUM(Goles)),2), 0) FROM vw_finales2 T where idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) GolMessiFinalesMin, (SELECT COALESCE(round(SUM(Minutos)/(SUM(Goles)),2), 0) FROM vw_finales2 T where idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) GolCristianoFinalesMin, (SELECT COALESCE(round(SUM(Minutos)/(SUM(Asistencias)),2), 0) FROM vw_finales2 T where idJugador = 1 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) AsistenciaMessiFinalesMin, (SELECT COALESCE(round(SUM(Minutos)/(SUM(Asistencias)),2), 0) FROM vw_finales2 T where idJugador = 2 AND T.Competicion IN ('Champions League','UEFA Champions League') AND T.Ronda = 'Fase de grupos' AND YEAR(T.Fecha) = 2025) AsistenciaCristianoFinalesMin, /* Fechas */ (SELECT FechaNacimiento FROM mc_jugadores WHERE id = 1) FechaNacimientoMessi, (SELECT FechaNacimiento FROM mc_jugadores WHERE id = 2) FechaNacimientoCristiano, (SELECT FechaNacimiento FROM mc_jugadores WHERE id = 10) FechaNacimientoMbappe, (SELECT FechaNacimiento FROM mc_jugadores WHERE id = 9) FechaNacimientoHaaland ) D LIMIT 1;