Report List and code, lijst met alle rapporten en code: Strong McLemore Ancestry

You are currently anonymous

Report: Report List and code, lijst met alle rapporten en code

Description: If the tree is mentioned as savenije please replace with your won tree. Als de naam van de tree=savenije vervang die door uw eigen stamboom naam

reportID

Report Name

reportdesc

sqlselect

active

201

219

sources: citations with associated individuals, ordered by individual's name

Bronnen: citaten met geaccossieerde personen, gerangschikt naar iemand's naam

SELECT p.personID, p.lastname, p.firstname, p.living, c.eventID, c.sourceID, c.description, c.citetext, c.page, p.gedcom FROM tng_citations AS c
LEFT JOIN tng_people AS p ON (c.persfamID=p.personID AND c.gedcom=p.gedcom)
WHERE p.personID<>'' ORDER BY p.lastname, p.firstname, p.personID, c.description;

202

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

SELECT YEAR(p.birthdatetr)-YEAR(father.birthdatetr) AS parents_age, COUNT(*) AS Number_, 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 Number_, 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;

203

192

Statistics of places where people were baptized

Statistieken waar mensen gedoopt zijn.

SELECT REVERSE(SUBSTRING_INDEX(REVERSE(SUBSTRING_INDEX(altbirthplace,",",2)),",",1)) as gemeente_or_state, COUNT(*) AS Number, RPAD('',COUNT(*)/100,'=') AS Graph FROM tng_people WHERE altbirthplace <> "" group BY gemeente_or_state order by Number desc;

204

Steenbok

Personen, geboren in het astrologische teken Steenbok (Capricornus): 22.12.-20.01.
Individuals born in astrological sign capricornus: 22 DEC - 20 JAN

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.

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

205

Stier

Personen, geboren in het astrologische teken Stier (Taurus): 21 april-20 mei
Individuals born in astrological sign taurus: 21 APR - 20 MAY 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.

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;

206

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

SELECT f.familyID, h.personID as personID1, h.lastname AS LastName1, h.firstname AS FirstName1, h.sex AS Sex1, h.birthdate as birthdate1, w.personID, w.lastname AS LastName2, w.firstname AS FirstName2, w.sex AS Sex2, w.birthdate as birthdate2, f.living, f.gedcom, f.changedby
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

207

Tweelingen

Personen, geboren in het astrologische teken tweelingen (Gemini): 21 mei-21 juni
Individuals born in astrological sign gemini: 21 MAY - 21 JUNTweelingen 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.

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;

208

225

Unused place names

Ongebruikte plaatsnamen

SELECT id, gedcom, place, longitude, latitude, notes
FROM tng_places
WHERE gedcom = 'savenije'
AND place
IN (

SELECT pl.place
FROM tng_places AS pl
LEFT JOIN (

SELECT gedcom, birthplace AS place
FROM `tng_people`
WHERE gedcom = 'savenije'
UNION SELECT gedcom, altbirthplace
FROM `tng_people`
WHERE gedcom = 'savenije'
UNION SELECT gedcom, marrplace
FROM `tng_families`
WHERE gedcom = 'savenije'
UNION SELECT gedcom, deathplace
FROM `tng_people`
WHERE gedcom = 'savenije'
UNION SELECT gedcom, burialplace
FROM `tng_people`
WHERE gedcom = 'savenije'
UNION SELECT gedcom, eventplace
FROM tng_events
WHERE gedcom = 'savenije'
) AS p
USING ( gedcom, place )
WHERE pl.gedcom = 'savenije'
AND isnull( p.place )
)

209

281

Veranderingen aangebracht door Jaap

SELECT lastname, firstname, birthdate, deathdate, birthplace, deathplace, changedby, changedate FROM `tng_people` WHERE changedby = "databoss" ORDER BY `tng_people`.`changedate` DESC

210

280

Veranderingen aangebracht door Joos

SELECT lastname, firstname, birthdate, deathdate, birthplace, deathplace, changedby, changedate
FROM `tng_people`
WHERE changedby = "joos"
ORDER BY `tng_people`.`changedate` DESC

211

282

Veranderingen aangebracht door Peer

SELECT lastname, firstname, birthdate, deathdate, birthplace, deathplace, changedby, changedate
FROM `tng_people`
WHERE changedby = "Peer Notermans"
ORDER BY `tng_people`.`changedate` DESC

212

Veterans

An overview of veterans (at least if you added some)

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

213

Vissen

Personen, geboren in het astrologische teken Vissen (Pisces): 20.02.-20.03.
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.

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;

214

Waterman

Personen, geboren in het astrologische teken Waterman (Aquarius): 21.01.-19.02.
Individuals born in astrological sign aquarius: 21 JAN - 19 FEB

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.

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;

215

Weegschaal

Personen, geboren in het astrologische teken Weegschaal (Libra): 24.9.-23.10.
Individuals born in astrological sign libra: 24 SEP - 23 OCT 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.

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;

216

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.

SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, p.gedcom, p.changedate, p.changedby 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;

217

127

Wezen, Orphans

Personen zonder ouders, geoordend volgens de laatste invoer eerst.
People without any parents, ordered according to the last input.

SELECT personID, firstname AS first_name,lnprefix AS tussenvoegsel,lastname AS last_name, birthdate AS Geboortedatum, birthplace AS Geboorteplaats, changedate AS Veranderdatum, gedcom, changedby FROM tng_people WHERE famc= "" order by changedate DESC

218

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)

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);

219

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)

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;