Report: Faulty birth, baptism, death and burial APROXIMATE dates, e.g. abt1988

From TNG_Wiki
Jump to navigation Jump to search

Description: Faulty birth, baptism, death and burial APROXIMATE dates, e.g. abt1988, looks only at birth, baptism, death and burial dates.

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, altbirthdate, deathdate, burialdate, living, gedcom 
FROM tng_people 
WHERE ( (UCASE(birthdate) 
LIKE "%CAL%" AND birthdate != "" and length(birthdate) < 8 AND birthdatetr != "0000-00-00") 
OR (UCASE(birthdate) LIKE "%EST%" AND birthdate != "" and length(birthdate) < 8 AND birthdatetr != "0000-00-00") 
OR (UCASE(birthdate) LIKE "%BEF%" AND birthdate != "" and length(birthdate) < 8 AND birthdatetr != "0000-00-00") OR (UCASE(birthdate) LIKE "%AFT%" AND birthdate != "" and length(birthdate) < 8 AND 
birthdatetr != "0000-00-00") OR (UCASE(birthdate) LIKE "%ABT%" AND birthdate != "" 
and length(birthdate) < 8 AND birthdatetr != "0000-00-00") OR (UCASE(altbirthdate) 
LIKE "%CAL%" AND altbirthdate != "" and length(birthdate) < 8 AND birthdatetr != "0000-00-00") OR (UCASE(altbirthdate) LIKE "%EST%" AND altbirthdate != "" 
and length(altbirthdate) < 8 AND birthdatetr != "0000-00-00") OR (UCASE(altbirthdate) 
LIKE "%BEF%" AND altbirthdate != "" and length(altbirthdate) < 8 AND birthdatetr != "0000-00-00") 
OR (UCASE(altbirthdate) LIKE "%AFT%" AND altbirthdate != "" and length(altbirthdate) < 8 
AND birthdatetr != "0000-00-00") OR (UCASE(altbirthdate) LIKE "%ABT%" AND altbirthdate != "" 
and length(altbirthdate) < 8 AND birthdatetr != "0000-00-00") OR (UCASE(deathdate) LIKE "%CAL%" 
AND deathdate != "" and length(deathdate) < 8 AND deathdatetr != "0000-00-00") OR (UCASE(deathdate) 
LIKE "%EST%" AND deathdate != "" and length(deathdate) < 8 AND deathdatetr != "0000-00-00") 
OR (UCASE(deathdate) LIKE "%BEF%" AND deathdate != "" and length(deathdate) < 8 
AND deathdatetr != "0000-00-00") OR (UCASE(deathdate) LIKE "%AFT%" AND deathdate != "" 
and length(deathdate) < 8 AND deathdatetr != "0000-00-00") OR (UCASE(deathdate) LIKE "%ABT%" 
AND deathdate != "" and length(deathdate) < 8 AND deathdatetr != "0000-00-00") OR (UCASE(burialdate) 
LIKE "%CAL%" AND burialdate != "" and length(burialdate) < 8 AND burialdatetr != "0000-00-00") 
OR (UCASE(burialdate) LIKE "%EST%" AND burialdate != "" and length(burialdate) < 8 
AND burialdatetr != "0000-00-00") OR (UCASE(burialdate) LIKE "%BEF%" AND burialdate != "" 
and length(burialdate) < 8 AND burialdatetr != "0000-00-00") OR (UCASE(burialdate) LIKE "%ABT%" 
AND burialdate != "" and length(burialdate) < 8 AND burialdatetr != "0000-00-00") OR (UCASE(burialdate) 
LIKE "%AFT%" AND burialdate != "" and length(burialdate) < 8 AND burialdatetr != "0000-00-00") ) 
AND year(birthdatetr) > "999" ORDER BY lastname, firstname, personID
Retrieved from "https://tng.lythgoes.net/wiki/index.php?title=Report:_Faulty_birth,_baptism,_death_and_burial_APROXIMATE_dates,_e.g._abt1988&oldid=14058"