|
|
|
|
|
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 mwtitle,
lastname, firstname, lnprefix, suffix, prefix, tng_people.title as title, 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" ORDER BY ordernum | |