7s3UspHf9Bj7c9D/auwpaWd/mZnmvL2i/qW5SSJcEdz6zl3+C3V2tNM2z4MVhOIZ4YrB6afz9O0AAKMTrPU3IpioAKlOjjoMZ39yT/I6tpTHj1/2kEL2UIpL7fuE8DyvGkTEDJsJ6YjNjTuZvFaB13qgyZbo6Yy490vuTV8jWxCuGD6WcfiJqFXd+9iKhL4wEukXvlJ3s0K06oCz7nB+9yQO9vHugNri9RUe/T9bLQvin4UKxXEiHOAvQ7zgoxZpUP9gyostN323moKRPT1iF5dmDG5boV/T95Ap5qUzuIJxqcCVS7Q7q+LraJu5jBiH+75vUSQVqyBqiq/tA7eFS5gleFFju2c4/CaBbYvVM2YKO2poQ+vQHd4/9CQda4cg0SWo2V/JYmfCkmdZcS3ev2WPWvycJNTrZS2c2Qema9N9VGRug5s+Ugv8LOZRklTTaZRH8S24dB0wSQWtG1oiYtj8yaWVswFRsp0PvvpjEzjGcXORpdWOGzAJviOESc/WUyX0NQ1rMdPAG3KJmnCjCr/aY6y1EphjCYono5W4pPhMzWs70V0LZD4fuH70twKQndaNg36e7pi56OSjE4wIeoj/FmcWRMY1SQcAlwVaN9xP+5B9dmWclvz+1ZTUheQtCKVnLLgafRyKlD5BhzSfEjLxD6XiJ5DvXL7F1PQQuns1E3o506jQjsA9XQg2nnzGOvMwOjkWomXN2KqD3slmhl+q7wvF7Y504jNAvIi2q+DoKOSKVJcooLmZIjuX+SP73xpKzCye3poEEwQYzN3STfW81blF88NZggMFORPIHTRVWhlpBPKWEh06NZ7C0M31HH72EyY3UDZQETlFRez0y0oJ3xLdCaAuIalv9szW9K4U1x0yh3Tf2AE86LESLVEoKY9pS+1YDH2TyJuQKAQ9Fb34VbhqEgoUxC96RLd9xLmFHHM10vgY0j/XaBfjaBMIj3ZajfBEWe50pohT/CrLwS7B7k9w3cHbybzooRpcq00f8ACDCGVQfkfyp25Bx4sgHNlgFScK5lgbsXxYRx7Q+AlD08wnI29Hhotr3WtG0IscieUhama9+l9fjZhMffZEVIjuwNGlc8hKdFZCV9UFKpk1mkPi7XF9n+unmSo3balvFcms8IGeBeB02RiJxkZHDOyejBpW2lIfXqNoxZDNpmp5cA+Gj4gjOgGDlM7SILlzP3hrgTvJvxcoitYspeG/P1VtEutLAXyyuXtm7WV/G/QofSFEp0UwtFoyNtAtgu7mA+QtJm1LCFmH2ZvQqqSJjvlTAJT6Pw6Lc2WoXFt4ydskE7nYmpcj/FR9I0J2F15GeQ+5pkJFEdg+7xPFhDct6Iqp0m0SLzdhlTtnqLM5C0JqLbIx72sbOVY0OYk=
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