LEFT JOIN profiles AS p ON (ap.pid = p.pid)
WHERE state = \'active\' AND p.deathdate IS NULL
GROUP BY jour', (int)$jours, 1 + (int)$jours);
LEFT JOIN profiles AS p ON (ap.pid = p.pid)
WHERE state = \'active\' AND p.deathdate IS NULL
GROUP BY jour', (int)$jours, 1 + (int)$jours);