20rCiUbudEmUeAj2gJW2rQlW7Ai4Q9P7H6kyJ3c3z8OhHqk7bBqAzlhL/qwJy50UKF/yVM4X2C7DSbGZIbM0ON4O/Y2ZpOBRNhTsIonNGTilwDilHvt8DwXyXzqB8j1JsRll+Uig68ULMWoppa7zG6keOWZPi1BOdR7CsnUiNE4c3OCqyIvSD9sN5e6TcVuwfMh9qAj9Bm6xGKzs1qed6sd//D555Sm/40K8v/5KIsxIkxDnGhSW0BUEgUVW3wZZk7J0QULmG4X6REKZExzKk/OkFFHwebyWOyV8+KBeAeE/LDQo4a01Wi2cAEWFQrT6LzW2x1wHQgxYy4VdXoAdubFLJFstHxoTX77uFaQgS2JIOQ5SmpN/QhZPyidZAlbx7OAaqMcsAfZAFPj9YvsgNiMjymLLFG/rAmdNZ5SdeXCe3splXWmirHw7g9ZJhSiVdhfWIm5FEizBH8i7Q2tNXRcpjKGLBoTZXGe/T0HBXX2L2gQlHpigmlVI3HT04lN+DWSgp+V1jiJdDt17TYdnNCl8dhIr/R/gq3aKMN+6Fz3Sd8pvF/JRW9H5kyF6EvncqnHTq2q819k/VWjo8q96ZhtSOi+uTagutW3zona/aLKw7MurlQDziKFfUZ8ebaWSHCRLo3+/rmjeG4BNR72yM+ODfaHx5FFzlOaYhYS9VqCDO+OzEokUQ9Id9h1bIBNP4tilTWDQQhPK7GrN4bn0MuK1phenSRj3Pzgr0nt932u7pkwn536ocL1ddZt76slOu9C2BHgo0Z45+8O8tO6EaOQNmtFKgZbtq4GGN+ZEnTjlIeDQEKEbPmq1P2FdZ7eKzulcUiFpxlAgDUgN95xF8dq6apZGwsaPNr11gFQChRVhW7qRBCPSTWfnR6bATYzx1UmgcQ6/B9hlBbCVovvqL6QoxIA5Kp48LBdLrFVe2dlGH+E4T0AAJtRZSojty003Me/oHlX8fHvzIIqyIOJAiNj9VvzcO7GmAgT+QWhl0sytOXmCN+EsZHYkIWiiBLgxymDdPKz6zgCzQbb9J+sx69ShOc77WmHusrQHe4MC+1enSpkkowDN28hB5X5rTvUUTp6gbT5TsO7kILyvYCzqe3xfAl3hYB3X082fdMGTPGp3+XpXcM7bX4pT4VQXJcZWc4pLMpHbU2yhK0YRckeqmA2sYh7UUPw93hERfZ3Nm67OlXySmPe3aI+UUp/ycWXFT/u3I5QT21vbbsHpMkqNQP9ctmAqBp4athnlmXPWAXHj2zUQJlEbFh8hUaDmLgp8q3tQerQfdxbZUMVUGNhIuVOdutv+bbaqayUNjKJQDkepYAMkwWGsXzlvg9UjuAad/yaVjfWxfcpdMc2Waw6+75+ehJRa26j8+krfcAU=
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