yv3uMkwBAYmOllbl8f5K+swHiylhhWjvGG60/KfsoDETTU8+58Q7Kit0fzZZ7h23buw3d8jNIV7KG5RVGVV65HKfLPE2ripAFaYS21HR8HumjpWfUUoy5fHkoFTtCOO6KNDsK1/8QbECMekv6LPA6NSq3CshFjv3dpUq/BFZdj6Lv20mVRMiuZ01Dfj4hFZvqcG/dhLz3EpmZ2uNg6Co32IRqRtDqrgOt1Fn4+DHalnr2WjuLiKEzL9GCaJkF6r8dD5sCzxuFq3jTXYHOdXkkFs0yfG5tIAU93DaRelBDKW4KikKTdGIFHDn08UgfyWxHOrkkVhI/vVYxrlzxq7OduiKlVIHbbiL2bQbCGp3IgLlTGUvmztgbd3UrYzCtjRPp782pQco59vxBat3ctROtKx5Lv4IwaljTm/UwkQAMPyZ2oA468KB09wttIuxMrGNVfTCFlzYaeskhyL2yscXarWYB/2ziL+P9DNWgNgNUNCZD5yHnoAyjs80SiSZensPQKYzjIS+p0K7w1XGI57r+AsWGwBw1hdAqZFGaAUjdvGDoDgPl2XHB9DBUtIfKKZWdajtBrh6MPbSXndP1CVfXwDeCmUo/SOaVD6mEQNVbl/9NZ1QAsSHh2LQ9kOfiH5hi47Y5MKAMAeZPmJoFJiU781u4jYmdanZNGCgBfqC1kRq4lgVIkibvy+ge3VskdjXY3wKEOrTOuvdDeNcnDp95CG/RguiMNLHaLV86JsXdQqXHtXyIrzG+8iBEz0lY5QHDJIqtT8nQVErgJmL/giJb5LrNQ+KN4u+6ft07bWyY5V2Fgjf0ypBuVdKVLhuNVSs0Zc39iPU9EbHgmQr4L1GrxTxCZc6HioFf/kPGywsa7UoTn6EdwU3VfG5mUjzk3JPyz9R3xnldm+OEjyK4LAzsVCveW0gYrQ1CG5xsP9bBtC5Irj7odzIrNyB279kVYW/kTnUZjKWBIZav0WYRybb20vk3NPX0YHlc3ioSIwpRt+z2xOlncPZ1mmTIH9J3NDbqFyuthPlP6WZD+SQ6/1kE8lg59hrl96A/bJqyN3DsIwM6E1gKkGYtvvJosDxyvOfd8VqNrF+MsO6ob5QnPHk6CI/L7YRc5PQd1saV5rk8jT1aiBzJIf4nESSEzibvjEF0O4lVrcYoLNXBU2+/bcWHUi4nIEt9UpSz81LcZz0ss+gMq8jR03KrxSw2B5WGMQ/QTahVVANvBW9aEJo5januPTYs/O00XJ32jtvUolbyxXhMPXpxNcgfHquGYv8rkHT3wpyvBDHg2sNAPnWmII2FBg2Li1GHSKIWmM/ug3uNIRt3aATUhnsRhoU+JYft6yqveEri84+RAYRPh3uCUDGqfJhmpNeci4+EBZ5iPQ=
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