|
resultaten 101 tot 150 van 235
| |
Klikplaatje |
Omschrijving |
Aantekeningen |
Verbonden met |
Kan query niet uitvoeren: SELECT tng_photolinks.ID, tng_photolinks.personID as personID, people.living as living, people.branch as branch, tng_families.branch as fbranch,
tng_families.living as fliving, people.lastname as lastname, people.lnprefix as lnprefix, people.firstname as firstname, people.suffix as suffix, nameorder,
tng_photolinks.gedcom, treename, tng_sources.title, tng_sources.sourceID
FROM tng_photolinks, tng_trees
LEFT JOIN tng_people AS people ON tng_photolinks.personID = people.personID AND tng_photolinks.gedcom = people.gedcom
LEFT JOIN tng_families ON tng_photolinks.personID = tng_families.familyID AND tng_photolinks.gedcom = tng_families.gedcom
LEFT JOIN tng_sources ON tng_photolinks.personID = tng_sources.sourceID AND tng_photolinks.gedcom = tng_sources.gedcom
WHERE photoID = "259" AND tng_photolinks.gedcom = tng_trees.gedcom ORDER BY lastname, lnprefix, firstname, personID |
