Bericht: RFP083

         Beschreibung: Häufigkeitsverteilung des Alters, wo Männer (M) Vater bzw. Frauen (F) Mutter werden (für alle Kinder)

Fehler: Die Syntax der Suchabfrage für diesen Bericht (ID: 28) ist ungültig, deswegen kann dieser Bericht nicht erstellt werden. Benachrichtigen Sie den Systemverantwortlichen wolli@radio-rum.de.

Suchabfrage: SELECT YEAR(p.birthdatetr)-YEAR(father.birthdatetr) AS ElternAlter, COUNT(*) AS Anzahl, RPAD('',COUNT(*)/20,'M') AS Graphik 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 ElternAlter UNION SELECT YEAR(p.birthdatetr)-YEAR(mother.birthdatetr) AS ElternAlter, COUNT(*) AS Anzahl, RPAD('',COUNT(*)/20,'F') AS Graphik 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 ElternAlter ORDER BY ElternAlter
Fehlermeldung: