Print
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 = 'Halifax, NS' 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 = 'Halifax, NS' ORDER BY lastname, firstname, IF(datetr1,datetr1,datetr2), lastname, firstname LIMIT 100 | |
Print