IOeG5t12SL09QozqyNOZnvyuOjcm0yYYIpQ3ihuZHssphiLrtwKHXBMRyEc/xfLs6E1pjJgc+TgfTll070aXIfNr6WvGDflj7Y1gztCCLhJcFaYvcWWKNd1QQo/zLcr5d536wozFVjvtRuieZft3lK4gtU//vGbAtGFZHOrPokwmYD+DNJU0f5ghfEGqvsiwiOggc3Ao9Jy+7LZZRDC0wF6jlJyvIpIIpFHL+vzbb/qDLSLhq7cXrKf+bdezCpfaFU0p7+Gn/rYEfeJV2GmHtrvbiekxRQIHNrOMnRGzUcVkFhNVkDJO1Lv1ZH2wjjy8VJLCGVv/mtuivk45bK7mN8KO87zVcM0sUB1mVE6YJo4Yf7Tx+fXMZmDbdk7AzmftWFdxqzDUn2mVnJjZ6GuIvCc0cXA4CqTohdH7WSF7q+4bzZqkVc6pS8nFVWSB58Sm43JFxRqYZiNda1TMeU1SS2ZBkR/PL/Pj5f7YmouLV3N01faA15xnHTXQZ31lCnSkw6Q6JxpHJZDsdAFQrZAECOk0QFQleqgZ6HvIE4HJhTKFK7g7NUK1xwSdz9gkPuuknpP8SLa3Mz3LWOglcxwWXQ8E8YxxvjjQyZbXjghvHjFUqSWh7bieR63VQui2cYs7wD2obwUaFd/IqEe2JBLVc4GA5HdkisAx88GzZyqsEW5KZY6jd9KD/82ywNuAF1QkcDY5gxQdd3iHkoI+YE9pmf8rLDh2f52Lk5jQq7O/gvPah98eE+ck9I39klek3pGX6PG3aydPS9CdIS7vDq4u5rsjPgSm3jBuUJwDmXnNcPU+0CSO5reccUbJ7Jo6V/gsgDM555kcGcvo0W8rG2FxeherC41u0HPJdQvL9MubY0s2QSw5dgSmoHKn8oGYweWcLnLhvyNXSgSxJFBCZx9FpnzyVG/mM5KGGkw3fXeLFXUO/1/5Qf3g7XMMrpvVJHADB31oqdmjcfQJgSH/oCfIZgO7Jqd/w67+gy81LHFM7p8QQAjW63SuIfxGP3VtN+qFIo6ht5uy2e8/ohjLslV1zo1M1ZZWOydDo5BdmHCyl5usrxBcVWMsLn1jhk/16BVkWsZxjLIJ7pHhMBrX5zjfwf7UnyA7NdN26l0u8Fjuryes+mXLHjn7Di7F1qhVYxkS2d/nt+ZMrstKM9MlRWhVlnIgSe/Tzi3Qi94+mVt/Aj3jNJM/Gj1x86ClIrujKRA7lI8SLezhkw7Gj0NXZiTNpEb85qqJSeIoGJT3mUzZhNWzoAXFtQo0whydvSzj7oAcXhU7eUrDtjS/Q5b5R5U9oAIQApsLQC0+8eWLbcwVs8+mqK+OMToIEttfh0Buovicph5HofqWxhn49bC48o00itWbwJ94CH7Bm2dccqk=
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