aPXDbYgWOxm7p28TloST5CTigLF9v/G1SXxgObizHJUmbEaSAmX8WlJRmCHbO7uvEsyrHK2SnKTbnzdZ+x32K6Gg0SVtR9UW6Kymlx+JGVPHKWqiCtaN+jN3BJbs2YXwjEUdiECH00dsWco3cvUxJttY9XFykS/VCnd7zKqN199VFHOV79jqkEVc58HQFrr+lxQuAZapHX82KQd0I7mnvj4QpanKU+JXiypLvZOljaS1vzyrnevSRuEDJbHLXRaxN6T8/iIFqMKv/FpXgiJYBLjqITCg/L75LtyuO4cXHh1TaOHndpgJFOOrCWCrp7irML0oPZQt9mGsQO0VJrXTCobzAMMi0t7Us8b+Px+mA2YE3tspwl/4Kz93fWd6mHF/Y7VdKYcm1PcnQk9trfBV9IXwIneEpxUK4R/UCAE58x4KtE9w+JNVHcEiC/4HM0D7f24Pcn37v8IFOpXboyV6an2qYpiaNorrCYl/kPrRTongm+0ZTyHGJGOxl+B7PNwccIa5cd9QLvki9BSe6sY7+KiyK2hskUWxXWkXc7Mew9xkwvqzb6Bpf+QhOYEBFpJLETw1iRmjTWYANtduRysBWFInDfzQSw5kMjyFnvmZkSdzOa64a8j9PBXfiB36CK3xH7LxKz/TSKRjYTmVITv3AJU/whYd7toKNJWvlBmOqyBINiDT/sbBNY7G4Lqd1EZ1UXG8iftVaKevEFe1MuoZpHJz3fut5IWLpkAsucy2ebfpSV92wUZzno9Ol/xrp2LokCFVdGSSqBH1WS2/YtEe9gusfFucuWPVMxuZIDMYEdGPIybIBd1MkTuS7xqzvBzB+x7kdRAyRgqQCQtBFyH5TAwc6x7mR3lWsAVgoBLOkz8opTvMzad/yK/JopSY7QR1Ti+U8Rj+BpMWPZLzVlyj2oKtFS8JNOSnGMzZICbLNGUR7fzufyutBmomzXu5PHjsLVl2fvWcmNuaajfDk/aTZ4dId2oOeZIqE5mVNToPdjs1nHzF9OjYqGxJKp2RwU/T8+IvB/lsmJlX9IF985bTShr3ex+yuNxI+GU8KH3LzVNtCFPZB+mNMBy+iTYIP+B6hAGRGFMRfi86K1nJSEZ5yF2NmBfQpOBb5RNuGJZua6mb/+aeR0102QMVt2jsWxXC+2+H2NJXJ7J9uQGRWSKokh9w9lm4H67RhcCe/JiNyIael0Eg8RQVU8xKZ17iMLYzRX47XdKrIrjyMo0Q9vAb73+RmdBjy1cRwVWmp6q55+736b+OEBZjFvioEfrbFEI4KZ6VWR9LaSkaBpLYS93whqR3P29Uo10Cj9D+jo9pSiJ81bllXR5JjFfajWsoGlL38uzbP6jFqSy5H0LyM7f5X9bDlq0/gUbfFnrCe8Y=
1 - SELECT et.id, et.residence, et.bottin, et.emploi, et.msss, (eev.dateFin > NOW()) as vedette FROM emplois_temp et
LEFT JOIN envois_eer_emplois_vedette eev ON eev.emploi = et.id AND eev.dateFin > NOW()
LEFT JOIN residences r2 ON r2.id = et.residence WHERE et.bottin = AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT desapprouve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0')
AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100