Print Voeg bladwijzer toe

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

         Beschrijving: 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


Treffers 201 t/m 210 van 210

«Vorige 1 2 3 4 5

# reportID Rapportnaam reportdesc sqlselect active
201 21  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;  
202 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 )
203 44  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 
204 30  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; 
205 29  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; 
206 25  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; 
207 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;  
208 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  
209 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);  
210 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;  


«Vorige 1 2 3 4 5