AnHhf4KmmtMXxM8VpEO8U0neiIhX1JWSvIoyYZHO+n0yKvvSnUHeSXJRi1QOkhD3pNLMuFCLxd+9LXupkYdBNbrMFGcVXPpc1toh0nFTZE4mbvCL0GDsnB0ggPtv+XVx9uGAAGPQ9c3wx1R0aoiK1RLA7s5YJkHogFPHBLuIajejdqNJj+zP9toNfjVsxjJbn+RcwO6AF3D4wkK+mykYbZCY/Q5E8ES5/ljHEreInoGPyMYIlY1KnDHy7WXuc+rsaZuk7QqotMtrMYtYSx+kfAJm8TE4liZl0KL7CBdN43q9s954mLHG7rVNCnG3tdKkFyzf1a7nzazmXpHLLjvnAypwe8tUyFmjDWTyJ2yTgz7kjSG+0CyUTA2V0tCIImnLNGJg+U+xHd+BcNpqv4UlN2vTLzBfxjm6AC8e0lTW2pTxxpuUjoxLiiFBRhYCVQbiu/nMUkSReDlr0UX4ENY4S0BN3qgss+TOtGRrotuyQgmyfZG8zkF9sYUQq1U26WQGShWNeZtwAec0kkSTsnfHzJVVYgKomCdD1ibxJvtWqpCDYDtt2ce2MSyFyzvhAn+Z45URk7cHR0lb+hvNRqWlx5vuUzg1rodkTil0bfm4TLtbhxdOc/GVJuAxYOdMvu/hJj0fFHe1LLYwNZ+J9hYWQYlmp1ZPtvebb41cky0SYGSjnGkVDV2t4+qUaz62kzWVJM3eiYQL+jsi6ZvlDJu47eh+UrPGvxPBTi5A8LHpnnz+1wnv2Vhedzn42jYUPSlJ0fUeiSCJDLMjs0gvJ4cJU04rlXE7YVX7UoSrlRc0RU50EbF4lkyU6HaTswtWK7Sd5PeF2opXOPc4sK6NRuHWxAUkCKKBd3+6AAdlNSunIpCwht/QsNHKMsXr+mvU6C5t2KABso9kPSyQ5pi4U9zg+ZTCrKUVa8Uy3XkZCECuv3UjcDrFOl8/xkSeRXQ1Ufdb5s6lAUct3GguSeELGs3wX12XVj6k8487DPFGmiIlxNTHxZ9/iVGg9iQiI5QyqVYg3YyI18DgVKA/OhniWCH2OTDmcWCJlDyek7LS7eRSuLhZHueTM20WENr3UtRp0NPNAETDDDeTTsxBWrik5ZZkE9+5BwERihhasYm+F0/5IBFitLrfH8+Wn3MKHReKmH2+A6Gec6KC42TO5DdMFJQ/dIVVi+LO9MMOgcj1Qsh7e4OewiLNvGJX5gfPbr8AdgIoqezwFcNOhxWUY6l5zqc6UOAwUx2rQ79yb6+pSblw+yuyC4ijm7TE9pCY/VkkIPW/IZO+zfWhmXM9NhSTaVh6t69LY/aLGUjtIJzPIJ6Hfeiy2TcKhWCzlFRP44QlxYHoY+kAFF7Y2H9XQgrxQI52c9Qbm9wWcPeT9KOmoe0=
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