uBJZcKCKm75D7r+UFEipNCfAHenF9M5JZZmStfB0iGHpzUx3+ZzJ/WVvsm31oH550FdpRsy6Qb3HxNXpllsuk1ljMzRHTn/raf2l+1PbImXZvleJ5FOLGe2QJeDK+27eX6gTKepNuhd1JKBVW1henhLXF25Z9bLFTnrpHk7jzm7KDiPwe1+PW2bVrMk/pxcZ6rhqjViK5A+qW1U6IBhyYZbQNZltzSK43t/UeBjIzJdhGYisojCsUjJhOYT5IGODUnqzrgvxBwcb8FExhGHlpSb0TZVFSlWG+OQqcPzQVdcLGXRBf3wAFATVsb68RgAoCkM3d0BAXE/Ro7/KWKw8b9iLFuEF7/MVQXwnTuJVGobu4tcbVRWFiUvheGGXUKrAB0MCkIQC7Emh/gLJrFr50P1SOSgKhG1AoEXL5HWpHHtt/Tuh5dNqJTUTpyxrEHWHlrLHG9dAPhV7jheqdbc2u3bKYo4A+vI6PSl3i188QYj2070y8/gFYCW+/4ftrrPfsWYTieBrIT6vLUO//JCofFreZmp0SFr2OOsXPMGTsrnqnnk+ocS1JgXQsrLdXFjBFhwAZofyycbB8c8AA1D4C4ZQfW0M8ZgN2+RdFHe7F1gx4WF5p/E5wiPo7p24xbG7e2UYNM5vDE5rvHSqhnIZmU3yK5wr3hVs5ogC5SwDoQ/+eH4UWldDPD/X54KsmZVYxoBOMDSzD33a8ucilioBk2lGQwAuZH3TRPQnQOgoAT+o1Ypvz92WDDFy04eSKRcXs2JStHclyR/vVbohhkrbIQ5SyBKVzMGSf9bcm+QEWrGy3aRSa+k6iW8BUSyu2k756+wCx74t6OHoHywLSDk/vEWS0CYuKPURpsVdS8fMk7AWPAtFv7VIUqONPOWiTx3Ved0fxngtZbNp+BPELZe0wcAI73dDk4sf1+VnwGKyEsewoUFmNr6hxSzkQ6qJovAmCvGCX+KvdAOPobzcAyTD+bSmEFezYYQQ4/IGCjGNKvWgLY4wtjdFtWwKcgVMD2VRYDV5Uz03NOYHao7ORNurQUUs1DWNJE6dgZ74kSiiAU/63ebzNl1N9U+AtUCMJTgoP5819wlzu9S9e3U1KVK71OnIh47572dBbVjSTuzuUJXYV4mCujpQhmm28ykP9JJB49M6fZzRpsRUdiqjdhi6OqUKqfCzjUkH+kyYkR1h4ookr6gZjC0FesFcpEiH/0ZfRHcZB11JsxE/AU9aAzJmvfaVqsiHifNnlg4nFNwuPovIBXWJtPWxeNSd+igmFLL5CghUfPNrCwqqoRUGv8UJHpSfppdC6BLr69UfSAPIIRsGVHEbS1WNcFE5YdZRqmml3Jfy8/ivVd6ZBZ2sYKIh+YghZiZdbKtkJRe35tc=
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