Report: Saints in the Family Tree
Description:
SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,firstname, lastname,e4.info as info4,e35.info as info35,birthdate,birthplace,deathdate,deathplace, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_events e4 ON tng_people.personID = e4.persfamID AND tng_people.gedcom = e4.gedcom AND e4.eventtypeID = "4" LEFT JOIN tng_events e35 ON tng_people.personID = e35.persfamID AND tng_people.gedcom = e35.gedcom AND e35.eventtypeID = "35" WHERE ((title LIKE "%Saint%") AND ((tng_people.living !=1 && tng_people.private != 1))) ORDER BY lastname,firstname
Matches 1 to 12 of 12
# | Full Name | Description | Possessions | Birth Date | Birth Place | Death Date | Death Place |
---|---|---|---|---|---|---|---|
1 | Saint and Queen Balthild | Between 626 and 627 | 30 Jan 680 | Abbaye de Chelles, Chelles, Seine-et-Marne, Île-de-France, France ![]() |
|||
2 | Saint and Queen Bertha | DECEASED | |||||
3 | ![]() |
Abt 474 | Lyon, Rhône, Rhône-Alpes, France ![]() |
3 Jun 548 | Basilique de Saint-Martin, Tours, Indre-et-Loire, Centre, France ![]() |
||
4 | ![]() |
Abt 466 | 27 Nov 511 | ||||
5 | Saint and Bishop Gaius Sollius Modestus Apollinaris Sidonius | Abt 5 Nov 430 | Lyon, Rhône, Rhône-Alpes, France ![]() |
Between 481 and 490 | |||
6 | Saint Tarsicius | DECEASED | |||||
7 | Saint and Duchess Chrodoare D'Amay | Abt 560 | Schwaben, Kelheim, Bayern, Germany ![]() |
Bef 634 | Collégiale Saints-Georges-et-Ode d'Amay, Amay, Liege, Belgium ![]() |
||
8 | ![]() |
Between 750 and 755 | 28 May 812 | Gellone Abbey, Saint-Guilhem-le-Désert, Hérault, Languedoc-Roussillon, France ![]() |
|||
9 | Saint and Bishop Arnulf De Metz | Abt 582 | Lay-Saint-Christophe, Meurthe-et-Moselle, Lorraine, France ![]() |
Between 643 and 647 | Abbaye de Remiremont, Remiremont, Vosges, Lorraine, France ![]() |
||
10 | Saint and Queen Ingigerd De Suede | 1001 | 10 Feb 1050 | Kiev, Ukraine ![]() |
|||
11 | Saint and King Æthelberht Of Kent | Abt 550 | Feb 616 | ||||
12 | ![]() |
Abt 475 | 524 | Orléans, Loiret, Centre, France ![]() |