REGISTERs-Matriky
Dotaz nelze provést: SELECT tng_medialinks.mediaID, tng_medialinks.personID as personID, people.personID as personID2, people.living as living, people.private as private, people.branch as branch, tng_medialinks.eventID, tng_families.branch as fbranch, tng_families.living as fliving, tng_families.private as fprivate, familyID, husband, wife, people.lastname as lastname, people.lnprefix as lnprefix, people.firstname as firstname, people.prefix as prefix, people.suffix as suffix, nameorder, tng_medialinks.gedcom, tng_sources.title, tng_sources.sourceID, tng_repositories.repoID, reponame, deathdate, burialdate, linktype FROM tng_medialinks LEFT JOIN tng_people AS people ON tng_medialinks.personID = people.personID AND tng_medialinks.gedcom = people.gedcom LEFT JOIN tng_families ON tng_medialinks.personID = tng_families.familyID AND tng_medialinks.gedcom = tng_families.gedcom LEFT JOIN tng_sources ON tng_medialinks.personID = tng_sources.sourceID AND tng_medialinks.gedcom = tng_sources.gedcom LEFT JOIN tng_repositories ON (tng_medialinks.personID = tng_repositories.repoID AND tng_medialinks.gedcom = tng_repositories.gedcom) WHERE mediaID = "2177" AND tng_medialinks.gedcom = "family" ORDER BY lastname, lnprefix, firstname, personID LIMIT 51