nfT0Po0Uei8PDBquy3qOXK+SvhrmtO9Zd39kU8xLoLg8Dr4FqIYYKU4lwYwjXO032G7V1e/4i/9jJG1sH3cVMz92f99xKFwjQsgx1iOnYHQQOcKjabnzQhofaTb8bZVz4UPLhFSfLna0zuUlqSUPw4c6G94BNPi6aEz04J0sZCvXrY6e3GOr0P+EjN551o3qZmpVYVTAzvMfhfboZh2Opu87I8jqZYQbIlOlIVzlRTV/hg/t+zi01WdO8WI02ueW2UhnMF7DSRX4q7F41Od76WrbVHyBPUU+tgITIMuw8OrQcTSMUEduyyXdg8keKzd/TuLEn5xmb5F3gc280pw5+VJROTzOdnUcLHRp398zGxPT30IqA7iFc0GJyWqM8HL3E+BXR5RrWUp6FAneOnRioVoWZEFyWLd7ZqJprFWcDUlAYyQAmelgN5ryPK1qRfoe6L9+gDZkA06AL1NakqMV13RQ7qOQebfWvu50oEAvSr7UFKyOn8FcP7pBF067Fec+ZtcOCNiQfLHXFUAPT9F9A9YqzNogiKKnCh+52PM/RBCb11RKV+5x1vgRtIAV8M9alx71HUn0IVcpQopt03kSQ4Cf+lMNJEnmW/2eD2iAg/9KeO2ixubv6Hd4/laGXP3NnsLTzmshZrzqQVzIAblj6FXV9U7lmNdhMBG3acElppYg3lrLwarf7GxOtuHW/zYNGcgUwST7p8paAeJvtW/kjdsT8BgUPJGZJpgjv/0gp8csnXFM72/QwG/rslBlc+fEE0r59sq/JMP2/tITXqfplqq52J/OTp26ExPwhoi2B/xm3y+XNiLk3/Vla0rm/MEQXhey3qd+jTlXKFPV3LLHBf5iZVog5cpfDSqTKTHuRrlJxqRbwxrZjq5qKKDV/IJhfJ2Kig6r9iOoh5rdkzcgEOgCI0yM81DDtVAawrQvpiyVoD3JoyXRkr8j0EPYvAq22GY4OPufXYCKLftciNvzcw4qopqvArmBaVkPUfko0wy54RYeas0DAbk80JLrAgH2XVj6jkzi/N4OG/GGt496/glZE0zOjYltIhCKU1LWxmnzlrrPIMbh9xGu21fVNptUMuqedWJagYiUbDdi9lY5Z/pdeON2PtN5XhiChXCf790BwytbRF3cyUXhUcnwI+FrYqGJQYYJeX9WpTCNr1ZLJIdvJt3qpYbZBIBESzXDKOfqN1Hi6tF7wtr+PacC5CnU8H052KOcmVICygIBAeCLCZo3z3SONjTyKAWi4KB1690ab4x/72guxp58aGvLe0zdQSu40vbeOmDcKxhuHY0tOAdW1l7IFlc22jpwJZihnd/0uCrwCRyWzRSVdxNiDOYaTAtp4D+QLCXsuMH8373QL3ns3XPiUN+KK0m19WI=
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