Our Family Genealogy Pages

Home Page  |  What's New  |  Photos  |  Histories  |  Headstones  |  Reports  |  Surnames

First Name:

Last Name:

Report: Changes in histories with people

         Description: Documents/histories changed within the last 90 days (listing *with* linked individuals)

Error: The syntax of the query run with this report (ID: 33) was incorrect, and as a result the report could not be run. Please contact the system administrator at John@rosique.net.

Query: SELECT dc.docID, description, notes, p.personID, p.lastname, p.firstname, dc.changedate, p.living, p.gedcom FROM tng_docs AS dc LEFT JOIN tng_doclinks AS dcl ON dc.docID=dcl.docID LEFT JOIN tng_people AS p ON dcl.personID=p.personID WHERE DATE_SUB(CURDATE(),INTERVAL 90 DAY)<=dc.changedate ORDER BY dc.changedate DESC
Error Message: