|
Report: Changed headstones with links to cemetriesDescription: 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 |