| Beskrivelse |
Antal |
Warning: mysqli_query() [function.mysqli-query]: (22003/1690): BIGINT UNSIGNED value is out of range in '(year(`jensenmoller_dk_db`.`tng_people`.`deathdatetr`) - year(`jensenmoller_dk_db`.`tng_people`.`birthdatetr`))' in /var/www/jensenmoller.dk/public_html/slaegt/tngconnect.php on line 104
Kan ikke køre forespørgsel: SELECT YEAR( deathdatetr ) - YEAR( birthdatetr )
AS yearsold, DAYOFYEAR( deathdatetr ) - DAYOFYEAR( birthdatetr ) AS daysold,
IF(DAYOFYEAR(deathdatetr) and DAYOFYEAR(birthdatetr),TO_DAYS(deathdatetr) - TO_DAYS(birthdatetr),(YEAR(deathdatetr) - YEAR(birthdatetr)) * 365) as totaldays
FROM tng_people
WHERE birthdatetr != '0000-00-00' AND deathdatetr != '0000-00-00'
AND birthdate not like 'AFT%' AND deathdate not like 'AFT%'
AND birthdate not like 'BEF%' AND deathdate not like 'BEF%'
AND birthdate not like 'ABT%' AND deathdate not like 'ABT%'
AND birthdate not like 'BET%' AND deathdate not like 'BET%'
AND birthdate not like 'CAL%' AND deathdate not like 'CAL%'
ORDER BY totaldays DESC
Jensen Møller - Familie Historie