Beschreibung: Familienmitglieder mit Lebensmittelpunkt Baden-W?rttemberg
SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,lastname, firstname,birthdate,birthplace,deathdate,deathplace,(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 ((birthplace LIKE "%Baden-W?rttemberg%" OR deathplace LIKE "%Baden-W?rttemberg%") AND (tng_people.private != 1)) AND tng_people.gedcom = "0001" ORDER BY lastname
| # | Nachname, Taufnamen | Geburtsdatum | Geburtsort | Sterbedatum | Sterbeort | Partner-Name |
|---|
Diese Website läuft mit The Next Generation of Genealogy Sitebuilding v. 14.0.3, programmiert von Darrin Lythgoe © 2001-2025.
Betreut von Admin - Bei Steup's.