 |
|
Bedford, NY (oldest church in bedford) Buried Matches 1 to 1 of 1
Cannot execute query: SELECT distinct people.ID, people.personID, lastname, lnprefix, firstname, people.living, people.branch, suffix, nameorder, families.marrplace as place1, '' as place2, families.marrdate as date1, '' as date2, families.marrdatetr as datetr1, '' as datetr2, people.gedcom, treename FROM (people, trees ) LEFT JOIN families ON people.gedcom = families.gedcom AND people.personID = families.husband WHERE people.gedcom = trees.gedcom AND people.living != 1 AND families.marrplace = 'Bedford, NY (oldest church in bedford)' UNION SELECT distinct people.ID, people.personID, lastname, lnprefix, firstname, people.living, people.branch, suffix, nameorder, families.marrplace as place2, '' as place1, families.marrdate as date2, '' as date1, families.marrdatetr as datetr2, '' as datetr1, people.gedcom, treename FROM (people, trees ) LEFT JOIN families ON people.gedcom = families.gedcom AND people.personID = families.wife WHERE people.gedcom = trees.gedcom AND people.living != 1 AND families.marrplace = 'Bedford, NY (oldest church in bedford)' ORDER BY lastname, firstname, IF(datetr1,datetr1,datetr2), lastname, firstname LIMIT 100 | ||||||||||||
Print