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 101 til 150 fra 201 » Kommasepareret CSV fil
| # | reportID | Rapportnavn | reportdesc | sqlselect | active |
| 101 | 255 | Personer: Bopæl | residences with associated names | SELECT e.eventplace AS dwelling_place, e.info AS additional_information, p.personID, p.lastname, p.firstname, p.birthdate, p.deathdate, p.living, p.gedcom FROM tng_events AS e INNER JOIN tng_people AS p ON (e.persfamID=p.personID AND e.gedcom=p.gedcom) INNER JOIN tng_eventtypes AS et ON e.eventtypeID=et.eventtypeID WHERE et.tag="RESI" AND e.eventplace<>"" ORDER BY e.eventplace, p.lastname, p.firstname; |
1 |
| 102 | 256 | Personer: Bopæl | Folk, hvor bopælsstedet er tomt, kontrollerer sandsynligheden for forekomsten. | SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.deathdate, e.eventplace AS dwelling_place, e.info AS additional_information, p.living, p.gedcom FROM tng_events AS e LEFT JOIN tng_people AS p ON (e.persfamID=p.personID AND e.gedcom=p.gedcom) LEFT JOIN tng_eventtypes AS et ON e.eventtypeID=et.eventtypeID WHERE et.tag="RESI" AND e.eventplace="" ORDER BY p.lastname, p.firstname, p.personID; |
1 |
| 103 | 109 | Personer: Børn | Enkeltpersoner (ikke: familier!) Med antal tilhørende børn | SELECT COUNT(*) AS Number_of_children, f.familyID, h.personID, h.lastname AS Last_name, h.firstname AS First_name, 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 Number_of_children, f.familyID, w.personID, w.lastname AS Last_name, w.firstname AS First_name, 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 Number_of_children DESC, Last_name, First_name, familyID | 1 |
| 104 | 124 | Personer: Dagsforskel mellem død og liv | Frekvensfordeling af forskel (i "absolutte" uger) mellem dag/måned af fødsel og dag/måned af dødsfald | 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 Diffence_in_weeks, COUNT(*) AS Amount, RPAD('',COUNT(*)/5,'=') AS Graphik FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>0 AND DAYOFYEAR(deathdatetr)<>0 GROUP BY Diffence_in_weeks ORDER BY Diffence_in_weeks |
1 |
| 105 | 184 | Personer: Datoer | Personer uden datoer. | SELECT personID, lastname, firstname, living, gedcom FROM tng_people WHERE ((birthdate is NULL) OR (birthdate="")) AND (birthdatetr="0000-00-00") AND ((altbirthdate is NULL) OR (altbirthdate="")) AND (altbirthdatetr="0000-00-00") AND ((deathdate is NULL) OR (deathdate="")) AND (deathdatetr="0000-00-00") AND ((burialdate is NULL) OR (burialdate="")) AND (burialdatetr="0000-00-00") ORDER BY lastname, firstname; |
1 |
| 106 | 65 | Personer: days between birth and baptism | number of days from birth and baptism | SELECT personID, lastname, firstname, birthdate, altbirthdate, TO_DAYS(altbirthdatetr)-TO_DAYS(birthdatetr) AS NumberTage, 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 |
| 107 | 243 | Personer: death causes without names (including frequency) | Personen: doodsoorzaak zonder namen maar met frequentie | SELECT cause AS cause_of_death, COUNT( * ) AS total FROM tng_events WHERE cause <> "" AND parenttag = "DEAT" GROUP BY cause_of_death ORDER BY cause_of_death; |
1 |
| 108 | 78 | Personer: Død | Personer with and unclear date of death | 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 |
| 109 | 138 | Personer: Død | Fejlagtige begravelsesdatoer | SELECT gedcom, personID, lnprefix, lastname, firstname, burialdate, burialdatetr, changedby FROM tng_people WHERE Length( burialdate ) >4 AND NOT ( burialdate LIKE "Abt%" OR burialdate LIKE "Cal %" OR burialdate LIKE "Bef %" OR burialdate LIKE "Aft %" OR burialdate LIKE "Est %" OR burialdate LIKE "Bet %" OR burialdate LIKE "% BC" ) AND burialdatetr LIKE "%-00-00" |
1 |
| 110 | 139 | Personer: Død | Fejlagtige dødsdatoer | SELECT gedcom, personID, lnprefix, lastname, firstname, deathdate, deathdatetr, changedby FROM tng_people WHERE Length( deathdate ) >4 AND NOT ( deathdate LIKE "Abt%" OR deathdate LIKE "Cal %" OR deathdate LIKE "Bef %" OR deathdate LIKE "Aft %" OR deathdate LIKE "Est %" OR deathdate LIKE "Bet %" OR deathdate LIKE "% BC" ) AND deathdatetr LIKE "%-00-00" |
1 |
| 111 | 152 | Personer: Død | Alder med måneder og dage. | SELECT personid, last_name, first_name, birth_date, death_date, concat( ay, 'y, ', am, 'm, ', ad, if( around, 'd (around)', 'd' ) ) AS age, living, gedcom 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, gedcom FROM ( SELECT personid, lastname AS last_name, firstname AS first_name, birthdatetr AS birth_date, deathdatetr AS death_date, 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, gedcom 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 |
| 112 | 153 | Personer: Død | Alder på personer ved død. | SELECT personid, last_name, first_name, birth_date, death_date, age, months, days, approx, living, gedcom FROM ( SELECT personid, last_name, first_name, birth_date, death_date, year( adeath_date ) - year( abirth_date ) - ( mid( adeath_date, 6, 5 ) < mid( abirth_date, 6, 5 ) ) AS age, ( mid( adeath_date, 6, 5 ) < mid( abirth_date, 6, 5 ) ) *12 + month( adeath_date ) - month( abirth_date ) - ( DAY( adeath_date ) < DAY( abirth_date ) ) AS months, DAY( adeath_date ) - DAY( abirth_date ) + if( DAY( adeath_date ) < DAY( abirth_date ) , DAY( last_DAY( adeath_date - INTERVAL 1 MONTH ) ) , 0 ) AS days, ( birth_date != abirth_date OR ( death_date != adeath_date AND living ) ) AS approx, living, gedcom 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 abirth_date, if( deathdatetr, if( DAY( deathdatetr ) , deathdatetr, concat( year( deathdatetr ) , if( month( deathdatetr ) , mid( deathdatetr, 5, 3 ) , '-01' ) , '-01' ) ) , now( ) ) AS adeath_date, gedcom FROM tng_people WHERE gedcom = 'savenije' AND birthdatetr AND ( deathdatetr <> "0000-00-00" OR living ) ) AS ppl ) AS agp ORDER BY age DESC , months DESC , days DESC , last_name, first_name |
1 |
| 113 | 237 | Personer: Død | Begravet før dødsdato. | SELECT personID, firstname, lastname, deathdate, deathdatetr, burialdate, burialdatetr, YEAR( burialdatetr ) - YEAR( deathdatetr ) AS difference FROM tng_people WHERE ( burialdatetr - deathdatetr <0 ) AND ( `burialdatetr` !=0000 -00 -00 OR YEAR( burialdatetr ) !=0000 ) AND birthdate != "" AND burialdate != "" AND `living` = "0" AND burialdate != "n" AND burialdatetr - deathdatetr !=0 |
1 |
| 114 | 246 | Personer: Død | Personer, der døde på samme dag og måned som de blev født (UDEN børn der døde ved fødslen) | SELECT personID, lastname, firstname, birthdate, deathdate, YEAR(deathdatetr)-YEAR(birthdatetr) AS age, living, gedcom FROM tng_people WHERE DAYOFMONTH(birthdatetr)<>0 AND DAYOFMONTH(deathdatetr)<>0 AND MONTH(birthdatetr)<>0 AND MONTH(deathdatetr)<>0 AND DAYOFMONTH(birthdatetr)=DAYOFMONTH(deathdatetr) AND MONTH(birthdatetr)=MONTH(deathdatetr) AND YEAR(deathdatetr)-YEAR(birthdatetr)>0 ORDER BY lastname, firstname, birthdatetr; | 1 |
| 115 | 249 | Personer: Emigration | Personer: events: emigrated persons | SELECT p.personID, lastname, firstname, birthdate, deathdate, eventdate AS date_emigration, eventplace AS place_to_where, info AS reasons, p.living, p.gedcom FROM tng_events AS e INNER JOIN tng_eventtypes AS et ON e.eventtypeID=et.eventtypeID INNER JOIN tng_people AS p ON (e.persfamID=p.personID AND e.gedcom=p.gedcom) WHERE et.tag="EMIG" ORDER BY lastname, firstname, p.personID; |
1 |
| 116 | 250 | Personer: Erhverv | Personer: events: occupations with names | SELECT info AS description_of_occupation, eventdate AS date_, eventplace AS place_of_the_occupation, p.personID, lastname, firstname, birthdate, p.living, p.gedcom FROM tng_events AS e INNER JOIN tng_eventtypes AS et ON e.eventtypeID=et.eventtypeID INNER JOIN tng_people AS p ON (e.persfamID=p.personID AND e.gedcom=p.gedcom) WHERE et.tag="OCCU" ORDER BY info, lastname, firstname, p.personID; |
1 |
| 117 | 251 | Personer: Erhverv | Personer: events: occupations without names (including frequency) | SELECT info AS Occupation, COUNT(*) AS total FROM tng_events AS e INNER JOIN tng_eventtypes AS et ON e.eventtypeID=et.eventtypeID INNER JOIN tng_people AS p ON (e.persfamID=p.personID AND e.gedcom=p.gedcom) WHERE et.tag="OCCU" AND info<>"" GROUP BY Occupation ORDER BY Occupation; |
1 |
| 118 | 252 | Personer: Erhverv | Personer: events: occuring occupations ordered on frequency | SELECT info AS Occupation, COUNT(*) AS total FROM tng_events AS e INNER JOIN tng_eventtypes AS et ON e.eventtypeID=et.eventtypeID INNER JOIN tng_people AS p ON (e.persfamID=p.personID AND e.gedcom=p.gedcom) WHERE et.tag="OCCU" AND info<>"" GROUP BY Occupation ORDER BY total DESC, Occupation; |
1 |
| 119 | 254 | Personer: Erhverv | Landmænd & bønder Med navn, sorteret efter erhverv. |
SELECT info AS description_of_the_occupation, eventdate AS Dates, eventplace AS place_of_the_occupation, agency AS position, p.personID, lastname, firstname, birthdate, p.living, p.gedcom FROM tng_events AS e INNER JOIN tng_eventtypes AS et ON e.eventtypeID = et.eventtypeID INNER JOIN tng_people AS p ON ( e.persfamID = p.personID AND e.gedcom = p.gedcom ) WHERE et.tag = "OCCU" AND ( info LIKE "%bonde%" OR info LIKE "%landmand%" OR info LIKE "%gaardm%" ) ORDER BY info, lastname, firstname, p.personID; |
1 |
| 120 | 127 | Personer: Forældreløse | Folk uden forældre, sorteret efter sidste redigering | 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 |
| 121 | 128 | Personer: Forældreløse | Forældreløse uden partner og børn. Personer, der er ikke er forbundet med nogen. Åbn venligst rapporten i et nyt vindue. |
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 |
| 122 | 107 | Personer: Forældrer | Personer uden far eller mor. | SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, father.personID AS fatherNr, father.lastname AS Name1, father.firstname AS firstname1, father.living, mother.personID AS motherNr, mother.lastname AS Name2, mother.firstname AS firstname2, 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 |
| 123 | 129 | Personer: Forældrer | Individer med mor, men uden far (far mangler) | SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, father.personID AS ID_Vader, father.lastname AS Name1, father.firstname AS first_name, father.living, mother.personID AS ID_mother, mother.lastname AS Name2, mother.firstname AS first_name2, 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 |
| 124 | 60 | Personer: Fødsel | Personer med uklar fødselsdato f.eks. "CA", "FØR", "EFTER" | 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 "%CA%" AND birthdate<>"") OR (UCASE(birthdate) LIKE "%EFTER%" AND birthdate<>"") OR (UCASE(birthdate) LIKE "%FØR%" AND birthdate<>"") ) AND Birthdate <> "y" ORDER BY lastname, firstname, personID; |
1 |
| 125 | 136 | Personer: Fødsel | Fejlagtige fødselsdatoer | SELECT personID, lnprefix, lastname, firstname, birthdate, birthdatetr, gedcom, changedby FROM tng_people WHERE Length( birthdate ) >4 AND NOT ( birthdate LIKE "Abt%" OR birthdate LIKE "Cal %" OR birthdate LIKE "Bef %" OR birthdate LIKE "Aft %" OR birthdate LIKE "Est %" OR birthdate LIKE "Bet %" OR birthdate LIKE "% BC" ) AND birthdatetr LIKE "%-00-00" | 1 |
| 126 | 59 | Personer: Fødselsdag | Fødselsdage i den nuværende måned (kun afdøde personer) |
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 |
| 127 | 67 | Personer: Fødselsdag | Personer med 50. fødselsdag dette eller næste år | 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 |
| 128 | 68 | Personer: Fødselsdag | with 60. birthdate this year or next year | 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 |
| 129 | 69 | Personer: Fødselsdag | with 65. birthdate this year or next year | 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 |
| 130 | 70 | Personer: Fødselsdag | with 70. birthdate this year or next year | 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 |
| 131 | 71 | Personer: Fødselsdag | with 75. birthdate this year or next year | 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 |
| 132 | 72 | Personer: Fødselsdag | with 80. birthdate this year or next year | 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 |
| 133 | 73 | Personer: Fødselsdag | with 85. birthdate this year or next year | 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 |
| 134 | 74 | Personer: Fødselsdag | with 90. birthdate this year or next year | 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 |
| 135 | 75 | Personer: Fødselsdag | with 100. birthdate this year or next year | 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 |
| 136 | 155 | Personer: Født | Født efter daabsdato. | SELECT personID, firstname, lastname, birthdate, birthdatetr, altbirthdate, altbirthdatetr, YEAR( altbirthdatetr ) - YEAR( birthdatetr ) AS Age, gedcom, changedby FROM tng_people WHERE ( altbirthdatetr - birthdatetr <0 ) AND ( `birthdatetr` !=0000 -00 -00 OR YEAR( altbirthdatetr ) !=0000 ) AND birthdate != "" AND altbirthdate != "" AND `living` = "0" AND altbirthdate != "n" AND altbirthdatetr - birthdatetr !=0 |
1 |
| 137 | 157 | Personer: Født | Født efter dødsdato. | SELECT personID, firstname, lastname, birthdate, birthdatetr, birthplace, deathdate, deathdatetr, deathplace, YEAR( deathdatetr ) - YEAR( birthdatetr ) AS Age, gedcom, changedby 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 ( deathdatetr ) - ( birthdatetr ) !=0 |
1 |
| 138 | 168 | Personer: Født | Børn født hvor en af forældrene er under 15 år eller mor er over 49 år. (Alt ældre end 50 år bør være forkert, ihvertfald for mere end 50 år siden). | 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.changedby, 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%" AND (YEAR(father.birthdatetr) > 1700 OR YEAR(mother.birthdatetr) > 1700) AND (YEAR( p.birthdatetr ) - YEAR( mother.birthdatetr ) < 15 OR YEAR( p.birthdatetr ) - YEAR( mother.birthdatetr ) > 49 OR YEAR( p.birthdatetr ) - YEAR( father.birthdatetr ) < 15) ORDER BY Mother_age, p.lastname, p.firstname, p.birthdatetr |
1 |
| 139 | 18 | Personer: Hyppigheden af stjernetegn | Hyppigheden af stjernetegn | SELECT CASE WHEN (MONTH(birthdatetr)=3 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=4 AND DAYOFMONTH(birthdatetr)<=20) THEN "Vædderen (Aries)" WHEN (MONTH(birthdatetr)=4 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=5 AND DAYOFMONTH(birthdatetr)<=20) THEN "Tyren (Taurus)" WHEN (MONTH(birthdatetr)=5 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=6 AND DAYOFMONTH(birthdatetr)<=21) THEN "Tvillingerne (Gemini)" WHEN (MONTH(birthdatetr)=6 AND DAYOFMONTH(birthdatetr)>=22) OR (MONTH(birthdatetr)=7 AND DAYOFMONTH(birthdatetr)<=22) THEN "Krebsen (Cancer)" WHEN (MONTH(birthdatetr)=7 AND DAYOFMONTH(birthdatetr)>=23) OR (MONTH(birthdatetr)=8 AND DAYOFMONTH(birthdatetr)<=23) THEN "Løven (Leo)" WHEN (MONTH(birthdatetr)=8 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=9 AND DAYOFMONTH(birthdatetr)<=23) THEN "Jomfruen (Virgo)" WHEN (MONTH(birthdatetr)=9 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=10 AND DAYOFMONTH(birthdatetr)<=23) THEN "Vægten (Libra)" WHEN (MONTH(birthdatetr)=10 AND DAYOFMONTH(birthdatetr)>=24) OR (MONTH(birthdatetr)=11 AND DAYOFMONTH(birthdatetr)<=22) THEN "Skorpionen (Scorpius)" WHEN (MONTH(birthdatetr)=11 AND DAYOFMONTH(birthdatetr)>=23) OR (MONTH(birthdatetr)=12 AND DAYOFMONTH(birthdatetr)<=21) THEN "Skytten (Sagittarius)" WHEN (MONTH(birthdatetr)=12 AND DAYOFMONTH(birthdatetr)>=22) OR (MONTH(birthdatetr)=1 AND DAYOFMONTH(birthdatetr)<=20) THEN "Stenbukken (Capricornus)" WHEN (MONTH(birthdatetr)=1 AND DAYOFMONTH(birthdatetr)>=21) OR (MONTH(birthdatetr)=2 AND DAYOFMONTH(birthdatetr)<=19) THEN "Vandmanden (Aquarius)" WHEN (MONTH(birthdatetr)=2 AND DAYOFMONTH(birthdatetr)>=20) OR (MONTH(birthdatetr)=3 AND DAYOFMONTH(birthdatetr)<=20) THEN "Fiskene (Pisces)" END AS Stjernetegn, COUNT(*) AS Antal FROM tng_people WHERE DAYOFYEAR(birthdatetr)<>"" GROUP BY Stjernetegn; | 1 |
| 140 | 276 | Personer: Levende Løvendahl | Du skal være logget ind for at se noget nyttigt her | SELECT tng_people.living, firstname, lastname, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) WHERE (tng_people.living = 1 AND lastname like "løvendahl%") ORDER BY firstname | 1 |
| 141 | 141 | Personer: Levende Ravnholdt | Du skal være logget ind for at se noget nyttigt her | SELECT tng_people.living, firstname, lastname, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) WHERE (tng_people.living = 1 AND lastname like "ravnhold%") ORDER BY firstname | 1 |
| 142 | 121 | Personer: Levetid | Antal dage mellem fødselsdag og død. | 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 |
| 143 | 58 | Personer: Markeret som levende | Personer markeret som "levende" med alder > 110 år | SELECT personID, lastname, firstname, birthdate, YEAR(CURDATE())-YEAR(birthdatetr) AS Years, birthplace, living, gedcom FROM tng_people WHERE (YEAR(CURDATE())-YEAR(birthdatetr)>110) AND living=1 AND YEAR(birthdatetr)<>0 ORDER BY lastname, firstname, birthdatetr; | 1 |
| 144 | 130 | Personer: Mor mangler | Individer med far, men uden mor (mor mangler) | SELECT p.personID, p.lastname, p.firstname, p.birthdate, p.living, father.personID AS ID_vader, father.lastname AS last_name, father.firstname AS first_name, father.living, mother.personID AS ID_mother, mother.lastname AS last_name2, mother.firstname AS first_name2, 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 |
| 145 | 165 | Personer: Navn | Personer, hvis efternavne er forskellige fra farens og moderens efternavn. | 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 |
| 146 | 166 | Personer: Navn | Personer med et andet efternavn end deres far (født efter 1828) |
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)>"1828" ORDER BY p.lastname, p.firstname, p.birthdatetr; |
1 |
| 147 | 164 | Personer: Navne | Folk med et andet efternavn end deres far, men det samme som deres mor. (født efter 1828, før brugte mange patronymer) |
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)>"1828") AND father.lastname <> "" AND father.lastname <> mother.lastname ORDER BY p.lastname, p.firstname, p.birthdatetr; |
1 |
| 148 | 247 | Personer: Navne | Personer: events: alias names (not: nick names) with associated people, order | SELECT p.personID, lastname, firstname, birthdate, deathdate, info AS also_known_as, p.living, p.gedcom FROM tng_events AS e INNER JOIN tng_eventtypes AS et ON e.eventtypeID=et.eventtypeID INNER JOIN tng_people AS p ON (e.persfamID=p.personID AND e.gedcom=p.gedcom) WHERE et.tag="ALIA" ORDER BY lastname, firstname, p.personID; |
1 |
| 149 | 248 | Personer: Navne | Personer: events: alias names (not: nick names) with associated people, order | SELECT info AS also_known_as, p.personID, lastname, firstname, birthdate, deathdate, p.living, p.gedcom FROM tng_events AS e INNER JOIN tng_eventtypes AS et ON e.eventtypeID=et.eventtypeID INNER JOIN tng_people AS p ON (e.persfamID=p.personID AND e.gedcom=p.gedcom) WHERE et.tag="ALIA" ORDER BY info, lastname, firstname, p.personID; |
1 |
| 150 | 222 | Personer: Notater | Personer with associated notes | 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 |
«Forrige 1 2 3 4 5 Næste»