Zoek | Geavanceerd zoeken | Zoek Families | Doorzoek siteBeschrijving: If the tree is mentioned as savenije please replace with your won tree. Als de naam van de tree=savenije vervang die door uw eigen stamboom naam
Treffers 201 t/m 205 van 205 » Komma gescheiden CSV bestand
| # | reportID | Rapportnaam | reportdesc | sqlselect | active |
| 201 | 44 | Veterans | An overview of veterans (at least if you added some) | SELECT tng_people.living, lnprefix, suffix, tng_people.branch,lastname, firstname,birthdate,deathdate,e104.eventdate as eventdate104,e104.eventplace as eventplace104,e104.info as info104, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_events e104 ON tng_people.personID = e104.persfamID AND tng_people.gedcom = e104.gedcom AND e104.eventtypeID = "104" WHERE (e104.eventplace LIKE "%%") ORDER BY lastname | 1 |
| 202 | 128 | Wezen zonder partner en kinderen, Orphans without partner and childeren | Mensen die dus aan niemand verbonden zijn. Open de links in het rapport alstublieft in een nieuw venster. Persons who are connected to nobody. Open the links in the report please in a new window. |
SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, p.gedcom, p.changedate, p.changedby FROM tng_people AS p LEFT OUTER JOIN tng_children AS c ON (p.personID=c.personID AND p.gedcom=c.gedcom) LEFT OUTER JOIN tng_families AS f1 ON (p.personID=f1.husband AND p.gedcom=f1.gedcom) LEFT OUTER JOIN tng_families AS f2 ON (p.personID=f2.wife AND p.gedcom=f2.gedcom) WHERE c.personID IS NULL AND f1.husband IS NULL AND f1.wife IS NULL AND f2.husband IS NULL AND f2.wife IS NULL ORDER BY p.changedate, p.lastname, p.firstname, p.birthdate DESC; |
1 |
| 203 | 127 | Wezen, Orphans | Personen zonder ouders, geoordend volgens de laatste invoer eerst. People without any parents, ordered according to the last input. |
SELECT personID, firstname AS first_name,lnprefix AS tussenvoegsel,lastname AS last_name, birthdate AS Geboortedatum, birthplace AS Geboorteplaats, changedate AS Veranderdatum, gedcom, changedby FROM tng_people WHERE famc= "" order by changedate DESC | 1 |
| 204 | 172 | Wrong place names for FAMIILIES | Places to families, which are NOT a member of the places table (check for data plausibility) Gezinnen in plaatsen die niet in de plaatsnamen lijst staan (controle op plausibiliteit) |
SELECT familyID, husband, wife, "Place of marriage" AS Kind_of_place, marrplace AS Entered_place_name, f.gedcom FROM tng_families AS f LEFT JOIN tng_places AS pl ON (f.marrplace=pl.place AND f.gedcom=pl.gedcom) WHERE ISNULL(place) AND marrplace<>"" UNION SELECT familyID, husband, wife, "Place of divorce" AS Kind_of_place, divplace AS Entered_place_name, f.gedcom FROM tng_families AS f LEFT JOIN tng_places AS pl ON (f.divplace=pl.place AND f.gedcom=pl.gedcom) WHERE ISNULL(place) AND divplace<>"" ORDER BY CAST(SUBSTRING(familyID, 2) AS UNSIGNED); |
1 |
| 205 | 171 | Wrong place names for PERSONS | Places to persons, which are NOT a member of the places table (check for data plausibility) Mensen in plaatsen die niet in de plaatsnamen lijst staan (controle op plausibiliteit) |
SELECT personID, lastname, firstname, "Place of birth" AS Kind_of_place, birthplace AS place_detail, living, p.gedcom FROM tng_people AS p LEFT JOIN tng_places AS pl ON (p.birthplace=pl.place AND p.gedcom=pl.gedcom) WHERE ISNULL(place) AND birthplace<>"" UNION SELECT personID, lastname, firstname, "Place of birth" AS Kind_of_place, altbirthplace AS place_detail, living, p.gedcom FROM tng_people AS p LEFT JOIN tng_places AS pl ON (p.altbirthplace=pl.place AND p.gedcom=pl.gedcom) WHERE ISNULL(place) AND altbirthplace<>"" UNION SELECT personID, lastname, firstname, "Place of death" AS Kind_of_place, deathplace AS place_detail, living, p.gedcom FROM tng_people AS p LEFT JOIN tng_places AS pl ON (p.deathplace=pl.place AND p.gedcom=pl.gedcom) WHERE ISNULL(place) AND deathplace<>"" UNION SELECT personID, lastname, firstname, "Place of burial" AS Kind_of_place, burialplace AS place_detail, living, p.gedcom FROM tng_people AS p LEFT JOIN tng_places AS pl ON (p.burialplace=pl.place AND p.gedcom=pl.gedcom) WHERE ISNULL(place) AND burialplace<>"" UNION SELECT personID, lastname, firstname, "Place of event" AS Kind_of_place, eventplace AS place_detail, living, p.gedcom FROM tng_events AS e LEFT JOIN tng_places AS pl ON (e.eventplace=pl.place AND e.gedcom=pl.gedcom) LEFT JOIN tng_people AS p ON (e.persfamID=p.personID AND e.gedcom=p.gedcom) WHERE ISNULL(place) AND eventplace<>"" ORDER BY lastname, firstname; |
1 |
Deze site werd aangemaakt door The Next Generation of Genealogy Sitebuilding v. 12.3, geschreven door Darrin Lythgoe © 2001-2025.
Gegevens onderhouden door Your Name.