Purfürst Genealogy of the World
Home | What's New | Photos | Histories | Sources | Reports | Cemeteries | Headstones | Statistics | Surnames
Description: Deaths in Illinois
Error: The syntax of the query run with this report (ID: 51) was incorrect, and as a result the report could not be run. Please contact the system administrator at email@example.com.
Query: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, tng_people.branch,lastname, firstname,deathdate,deathplace,birthdate,birthplace,(if(sex='M',families1.wife,families2.husband)) as spouse, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_families AS families1 ON (tng_people.gedcom = families1.gedcom AND tng_people.personID = families1.husband ) LEFT JOIN tng_families AS families2 ON (tng_people.gedcom = families2.gedcom AND tng_people.personID = families2.wife ) WHERE ((deathplace LIKE) AND ((tng_people.living !=1 && tng_people.private != 1))) ORDER BY lastname,firstname