Rathlin Directory

Home | What's New | Photos | Histories | Sources | Reports | Calendar | Cemeteries | Headstones | Statistics | Surnames
Home Search Login  
Print

 Surname Statistics

Tree:  

Last Name:*        
*Enter all or any portion of the surname
An error has occurred in the TNG software. What to do:

If you just installed an upgrade, you might have skipped part of the installation instructions. Go back to the upgrade readme page reread the instructions. Pay special attention to the database structure step.

If you just installed TNG for the first time, you might still need to create the database tables. Return to the readme.html page to find that step.

If you are the site owner, you may contact TNG support for further assistance with this problem. Please copy the query below and paste it into your message.



Query: SELECT gedcom, 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, SUM(CASE WHEN sex = 'U' THEN 1 ELSE 0 END) AS Unknown, 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 <> '' GROUP BY Surname ORDER BY Individuals DESC LIMIT 50

Table 'afkeoghc_Rath_New.tng_people' doesn't exist