"3","All the women in the database sorted on first name","Een overzicht van alle vrouwen in het bestand gesorteerd op voornaam","15","personID
fullname
title
spousename
spouseid
birthdate
birthplace
marrdate
marrplace
deathdate
deathplace
","sex
starts with
\"F\"
","firstname
lastname
","","1"
"5","People sorted on date","This gives you a list of the people born before 1500, sorted on date of birth","17","personID
spouseid
fullname
birthdate
deathdate
sex
title
spousename
title
gedcom
","(
(
yearonly
birthdatetr
<=
1500
AND
birthdatetr
!=
0000-00-00
)
OR
yearonly
deathdate
<=
1500
)
AND
birthdate
!=
\"y\"
","birthdatetr
firstname
","","1"
"33","Changes in histories with people","Veranderde documenten, levensverhalen MET links naar de personen<br>Documents/histories changed within the last 90 days (listing *with* linked individuals)  ","20","","","","SELECT dc.mediaID, description, notes, p.personID, p.lastname, p.firstname, dc.changedate, p.living, p.gedcom
FROM tng_media AS dc
LEFT JOIN tng_medialinks AS dcl ON dc.mediaID = dcl.mediaID
LEFT JOIN tng_people AS p ON dcl.personID = p.personID
WHERE DATE_SUB( CURDATE( ) , INTERVAL 90
DAY ) <= dc.changedate
AND dc.mediatypeID = \"histories\"
ORDER BY dc.changedate DESC ","1"
"4","All the men in the database sorted on first name","Alle mannen in de database gesorteerd op voornaam, ","16","personID
fullname
title
spousename
spouseid
birthdate
birthplace
marrdate
marrplace
deathdate
deathplace
","sex
starts with
\"M\"
","firstname
lastname
birthdate
","","1"
"32","Document changes","Veranderingen van de laatste 90 dagen in documenten, ZONDER de gelinkte personen. <br>Documents/histories changed within the last 90 days (listing *without* linked individuals)  ","19","","","","SELECT doc.mediaID, mediatypeID, description, notes, changedate
FROM tng_media AS doc
LEFT JOIN tng_medialinks AS documentlink ON doc.mediaID = documentlink.mediaID
WHERE (
DATE_SUB( CURDATE( ) , INTERVAL -90
DAY )
)
AND doc.mediatypeID = \"documents\"
ORDER BY doc.changedate DESC ","1"
"31","Changed persons in the last 90 days","Lijst van personen waarin veranderingen en of toevoegingen zijn gedaan in de laatste 90 dagen, gesorteerd aflopend op de veranderdatum<br>List of the the people which changed the last 90 days, sorted on the last change date","18","","","","SELECT personID, lastname, firstname AS Name, birthdate, birthplace, deathdate, changedate, gedcom, living FROM tng_people WHERE
DATE_SUB(CURDATE(),INTERVAL 90 DAY)<=changedate ORDER BY changedate DESC","1"
"17","Individuals, with their zodiacal sign","Een lijst van alle personen met hun sterrenbeeld<br>A list of all the people with their zodiacal sign","14","","","","SELECT personID, lastname, firstname, birthdate, birthplace,gedcom,  CASE WHEN (MONTH(birthdatetr)=3 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=4 AND DAYOFMONTH(birthdatetr)<=20) THEN \"Ram (Aries)\" WHEN (MONTH(birthdatetr)=4 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=5 AND DAYOFMONTH(birthdatetr)<=20) THEN \"Stier (Taurus)\" WHEN (MONTH(birthdatetr)=5 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=6 AND DAYOFMONTH(birthdatetr)<=21) THEN \"Tweelingen (Gemini)\" WHEN (MONTH(birthdatetr)=6 AND DAYOFMONTH(birthdatetr)>=22) OR (MONTH(birthdatetr)=7 AND DAYOFMONTH(birthdatetr)<=22) THEN \"Kreeft (Cancer)\" WHEN (MONTH(birthdatetr)=7 AND DAYOFMONTH(birthdatetr)>=23) OR (MONTH(birthdatetr)=8 AND DAYOFMONTH(birthdatetr)<=23) THEN \"Leeuw (Leo)\" WHEN (MONTH(birthdatetr)=8 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=9 AND DAYOFMONTH(birthdatetr)<=23) THEN \"Maagd (Virgo)\" WHEN (MONTH(birthdatetr)=9 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=10 AND DAYOFMONTH(birthdatetr)<=23) THEN \"Weegschaal (Libra)\" WHEN (MONTH(birthdatetr)=10 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=11 AND DAYOFMONTH(birthdatetr)<=22) THEN \"Schorpioen (Scorpius)\" WHEN (MONTH(birthdatetr)=11 AND DAYOFMONTH(birthdatetr)>=23) OR (MONTH(birthdatetr)=12 AND DAYOFMONTH(birthdatetr)<=21) THEN \"Boogschutter (Sagittarius)\" WHEN (MONTH(birthdatetr)=12 AND DAYOFMONTH(birthdatetr)>=22) OR (MONTH(birthdatetr)=1 AND DAYOFMONTH(birthdatetr)<=20) THEN \"Steenbok (Capricornus)\" WHEN (MONTH(birthdatetr)=1 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=2 AND DAYOFMONTH(birthdatetr)<=19) THEN \"Waterman (Aquarius)\" WHEN (MONTH(birthdatetr)=2 AND DAYOFMONTH(birthdatetr)>=20) OR (MONTH(birthdatetr)=3 AND DAYOFMONTH(birthdatetr)<=20) THEN \"Vissen (Pisces)\" END AS Sterrenbeeld, living FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" ORDER BY lastname, firstname, personID;","1"
"18","Individuals: frequency of zodiacal signs","Personen: Frekwentie van de sterrenbeelden","13","","","","SELECT CASE WHEN (MONTH(birthdatetr)=3 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=4 AND DAYOFMONTH(birthdatetr)<=20) THEN \"Ram (Aries)\" WHEN (MONTH(birthdatetr)=4 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=5 AND DAYOFMONTH(birthdatetr)<=20) THEN \"Stier (Taurus)\" WHEN (MONTH(birthdatetr)=5 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=6 AND DAYOFMONTH(birthdatetr)<=21) THEN \"Tweelingen (Gemini)\" WHEN (MONTH(birthdatetr)=6 AND DAYOFMONTH(birthdatetr)>=22) OR (MONTH(birthdatetr)=7 AND DAYOFMONTH(birthdatetr)<=22) THEN \"Kreeft (Cancer)\" WHEN (MONTH(birthdatetr)=7 AND DAYOFMONTH(birthdatetr)>=23) OR (MONTH(birthdatetr)=8 AND DAYOFMONTH(birthdatetr)<=23) THEN \"Leeuw (Leo)\" WHEN (MONTH(birthdatetr)=8 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=9 AND DAYOFMONTH(birthdatetr)<=23) THEN \"Maagd (Virgo)\" WHEN (MONTH(birthdatetr)=9 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=10 AND DAYOFMONTH(birthdatetr)<=23) THEN \"Weegschaal (Libra)\" WHEN (MONTH(birthdatetr)=10 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=11 AND DAYOFMONTH(birthdatetr)<=22) THEN \"Schorpioen (Scorpius)\" WHEN (MONTH(birthdatetr)=11 AND DAYOFMONTH(birthdatetr)>=23) OR (MONTH(birthdatetr)=12 AND DAYOFMONTH(birthdatetr)<=21) THEN \"Boogschutter (Sagittarius)\" WHEN (MONTH(birthdatetr)=12 AND DAYOFMONTH(birthdatetr)>=22) OR (MONTH(birthdatetr)=1 AND DAYOFMONTH(birthdatetr)<=20) THEN \"Steenbok (Capricornus)\" WHEN (MONTH(birthdatetr)=1 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=2 AND DAYOFMONTH(birthdatetr)<=19) THEN \"Waterman (Aquarius)\" WHEN (MONTH(birthdatetr)=2 AND DAYOFMONTH(birthdatetr)>=20) OR (MONTH(birthdatetr)=3 AND DAYOFMONTH(birthdatetr)<=20) THEN \"Vissen (Pisces)\" END AS Sterrebeeld, COUNT(*) AS Aantal FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" GROUP BY Sterrebeeld; ","1"
"19","Ram","Personen, geboren in het astrologische teken Ram (Aries): 21 maart -20 April <br>Ram 21 maart - 21 april 								Ik ben

Het ik ben
Het pure begin.
De impulsieve aktie 
Heerser Mars;
- zegt iets over de manier waarop je je energie wilt besteden
- hoe je voor jezelf opkomt
- hoe je akties onderneemt en jezelf onderscheidt van anderen 
Aries is the Cardinal-Fire sign. Aries people need to keep physically busy. They accomplish many things simply because of their restless energy. They need to learn how to make constructive use of their energetic efforts. The typical Aries urge is to take on more projects than can be done reasonably well. Though others may find it difficult to physically keep pace, they are attracted to the animation and spirit of Aries personalities.","4","","","","SELECT personID, lastname, firstname, birthdate, birthplace,gedcom, living FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" AND ((MONTH(birthdatetr)=3 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=4 AND DAYOFMONTH(birthdatetr)<=20)) ORDER BY lastname, firstname, personID; ","1"
"20","Stier","Personen, geboren in het astrologische teken Stier (Taurus): 21 april-20 mei <br>Individuals born in astrological sign taurus: 21 APR - 20 MAY <pr>Stier 21 april - 21 mei 								Ik heb Materieel en geestelijk bezit, principes en ideeën
Zekerheden en dingen die van waarde zijn voor iemand. 
Je motivatie en vaardigheden
Heerser Venus 
- zegt hoe je omgaat met het aardse, met je lichaam en hoe je \"in je lijf zit\" 
- over je gevoel voor harmonie en schoonheid, dingen waarvan je geniet
- hoe je motivatie is om iets te doen, en op welke manier je met je vaardigheden omgaat
Taurus is the Fixed-Earth sign. Taureans stubbornly cling to their own ideas and habits, and may fail to take advantage of new ideas or situations simply because they cannot see their practical use. They have to understand that while tenacity and a stable temperament yield rewards in many endeavors, tolerance and flexibility are the best assets when it comes to personal relationships.","5","","","","SELECT personID, lastname, firstname, birthdate, birthplace,gedcom, living FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" AND ((MONTH(birthdatetr)=4 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=5 AND DAYOFMONTH(birthdatetr)<=20)) ORDER BY lastname, firstname, personID; ","1"
"21","Tweelingen","Personen, geboren in het astrologische teken tweelingen (Gemini): 21 mei-21 juni <br>Individuals born in astrological sign gemini: 21 MAY - 21 JUN<pr>Tweelingen 21 mei - 21 Juni 							Ik vergaar kennis
Kontakten en kommunikatie
Het omgaan met informatie 
Uitwisseling met de andere mens 
Heerser Mercurius;
- hoe je manier van praten, schrijven en telefoneren is 
- hoe je met je direkte omgeving omgaat
- hoe je iets overdenkt en leert van de dagelijkse ervaringen
Gemini is the Mutable-Air sign. Using their communicative skills, Geminis adapt to any situation they encounter. However, they must learn to speak with candor instead of simply repeating what others want to hear. Clever-tongued Geminis develop the amazing ability to obscure the facts in their stimulating and imaginative chatter.","6","","","","SELECT personID, lastname, firstname, birthdate, birthplace,gedcom, living FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" AND ((MONTH(birthdatetr)=5 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=6 AND DAYOFMONTH(birthdatetr)<=21)) ORDER BY lastname, firstname, personID; ","1"
"22","Kreeft","Personen, geboren in het astrologische teken kreeft (Cancer): 22 juni-22 juli <br>Individuals born in astrological sign cancer: 22 JUN - 22 JUL <pr>Kreeft  21 juni - 23 juli 								Ik voel

Emoties ; Afkomst; Gevoel voor traditie
Huis; Familie; Veiligheid en geborgenheid						
Onberedeneerbare stemmingen die uit het diepst van ons innerlijk (de psyche); omhoogkomen.
Heerser Maan: 
- zegt iets over je onbewuste gedrag en het gedrag dat je inschakelt om weer op poten te
  komen
- hoe je met gevoelens en met intimiteiten omgaat 
- in hoeverre je \"echt bij jezelf\" kunt zijn
- hoe je omgaat met voeding en je eigen huis hoe je omgaat met veiligheid en emotionele
  geborgenheid
- hoe je je ervaringen verwerkt en verteert en omgaat met je verleden
Cancer is the Cardinal-Water sign. Cancerians get things done through the power of their emotional commitment. Not only do they aggressively work to accomplish the goals inspired by their own feelings, they also know how to appeal to the emotions of others. By making other people feel like family members, Cancerians effectively inspire others to help get projects accomplished. They have to learn how to reach an emotional balance since they tend to be overly sensitive and moody.","7","","","","SELECT personID, lastname, firstname, birthdate, birthplace,gedcom, living FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" AND ((MONTH(birthdatetr)=6 AND DAYOFMONTH(birthdatetr)>=22) OR (MONTH(birthdatetr)=7 AND DAYOFMONTH(birthdatetr)<=22)) ORDER BY lastname, firstname, personID; ","1"
"23","Leeuw","Personen, geboren in het astrologische teken leeuw (Leo): 23 juli -23 augustus <br>Individuals born in astrological sign leo: 23 JUL - 23 AUG <pr>Leeuw  23 juli - 23 augustus 								Ik wil Zelfexpressie en eigenwaarde
De presentatie van het ego 
De scheppingsdrang 
Heerser Zon;
- zegt iets over je bewuste gedrag
- geeft de weg aan die \'n mens het beste kan gaan om zich in overeenstemming met z’n diepste
  ware zijn te ontplooien
- hoe je omgaat met creativiteit, romantiek, kinderen en in hoeverre je \"het kind in jezelf\" een
  plaats durft te geven.
- of je vertrouwen hebt in je intuïtie en je hart, jezelf durft te zijn
Leo is the Fixed-Fire sign. Leos stubbornly cling to their pride. They resent the indignity of altering their opinions or behavior in front of or at the request of others. Their stubborn nature makes it hard for them to accept that there is no virtue in giving what they want to give rather than what may really be wanted or needed, and no reward in misguided loyalty to those who are not worthy of it.","8","","","","SELECT personID, lastname, firstname, birthdate, birthplace,gedcom, living FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" AND ((MONTH(birthdatetr)=7 AND DAYOFMONTH(birthdatetr)>=23) OR (MONTH(birthdatetr)=8 AND DAYOFMONTH(birthdatetr)<=23)) ORDER BY lastname, firstname, personID; ","1"
"24","Maagd","Personen, geboren in het astrologische teken (Virgo): 24 augustus-23 september <br>Individuals born in astrological sign virgo: 24 AUG - 23 SEP <pr>Maagd 23 augustus - 23 september 						Ik onderzoek 
Werk. Een taak hebben
Dienstbaar en praktisch zijn 
Kritisch vermogen
Gezondheid en het opbouwen van levensgewoonten 
Heerser Mercurius ;
- hoe je met je werk omgaat
- hoe je analyseert en je bezig houdt met het detail
- in hoeverre je dienstbaar kunt zijn en kunt geven aan een doel buiten jezelf
Virgo is the Mutable-Earth sign. Virgos adapt to different people and situations by finding ways to make themselves useful. To hide their vulnerability, they focus attention on what they\'re doing rather than who they are. To deflect attention away from themselves, Virgos will also focus on other people by praising their talents and virtues, or just as likely, by listing their faulty behavior or personal defects.","9","","","","SELECT personID, lastname, firstname, birthdate, birthplace,gedcom, living FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" AND ((MONTH(birthdatetr)=8 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=9 AND DAYOFMONTH(birthdatetr)<=23)) ORDER BY lastname, firstname, personID; ","1"
"25","Weegschaal","Personen, geboren in het astrologische teken Weegschaal (Libra): 24.9.-23.10. <br>Individuals born in astrological sign libra: 24 SEP - 23 OCT <pr>Weegschaal 23 september - 23 oktober 						Ik verenig
Relaties 
Samenwerkingsverbanden 
Afspraken en kontrakten
Heerser Venus; 
- zegt iets over de manier waarop je in staat bent liefde te geven of te ontvangen, 
- hoe je tegendelen verenigt en in hoeverre je bereid bent water bij de wijn te doen
 	
Libra is the Cardinal-Air sign. Librans accomplish things because they intellectually evaluate what needs to be done, and then they charm others into cooperating with them to achieve the goal. By unselfishly sharing the success of accomplishment with those who assisted, Librans continue to engender the cooperative efforts of others. They have to learn how to deal with confrontations. Fear of hurting others or avoidance of hostile situations can keep them from pursuing their goals.","10","","","","SELECT personID, lastname, firstname, birthdate, birthplace,gedcom, living FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" AND ((MONTH(birthdatetr)=9 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=10 AND DAYOFMONTH(birthdatetr)<=23)) ORDER BY lastname, firstname, personID;","1"
"26","Schorpioen","Personen, geboren in het astrologische teken Schorpioen (Skorpius): 24.10.-22.11. <br>Individuals born in astrological sign scorpio: 24 OCT - 22 NOV<pr>Schorpioen 23 oktober - 22 november 				Ik geniet of ik vernietig 

Transformatie- en verwerkingsprocessen. 
Psychologie Machtsbehoefte. Wilskracht en sexualiteit
Het verborgene en alles wat ooit verdrongen werd 
Heerser Pluto;
- geeft aan hoe je met diepe innerlijke veranderingen omgaat
- hoe de sexualiteit wordt beleefd als een totale overgave aan de ander. 
- geeft aan waar je je \"donkere kant\" , om met Jung te spreken: je schaduw ontmoet.
Scorpio is the Fixed-Water sign. Scorpios stubbornly cling to emotional attachments. They rarely forget or forgive emotional rejection. They have to learn that jealousy and possessiveness are self-defeating. Rechanneling negative feelings and experiences into constructive activities benefits others as well as themselves. No other sign has the emotional strength of Scorpio.","11","","","","SELECT personID, lastname, firstname, birthdate, birthplace,gedcom, living FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" AND ((MONTH(birthdatetr)=10 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=11 AND DAYOFMONTH(birthdatetr)<=22)) ORDER BY lastname, firstname, personID;","1"
"27","Boogschutter","Personen, geboren in het astrologische teken Boogschutter (Sagittarius): 23.11.-21.12. <br>Individuals born in astrological sign sagittarius: 23 NOV - 21 DEC <pr>Boogschutter  22 november - 21 december 						Ik wil recht
 
Oordeels- en meningsvorming
Hogere studies. Het recht. Het buitenland 
Idealen, Religie. Vrijheidsdrang
Heerser Jupiter 
- doet je zoeken naar de samenhang der dingen, door je steeds weer het waarom van de dingen
  af te vragen en zo tot nieuwe inzichten te komen en die kennis dan uit te dragen
- maakt je bewust van datgene wat jij als de waarheid ziet 
Sagittarius is the Mutable-Fire sign. Restless energy and the need for personal independence keeps Sagittarians moving in many directions. They become experts at adapting to whatever culture and clime happens to fit their current interest. Always ready to travel for business or pleasure, and sometimes because of an overwhelming urge to escape (either figuratively or literally), they are all too willing to bypass the confinements of responsibility and work.","12","","","","SELECT personID, lastname, firstname, birthdate, birthplace,gedcom, living FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" AND ((MONTH(birthdatetr)=11 AND DAYOFMONTH(birthdatetr)>=23) OR (MONTH(birthdatetr)=12 AND DAYOFMONTH(birthdatetr)<=21)) ORDER BY lastname, firstname, personID;","1"
"28","Steenbok","Personen, geboren in het astrologische teken Steenbok (Capricornus): 22.12.-20.01. <br>Individuals born in astrological sign capricornus: 22 DEC - 20 JAN
<p>Steenbok 22 december - 21 januari  					Ik streef mijn doel na

Maatschappelijke positie. Je doelen 
Het leerproces van de pijn. Wetten 
Plichten en verantwoordelijkheden 
Heerser Saturnus
- geeft aan hoe we door noodzakelijke beperkingen onze eigen vorm moeten zien te vinden,
  om daarmee te kunnen funktioneren in de maatschappij
- hoe je met verantwoordelijkheden, plichten en allerlei wetten omgaat 
- welke doelen je jezelf stelt
Capricorn is the Cardinal-Earth sign. Capricorns are natural goal setters. They willingly handle many tasks if it helps them get what they want. Many things get accomplished simply because they happen to be part of Capricorn\'s overall efforts to reach higher goals. They need definitive guidelines. Rules and regulations provide structure they need for establishing the pattern of their own actions. They must learn however, that the end never justifies the means.
","1","","","","SELECT personID, lastname, firstname, birthdate, birthplace,gedcom, living FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" AND ((MONTH(birthdatetr)=12 AND DAYOFMONTH(birthdatetr)>=22) OR (MONTH(birthdatetr)=1 AND DAYOFMONTH(birthdatetr)<=20)) ORDER BY lastname, firstname, personID","1"
"29","Waterman","Personen, geboren in het astrologische teken Waterman (Aquarius): 21.01.-19.02. <br>Individuals born in astrological sign aquarius: 21 JAN - 19 FEB <p>Waterman . 21 januari - 20 februari 					Ik ben ik, en jij bent jij
Vrienden. Geestverwanten. Persoonlijke vrijheid.
Nieuwe strukturen op basis van gelijkheid voor iedereen 
Politieke partijen. Klubverband
Heerser Uranus;
- geeft de behoefte tot veranderen, verbreken en doorbreken aan van bestaande normen en
  grenzen, zodat je je als individu kunt ontwikkelen.
- hoe je oorspronkelijk en origineel wilt zijn
- mensen die je helpen bij het vervullen van je wensen, die ten dienste staan van de mensheid
Aquarius is the Fixed-Air sign. Aquarians are born looking for ideologies to which they can stubbornly cling. They refuse to budge whenever an issue involves what they believe to be a \"matter of principle. \" As in the case of the Aquarian Abraham Lincoln, society greatly benefits when these principles happen to be noble ones.","2","","","","SELECT personID, lastname, firstname, birthdate, birthplace,gedcom, living FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" AND ((MONTH(birthdatetr)=1 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=2 AND DAYOFMONTH(birthdatetr)<=19)) ORDER BY lastname, firstname, personID;","1"
"30","Vissen","Personen, geboren in het astrologische teken Vissen (Pisces): 20.02.-20.03. <br>Individuals born in astrological signVissen 20 februari - 22 maart 					Ik offer en droom verder Afzondering. Eenheidsbeleving. Illusies
Helderziendheid. Aanvoelend vermogen. Geheimen. Fantasie 
Dromen. Hypnose, Verborgen vijanden. Onzichtbare tegenwerking 
Heerser; Neptunus
- geeft aan daar waar je zonder eigenbelang anderen kunt helpen 
- hoe je omgaat met spirituele waarden
- daar waar je \"de mist in kan raken\", en erg beïnvloedbaar bent - 
- hoe iemand intuïtief zijn juiste draai in het leven vindt.
Pisces is the Mutable-Water sign. Pisceans adapt emotionally to the influence of their environment. Often painfully shy, they are adept at imitating the mannerisms of other people as a way of hiding their own personality. Pisceans can too easily become victims of their considerable ability to identify with the personality and problems of other people, since it severely restricts the development of their own personality traits and talents.","3","","","","SELECT personID, lastname, firstname, birthdate, birthplace,gedcom, living FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" AND ((MONTH(birthdatetr)=2 AND DAYOFMONTH(birthdatetr)>=20) OR (MONTH(birthdatetr)=3 AND DAYOFMONTH(birthdatetr)<=20)) ORDER BY lastname, firstname, personID;","1"
"34","Changed families","Gezinnen die verandert zijn in de laatste 90 dagen<br>Families changed within the last 90 days","21","","","","SELECT familyID, h.personID, h.lastname, h.firstname, w.personID AS FraupersonID, w.lastname AS FrauName, w.firstname AS FrauVorname, marrdate, marrplace, f.changedate, f.living, f.gedcom FROM tng_families AS f LEFT JOIN tng_people AS h ON f.husband=h.personID LEFT JOIN tng_people AS w ON f.wife=w.personID WHERE DATE_SUB(CURDATE(),INTERVAL 90 DAY)<=f.changedate ORDER BY changedate DESC;","1"
"35","Changes in headstones (Last 90 days w.o. people","headstones: changes within the last 90 days (listing *without* linked individuals and *without* linked cemeteries)","22","","","","SELECT mediaID, description, notes, changedate
FROM tng_media AS hs
WHERE DATE_SUB( CURDATE( ) , INTERVAL 90
DAY ) <= hs.changedate
AND hs.mediatypeID = \"headstones\"
ORDER BY hs.changedate DESC ","1"
"36","Changed headstones with links to cemetries","Headstones: changes within the last 90 days (listing *without* linked individuals but *with* linked cemeteries)  ","23","","","","SELECT mediaID, description, hs.notes, hs.changedate, cemname, city, county, state, country
FROM tng_media AS hs
LEFT JOIN tng_cemeteries AS cem ON cem.cemeteryID = hs.cemeteryID
WHERE hs.mediatypeID = \"headstones\"
AND DATE_SUB( CURDATE( ) , INTERVAL 90
DAY ) <= hs.changedate
ORDER BY hs.changedate, description DESC ","1"
"37","Changed photos, without links to people","Photos changed within the last 90 days (listing *without* linked individuals)","24","","","","SELECT description, m.notes, m.changedate
FROM tng_media AS m
WHERE m.mediatypeID = \"photos\"
AND DATE_SUB( CURDATE( ) , INTERVAL 90
DAY ) <= m.changedate
ORDER BY m.changedate DESC ","1"
"38","Photos changed within the last 90 days","Photos changed within the last 90 days (listing *with* linked individuals) ","25","","","","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; ","1"
"41","empty notes","empty notes","118","","","","SELECT persfamID, note FROM tng_xnotes AS xn LEFT JOIN tng_notelinks AS nl ON 
nl.xnoteID=xn.ID WHERE note REGEXP \"[print]|[punct]|[\\.]|
[\\?]\"=0 ORDER BY persfamID;","1"
"43","Unknown sex","A list of the people with unknown gender and not stillborn
Een lijst met personen waarvan de sexe onbekend is en die niet doodgeboren zijn.","27","personID
fullname
birthdate
birthplace
deathdate
deathplace
","sex
=
\"U\"
AND
firstname
!=
\"NN\"
","personID
","","1"
"44","Veterans","An overview of veterans (at least if you added some)","30","","","","SELECT tng_people.living, lnprefix, suffix, tng_people.branch,lastname, firstname,birthdate,deathdate,e104.eventdate as eventdate104,e104.eventplace as eventplace104,e104.info as info104, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_events e104 ON tng_people.personID = e104.persfamID AND tng_people.gedcom = e104.gedcom AND e104.eventtypeID = \"104\" WHERE (e104.eventplace LIKE \"%%\") ORDER BY lastname","1"
"45","all occuring places, including place levels","all occuring places, including place levels ","31","","","","SELECT place,longitude,latitude, notes, ID FROM tng_places ORDER BY place; ","1"
"46","sources with citation frequency, ordered by sources","sources with citation frequency, ordered by sources ","32","","","","SELECT s.sourceID AS SourceNr, s.title AS Title, s.shorttitle AS ShortTitle, s.author AS Author, s.publisher AS Publisher, s.comments AS Comments, COUNT(*) AS Number FROM tng_sources AS s LEFT JOIN tng_citations AS c ON s.sourceID=c.sourceID GROUP BY s.sourceID ORDER BY s.sourceID; ","1"
"47","sources with citation frequency, ordered by frequency","sources with citation frequency, ordered by frequency ","33","","","","SELECT s.sourceID AS SourceNr, s.title AS Title, s.shorttitle AS ShortTitle, s.author AS Author, s.publisher AS Publisher, s.comments AS Remarks, COUNT(*) AS Number FROM tng_sources AS s LEFT JOIN tng_citations AS c ON s.sourceID=c.sourceID GROUP BY s.sourceID ORDER BY Number","1"
"48","sources: citation texts - with frequency of occurence","sources: citation texts - with frequency of occurence ordered by description","35","","","","SELECT description, COUNT(*) AS Number FROM tng_citations GROUP BY description ORDER BY description; ","1"
"52","individuals: frequency distribution of zodiacal signs","individuals: frequency distribution of zodiac signs ","36","","","","SELECT CASE WHEN (MONTH(birthdatetr)=3 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=4 AND DAYOFMONTH(birthdatetr)<=20) THEN \"Aries\" WHEN (MONTH(birthdatetr)=4 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=5 AND DAYOFMONTH(birthdatetr)<=20) THEN \"Taurus\" WHEN (MONTH(birthdatetr)=5 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=6 AND DAYOFMONTH(birthdatetr)<=21) THEN \"Gemini\" WHEN (MONTH(birthdatetr)=6 AND DAYOFMONTH(birthdatetr)>=22) OR (MONTH(birthdatetr)=7 AND DAYOFMONTH(birthdatetr)<=22) THEN \"Cancer\" WHEN (MONTH(birthdatetr)=7 AND DAYOFMONTH(birthdatetr)>=23) OR (MONTH(birthdatetr)=8 AND DAYOFMONTH(birthdatetr)<=23) THEN \"Leo\" WHEN (MONTH(birthdatetr)=8 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=9 AND DAYOFMONTH(birthdatetr)<=23) THEN \"Virgo\" WHEN (MONTH(birthdatetr)=9 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=10 AND DAYOFMONTH(birthdatetr)<=23) THEN \"Libra\" WHEN (MONTH(birthdatetr)=10 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=11 AND DAYOFMONTH(birthdatetr)<=22) THEN \"Scorpius\" WHEN (MONTH(birthdatetr)=11 AND DAYOFMONTH(birthdatetr)>=23) OR (MONTH(birthdatetr)=12 AND DAYOFMONTH(birthdatetr)<=21) THEN \"Sagittarius\" WHEN (MONTH(birthdatetr)=12 AND DAYOFMONTH(birthdatetr)>=22) OR (MONTH(birthdatetr)=1 AND DAYOFMONTH(birthdatetr)<=20) THEN \"Capricornus\" WHEN (MONTH(birthdatetr)=1 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=2 AND DAYOFMONTH(birthdatetr)<=19) THEN \"Aquarius\" WHEN (MONTH(birthdatetr)=2 AND DAYOFMONTH(birthdatetr)>=20) OR (MONTH(birthdatetr)=3 AND DAYOFMONTH(birthdatetr)<=20) THEN \"Pisces\" END AS Sternzeichen, COUNT(*) AS Anzahl, RPAD(\'\',COUNT(*)/50,\'=\') AS Graphik FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>\"\" GROUP BY Sternzeichen; ","1"
"53","individuals without places","individuals without places - missing birth/baptism/death/burial place (empty place fields) ","38","","","","SELECT personID, lastname, firstname, living, gedcom FROM tng_people WHERE ((birthplace=NULL) OR (birthplace=\"\")) AND ((altbirthplace=NULL) OR (altbirthplace=\"\")) AND ((deathplace=NULL) OR (deathplace=\"\")) AND ((burialplace=NULL) OR (burialplace=\"\")) ORDER BY lastname, firstname;  ","1"
"54","individuals without date of birth/baptism/death/burial","individuals without date of birth/baptism/death/burial (empty date fields) ","37","","","","SELECT personID, lastname, firstname, living, gedcom FROM tng_people WHERE
((birthdate=NULL) OR (birthdate=\"\")) AND
(birthdatetr=\"0000-00-00\") AND
((altbirthdate=NULL) OR (altbirthdate=\"\")) AND
(altbirthdatetr=\"0000-00-00\") AND
((deathdate=NULL) OR (deathdate=\"\")) AND
(deathdatetr=\"0000-00-00\") AND
((burialdate=NULL) OR (burialdate=\"\")) AND
(burialdatetr=\"0000-00-00\")
ORDER BY lastname, firstname; ","1"
"55","indivuals ordered by ascending age","indivuals ordered by ascending age (only deceased) ","39","","","","SELECT lastname, firstname, personID, birthdate, birthdatetr, deathdate, deathdatetr, YEAR(deathdatetr)-YEAR(birthdatetr) AS Age, gedcom FROM tng_people WHERE (birthdatetr<>\"0000-00-00\") AND (deathdatetr<>\"0000-00-00\") ORDER BY Age, lastname, firstname ","1"
"56","individuals: age frequency distribution","individuals: age frequency distribution (only deceased)
Individuen: leeftijdsgrafieken (alleen overledenen)","40","","","","SELECT YEAR(deathdatetr)-YEAR(birthdatetr) AS Age, COUNT(YEAR(deathdatetr)-YEAR(birthdatetr)) AS Total FROM tng_people WHERE (birthdatetr<>\"0000-00-00\") AND (deathdatetr<>\"0000-00-00\") GROUP BY Age","1"
"57","individuals: age frequency per decade","individuals: age frequency per decade (only deceased), one = equals 100 people 
Individuen: leeftijdsverdeling per 10 jaren (alleen overledenen), een = is 100 mensen","42","","","","SELECT 10*FLOOR((YEAR(deathdatetr)-YEAR(birthdatetr))/10) AS  Age_From, 10*FLOOR((YEAR(deathdatetr)-YEAR(birthdatetr))/10)+9 AS Age_To, COUNT(*) AS Total, RPAD(\'\',COUNT(*)/100,\'=\') AS Graphik FROM tng_people WHERE (birthdatetr<>\"0000-00-00\") AND (deathdatetr<>\"0000-00-00\") GROUP BY  Age_From; ","1"
"58","Individuals marked as  living","Individuals marked as \"living\" with age > 100 years ","43","","","","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;","1"
"59","inviduals: birthdays in the current month","inviduals: birthdays in the current month (only deceased persons) ","44","","","","SELECT personID, lastname, firstname, birthdate, deathdate, YEAR(NOW())-YEAR(birthdatetr) AS Years, gedcom FROM tng_people WHERE MONTH(birthdatetr)=MONTH(NOW()) AND living=0 ORDER BY lastname, firstname, personID; ","1"
"60","individuals with an unclear date of birth","individuals with an unclear date of birth e.g. \"ABT\", \"BEF\", \"AFT\", \"CAL\" ","45","","","","SELECT personID, lastname, firstname, birthdate, living, gedcom FROM tng_people WHERE
((UCASE(birthdate) LIKE \"%CAL%\" AND birthdate<>\"\") OR
(UCASE(birthdate) LIKE \"%ERR%\" AND birthdate<>\"\") OR
(UCASE(birthdate) LIKE \"%BEF%\" AND birthdate<>\"\") OR
(UCASE(birthdate) LIKE \"%AFT%\" AND birthdate<>\"\") OR
(UCASE(birthdate) LIKE \"%ABT%\" AND birthdate<>\"\") OR
(UCASE(birthdate) LIKE \"%BEF%\" AND birthdate<>\"\") OR
(UCASE(birthdate) LIKE \"%AFT%\" AND birthdate<>\"\")  ) AND Birthdate <> \"y\" 
ORDER BY lastname, firstname, personID; ","1"
"61","individuals: birth frequency by century","individuals: birth frequency by century,  one = equals 100 people 
Individuen: geboortegrafieken per eeuw, een = is 100 mensen","46","","","","SELECT 100*FLOOR(YEAR(birthdatetr)/100) AS Year_From, (100*FLOOR(YEAR(birthdatetr)/100))+99 AS Year_Till, COUNT(*) AS Anzahl, RPAD(\'\',COUNT(*)/100,\'=\') AS Grafic FROM tng_people WHERE birthdatetr<>\'0000-00-00\'GROUP BY Year_From ORDER BY Year_From; ","1"
"62","individuals: birth frequency by decades","individuals: birth frequency by decades,  one = equals 50 people 
Individuen: geboortegrafieken per 10 jaren, een = is 50 mensen","47","","","","SELECT 10*FLOOR(YEAR(birthdatetr)/10) AS from_Year, (10*FLOOR(YEAR(birthdatetr)/10))+9 AS till_Year, COUNT(*) AS Total, RPAD(\'\',COUNT(*)/50,\'=\') AS Grafic FROM tng_people WHERE birthdatetr<>\'0000-00-00\' GROUP BY from_Year ORDER BY from_Year; ","1"
"63","individuals: birth frequency by calendar months","individuals: birth frequency by calendar months,  one = equals 50 people 
Individuen: geboortegrafieken per kalendermaand, een = is 50 mensen","48","","","","SELECT MONTHNAME(birthdatetr) AS Month_of_Birth, MONTH(birthdatetr) AS number_of_month_of_birth, COUNT(*) AS Total, RPAD(\'\',COUNT(*)/50,\'=\') AS Graphic FROM tng_people WHERE MONTH(birthdatetr)>0 GROUP BY number_of_month_of_birth; ","1"
"64","individuals: baptism frequency by century","individuals: baptism frequency by century,  one = equals 100 people 
Individuen: doopgrafieken per eew, een = is 100 mensen","49","","","","SELECT 100*FLOOR(YEAR(altbirthdatetr)/100) AS from_Year, 99+(100*FLOOR(YEAR(altbirthdatetr)/100)) AS till_Year, COUNT(*) AS Total, RPAD(\'\',COUNT(*)/100,\'X\') AS Graphic FROM tng_people WHERE altbirthdatetr<>\'0000-00-00\' GROUP BY from_Year ORDER BY from_Year; ","1"
"65","individuals: days between birth and baptism","individuals: number of days from birth and baptism
individuen: aantal dagen tussen geboorte en doop","50","","","","SELECT personID, lastname, firstname, birthdate, altbirthdate, TO_DAYS(altbirthdatetr)-TO_DAYS(birthdatetr) AS AnzahlTage, living, gedcom FROM tng_people WHERE birthdate<>\"\" AND altbirthdate<>\"\" AND DAYOFMONTH(altbirthdatetr)>0 AND DAYOFMONTH(birthdatetr)>0 ORDER BY ABS(TO_DAYS(altbirthdatetr)-TO_DAYS(birthdatetr)) DESC, lastname, firstname, birthdatetr; ","1"
"66","individuals: frequency distribution of days from birth to baptism","individuals: frequency distribution of days from birth to baptism,  one = equals 10 people 
Individuen: grafiek van de verdeling van dagen tussen geboorte en doop, een = is 10 mensen","51","","","","SELECT TO_DAYS(altbirthdatetr)-TO_DAYS(birthdatetr) AS Total_days, COUNT(*) AS Frequency, RPAD(\'\',COUNT(*)/10,\'=\') AS Graphic FROM tng_people WHERE altbirthdate<>\"\" AND birthdate<>\"\" AND DAYOFMONTH(altbirthdatetr)>0 AND DAYOFMONTH(birthdatetr)>0 GROUP BY Total_days ORDER BY Total_days; ","1"
"67","individuals with 50. birthdate this year or next year","individuals with 50. birthdate this year or next year ","52","","","","SELECT personID, lastname, firstname, YEAR(CURDATE())-YEAR(birthdatetr) AS Years, birthdate, birthplace, living, gedcom FROM tng_people WHERE (YEAR(CURDATE())-YEAR(birthdatetr)=49 OR YEAR(CURDATE())-YEAR(birthdatetr)=50) AND living=1 ORDER BY birthdatetr, lastname, firstname","1"
"68","individuals with 60. birthdate this year or next year","individuals with 60. birthdate this year or next year ","53","","","","SELECT personID, lastname, firstname, YEAR(CURDATE())-YEAR(birthdatetr) AS Years, birthdate, birthplace, living, gedcom FROM tng_people WHERE (YEAR(CURDATE())-YEAR(birthdatetr)=59 OR YEAR(CURDATE())-YEAR(birthdatetr)=60) AND living=1 ORDER BY birthdatetr, lastname, firstname; ","1"
"69","individuals with 65. birthdate this year or next year","individuals with 65. birthdate this year or next year ","54","","","","SELECT personID, lastname, firstname, YEAR(CURDATE())-YEAR(birthdatetr) AS Jahre, birthdate, birthplace, living, gedcom FROM tng_people WHERE (YEAR(CURDATE())-YEAR(birthdatetr)=64 OR YEAR(CURDATE())-YEAR(birthdatetr)=65) AND living=1 ORDER BY birthdatetr, lastname, firstname; ","1"
"70","individuals with 70. birthdate this year or next year","individuals with 70. birthdate this year or next year ","55","","","","SELECT personID, lastname, firstname, YEAR(CURDATE())-YEAR(birthdatetr) AS Years, birthdate, birthplace, living, gedcom FROM tng_people WHERE (YEAR(CURDATE())-YEAR(birthdatetr)=69 OR YEAR(CURDATE())-YEAR(birthdatetr)=70) AND living=1 ORDER BY birthdatetr, lastname, firstname; ","1"
"71","individuals with 75. birthdate this year or next year","individuals with 75. birthdate this year or next year ","56","","","","SELECT personID, lastname, firstname, YEAR(CURDATE())-YEAR(birthdatetr) AS Years, birthdate, birthplace, living, gedcom FROM tng_people WHERE (YEAR(CURDATE())-YEAR(birthdatetr)=74 OR YEAR(CURDATE())-YEAR(birthdatetr)=75) AND living=1 ORDER BY birthdatetr, lastname, firstname; ","1"
"72","individuals with 80. birthdate this year or next year","individuals with 80. birthdate this year or next year ","57","","","","SELECT personID, lastname, firstname, YEAR(CURDATE())-YEAR(birthdatetr) AS Years, birthdate, birthplace, living, gedcom FROM tng_people WHERE (YEAR(CURDATE())-YEAR(birthdatetr)=79 OR YEAR(CURDATE())-YEAR(birthdatetr)=80) AND living=1 ORDER BY birthdatetr, lastname, firstname; ","1"
"73","individuals with 85. birthdate this year or next year","individuals with 85. birthdate this year or next year ","58","","","","SELECT personID, lastname, firstname, YEAR(CURDATE())-YEAR(birthdatetr) AS Years, birthdate, birthplace, living, gedcom FROM tng_people WHERE (YEAR(CURDATE())-YEAR(birthdatetr)=84 OR YEAR(CURDATE())-YEAR(birthdatetr)=85) AND living=1 ORDER BY birthdatetr, lastname, firstname; ","1"
"74","individuals with 90. birthdate this year or next year","individuals with 90. birthdate this year or next year ","59","","","","SELECT personID, lastname, firstname, YEAR(CURDATE())-YEAR(birthdatetr) AS Years, birthdate, birthplace, living, gedcom FROM tng_people WHERE (YEAR(CURDATE())-YEAR(birthdatetr)=89 OR YEAR(CURDATE())-YEAR(birthdatetr)=90) AND living=1 ORDER BY birthdatetr, lastname, firstname; ","1"
"75","individuals with 100. birthdate this year or next year","individuals with 100. birthdate this year or next year ","61","","","","SELECT personID, lastname, firstname, YEAR(CURDATE())-YEAR(birthdatetr) AS Years, birthdate, birthplace, living, gedcom FROM tng_people WHERE (YEAR(CURDATE())-YEAR(birthdatetr)=99 OR YEAR(CURDATE())-YEAR(birthdatetr)=100) AND living=1 ORDER BY birthdatetr, lastname, firstname; ","1"
"76","individuals, by place of birth","individuals, sorted by place of birth","62","","","","SELECT birthplace, personID, lastname, firstname, birthdate, altbirthdate, living, gedcom FROM tng_people WHERE birthplace<>\"\" ORDER BY birthplace, lastname, firstname; ","1"
"77","individuals, by place of baptism","individuals, by place of baptism ","63","","","","SELECT birthplace AS Place_name, personID, lastname, firstname, birthdate, altbirthdate, living, gedcom FROM tng_people WHERE birthplace<>\"\"
UNION
SELECT altbirthplace AS Place_name, personID, lastname, firstname, birthdate, altbirthdate, living, gedcom FROM tng_people WHERE altbirthplace<>\"\" 
ORDER BY Place_name, lastname, firstname; ","1"
"78","individuals with and unclear date of death","individuals with and unclear date of death ","64","","","","SELECT personID, lastname, firstname, deathdate, burialdate, gedcom FROM tng_people WHERE
((UCASE(deathdate) LIKE \"%CA%\") OR
(UCASE(deathdate) LIKE \"%ERR%\") OR
(UCASE(deathdate) LIKE \"%VOR%\") OR
(UCASE(deathdate) LIKE \"%NACH%\") OR
(UCASE(deathdate) LIKE \"%ABT%\") OR
(UCASE(deathdate) LIKE \"%BEF%\") OR
(UCASE(deathdate) LIKE \"%AFT%\") OR DAYOFMONTH(deathdate)=0 OR MONTH(deathdate)=0) 
ORDER BY lastname, firstname, personID; ","1"
"79","individuals: death frequency by century","individuals: death frequency by century, one = equals 100 people

Individuen: overlijdensgrafieken per eeuw, een = is 100 mensen","65","","","","SELECT 100*FLOOR(YEAR(deathdatetr)/100) AS since_year, (100*FLOOR(YEAR(deathdatetr)/100))+99 AS till_year, COUNT(*) AS Anzahl, RPAD(\'\',COUNT(*)/100,\'=\') AS Graphic FROM tng_people WHERE deathdatetr<>\'0000-00-00\' GROUP BY since_year ORDER BY since_year;","1"
"80","individuals: death frequency by decades","individuals: death frequency by decades one = equals 20 people Individuen: overlijdensgrafieken per 10 jaar, een = is 20 mensen","66","","","","SELECT 10*FLOOR(YEAR(deathdatetr)/10) AS since_year, (10*FLOOR(YEAR(deathdatetr)/10))+9 AS till_year, COUNT(*) AS Anzahl, RPAD(\'\',COUNT(*)/20,\'=\') AS Graphik FROM tng_people WHERE deathdatetr<>\'0000-00-00\' GROUP BY since_year ORDER BY since_year; ","1"
"81","individuals: death frequency by calendar months","individuals: death frequency by calendar months one = equals 50 people 
Individuen: overlijdensgrafieken per kalendermaand, een = is 50 mensen","67","","","","SELECT MONTHNAME(deathdatetr) AS name_of_month_of_death, MONTH(deathdatetr) AS number_of_death_month, COUNT(*) AS Anzahl, RPAD(\'\',COUNT(*)/50,\'=\') AS Graphic FROM tng_people WHERE MONTH(deathdatetr)>0 GROUP BY number_of_death_month; ","1"
"82","individuals: death frequency by day-of-week","individuals: death frequency by day-of-week one = equals 50 people 
Individuen: overlijdensgrafieken per dag van de week, een = is 50 mensen","68","","","","SELECT DAYNAME(deathdatetr) AS name_of_day_of_death, DAYOFWEEK(deathdatetr) AS number_of_death_day, COUNT(*) AS Anzahl, RPAD(\'\',COUNT(*)/50,\'=\') AS Graphik FROM tng_people WHERE DAYOFWEEK(deathdatetr)>0 GROUP BY number_of_death_day; ","1"
"83","individuals: birth frequency by day-of-week","individuals: birth frequency by day-of-week one = equals 50 people Individuen: geboorte grafieken per dag van de week, een = is 50 mensen","66","","","","SELECT DAYNAME(birthdatetr) AS Name_of_birth_weekday , DAYOFWEEK(birthdatetr) AS Number_of_day_of_the_week, COUNT(*) AS Anzahl, RPAD(\'\',COUNT(*)/50,\'=\') AS Graphic FROM tng_people WHERE DAYOFWEEK(birthdatetr)>0 GROUP BY Number_of_day_of_the_week; ","1"
"84","families with missing partners","families with missing partners ","69","","","","SELECT familyid, husband AS Husband_PersonID, wife AS EhefrauPersonID, marrdate, living, gedcom FROM tng_families WHERE ((husband LIKE \'I%\'=0) OR (husband=\'-\') OR (wife LIKE \'I%\'=0) OR (wife=\'-\')) ORDER BY familyID; ","1"
"88","families: marriage frequency by decades","families: marriage frequency by decades one = equals 10 people 
Gezinnen: huwelijksgrafieken per eeuw, een = is 10 mensen","71","","","","SELECT 10*FLOOR(YEAR(marrdatetr)/10) AS since_year, 10*FLOOR(YEAR(marrdatetr)/10)+9 AS till_year, COUNT(*) AS Totals, RPAD(\'\',COUNT(*)/10,\'=\') AS Graphic FROM tng_families WHERE marrdatetr<>\'0000-00-00\' GROUP BY since_year ORDER BY since_year; ","1"
"89","families: marriage frequency by calendar month","families: marriage frequency by calendar month one = equals 50 people 
Gezinnen: huwelijksgrafieken per kalendermaand, een = is 50 mensen","73","","","","SELECT MONTHNAME(marrdatetr) AS month_in_which_married, MONTH(marrdatetr) AS month_of_marriage_nr, COUNT(*) AS Totals, RPAD(\'\',COUNT(*)/50,\'=\') AS Graphic FROM tng_families WHERE MONTH(marrdatetr)>0 GROUP BY month_of_marriage_nr; ","1"
"87","families: marriage frequency by century","families: marriage frequency by century one = equals 100 people 
Gezinnen: huwelijksgrafieken per eeuw, een = is 100 mensen","70","","","","SELECT 100*FLOOR(YEAR(marrdatetr)/100) AS since_year, 100*FLOOR(YEAR(marrdatetr)/100)+99 AS till_year, COUNT(*) AS Total, RPAD(\'\',COUNT(*)/100,\'=\') AS Graphic FROM tng_families WHERE marrdatetr<>\'0000-00-00\'GROUP BY since_year ORDER BY since_year;","1"
"90","families: marriage frequency by day-of-week","families: marriage frequency by day-of-week one = equals 50 people 
Gezinnen: huwelijksgrafieken per dag van de week, een = is 50 mensen","72","","","","SELECT DAYNAME(marrdatetr) AS day_of_marriage, DAYOFWEEK(marrdatetr) AS number_of_the_week, COUNT(*) AS Total, RPAD(\'\',COUNT(*)/50,\'=\') AS Graphic FROM tng_families WHERE DAYOFWEEK(marrdatetr)>0 GROUP BY number_of_the_week; ","1"
"91","individuals married with age <= 18 years","individuals married with age <= 18 years and marriage date AFTER 1785
(before 1785 there are too many people in the database who where married at a too young age, notably nobility)","74","","","","SELECT p.personID, p.lastname, p.firstname, p.sex, p.birthdate, f.marrdate, p.deathdate, f.familyID, YEAR(f.marrdatetr)-YEAR(p.birthdatetr) AS marriage_a_g_e_, p.living, f.gedcom FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.husband WHERE (f.marrdatetr-p.birthdatetr>0) AND (YEAR(f.marrdatetr)-YEAR(p.birthdatetr)<=18) and YEAR(p.birthdatetr)>1785
UNION
SELECT p.personID, p.lastname, p.firstname, p.sex, p.birthdate, f.marrdate, p.deathdate, f.familyID, YEAR(f.marrdatetr)-YEAR(p.birthdatetr) AS marriage_a_g_e_, p.living, f.gedcom FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.wife WHERE (f.marrdatetr-p.birthdatetr>0) and YEAR(p.birthdatetr)>1785 AND (YEAR(f.marrdatetr)-YEAR(p.birthdatetr)<=18) ORDER BY marriage_a_g_e_, lastname, firstname, personID; ","1"
"92","individuals married with age >= 80 years","individuals married with age >= 80 years","75","","","","SELECT p.personID, p.lastname, p.firstname, p.sex, p.birthdate, f.marrdate, p.deathdate, f.familyID, YEAR(f.marrdatetr)-YEAR(p.birthdatetr) AS Heiratsalter, p.living, f.gedcom FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.husband WHERE YEAR(p.birthdatetr)>0 AND f.marrdatetr-p.birthdatetr>0 AND YEAR(f.marrdatetr)-YEAR(p.birthdatetr)>=80
UNION
SELECT p.personID, p.lastname, p.firstname, p.sex, p.birthdate, f.marrdate, p.deathdate, f.familyID, YEAR(f.marrdatetr)-YEAR(p.birthdatetr) AS Heiratsalter, p.living, f.gedcom FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.wife WHERE YEAR(p.birthdatetr)>0 AND f.marrdatetr-p.birthdatetr>0 AND YEAR(f.marrdatetr)-YEAR(p.birthdatetr)>=80 ORDER BY Heiratsalter, lastname, firstname, personID; ","1"
"93","families: individuals with marriage date *before* birthdate","families: individuals with marriage date *before* birthdate ","77","","","","SELECT p.personID, p.lastname, p.firstname, p.sex, p.birthdate, f.marrdate, p.deathdate, f.familyID, YEAR(f.marrdatetr)-YEAR(p.birthdatetr) AS Heiratsalter, p.living, f.gedcom FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.husband WHERE YEAR(p.birthdatetr)>0 AND YEAR(f.marrdatetr)>0 AND f.marrdatetr-p.birthdatetr<0
UNION
SELECT p.personID, p.lastname, p.firstname, p.sex, p.birthdate, f.marrdate, p.deathdate, f.familyID, YEAR(f.marrdatetr)-YEAR(p.birthdatetr) AS Heiratsalter, p.living, f.gedcom FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.wife WHERE YEAR(p.birthdatetr)>0 AND YEAR(f.marrdatetr)>0 AND f.marrdatetr-p.birthdatetr<0 ORDER BY Heiratsalter, lastname, firstname, personID;","1"
"94","families: individual with marriage date *after* death date","families: individual with marriage date *after* death date ","76","","","","SELECT p.personID, p.lastname, p.firstname, p.sex, p.birthdate, p.deathdate, f.marrdate, f.familyID, YEAR(p.deathdatetr)-YEAR(f.marrdatetr) AS Jahresdifferenz, f.gedcom FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.husband WHERE YEAR(p.deathdatetr)>0 AND YEAR(f.marrdatetr)>0 AND f.marrdatetr>p.deathdatetr
UNION
SELECT p.personID, p.lastname, p.firstname, p.sex, p.birthdate, p.deathdate, f.marrdate, f.familyID, YEAR(p.deathdatetr)-YEAR(f.marrdatetr) AS Jahresdifferenz, f.gedcom FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.wife WHERE YEAR(p.deathdatetr)>0 AND YEAR(f.marrdatetr)>0 AND f.marrdatetr>p.deathdatetr ORDER BY Jahresdifferenz, lastname, firstname, personID; ","1"
"95","families: frequency distribution of marriage age, by year","families: frequency distribution of marriage age, 
Gezinnen: huwelijksgrafieken per huwelijksleeftijd","78","","","","SELECT YEAR(f.marrdatetr)-YEAR(p.birthdatetr) AS Heiratsalter, COUNT(*) AS Anzahl FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.husband WHERE p.birthdatetr>0 AND f.marrdatetr-p.birthdatetr>0 GROUP BY Heiratsalter
UNION
SELECT YEAR(f.marrdatetr)-YEAR(p.birthdatetr) AS Heiratsalter, COUNT(*) AS Anzahl FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.wife WHERE p.birthdatetr>0 AND f.marrdatetr-p.birthdatetr>0 GROUP BY Heiratsalter ORDER BY Heiratsalter; ","1"
"96","families: frequency distribution of wife\'s marriage age, by year","families: frequency distribution of wife\'s marriage age, by year one = equals 50 people 
Gezinnen: huwelijksgrafieken per huwelijksleeftijd van de vrouw, een = is 50 mensen","79","","","","SELECT YEAR(f.marrdatetr)-YEAR(p.birthdatetr) AS age_of_marriage, COUNT(*) AS Totals, RPAD(\'\',COUNT(*)/50,\'=\') AS Graphik FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.wife WHERE p.birthdatetr>0 AND f.marrdatetr-p.birthdatetr>0 GROUP BY age_of_marriage ORDER BY age_of_marriage; ","1"
"97","families: frequency distribution of husband\'s marriage age, by year","families: frequency distribution of husband\'s marriage age, by year one = equals 50 people 
Gezinnen: huwelijksgrafieken per huwelijksleeftijd van de man, een = is 50 mensen","80","","","","SELECT YEAR(f.marrdatetr)-YEAR(p.birthdatetr) AS age_at_marriage, COUNT(*) AS Totals, RPAD(\'\',COUNT(*)/50,\'=\') AS Graphic FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.husband WHERE p.birthdatetr>0 AND f.marrdatetr-p.birthdatetr>0 GROUP BY age_at_marriage ORDER BY age_at_marriage; ","1"
"98","families: frequency distribution of wife\'s marriage age, by 5-year-steps","families: frequency distribution of wife\'s marriage age, by 5-year-steps one = equals 50 people 
Gezinnen: huwelijksgrafieken van de vrouw\'s huwelijksleeftijd met 5 jaar stappen, een = is 50 mensen","81","","","","SELECT 5*FLOOR((YEAR(f.marrdatetr)-YEAR(p.birthdatetr))/5) AS married_age_from, 5*FLOOR((YEAR(f.marrdatetr)-YEAR(p.birthdatetr))/5)+4 AS married_age_till, COUNT(*) AS Total, RPAD(\'\',COUNT(*)/50,\'=\') AS Graphic FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.wife WHERE p.birthdatetr>0 AND f.marrdatetr-p.birthdatetr>0 GROUP BY married_age_from ORDER BY married_age_from; ","1"
"99","families: frequency distribution of husband\'s marriage age, by 5-year-steps","families: frequency distribution of husband\'s marriage age, by 5-year-steps one = equals 50 people 
Gezinnen: huwelijksgrafieken van de man\'s huwelijksleeftijd met 5 jaar stappen, een = is 50 mensen","82","","","","SELECT 5*FLOOR((YEAR(f.marrdatetr)-YEAR(p.birthdatetr))/5) AS age_of_marriage_since, 5*FLOOR((YEAR(f.marrdatetr)-YEAR(p.birthdatetr))/5)+4 AS age_of_marriage_till, COUNT(*) AS Totals, RPAD(\'\',COUNT(*)/50,\'=\') AS Graphik FROM tng_people AS p LEFT JOIN tng_families AS f ON p.personID=f.husband WHERE p.birthdatetr>0 AND f.marrdatetr-p.birthdatetr>0 GROUP BY age_of_marriage_since ORDER BY age_of_marriage_since; ","1"
"100"," families: occuring marriage types without names (but with frequency)"," families: occuring marriage types without names (but with frequency) one = equals 5 people 
Gezinnen: \"typen huwelijk\" zonder namen maar met aantallen, een = is 5 mensen","83","","","","SELECT marrtype AS marriage_type, COUNT(*) AS Totals, RPAD(\'\',COUNT(*)/5,\'=\') AS Graphic FROM tng_families WHERE marrtype<>\'\' GROUP BY marrtype ORDER BY marrtype;","1"
"105","Same sex marriages","","84","","","","SELECT f.familyID, h.personID, h.lastname AS Nachname1, h.firstname AS Vorname1, h.sex AS Geschlecht1, w.personID, w.lastname AS Nachname2, w.firstname AS Vorname2, w.sex AS Geschlecht2, f.living, f.gedcom FROM tng_families AS f LEFT JOIN tng_people AS h ON f.husband=h.personID LEFT JOIN tng_people AS w ON f.wife=w.personID WHERE h.sex=w.sex ORDER BY familyID; ","1"
"106","Families sorted according to number of children","","85","","","","SELECT COUNT(*) AS Kinderzahl, f.familyID, h.personID, h.lastname AS Nachname, h.firstname AS Vorname, h.birthdate, h.deathdate, f.living, f.gedcom FROM tng_children AS c INNER JOIN tng_families AS f ON (c.familyID=f.familyID AND c.gedcom=f.gedcom) INNER JOIN tng_people AS h ON (f.husband=h.personID AND f.gedcom=h.gedcom) WHERE h.personID<>\"\" GROUP BY h.personID
UNION
SELECT COUNT(*) AS Kinderzahl, f.familyID, w.personID, w.lastname AS Nachname, w.firstname AS Vorname, w.birthdate, w.deathdate, f.living, f.gedcom FROM tng_children AS c INNER JOIN tng_families AS f ON (c.familyID=f.familyID AND c.gedcom=f.gedcom) INNER JOIN tng_people AS w ON (f.wife=w.personID AND f.gedcom=w.gedcom) WHERE w.personID<>\"\" GROUP BY w.personID
ORDER BY Kinderzahl DESC, familyID, Nachname, Vorname; ","1"
"107"," individuals with missing father or missing mother"," individuals with missing father or missing mother ","86","","","","SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, father.personID AS VaterNr, father.lastname AS Name1, father.firstname AS Vorname1, father.living, mother.personID AS MutterNr, mother.lastname AS Name2, mother.firstname AS Vorname2, mother.living, p.gedcom FROM tng_children AS c LEFT JOIN tng_families AS f ON c.familyID=f.familyID LEFT JOIN tng_people AS p ON c.personID=p.personID LEFT JOIN tng_people AS mother ON f.wife=mother.personID LEFT JOIN tng_people AS father ON f.husband=father.personID WHERE f.husband=\"\" OR f.wife=\"\" ORDER BY p.lastname, p.firstname, p.birthdatetr; ","1"
"108","Incomplete families","Families where husband or wife is missing","87","","","","SELECT familyid, husband AS EhemannPersonID, wife AS EhefrauPersonID, marrdate, living, gedcom FROM tng_families WHERE (husband LIKE \'I%\'=0) OR (husband=\'-\') OR (wife LIKE \'I%\'=0) OR (wife=\'-\') ORDER BY familyID; ","1"
"109","Individuals (not: families!) with number of associated children","Individuals (not: families!) with number of associated children ","88","","","","SELECT COUNT(*) AS Kinderzahl, f.familyID, h.personID, h.lastname AS Nachname, h.firstname AS Vorname, h.birthdate, h.deathdate, f.living, f.gedcom FROM tng_children AS c LEFT JOIN tng_families AS f ON c.familyID=f.familyID LEFT JOIN tng_people AS h ON f.husband=h.personID WHERE h.personID<>\"\" GROUP BY h.personID
UNION
SELECT COUNT(*) AS Kinderzahl, f.familyID, w.personID, w.lastname AS Nachname, w.firstname AS Vorname, w.birthdate, w.deathdate, f.living, f.gedcom FROM tng_children AS c LEFT JOIN tng_families AS f ON c.familyID=f.familyID LEFT JOIN tng_people AS w ON f.wife=w.personID WHERE w.personID<>\"\" GROUP BY w.personID
ORDER BY Kinderzahl DESC, Nachname, Vorname, familyID;  ","1"
"110","Families: twins, triplets..","Families: twins, triplets..","89","","","","SELECT c.familyID, p.personID, p.lastname, p.firstname, p.birthdate, p.birthplace, p.living, COUNT(c.familyID) AS Anzahl, p.gedcom FROM tng_children AS c INNER JOIN tng_people AS p ON p.personID=c.personID INNER JOIN tng_children AS c2 ON c2.familyID=c.familyID INNER JOIN tng_people AS p2 ON p2.personID=c2.personID WHERE (p2.birthdatetr=p.birthdatetr OR p2.birthdatetr=DATE_ADD(p.birthdatetr, INTERVAL 1 DAY) OR p2.birthdatetr=DATE_SUB(p.birthdatetr, INTERVAL 1 DAY)) AND YEAR(p.birthdatetr)<>0 AND MONTH(p.birthdatetr)<>0 AND DAYOFMONTH(p.birthdatetr)<>0 GROUP BY c.familyID, p.personID, p.birthdatetr HAVING COUNT(c2.familyID)>=2 ORDER BY p.lastname, c.familyID, p.birthdatetr; ","1"
"111","Families: Twins","Families: Twins ","90","","","","SELECT c.familyID, p.personID, p.lastname, p.firstname, p.birthdate, p.birthplace, p.living, p.gedcom FROM tng_children AS c INNER JOIN tng_people AS p ON p.personID=c.personID INNER JOIN tng_children AS c2 ON c2.familyID=c.familyID INNER JOIN tng_people AS p2 ON p2.personID=c2.personID WHERE (p2.birthdatetr=p.birthdatetr OR p2.birthdatetr=DATE_ADD(p.birthdatetr, INTERVAL 1 DAY) OR p2.birthdatetr=DATE_SUB(p.birthdatetr, INTERVAL 1 DAY)) AND YEAR(p.birthdatetr)<>0 AND MONTH(p.birthdatetr)<>0 AND DAYOFMONTH(p.birthdatetr)<>0 GROUP BY c.familyID, p.personID, p.birthdatetr HAVING COUNT(c2.familyID)=2 ORDER BY p.lastname, c.familyID, p.birthdatetr; ","1"
"112","families, ordered by husband\'s name","families, ordered by husband\'s name ","91","","","","SELECT familyID, h.personID AS EhemannPersonID, h.lastname AS Nachname1, h.firstname AS Vorname1, w.personID AS EhefrauPersonID, w.lastname AS Nachname2, w.firstname AS Vorname2, f.living, f.gedcom FROM tng_families AS f LEFT JOIN tng_people AS h ON f.husband=h.personID LEFT JOIN tng_people AS w ON f.wife=w.personID ORDER BY h.lastname, h.firstname, h.personID, w.firstname, w.lastname, w.personID; ","1"
"113","families, ordered by wife\'s maiden name","families, ordered by wife\'s maiden name ","92","","","","SELECT familyID, w.personID AS EhefrauPersonID, w.lastname AS Nachname1, w.firstname AS Vorname1, h.personID AS EhemannPersonID, h.lastname As Nachname2, h.firstname AS Vorname2, f.living, f.gedcom FROM tng_families AS f LEFT JOIN tng_people AS h ON f.husband=h.personID LEFT JOIN tng_people AS w ON f.wife=w.personID ORDER BY w.lastname, w.firstname, w.personID, h.lastname, h.firstname, h.personID; ","1"
"114","families: husbands","families: husbands ","93","","","","SELECT familyID, marrdate, h.personID, h.lastname, h.firstname, h.birthdate, h.living, h.gedcom FROM tng_families AS f LEFT JOIN tng_people AS h ON f.husband=h.personID ORDER BY h.lastname, h.firstname, h.personID; ","1"
"115","families: marriage types with individuals (with personIDs *and* names)","families: marriage types with individuals (with personIDs *and* names) ","94","","","","SELECT marrtype AS Verbindungsart, familyID, marrdate, h.personID AS EhemannPersonID, h.lastname AS Nachname1, h.firstname AS Vorname1, w.personID AS EhefrauPersonID, w.lastname AS Nachname2, w.firstname AS Vorname2, f.living, f.gedcom FROM tng_families AS f LEFT JOIN tng_people AS h ON f.husband=h.personID LEFT JOIN tng_people AS w ON f.wife=w.personID WHERE f.marrtype<>\'\' ORDER BY f.marrtype, h.lastname, h.firstname, h.personID; ","1"
"116","families: wifes","families: wifes ","95","","","","SELECT familyID, marrdate, w.personID, w.lastname, w.firstname, w.birthdate, w.living, w.gedcom FROM tng_families AS f
LEFT JOIN tng_people AS w ON (f.wife=w.personID AND f.gedcom=w.gedcom)
ORDER BY w.lastname, w.firstname, w.personID; ","1"
"117","Families: individuals with missing father or missing mother","Families: individuals with missing father or missing mother ","96","","","","SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, father.personID AS VaterNr, father.lastname AS Name1, father.firstname AS Vorname1, father.living, mother.personID AS MutterNr, mother.lastname AS Name2, mother.firstname AS Vorname2, mother.living, p.gedcom FROM tng_children AS c
LEFT JOIN tng_families AS f ON (c.familyID=f.familyID AND c.gedcom=f.gedcom)
LEFT JOIN tng_people AS p ON (c.personID=p.personID AND c.gedcom=p.gedcom)
LEFT JOIN tng_people AS mother ON (f.wife=mother.personID AND f.gedcom=mother.gedcom)
LEFT JOIN tng_people AS father ON (f.husband=father.personID AND f.gedcom=father.gedcom)
WHERE f.husband=\"\" OR f.wife=\"\" ORDER BY p.lastname, p.firstname, p.birthdate","1"
"119","Faulty  birth, baptism, death and burial APROXIMATE dates, e.g. abt1988","foute geschatte datums bijv, abt1988 (geen spatie)
Kijkt alleen naar geboorte, doop, overlijdens en begraaf datums. ","117","","","","SELECT personID, lastname, firstname, birthdate, altbirthdate, deathdate, burialdate, living, gedcom FROM tng_people WHERE
(
(UCASE(birthdate) LIKE \"%CAL1%\" AND birthdate<>\"\") OR
(UCASE(birthdate) LIKE \"%ERR1%\" AND birthdate<>\"\") OR
(UCASE(birthdate) LIKE \"%BEF1%\" AND birthdate<>\"\") OR
(UCASE(birthdate) LIKE \"%AFT1%\" AND birthdate<>\"\") OR
(UCASE(birthdate) LIKE \"%ABT1%\" AND birthdate<>\"\") OR
(UCASE(altbirthdate) LIKE \"%CAL1%\" AND altbirthdate<>\"\") OR
(UCASE(altbirthdate) LIKE \"%ERR1%\" AND altbirthdate<>\"\") OR
(UCASE(altbirthdate) LIKE \"%BEF1%\" AND altbirthdate<>\"\") OR
(UCASE(altbirthdate) LIKE \"%AFT1%\" AND altbirthdate<>\"\") OR
(UCASE(altbirthdate) LIKE \"%ABT1%\" AND altbirthdate<>\"\") OR
(UCASE(deathdate) LIKE \"%CAL1%\" AND deathdate<>\"\") OR
(UCASE(deathdate) LIKE \"%ERR1%\" AND deathdate<>\"\") OR
(UCASE(deathdate) LIKE \"%BEF1%\" AND deathdate<>\"\") OR
(UCASE(deathdate) LIKE \"%AFT1%\" AND deathdate<>\"\") OR
(UCASE(deathdate) LIKE \"%ABT1%\" AND deathdate<>\"\") OR
(UCASE(burialdate) LIKE \"%CAL1%\" AND burialdate<>\"\") OR
(UCASE(burialdate) LIKE \"%ERR1%\" AND burialdate<>\"\") OR
(UCASE(burialdate) LIKE \"%BEF1%\" AND burialdate<>\"\") OR
(UCASE(burialdate) LIKE \"%ABT1%\" AND burialdate<>\"\") OR
(UCASE(burialdate) LIKE \"%AFT1%\" AND burialdate<>\"\")) AND birthdate <> \"y\" 
ORDER BY lastname, firstname, personID; ","1"
"121","individuals: number of days between birth and death","individuals: number of days between birthday and death
individuen: aantal dagen tussen verjaardag en overlijden","98","","","","SELECT personID, lastname, firstname, birthdate, deathdate, ABS(TO_DAYS(deathdatetr)-TO_DAYS(birthdatetr)) AS Number_of_days, living, gedcom FROM tng_people WHERE birthdate<>\"\" AND deathdate<>\"\" AND DAYOFMONTH(deathdatetr)>0 AND DAYOFMONTH(birthdatetr)>0 ORDER BY ABS(TO_DAYS(deathdatetr)-TO_DAYS(birthdatetr)) DESC, lastname, firstname, birthdatetr;  
","1"
"122","birthday to death,  one = equals 10 people","individuals: frequency distribution of days from birthday to death,  one = equals 10 people 
Individuen: grafiek van de verdeling van dagen tussen verjaardig en overlijden, een = is 10 mensen","99","","","","SELECT IF(ABS(DAYOFYEAR(deathdatetr)-DAYOFYEAR(birthdatetr))< 184,
TRUNCATE(ABS(DAYOFYEAR(deathdatetr)-DAYOFYEAR(birthdatetr))/7,0),
TRUNCATE((366-ABS(DAYOFYEAR(deathdatetr)-DAYOFYEAR(birthdatetr)))/7,0))
AS Difference_in_weeks, COUNT(*) AS Number, RPAD(\'\',COUNT(*)/5,\'=\') AS Stastistic FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>0 AND DAYOFYEAR(deathdatetr)<>0 GROUP BY Difference_in_weeks ORDER BY Difference_in_weeks; ","1"
"124","Dagen verschil tussen dood en leven","/ Individuals: frequency distribution of difference (in \"absolute\" weeks) between day/month of birth and day/month of death ","101","","","","SELECT IF(ABS(WEEK(deathdatetr,3)-WEEK(birthdatetr,3)) < 27,
ABS(WEEK(deathdatetr,3)-WEEK(birthdatetr,3)),53-ABS(WEEK(deathdatetr,3)-WEEK(birthdatetr,3)))
AS DifferenzWochen, COUNT(*) AS Anzahl, RPAD(\'\',COUNT(*)/5,\'=\') AS
Graphik FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>0 AND
DAYOFYEAR(deathdatetr)<>0 GROUP BY DifferenzWochen ORDER BY DifferenzWochen","1"
"125","DE WET VAN TWAALF","<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
<html xmlns=\"http://www.w3.org/1999/xhtml\">
<head>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" />
<title>Untitled Document</title>
<style type=\"text/css\">
<!--
.style2 {color: #800000}
.style4 {color: #800000; font-weight: bold; }
.style5 {font-size: medium}
-->
</style>
</head>

<body>
<span class=\"style2\">SAMENVATTING.</span><span class=\"style4 style2\"><br />
<br />
</span><span class=\"style2\">Hoe de 12 tekens van de dierenriem samenwerken en in elkaar grijpen,  wordt hieronder nog eens samengevat in een concreet voorbeeld.<br />
<br />
Er zal ergens een vereniging worden opgericht, bij voorbeeld tot steun van zieke, arme mensen.<br />
<br />
Het  initiatief ertoe wordt genomen door de heer Ram, die vol zit met idee&euml;n  en van zijn voornemen kennis geeft, door middel van een advertentie in  de krant van de heer Tweelingen. Wie sympathiseert met het plan mag  zijn kaartje sturen aan het bureau van het blad. De twee eerste  reflectanten zijn de heer Stier en mevr. Kreeft. Stier, de investeerder  heeft allang gevonden, dat er iets voor die arme drommels gedaan moest  worden en hij is blij, dat iemand de kat de bel aanbindt. Hij stuurt  zijn kaartje met het bericht erop, dat hij graag wil bijdragen in  eventueel te maken onkosten. Kreeft, die elke dag een emotie nodig  heeft, zat zich juist te vervelen en grijpt gauw de gelegenheid aan, om  zich eens &quot;wezenlijk verdienstelijk&quot; te maken. Hulp bieden aan arme  mensen! &quot;Die zijn vaak zo interessant&quot;.<br />
<br />
Zo maken deze vier de periode van ontstaan mee en vormen de voorlopige  commissie van bestuur. Zij roepen de andere gegadigden samen en nu  wordt de vereniging geconstitueerd. De heer Ram, die de zaak op gang  bracht, heeft het zijne gedaan en trekt zich voor het<br />
<br />
presidium  terug ten behoeve van de heer Leeuw, die zich in de voorzitterszetel  wonder goed op zijn plaats voelt. Als zijn rechterhand en steun wordt  tot secretaris gekozen de precieze en handige heer Maagd, die van de  heer Tweelingen het voorlopige secretariaat en de correspondentie  overneemt. Tot vice-voorzitter kiest men de welwillende en tactvolle  mevrouw Weegschaal, die als een zachte sordino, de forse autocratische  tonen van de president dempt. De beide overige leden van het voorlopige  bestuur nemen ook zitting in het definitieve, de heer Stier, als  penningmeester en mevr. Kreeft als algemeen adjunct.<br />
<br />
Voor haar moet de pret nog beginnen. Stier blijft altijd zitten waar hij zit.<br />
<br />
Nu is de vereniging er, en het lid, dat dadelijk principieel in de  oppositie is, is de heer Schorpioen, die op de voorgrond stelt, dat het  allereerst nodig is, te erkennen dat armoede niet moest bestaan en de  samenleving, waarin die aanwezig is, fout is en dat het heel aardig is  voor rijke mensen (met een schuin oog op de heer Stier) om een beetje  weldoenertje te spelen, als ze zelf meer dan genoeg hebben. Dat het ook  gemakkelijk is, royaal de grote heer te spelen (met een blik op de heer  Leeuw) maar dat het niet zo gemakkelijk is te leven naar: &ldquo;al het mijn 
is het uwe.&rdquo;<br />
<br />
Dan  komt de tijd om voor de vereniging om propaganda te maken, wat door de  heer Boogschutter met verve gedaan wordt. En ondertussen gaat het werk  beginnen. Armen moeten worden bezocht, verzoeken om steun onderzocht,  enz. Dat is werk voor de heer Steenbok, die altijd nog tijd vindt de  ondankbare baantjes op te knappen en steeds zwoegend in touw is. Bij  offici&euml;le gelegenheden, ontvangst ten stadhuize, optochten, mag deze  heer het vaandel dragen, terwijl de heer Leeuw de erewijn opdrinkt.<br />
<br />
Met  het optreden van de heer Waterman begint het contact zoeken met  zusterverenigingen, die hetzelfde doel nastreven en zo mogelijk wordt  er een federatief verband gesloten. Tenslotte zijn er geen armen meer,  dank zij het werk van de vereniging en in de laatste vergadering wordt  de heer Vis benoemd tot liquidateur. Wat met Ram begint; eindigt met  Vissen.<br />
<br />
Zo onderscheiden wij duidelijk in elke vereniging drie perioden:<br />
<br />
1.	Een leider met een groep volgelingen, dit om leiding vragen, de vorm 
is vaag en de leider is geen verantwoording verschuldigd.<br />
<br />
2. 	       Een bestuur gekozen uit en door de leden. Er is een reglement nodig en
dus is het bestuur verantwoording schuldig.<br />
<br />
3.	De propagandisten krijgen de leiding en voor het werk wordt een
betaalde beambte genomen. De vereniging ori&euml;nteert zich intercommunaal of internationaal en verdwijnt tenslotte.<br />
<br />
In de eerste periode dreigt het gevaar van Kreeft, die door de  overdrevenheid en emotionaliteit een verkeerd oordeel over de beweging  doet ontstaan en daardoor velen afschrikt.<br />
<br />
In de tweede periode dreigt het gevaar van Schorpioen, die met zijn  principes alle opportunisme vergeet en hevige inwendige strubbelingen  veroorzaakt.<br />
<br />
In de derde periode werkt alles mee tot verval. Feitelijk is dit het  tijdperk dat de vereniging zich &quot;te buiten gaat&quot;. Wij moeten dit in  filosofische zin nemen, maar letterlijk geschiedt het ook zo. De  krachtige propaganda doet een grote uitbreiding ontstaan en de begeerte  ontstaat
naar  een eigen tehuis. Dit wordt door Steenbok verwezenlijkt. Hiermede is de  vereniging op haar toppunt en begint nu af te zakken. De afstand tussen  het hoofdbestuur, zetelend in het tehuis, en de leden wordt steeds  groter. Leeuw, de autocraat, wordt uiteindelijk vervangen door  Waterman, de democratische, die een nieuw tijdperk van schijnbare  uitbreiding brengt door de congressen en banden met zusterverenigingen.  Doch Vissen, de opvolger van Schorpioen, in het bestuur is niet in  staat nieuwe animo te wekken.<br />
<br />
Slap beleid en verwaarlozing van  uiterlijk decorum doen de beweging steeds verder achteruitgaan, totdat  het besluit tot opheffing als een verlossing komt.<br />
<br />
En zo zien we in de bestuurswisselingen de groei weerspiegeld. In de  aanvang een minimum aan bestuursleden. Eigenlijk &eacute;&eacute;n leider, die  vanzelf voorzitter is: Ram, geassisteerd door 2 leden, de toegewijde  Stier, die alles betaalt en de kritiekloze Tweelingen, die alle  correspondentie afdoet.<br />
<br />
In de tweede periode: een volledig bestuur: Leeuw, Weegschaal, Stier,  Maagd en Kreeft. Na enige tijd is voor Kreeft, het nieuwtje eraf en men  benoemt de opposant Schorpioen in zijn plaats, hopende hem daardoor te  temmen. Nu is er voortdurend strijd tussen Leeuw en Schorpioen in het  bestuur. Weegschaal tracht te bemiddelen; als dit faalt, vertrekt zij  en wordt vervangen door de fanatieke Boogschutter, die nu het hoogste  woord krijgt en daardoor Leeuw doet opstappen. Nu wordt Boogschutter  voorzitter en in plaats van Weegschaal doet Waterman zijn intrede als  vice-voorzitter. Maagd is dan aan de beurt om te verdwijnen en wordt  vervangen door Steenbok, de betaalde ambtenaar.<br />
<br />
Schorpioen  houdt op te vechten tegen de luidruchtigheid van Boogschutter en het  formalisme van Steenbok. Hij verklaart de beweging voor dood en verlaat  met zijn aanhangers het strijdperk. In zijn plaats komt Vissen.<br />
<br />
Achtereenvolgens  worden Steenbok, Waterman en Vissen het meest invloedrijk. De enige die  er van het begin tot het einde in blijft is Stier, die er zijn goede  geld in gestoken heeft en uit de desolate boedel redt, wat er te redden  valt. </span>
</body>
</html>
","200","","","","SELECT * FROM `tng_places` WHERE `place`=NULL;","1"
"126","Places without coordinates","","103","","","","SELECT place,longitude,latitude, notes FROM tng_places WHERE longitude = \"\" OR latitude=\"\" OR longitude = null OR latitude= null ORDER BY place;","1"
"127","Wezen, Orphans","Personen zonder ouders, geoordend volgens de laatste invoer eerst. 
People without any parents, ordered according to the last input. ","104","","","","SELECT personID, firstname AS voornaam,lnprefix AS tussenvoegsel,lastname AS achternaam, birthdate AS Geboortedatum, birthplace AS Geboorteplaats, changedate AS Veranderdatum, gedcom FROM tng_people WHERE famc= \"\" order by changedate DESC ","1"
"128","Wezen zonder partner en kinderen, Orphans without partner and childeren","Mensen die dus aan niemand verbonden zijn. 
Open de links in het rapport alstublieft in een nieuw venster.
Persons who are connected to nobody. 
Open the links in the report please in a new window.","105","","","","SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, p.gedcom, p.changedate FROM tng_people AS p
LEFT OUTER JOIN tng_children AS c ON (p.personID=c.personID AND p.gedcom=c.gedcom)
LEFT OUTER JOIN tng_families AS f1 ON (p.personID=f1.husband AND p.gedcom=f1.gedcom)
LEFT OUTER JOIN tng_families AS f2 ON (p.personID=f2.wife AND p.gedcom=f2.gedcom)
WHERE c.personID IS NULL AND f1.husband IS NULL AND f1.wife IS NULL AND f2.husband IS NULL AND f2.wife IS NULL
ORDER BY p.changedate, p.lastname, p.firstname, p.birthdate DESC; ","1"
"129","individuals with mother, but without father (father is missing)","Individuen met hun moeder maar waar de vader mist","106","","","","SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, father.personID AS ID_Vader, father.lastname AS Name1, father.firstname AS Voornaam, father.living, mother.personID AS ID_moeder, mother.lastname AS Name2, mother.firstname AS Voornaam2, mother.living, p.gedcom FROM tng_children AS c
LEFT JOIN tng_families AS f ON (c.familyID=f.familyID AND c.gedcom=f.gedcom)
LEFT JOIN tng_people AS p ON (c.personID=p.personID AND c.gedcom=p.gedcom)
LEFT JOIN tng_people AS mother ON (f.wife=mother.personID AND f.gedcom=mother.gedcom)
LEFT JOIN tng_people AS father ON (f.husband=father.personID AND f.gedcom=father.gedcom)
WHERE f.husband=\"\" ORDER BY p.lastname, p.firstname, p.birthdate; ","1"
"130","families: individuals with father, but without mother (mother is missing)","Gezinnen met een missende moeder","107","","","","SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, father.personID AS ID_vader, father.lastname AS achternaam, father.firstname AS voornaam, father.living, mother.personID AS ID_moeder, mother.lastname AS achternaam2, mother.firstname AS voornaam2, mother.living, p.gedcom FROM tng_children AS c
LEFT JOIN tng_families AS f ON (c.familyID=f.familyID AND c.gedcom=f.gedcom)
LEFT JOIN tng_people AS p ON (c.personID=p.personID AND c.gedcom=p.gedcom)
LEFT JOIN tng_people AS mother ON (f.wife=mother.personID AND f.gedcom=mother.gedcom)
LEFT JOIN tng_people AS father ON (f.husband=father.personID AND f.gedcom=father.gedcom)
WHERE f.wife=\"\" ORDER BY p.lastname, p.firstname, p.birthdate; ","1"
"131","Places ordered by the last entered","Plaatsnamen georderend volgens de laatst toegevoegde","108","","","","SELECT place,longitude,latitude, notes, ID FROM tng_places 
ORDER BY ID DESC;","1"
"132","all occuring second place name levels p, including frequency,","all occuring second place name levels, including frequency, ordered by place name level 

Alle voorkomende tweede niveau plaatsnamen en hoe vaak ze voorkomen,geordend volgens plaatsnaam niveau","109","","","","SELECT REVERSE(SUBSTRING_INDEX(REVERSE(SUBSTRING_INDEX(place,\",\",2)),\",\",1)) AS Level_2, COUNT(*) AS Number FROM tng_places GROUP BY Level_2 ORDER BY Level_2; ","1"
"133","all occuring second place name levels, including frequency, ordered by frequency","all occuring second place name levels, including frequency, ordered by frequency

Alle voorkomende tweede niveau plaatsnamen en hoe vaak ze voorkomen. Geordend volgens frequentie","110","","","","SELECT REVERSE(SUBSTRING_INDEX(REVERSE(SUBSTRING_INDEX(place,\",\",2)),\",\",1)) AS Level_2, COUNT(*) AS Number FROM tng_places GROUP BY Level_2 ORDER BY Number DESC, Level_2;","1"
"134","All occuring third place levels, including frequency, ordered by place level","All occuring third place name levels, including frequency, ordered by place name level 

Alle voorkomende derde niveau plaatsnamen en hoe vaak ze voorkomen. Geordend bij plaatsnaam niveau. ","111","","","","SELECT LTRIM(REVERSE(SUBSTRING_INDEX(REVERSE(place),\",\",1))) AS Level_3, COUNT(*) AS Number FROM tng_places GROUP BY Level_3 ORDER BY Level_3;  ","1"
"135","All occuring third place name levels, including frequency, ordered by frequency","All occuring third place name levels, including frequency, ordered by frequency 

Alle voorkomende derde niveau plaatsnamen en hoe vaak ze voorkomen. Geordend volgens frequentie","112","","","","SELECT LTRIM(REVERSE(SUBSTRING_INDEX(REVERSE(place),\",\",1))) AS Level_3, COUNT(*) AS Number FROM tng_places GROUP BY Level_3 ORDER BY Number DESC, Level_3; ","1"
"136","Faulty birth dates","Foutieve geboortedatums","113","","","","SELECT personID, lastname, firstname, birthdate, birthdatetr, altbirthdate, deathdate, burialdate, living, gedcom FROM tng_people
WHERE (
`birthdate` <> \"y\"
OR `birthdate` <> \"Y\"
 OR `birthdate` = \"\")
AND `birthdatetr` = \"0000-00-00\" AND birthdate NOT LIKE \"%BC%\"

ORDER BY lastname, firstname, personID; ","1"
"137","Faulty baptismal dates","foutieve doopdatums","114","","","","SELECT personID, lastname, firstname, birthdate,  altbirthdate, altbirthdatetr, deathdate, burialdate, living, gedcom FROM tng_people
WHERE 
`altbirthdate` <> \"\"

AND `altbirthdatetr` = \"0000-00-00\"

ORDER BY lastname, firstname, personID; ","0"
"138","Faulty burial dates","foutieve begraafdatums","115","","","","SELECT personID, lastname, firstname, birthdate,  altbirthdate, deathdate, burialdate, burialdatetr, living, gedcom FROM tng_people
WHERE 
`burialdate` <> \"\"

AND `burialdatetr` = \"0000-00-00\"

ORDER BY lastname, firstname, personID; ","1"
"139","Faulty death dates","foutieve overlijdensdatums","116","","","","SELECT personID, lastname, firstname, birthdate,  altbirthdate, deathdate, deathdatetr, burialdate, living, gedcom FROM tng_people
WHERE ((
`deathdate` <> \"y\"
OR `deathdate` <> \"Y\"
) 
)
AND `deathdate` <> \"n\"
AND `deathdate` = NULL
AND living = \"0\"
AND `deathdatetr` = \"0000-00-00\" 
AND `birthdatetr` > \"1909\"
ORDER BY lastname, firstname, personID; ","1"
"140","Levende Savenije\'s","Je moet ingelogd zijn om hier iets te zien","150","","","","SELECT tng_people.living, firstname, lastname, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) WHERE (tng_people.living = 1 AND lastname like \"sav%n%\") ORDER BY firstname","1"
"141","Levende Boekholt\'s","Je moet ingelogd zijn om hier iets nuttigs te zien","150","","","","SELECT tng_people.living, firstname, lastname, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) WHERE (tng_people.living = 1 AND lastname like \"boekh%\") ORDER BY firstname","1"
"142","Levende personen","Je moet ingelogd zijn om hier iets nuttigs te zien","150","","","","SELECT tng_people.living, firstname, lastname, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) WHERE (tng_people.living = 1)  ORDER BY firstname","1"
"152","Age of living people","leeftijd van nog levenden
Similar to the report 124 only now it gives ages with the addition of months etc. 
","125","","","","SELECT personid, last_name, first_name, birth_date, death_date, concat( ay, \'y, \', am, \'m, \', ad, if( around, \'d (around)\', \'d\' ) ) AS age, living
FROM (

SELECT personid, last_name, first_name, birth_date, death_date, year( adt ) - year( abd ) - ( mid( adt, 6, 5 ) < mid( abd, 6, 5 ) ) AS ay, (
mid( adt, 6, 5 ) < mid( abd, 6, 5 )
) *12 + month( adt ) - month( abd ) - ( day( adt ) < day( abd ) ) AS am, day( adt ) - day( abd ) + if( day( adt ) < day( abd ) , day( last_day( adt - INTERVAL 1
MONTH ) ) , 0 ) AS ad, (
birth_date != abd
OR (
death_date != adt
AND NOT living
)
) AS around, living
FROM (

SELECT personid, lastname AS last_name, firstname AS first_name, birthdatetr AS birth_date, deathdatetr AS death_date, living, if( day( birthdatetr ) , birthdatetr, concat( year( birthdatetr ) , if( month( birthdatetr ) , mid( birthdatetr, 5, 3 ) , \'-01\' ) , \'-01\' ) ) AS abd, if( deathdatetr, if( day( deathdatetr ) , deathdatetr, concat( year( deathdatetr ) , if( month( deathdatetr ) , mid( deathdatetr, 5, 3 ) , \'-01\' ) , \'-01\' ) ) , now( ) ) AS adt, living
FROM tng_people
WHERE gedcom = \'savenije\'
AND birthdatetr
AND (
deathdatetr
OR living
)
) AS ppl
) AS agp
ORDER BY ay DESC , am DESC , ad DESC , last_name, first_name","1"
"153","Present age of living people","Leeftijd van levende personen

(alleen zichtbaar als je ingelogd bent)","124","","","","select personid,ln,fn,bd,dd,ay,am,ad, approx, living
from (select personid, ln, fn, bd, dd, 
year(adt)-year(abd)-(mid(adt,6,5)<mid(abd,6,5)) as ay,
(mid(adt,6,5)<mid(abd,6,5))*12+month(adt)-month(abd) 
-(day(adt)<day(abd))as am, day(adt)- day(abd)+ if(day(adt)<day(abd), 
day(last_day(adt - interval 1 month)),0) as ad,
(bd != abd or(dd != adt and not living))as approx, living
from (SELECT personid, lastname as ln, firstname as fn, birthdatetr as 
bd, deathdatetr as dd, living,
if(day(birthdatetr), birthdatetr, concat(year(birthdatetr), 
if(month(birthdatetr),mid(birthdatetr,5,3),\'-01\'),\'-01\'))  as abd, 
if(deathdatetr,if(day(deathdatetr),deathdatetr, 
concat(year(deathdatetr),if(month(deathdatetr),mid(deathdatetr,5,3),\'-01\'),\'-01\')),now())as 
adt
FROM tng_people where gedcom = \'savenije\' and birthdatetr and 
(deathdatetr or living)) as ppl) as agp
order by  ay desc,am desc,ad desc,ln,fn","1"
"154","Places with an empty description but with coordinates","Plaatsnamen zonder een beschrijving, maar met coordinaten","123","","","","SELECT place, longitude, latitude, zoom, placelevel, notes
FROM `tng_places`
WHERE (
notes = \"\"
OR notes = NULL
)
AND (
Longitude <> \"\"
AND latitude <> \"\"
)","1"
"155","Born after Baptized","Persons who are born after they are baptized
Personen die geboren zijn nadat ze gedoopt zijn.","122","","","","SELECT personID, firstname, lastname, birthdate, birthdatetr, altbirthdate, altbirthdatetr, YEAR( altbirthdatetr ) - YEAR( birthdatetr ) AS Age
FROM tng_people
WHERE (
YEAR( altbirthdatetr ) - YEAR( birthdatetr ) <0
)
AND (
`birthdatetr` !=0000 -00 -00
OR YEAR( altbirthdatetr ) !=0000
)
AND birthdate != \"\"
AND altbirthdate != \"\"
AND `living` = \"0\"
AND altbirthdate != \"n\"
AND YEAR( altbirthdatetr ) - YEAR( birthdatetr ) !=0","1"
"156","The wife is male","Marriages where the wife is male and therefore a mistake might have been made
Huwelijken waar de echtgenote is mannelijk en mogelijk verkeerd zou kunnen zijn ingevoerd","121","","","","SELECT f.familyID, h.personID, h.lastname AS LastName1, h.firstname AS FirstName1, h.sex AS Sex1, w.personID, w.lastname AS LastName2, w.firstname AS FirstName2, w.sex AS Sex2, f.living, f.gedcom
FROM tng_families AS f
LEFT JOIN tng_people AS h ON f.husband = h.personID
LEFT JOIN tng_people AS w ON f.wife = w.personID
WHERE (
w.sex = \"M\"
)
ORDER BY familyID","1"
"157","People born after they died","Personen geboren nadat ze overleden zijn. ","121","","","","SELECT personID, firstname, lastname, birthdate, birthdatetr, birthplace, deathdate, deathdatetr, deathplace, YEAR( deathdatetr ) - YEAR( birthdatetr ) AS Age
FROM tng_people
WHERE (
(
`birthdatetr`
) - ( `deathdatetr` ) >0
)
AND `birthdatetr` <>0000 -00 -00
AND `deathdatetr` <>0000 -00 -00
AND deathdate != \"y\"
AND deathdate != \"0\"
AND `living` = \"0\"
AND deathdate != \"n\"
AND YEAR( deathdatetr ) - YEAR( birthdatetr ) !=0","1"
"158","Husband is female","Marriages where the husband is female and therefore a mistake might have been made. 
Huwelijken waar de man vrouwelijk is en er mogelijk een fout gemaakt is.","119","","","","SELECT f.familyID, h.personID, h.lastname AS LastName1, h.firstname AS FirstName1, h.sex AS Sex1, w.personID, w.lastname AS LastName2, w.firstname AS FirstName2, w.sex AS Sex2, f.living, f.gedcom
FROM tng_families AS f
LEFT JOIN tng_people AS h ON f.husband = h.personID
LEFT JOIN tng_people AS w ON f.wife = w.personID
WHERE (
h.sex = \"F\"
)
ORDER BY familyID","1"
"159","People without a default image","Mensen zonder een standaard klikplaatje","126","","","","SELECT lastname, firstname, personid, gedcom FROM
(
  SELECT p.lastname, p.firstname, p.personid, p.gedcom, MAX(ml.defphoto) AS mdp,  
  COUNT(ml.medialinkid) AS n 
  FROM tng_people AS p, tng_medialinks AS ml, tng_media AS m
  WHERE ml.personid = p.personid AND ml.gedcom = p.gedcom and 
  ml.mediaid = m.mediaid AND m.gedcom = p.gedcom AND m.mediatypeid = \'photos\'
  GROUP BY p.personid
) 
AS tmp
WHERE n > 0 AND mdp != 1","1"
"160","Show private notes","Toon privé notities","126","","","","SELECT personID, lastname, firstname, birthdate, deathdate, living, note,
p.gedcom FROM tng_people AS p
INNER JOIN tng_notelinks AS nl ON (p.personID=nl.persfamID AND
p.gedcom=nl.gedcom)
INNER JOIN tng_xnotes AS xn ON (nl.xnoteID=xn.ID AND nl.gedcom=xn.gedcom)
WHERE nl.secret<>0
ORDER BY lastname, firstname, birthdatetr;","1"
"161","Documents linked to people not to an event","Documenten die aan een persoon gelinked zijn. ","155","","","","SELECT description, 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=m.gedcom)
LEFT JOIN tng_people AS p ON (ml.personID=p.personID AND ml.gedcom=p.gedcom)
WHERE mediatypeID=\"documents\" AND eventID=\"\"
ORDER BY description;
","1"
"162","Orphaned families","Families with no husband and no wife
Gezinnen met geen vader en geen moeder","128","","","","SELECT familyid, husband AS husbandPersonID, wife AS WifePersonID, marrdate, living, gedcom FROM tng_families WHERE husband=\"\" AND wife=\"\" ORDER BY CAST(SUBSTRING(familyID, 2) AS UNSIGNED); ","1"
"163","Double names","Wifes with duplicate marriage names (check for data plausibility) 

Vrouwen met een dubbele trouw naam. (Check naar de integriteit van de gegevens)","129","","","","SELECT personID, lastname, firstname, birthdate, living, p.gedcom, et.tag AS Event, et.description, e.info FROM tng_people AS p
LEFT JOIN tng_events AS e ON (e.persfamID=p.personID AND e.gedcom=p.gedcom)
LEFT JOIN tng_eventtypes AS et ON e.eventtypeID=et.eventtypeID
WHERE tag=\'EVEN\' AND description=\'Spousename\' GROUP BY personID, info HAVING COUNT(*)>1 ORDER BY lastname, firstname, birthdatetr; ","0"
"164","People with the same surname as their mother","People with a different surname as their father but the same as their mother (born after 1811, due to the Dutch system, before 1811 people used patronymics)
Mensen met een andere achternaam dan hun vader geboren na 1811 (voor 1811 gebruikte men patroniemen)maar dezelfde als hun moeder","130","","","","SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, p.gedcom, f.familyID, father.personID AS FatherNr, father.lastname AS Fatherlast_name, mother.personID AS MotherNr, mother.lastname AS Motherlast_name FROM tng_children AS ch LEFT JOIN tng_people AS p ON (ch.personID=p.personID AND ch.gedcom=p.gedcom) LEFT JOIN tng_families AS f ON (ch.familyID=f.familyID AND ch.gedcom=f.gedcom) LEFT JOIN tng_people AS father ON (father.personID=f.husband AND father.gedcom=f.gedcom) LEFT JOIN tng_people AS mother ON (mother.personID=f.wife AND mother.gedcom=f.gedcom)
WHERE (p.lastname=mother.lastname AND YEAR(p.birthdatetr)>\"1811\") AND  father.lastname <> \"\" AND father.lastname <> mother.lastname ORDER BY p.lastname, p.firstname, p.birthdatetr; ","1"
"165","Different surname as both parents","People whose last names is different from the last name of the father AND the last name of the mother.

Mensen met een andere achternaam dan de vader EN de moeder. ","131","","","","
SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, p.gedcom, father.lastname AS Fatherlast_name, mother.lastname AS Motherlast_name FROM tng_children AS ch LEFT JOIN tng_people AS p ON (ch.personID=p.personID AND ch.gedcom=p.gedcom) LEFT JOIN tng_families AS f ON (ch.familyID=f.familyID AND ch.gedcom=f.gedcom) LEFT JOIN tng_people AS father ON (father.personID=f.husband AND father.gedcom=f.gedcom) LEFT JOIN tng_people AS mother ON (mother.personID=f.wife AND mother.gedcom=f.gedcom)
WHERE p.lastname<>father.lastname AND p.lastname<>mother.lastname  AND YEAR(p.birthdatetr)>\"1811\" ORDER BY p.lastname, p.firstname, p.birthdatetr; ","1"
"166","People with a different surname as their father","People with a different surname as their father (born after 1811)

Mensen met een andere achternaam as hun vader (geboren na 1811)","132","","","","SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, p.gedcom, f.familyID, father.personID AS FatherNr, father.lastname AS Fatherlast_name, mother.personID AS MotherNr, mother.lastname AS Motherlast_name FROM tng_children AS ch LEFT JOIN tng_people AS p ON (ch.personID=p.personID AND ch.gedcom=p.gedcom) LEFT JOIN tng_families AS f ON (ch.familyID=f.familyID AND ch.gedcom=f.gedcom) LEFT JOIN tng_people AS father ON (father.personID=f.husband AND father.gedcom=f.gedcom) LEFT JOIN tng_people AS mother ON (mother.personID=f.wife AND mother.gedcom=f.gedcom)
WHERE p.lastname<>father.lastname AND YEAR(p.birthdatetr)>\"1811\" ORDER BY p.lastname, p.firstname, p.birthdatetr; ","1"
"167","People ordered with the age of their parents","People ordered with the age of their parents ordered according to the age of the father

Mensen geordend MET de leeftijd van hun ouders, gerangschikked volgens de leeftijd van de vader","133","","","","SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, father.personID AS FatherNr, father.birthdate AS FatherBirthdate, YEAR( p.birthdatetr ) - YEAR( father.birthdatetr ) AS Father_age, mother.personID AS MotherNr, mother.birthdate AS MotherBirthdate, YEAR( p.birthdatetr ) - YEAR( mother.birthdatetr ) AS Mother_age, p.gedcom
FROM tng_children AS ch
LEFT JOIN tng_people AS p ON ( ch.personID = p.personID
AND ch.gedcom = p.gedcom )
LEFT JOIN tng_families AS f ON ( ch.familyID = f.familyID
AND ch.gedcom = f.gedcom )
LEFT JOIN tng_people AS father ON ( father.personID = f.husband
AND father.gedcom = f.gedcom )
LEFT JOIN tng_people AS mother ON ( mother.personID = f.wife
AND mother.gedcom = f.gedcom )
WHERE p.birthdatetr <> \"0000-00-00\"
AND father.birthdatetr <> \"0000-00-00\"
AND mother.birthdatetr <> \"0000-00-00\"
AND p.birthdate NOT LIKE \"Aft%\"
ORDER BY Father_age, p.lastname, p.firstname, p.birthdatetr","1"
"168","People ordered with the age of their parents","People with the age of their parents, ordered by the age of the mother 

Mensen met de leeftijd van hun ouders gerangschikt volgens de leeftijd van de moeder","134","","","","SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, father.personID AS FatherNr, father.birthdate AS FatherBirthdate, YEAR( p.birthdatetr ) - YEAR( father.birthdatetr ) AS Father_age, mother.personID AS MotherNr, mother.birthdate AS MotherBirthdate, YEAR( p.birthdatetr ) - YEAR( mother.birthdatetr ) AS Mother_age, p.gedcom
FROM tng_children AS ch
LEFT JOIN tng_people AS p ON ( ch.personID = p.personID
AND ch.gedcom = p.gedcom )
LEFT JOIN tng_families AS f ON ( ch.familyID = f.familyID
AND ch.gedcom = f.gedcom )
LEFT JOIN tng_people AS father ON ( father.personID = f.husband
AND father.gedcom = f.gedcom )
LEFT JOIN tng_people AS mother ON ( mother.personID = f.wife
AND mother.gedcom = f.gedcom )
WHERE p.birthdatetr <> \"0000-00-00\"
AND father.birthdatetr <> \"0000-00-00\"
AND mother.birthdatetr <> \"0000-00-00\"
AND p.birthdate NOT LIKE \"Aft%\"
ORDER BY Mother_age, p.lastname, p.firstname, p.birthdatetr","1"
"169","Statistic of people becoming parents","Frequency distribution of age where males (M) become father and females (F) become mother (for all children) 

Verdeling van leeftijd waarop mensen ouder worden","135","","","","SELECT YEAR(p.birthdatetr)-YEAR(father.birthdatetr) AS parents_age, COUNT(*) AS amount_, RPAD(\'\',COUNT(*)/20,\'M\') AS Graph FROM tng_children AS ch LEFT JOIN tng_people AS p ON (ch.personID=p.personID AND ch.gedcom=p.gedcom) LEFT JOIN tng_families AS f ON (ch.familyID=f.familyID AND ch.gedcom=f.gedcom) LEFT JOIN tng_people AS father ON (father.personID=f.husband AND father.gedcom=f.gedcom)
WHERE p.birthdatetr<>\"0000-00-00\" AND father.birthdatetr<>\"0000-00-00\" AND YEAR(p.birthdatetr)-YEAR(father.birthdatetr)>15 AND YEAR(p.birthdatetr)-YEAR(father.birthdatetr)<60 GROUP BY parents_age
UNION
SELECT YEAR(p.birthdatetr)-YEAR(mother.birthdatetr) AS parents_age, COUNT(*) AS amount_, RPAD(\'\',COUNT(*)/20,\'F\') AS Graph FROM tng_children AS ch LEFT JOIN tng_people AS p ON (ch.personID=p.personID AND ch.gedcom=p.gedcom) LEFT JOIN tng_families AS f ON (ch.familyID=f.familyID AND ch.gedcom=f.gedcom) LEFT JOIN tng_people AS mother ON (mother.personID=f.wife AND mother.gedcom=f.gedcom)
WHERE p.birthdatetr<>\"0000-00-00\" AND mother.birthdatetr<>\"0000-00-00\" AND YEAR(p.birthdatetr)-YEAR(mother.birthdatetr)>15 AND YEAR(p.birthdatetr)-YEAR(mother.birthdatetr)<60 GROUP BY parents_age
ORDER BY parents_age; ","1"
"170","People born into more families","Mensen die in meerdere gezinnen zijn geboren","136","","","","SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, COUNT(*) AS number_of_families, p.gedcom FROM tng_children AS ch
LEFT JOIN tng_people AS p ON (ch.personID=p.personID AND ch.gedcom=p.gedcom)
GROUP BY personID HAVING COUNT(*)>1 ORDER BY lastname, firstname; ","1"
"171","Wrong place names for PERSONS","Places to persons, which are NOT a member of the places table (check for data plausibility) 

Mensen in plaatsen die niet in de plaatsnamen lijst staan (controle op plausibiliteit)","137","","","","SELECT personID, lastname, firstname, \"Place of birth\" AS Kind_of_place, birthplace AS place_detail, living, p.gedcom FROM tng_people AS p LEFT JOIN tng_places AS pl ON (p.birthplace=pl.place AND p.gedcom=pl.gedcom) WHERE ISNULL(place) AND birthplace<>\"\"
UNION
SELECT personID, lastname, firstname, \"Place of birth\" AS Kind_of_place, altbirthplace AS place_detail, living, p.gedcom FROM tng_people AS p LEFT JOIN tng_places AS pl ON (p.altbirthplace=pl.place AND p.gedcom=pl.gedcom) WHERE ISNULL(place) AND altbirthplace<>\"\"
UNION
SELECT personID, lastname, firstname, \"Place of death\" AS Kind_of_place, deathplace AS place_detail, living, p.gedcom FROM tng_people AS p LEFT JOIN tng_places AS pl ON (p.deathplace=pl.place AND p.gedcom=pl.gedcom) WHERE ISNULL(place) AND deathplace<>\"\"
UNION
SELECT personID, lastname, firstname, \"Place of burial\" AS Kind_of_place, burialplace AS place_detail, living, p.gedcom FROM tng_people AS p LEFT JOIN tng_places AS pl ON (p.burialplace=pl.place AND p.gedcom=pl.gedcom) WHERE ISNULL(place) AND burialplace<>\"\"
UNION
SELECT personID, lastname, firstname, \"Place of event\" AS Kind_of_place, eventplace AS place_detail, living, p.gedcom FROM tng_events AS e LEFT JOIN tng_places AS pl ON (e.eventplace=pl.place AND e.gedcom=pl.gedcom) LEFT JOIN tng_people AS p ON (e.persfamID=p.personID AND e.gedcom=p.gedcom) WHERE ISNULL(place) AND eventplace<>\"\"
ORDER BY lastname, firstname; ","1"
"172","Wrong place names for FAMIILIES","Places to families, which are NOT a member of the places table (check for data plausibility) 

Gezinnen in plaatsen die niet in de plaatsnamen lijst staan (controle op plausibiliteit)","138","","","","SELECT familyID, husband, wife, \"Place of marriage\" AS Kind_of_place, marrplace AS Entered_place_name, f.gedcom FROM tng_families AS f LEFT JOIN tng_places AS pl ON (f.marrplace=pl.place AND f.gedcom=pl.gedcom) WHERE ISNULL(place) AND marrplace<>\"\"
UNION
SELECT familyID, husband, wife, \"Place of divorce\" AS Kind_of_place, divplace AS Entered_place_name, f.gedcom FROM tng_families AS f LEFT JOIN tng_places AS pl ON (f.divplace=pl.place AND f.gedcom=pl.gedcom) WHERE ISNULL(place) AND divplace<>\"\"
ORDER BY CAST(SUBSTRING(familyID, 2) AS UNSIGNED); ","1"
"173","Media statistics","Media statistieken","139","","","","SELECT mediatypeID AS Media_Type, COUNT(*) AS Amount FROM tng_media GROUP BY mediatypeID
UNION
SELECT \"Total\" AS Media_Type, COUNT(*) AS Amount FROM tng_media;","1"
"174","Media overview by media type","Media overzicht per media type. ","140","","","","SELECT mediatypeID AS MediaType, mediaID AS MediaNr, description, gedcom FROM tng_media ORDER BY mediatypeID, description; ","1"
"175","Media which are always visible","Media having the \"always on\" tag activated

Media die als \"Altijd zichtbaar\" zijn gemarkeerd","141","","","","SELECT description, mediatypeID AS Mediia_type, p.personID, 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=m.gedcom)
LEFT JOIN tng_people AS p ON (ml.personID=p.personID AND ml.gedcom=p.gedcom)
WHERE alwayson<>0
ORDER BY description; ","1"
"176","Media not associated with a tree","Media die niet aan een boom vastzit","142","","","","SELECT mediaID AS MediaNr, description, mediatypeID AS Media_type FROM tng_media WHERE gedcom=\"\" OR ISNULL(gedcom) ORDER BY description;","1"
"177","Media without coordinates","Media zonder coordinaten","143","","","","SELECT mediaID, description, mediatypeID, gedcom FROM tng_media WHERE longitude=\"\" OR latitude=\"\" ORDER BY description; ","1"
"178","Media with coordinates","Media met coordinaten. ","144","","","","SELECT mediaID AS MediaNr, description, mediatypeID AS Media_Type, longitude, latitude, gedcom FROM tng_media WHERE longitude<>\"\" AND latitude<>\"\" AND NOT ISNULL(longitude) AND NOT ISNULL(latitude) ORDER BY description; ","1"
"179","Media with associated people, *without* having media linked to an event","Media with associated people, *without* having media linked to an event

Media met de eraan gelinked mensen zonder dat de media aan een gebeurtenis gelinked zijn. ","145","","","","SELECT description, mediatypeID AS Media_type, p.personID, 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=m.gedcom)
LEFT JOIN tng_people AS p ON (ml.personID=p.personID AND ml.gedcom=p.gedcom)
WHERE eventID=\"\"
ORDER BY description;  	 ","1"
"180","Media with associated people, *with* having media linked to an event","Media with associated people, *with* having media linked to an event

Media met eraan gelinkte mensen MET media gelinked aan een gebeurtenis
","146","","","","SELECT description, mediatypeID AS Media_type, p.personID, 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=m.gedcom)
LEFT JOIN tng_people AS p ON (ml.personID=p.personID AND ml.gedcom=p.gedcom)
WHERE eventID<>\"\"
ORDER BY description;  	","1"
"181","Media which are set as \"default photo\"","Media die als standaard foto zijn aangevinked","147","","","","SELECT description, mediatypeID AS Media_type, p.personID, 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=m.gedcom)
LEFT JOIN tng_people AS p ON (ml.personID=p.personID AND ml.gedcom=p.gedcom)
WHERE defphoto=1
ORDER BY description;  	 ","1"
"182","Media which are *not* set as \"default photo\"","Media die NIET als standaard foto zijn aangevinked","148","","","","SELECT description, mediatypeID AS Media_type, p.personID, 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=m.gedcom)
LEFT JOIN tng_people AS p ON (ml.personID=p.personID AND ml.gedcom=p.gedcom)
WHERE defphoto<>1
ORDER BY description; ","1"
"183","People *with* associated media, but *without* default photo","Mensen MET plaatjes, maar zonder standaard plaatje","149","","","","SELECT p.personID, p.lastname, p.firstname, p.living, p.gedcom, description, mediatypeID AS Media_type FROM tng_media AS m
LEFT JOIN tng_medialinks AS ml ON (ml.mediaID=m.mediaID AND ml.gedcom=m.gedcom)
LEFT JOIN tng_people AS p ON (ml.personID=p.personID AND ml.gedcom=p.gedcom)
WHERE defphoto<>1
ORDER BY lastname, firstname, birthdatetr; ","1"
"184","People without any dates","Mensen zonder enige datums","150","","","","SELECT personID, lastname, firstname, living, gedcom FROM tng_people WHERE
((birthdate=NULL) OR (birthdate=\"\")) AND
(birthdatetr=\"0000-00-00\") AND
((altbirthdate=NULL) OR (altbirthdate=\"\")) AND
(altbirthdatetr=\"0000-00-00\") AND
((deathdate=NULL) OR (deathdate=\"\")) AND
(deathdatetr=\"0000-00-00\") AND
((burialdate=NULL) OR (burialdate=\"\")) AND
(burialdatetr=\"0000-00-00\")
ORDER BY lastname, firstname; ","1"
"185","Children born before their mother","Kinderen geboren voor hun moeder","156","","","","SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, father.personID AS FatherNr, father.birthdate AS FatherBirthdate, YEAR( p.birthdatetr ) - YEAR( father.birthdatetr ) AS Father_age, mother.personID AS MotherNr, mother.birthdate AS MotherBirthdate, YEAR( p.birthdatetr ) - YEAR( mother.birthdatetr ) AS Mother_age, p.gedcom
FROM tng_children AS ch
LEFT JOIN tng_people AS p ON ( ch.personID = p.personID
AND ch.gedcom = p.gedcom )
LEFT JOIN tng_families AS f ON ( ch.familyID = f.familyID
AND ch.gedcom = f.gedcom )
LEFT JOIN tng_people AS father ON ( father.personID = f.husband
AND father.gedcom = f.gedcom )
LEFT JOIN tng_people AS mother ON ( mother.personID = f.wife
AND mother.gedcom = f.gedcom )
WHERE p.birthdatetr <> \"0000-00-00\"
AND father.birthdatetr <> \"0000-00-00\"
AND mother.birthdatetr <> \"0000-00-00\"
AND mother.birthdatetr > p.birthdatetr
AND p.birthdate NOT LIKE \"Aft%\"
ORDER BY Mother_age, p.lastname, p.firstname, p.birthdatetr;","1"
"186","Children born before their father","Kinderen geboren voor hun vader","157","","","","SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, father.personID AS FatherNr, father.birthdate AS FatherBirthdate, YEAR( p.birthdatetr ) - YEAR( father.birthdatetr ) AS Father_age, mother.personID AS MotherNr, mother.birthdate AS MotherBirthdate, YEAR( p.birthdatetr ) - YEAR( mother.birthdatetr ) AS Mother_age, p.gedcom
FROM tng_children AS ch
LEFT JOIN tng_people AS p ON ( ch.personID = p.personID
AND ch.gedcom = p.gedcom )
LEFT JOIN tng_families AS f ON ( ch.familyID = f.familyID
AND ch.gedcom = f.gedcom )
LEFT JOIN tng_people AS father ON ( father.personID = f.husband
AND father.gedcom = f.gedcom )
LEFT JOIN tng_people AS mother ON ( mother.personID = f.wife
AND mother.gedcom = f.gedcom )
WHERE p.birthdatetr <> \"0000-00-00\"
AND father.birthdatetr <> \"0000-00-00\"
AND mother.birthdatetr <> \"0000-00-00\"
AND father.birthdatetr > p.birthdatetr
AND p.birthdate NOT LIKE \"Aft%\"
ORDER BY Father_age, p.lastname, p.firstname, p.birthdatetr;","1"
"187","Children born after the death of their mother","Kinderen geboren na de dood van hun moeder","158","","","","SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, father.personID AS FatherNr, father.birthdate AS FatherBirthdate, YEAR( p.birthdatetr ) - YEAR( father.birthdatetr ) AS Father_age, mother.personID AS MotherNr, mother.birthdate AS MotherBirthdate, YEAR( p.birthdatetr ) - YEAR( mother.birthdatetr ) AS Mother_age, mother.deathdate, p.gedcom
FROM tng_children AS ch
LEFT JOIN tng_people AS p ON ( ch.personID = p.personID
AND ch.gedcom = p.gedcom )
LEFT JOIN tng_families AS f ON ( ch.familyID = f.familyID
AND ch.gedcom = f.gedcom )
LEFT JOIN tng_people AS father ON ( father.personID = f.husband
AND father.gedcom = f.gedcom )
LEFT JOIN tng_people AS mother ON ( mother.personID = f.wife
AND mother.gedcom = f.gedcom )
WHERE p.birthdatetr <> \"0000-00-00\"
AND mother.birthdatetr <> \"0000-00-00\"
AND p.deathdatetr <> \"0000-00-00\"
AND mother.deathdatetr <> \"0000-00-00\"
AND mother.deathdatetr < p.birthdatetr

ORDER BY Mother_age, p.lastname, p.firstname, p.birthdatetr;","1"
"188","Children born after 9 months after their father\'s death","Kinderen geboren later dan 9 maanden na hun vader\'s dood","159","","","","SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, father.personID AS FatherNr, father.birthdate AS FatherBirthdate, YEAR( p.birthdatetr ) - YEAR( father.birthdatetr ) AS Father_age, p.birthdate, (
(
YEAR( father.deathdatetr ) + MONTH( father.deathdatetr )
) - ( YEAR( p.birthdatetr ) + MONTH( p.birthdatetr ) )
) AS dif_F_death_Ch_birth, father.deathdate, mother.personID AS MotherNr, mother.birthdate AS MotherBirthdate, YEAR( p.birthdatetr ) - YEAR( mother.birthdatetr ) AS Mother_age, mother.deathdate, p.gedcom
FROM tng_children AS ch
LEFT JOIN tng_people AS p ON ( ch.personID = p.personID
AND ch.gedcom = p.gedcom )
LEFT JOIN tng_families AS f ON ( ch.familyID = f.familyID
AND ch.gedcom = f.gedcom )
LEFT JOIN tng_people AS father ON ( father.personID = f.husband
AND father.gedcom = f.gedcom )
LEFT JOIN tng_people AS mother ON ( mother.personID = f.wife
AND mother.gedcom = f.gedcom )
WHERE p.birthdatetr <> \"0000-00-00\"
AND father.birthdatetr <> \"0000-00-00\"
AND p.deathdatetr <> \"0000-00-00\"
AND father.deathdatetr <> \"0000-00-00\"
AND (
(
YEAR( father.deathdatetr ) + MONTH( father.deathdatetr )
) - ( YEAR( p.birthdatetr ) + MONTH( p.birthdatetr ) )
) < 0.9 order by dif_F_death_Ch_birth; ","1"