Difference between revisions of "Photos changed within the last 90 days"
Jump to navigation
Jump to search
m (Category added) |
|||
Line 1: | Line 1: | ||
− | Photos changed within the last 90 days (listing *with* linked individuals) | + | Description: Photos changed within the last 90 days (listing *with* linked individuals) |
Copy and paste the text between the lines into the reports section below "OR Leave Display, Criteria and Sort fields blank and enter direct SQL SELECT statement here:" and give it the title you think is appropriate | Copy and paste the text between the lines into the reports section below "OR Leave Display, Criteria and Sort fields blank and enter direct SQL SELECT statement here:" and give it the title you think is appropriate |
Revision as of 05:43, 8 August 2010
Description: Photos changed within the last 90 days (listing *with* linked individuals)
Copy and paste the text between the lines into the reports section below "OR Leave Display, Criteria and Sort fields blank and enter direct SQL SELECT statement here:" and give it the title you think is appropriate
SELECT description, m.notes, m.changedate, p.personID, p.gedcom, p.lastname, p.firstname, p.living, p.gedcom FROM tng_media AS m LEFT JOIN tng_medialinks AS ml ON (ml.mediaID=m.mediaID AND ml.gedcom=ml.gedcom) LEFT JOIN tng_people AS p ON (ml.personID=p.personID AND ml.gedcom=p.gedcom) WHERE mediatypeID<>"headstones" AND DATE_SUB(CURDATE(),INTERVAL 90 DAY)<=m.changedate ORDER BY m.changedate DESC;