select retrato.retrato, redes_sociales.*, biografia.en as biografia, paises.en, elo_feda.elo as eloEspanyol, elo_fce.elo as eloCatala, elo_fce.titulo as tituloCatala, federaciones.federacion, federaciones.bandera, sub_federaciones.federacion as subfederacion, sub_federaciones.bandera as banderaSub, paises.ca, paises.alpha2, rating2025.*, rating2025.titulo as titulo_rating, jugadores_general.*, jugadores_general.codigo_pais as banderaPais, clubs.club, clubs.logo, clubs.poblacion as poblacionClub, clubs.region as regionClub, clubs.provincia as provinciaClubs, clubs.codigo_pais as paisClub, clubs.id_club
FROM jugadores_general
left join clubs on jugadores_general.id_club=clubs.id_club
inner join rating2025 on jugadores_general.fide_id=rating2025.fide_id
inner join paises on jugadores_general.codigo_pais=paises.alpha2
left join federaciones on jugadores_general.id_federacion=federaciones.id_federacion
left join sub_federaciones on jugadores_general.id_subfederacion=sub_federaciones.id_federacion
left join elo_feda on jugadores_general.feda_id=elo_feda.id
left join redes_sociales on jugadores_general.fide_id=redes_sociales.fide_id
left join elo_fce on jugadores_general.fce_id=elo_fce.fce_id
left join retrato on jugadores_general.fide_id=retrato.fide_id
left join biografia on jugadores_general.fide_id=biografia.fide_id
where jugadores_general.fide_id='24585432'
Leo Gardner
Country
Spain
Rating Fide
1867
Rating Fide
1867
Rating Feda
1531
Rating Fce
1976
Penya d'Escacs Casino Prado Suburense
Sitges (Barcelona, ES)
Trajectory
- 2017 - Position 63 (Group b), 3.5 Points
- 2018 - Position 58 (Group b), 5 Points
- 2019 - Position 84 (Group b), 4.5 Points
- 2020 - Position 135 (Group a), 1.5 Points
- 2021 - Position 17 (Group b), 6.5 Points
- 2022 - Position 88 (Group b), 1.5 Points
Statistical data
59
Rounds played
29%
Win percentage
Statistics
*Only the Open tournament prizes are counted