Veel gestelde vragen This is a new feature at this site. An interactive way to talk about the genealogies

The owner of this website pays about 400 dollar per month to keep this webiste in the air. In order to view the data follow this link donate any amount you want. Now also possible on a bankaccount in the Netherlands, made possible by the familybank . The site gets 80.000 hits daily. Please click on the advertisements to generate money for me

Home Search Login Your Bookmarks  
Share Print Bookmark


Report: Surname list with frequency

         Description: Achternamen lijst met frequentie


An error has occurred in the TNG software. This could be due to a setup issue, an incomplete upgrade or a program bug. If you are the site owner, you may contact TNG support for help with this problem. Please copy the query below and paste it into your message.

Query: SELECT UPPER(lastname) AS Surname, COUNT(*) AS Individuals, SUM(CASE WHEN sex = 'M' THEN 1 ELSE 0 END) as Male, SUM(CASE WHEN sex = 'F' THEN 1 ELSE 0 END) as Female, IFNULL(MIN(CASE birthdatetr WHEN '0000-00-00' THEN NULL ELSE YEAR(birthdatetr) END),'') as Earliest_Birth, IFNULL(MAX(CASE birthdatetr WHEN '0000-00-00' THEN NULL ELSE YEAR(birthdatetr) END),'') AS Latest_Birth FROM tng_people WHERE lastname <> '' AND gedcom = 'savenije' GROUP BY lastname ORDER BY lastname

Lost connection to MySQL server during query