Report: People with aproximate birthdates in certain places

From TNG_Wiki
Jump to navigation Jump to search

Description: People with aproximate birthdates in the places you want. Replace Groningen and Drenthe (3rd level placenames) with place names you want to search for. Also replace 1910 and 1903 with years you want to search for the top threshold and 1600 for the bottom threshold.

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 ID,personID, lastname, firstname, birthdate,birthplace, altbirthdate, deathdate, deathplace, burialdate, living, gedcom FROM tng_people WHERE ( ( UCASE( birthdate ) LIKE "Abt%" OR UCASE( birthdate ) LIKE "Cal%" OR ( LENGTH( birthdate ) = "4" AND altbirthdate = "" ) ) AND ( ( birthplace LIKE "%Groningen" AND (YEAR( birthdatetr ) < "1910" AND YEAR( birthdatetr ) > "1600") ) OR ( birthplace LIKE "%Drenthe" AND YEAR( birthdatetr ) < "1903" ) ) ) ORDER BY ID, lastname, firstname, personID