MKUxH7vMcc89oNqKbwJfSsQXvUyS+zrCSJoNAh9/0n3K48Ld/W58pSlJm/3j69Aqw3m75odT4T+MvGMcQAKurHP+ESIMFXpcC+4K7/u7T9iRHe6z1WB66Nkz2XVDyNpJmjv+kDp2sXtta9nXDO97uw4846Ltl4lYWYWibJ3e6X/1oGqGBYhkNsf1VF6pO5Nk6++FU5LvEn8MHG8SO5aCeRSr+SoZUs7sZLwKFQvKDISgcw9gqi1yFXpKh+SGHApWmxdNGFhCmhYPCYUm3y3UohFy5x97sFB8pi8fn8ZU5Hqghse2NoiDLbNI01HJ+z4Faj/kdA84QXdvUI2d7UCuCd5b1piz1br9PRaHa8aRx3E9NIi22eP1RH/sZAb73fMhFpSXMEqbWK6MGhGvqrSv4+rWcK0AWtbaAfXmWV7HGajJT98xetSdT5LACGZ9ntGhT5XKeGfFCAgxIod3PIsIbh8gqo5AhUDHzywnOYQl2+xqx3NGinDYOLul7Fj5ccfCZQ5Er2fWpI3hTvfFde6Ak6m3rAMuPSlqV0CKhDZgDkNVKPjhxgu1LpHtl/9bUCHyuL1swQZZoHBFf+mMnjSxAnVnwU6sQ3IWMSaEu/66z4ovAenB4jLXpjeMbRvcPRIwangUeF8o+NIvkoopcxVpAQhS2+tAhtn7YSz0hQXJsHk7m1bYo7ApczwNjllKa8Pr2BofST8OZ+izMtqQYuNQKjvurcDVbKcBuGXnBplyinaR4MjQmsQyyx5hmuZG3J3nJio+dx0r7Zj+Qqvu0XbCZXYNEqg1mZ18RNrNvOR5Q43zmQPbWHvwAZMB/KVJPXJGE6Kg/O3MfKpN9g89MmySa3yx0qkw8OpWaZ9hrRqJzzevehNpMEnWFxalRlUYED0neL3uCdKswUJPBUCvjC9dQ2G+wnPmKYw569pCsuv+OH3d4EkBMXu/at4kOfLI+Y/MecpYQ5eCzRtzxYwtqE+VmdQRNpXsfiuoBQ6DGyJqqeJYW3bqod50CIJUIkxLPeyQr21mzWt6HqsI7bm/UuBmKU3RR33iNtEz2xaepZK4eRXPHVk5bxQpeANJ6g+uwxzqHy/3j8QIWu/5T91YTMbdKMCN04HEC37Tc/4gpMyAwkg0hJFT50N5Borjyvv0E0ZBdxXelG6VI1zcJ4jAhqerOGqDM1+MoB1QzYDGbOkSONdFZZGCTnDKUr0dhDPUToPpjnhA1wGA+y/94QQwVDGDL3zKx807TeiMde7bnck1tQ/eBgkFEKl+/VZViViMF/QzfFO2hJScWnR2qfek+Vtnjg9naZ2Ds3Ch82IJuuCb1bbFMjOg7FnxUFOs0fuTYwr8YkFyRzXVIXaTHOrZjGkmiILbkklwOfJaTGwdAsc=
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