Home
Search
Print
Login
Add Bookmark
Elusive People
Cannot execute query: SELECT DISTINCT tng_mostwanted.ID as mwID, mwtype, thumbpath, abspath, form, usecollfolder, mediatypeID, path, tng_media.description as mtitle,
tng_mostwanted.personID, tng_mostwanted.gedcom, tng_mostwanted.mediaID, tng_mostwanted.description as mwdesc, tng_mostwanted.title as title,
lastname, firstname, lnprefix, suffix, prefix, living, nameorder, branch
FROM tng_mostwanted
LEFT JOIN tng_media ON tng_mostwanted.mediaID = tng_media.mediaID
LEFT JOIN tng_people ON tng_mostwanted.personID = tng_people.personID AND tng_mostwanted.gedcom = tng_people.gedcom
WHERE mwtype = "person" AND tng_mostwanted.gedcom = "purvis" |