Re
J'ai résolu en partie en créant un rapport avec la requête suivante trouvée sur le Wiki TNG (section rapport)
SQL: SELECT id, gedcom, place, longitude, latitude, notes FROM tng_places WHERE gedcom = 'Lucas' AND place IN ( SELECT pl.place FROM tng_places AS pl LEFT JOIN ( SELECT gedcom, birthplace AS place FROM tng_people WHERE gedcom = 'Lucas' UNION SELECT gedcom, altbirthplace FROM tng_people WHERE gedcom = 'Lucas' UNION SELECT gedcom, marrplace FROM tng_families WHERE gedcom = 'Lucas' UNION SELECT gedcom, divplace FROM tng_families WHERE gedcom = 'Lucas' UNION SELECT gedcom, deathplace FROM tng_people WHERE gedcom = 'Lucas' UNION SELECT gedcom, burialplace FROM tng_people WHERE gedcom = 'Lucas' UNION SELECT gedcom, eventplace FROM tng_events WHERE gedcom = 'Lucas' UNION SELECT gedcom, personID FROM tng_medialinks WHERE gedcom = 'Lucas' AND linktype='L' UNION SELECT 'Lucas' as gedcom, place FROM tng_cemeteries ) AS p USING ( gedcom, place ) WHERE pl.gedcom = 'Lucas' AND isnull( p.place ) )
J'ai la liste des lieux inutilisés. Il n'y en pas tellement, un peu de travail
Cdlt
François (Tarn, France)