Print Bookmark

Report: Changes in histories with people

         Description: Veranderde documenten, levensverhalen MET links naar de personen
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 yourmail@domain.ext.

Query: SELECT dc.mediaID, description, notes, p.personID, p.lastname, p.firstname, dc.changedate,, p.gedcom FROM tng_media AS dc LEFT JOIN tng_medialinks AS dcl ON dc.mediaID = dcl.mediaID LEFT JOIN tng_people AS p ON dcl.personID = p.personID WHERE DATE_SUB( CURDATE( ) , INTERVAL 90 DAY ) <= dc.changedate AND dc.mediatypeID = "histories" ORDER BY dc.changedate DESC
Error Message:

This site powered by The Next Generation of Genealogy Sitebuilding ©, v. 9.2.2, written by Darrin Lythgoe 2001-2024.