p.sex = 'female' AS femme, p.deathdate IS NOT NULL AS decede,
p.birthdate, pd.promo, CONCAT(e.email, '@', d.name) AS mail
FROM profiles AS p
p.sex = 'female' AS femme, p.deathdate IS NOT NULL AS decede,
p.birthdate, pd.promo, CONCAT(e.email, '@', d.name) AS mail
FROM profiles AS p