- u.deces = '0000-00-00' AS alive, a.alias AS forlife, b.alias AS bestalias,
- e.email, e.last
+ u.deces = '0000-00-00' AS alive, u.hruid, a.alias AS forlife, b.alias AS bestalias,
+ IF(e.email IS NOT NULL, e.email, IF(FIND_IN_SET('googleapps', u.mail_storage), 'googleapps', NULL)) AS email, e.last