» Show All «Prev «1 ... 405 406 407 408 409 410 411 412 413 ... 443» Next» » Slide Show
Loading...
Walter McFarlane
An error has occurred in the TNG software. This could be due to a setup issue, an incomplete upgrade or a program bug. If you are the site owner, you may contact TNG support for help with this problem. Please copy the query below and paste it into your message.
Query: SELECT tng_medialinks.medialinkID, tng_medialinks.personID as personID, people.burialtype, 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, people.lastname as lastname, people.lnprefix as lnprefix, people.firstname as firstname, people.prefix as prefix, people.suffix as suffix, people.nameorder, altdescription, altnotes, tng_medialinks.gedcom,
familyID, people.personID as personID2, wifepeople.personID as wpersonID, wifepeople.firstname as wfirstname, wifepeople.lnprefix as wlnprefix, wifepeople.lastname as wlastname,
wifepeople.prefix as wprefix, wifepeople.suffix as wsuffix, husbpeople.personID as hpersonID, husbpeople.firstname as hfirstname, husbpeople.lnprefix as hlnprefix, husbpeople.lastname as hlastname,
husbpeople.prefix as hprefix, husbpeople.suffix as hsuffix, tng_sources.title, tng_sources.sourceID, tng_repositories.repoID, reponame
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_people AS husbpeople ON tng_families.husband = husbpeople.personID AND tng_families.gedcom = husbpeople.gedcom
LEFT JOIN tng_people AS wifepeople ON tng_families.wife = wifepeople.personID AND tng_families.gedcom = wifepeople.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 = "1983" AND linktype!="C" ORDER BY people.lastname, people.lnprefix, people.firstname, hlastname, hlnprefix, hfirstname LIMIT 51
Unknown column 'people.burialtype' in 'field list'
