Our Family Genealogy Pages

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

First Name:

Last Name:

Report: Changed headstones with links to cemetries

         Description: Headstones: changes within the last 90 days (listing *without* linked individuals but *with* linked cemeteries)

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

Query: select ID, description, hs.notes, hs.changedate, cemname, city, county, state, country FROM tng_headstones AS hs LEFT JOIN tng_cemeteries AS cem ON cem.cemeteryID=hs.cemeteryID WHERE DATE_SUB(CURDATE(),INTERVAL 90 DAY)<=hs.changedate ORDER BY hs.changedate, description DESC
Error Message: