Rapport: Report List and code, lijst met alle rapporten en code
Beskrivelse: 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
Match 201 til 213 fra 213 » Kommasepareret CSV fil
| # | reportID | Rapportnavn | reportdesc | sqlselect | active |
| 201 | 28 | Stenbukken - Capricornus | Individuals born in astrological sign capricornus: 22 DEC - 20 JAN 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 | 1 |
| 202 | 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 |
1 |
| 203 | 21 | Tvillingerne - Gemini | Individuals born in astrological sign gemini: 21 MAY - 21 JUN 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; | 1 |
| 204 | 20 | Tyren - Taurus | Individuals born in astrological sign taurus: 21 APR - 20 MAY 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; | 1 |
| 205 | 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 ) ) |
1 |
| 206 | 29 | Vandmanden - Aquarius | Individuals born in astrological sign aquarius: 21 JAN - 19 FEB 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; | 1 |
| 207 | 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 | 1 |
| 208 | 19 | Vædderen - Aries | 21 MAR -20 APR 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. |
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 |
| 209 | 25 | Vægten - Libra | Individuals born in astrological sign libra: 24 SEP - 23 OCT 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; | 1 |
| 210 | 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; |
1 |
| 211 | 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 | 1 |
| 212 | 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); |
1 |
| 213 | 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; |
1 |
«Forrige 1 2 3 4 5