Report: Unused place names
Description: Places which aren't used.
Copy and paste the text between the lines into the reports section below "OR Leave Display, Criteria and Sort fields blank and enter direct SQL SELECT statement here:" and give it the title you think is appropriate
To custom this report, please replace "00001" against "Your-Gedcom-Name"!
SELECT id, gedcom, place, longitude, latitude, notes FROM tng_places WHERE gedcom = '00001' AND place IN ( SELECT pl.place FROM tng_places AS pl LEFT JOIN ( SELECT gedcom, birthplace AS place FROM `tng_people` WHERE gedcom = '00001' UNION SELECT gedcom, altbirthplace FROM `tng_people` WHERE gedcom = '00001' UNION SELECT gedcom, marrplace FROM `tng_families` WHERE gedcom = '00001' UNION SELECT gedcom, deathplace FROM `tng_people` WHERE gedcom = '00001' UNION SELECT gedcom, burialplace FROM `tng_people` WHERE gedcom = '00001' UNION SELECT gedcom, eventplace FROM tng_events WHERE gedcom = '00001' ) AS p USING ( gedcom, place ) WHERE pl.gedcom = '00001' AND isnull( p.place ) )
