Report: Individuals marked as living

From TNG_Wiki
Jump to navigation Jump to search

Individuals marked as "living" with age > 100 years

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 personID, lastname, firstname, birthdate, YEAR(CURDATE())-YEAR(birthdatetr) 
AS Years, birthplace, living, gedcom FROM tng_people 
WHERE (YEAR(CURDATE())-YEAR(birthdatetr)>100) AND living=1 AND YEAR(birthdatetr)<>0 
ORDER BY lastname, firstname, birthdatetr