select neighbour.iso,
       neighbour.name,
       neighbour.capital,
       neighbour.tld
from geoname.neighbour n
join geoname.country as neighbour ON neighbour.isocode = n.neighbour
join geoname.country as country ON country.isocode = n.isocode
where country.iso = 'FR';
