E09swNpG3eRhHtS+n7UiLUtasEuAGVGJdoppu6QMvWMT/F/61hSeFfU+4T7WBdAaS7MIJla8Q9RwViO3n58ZBbbD2ywGRR3Kh7POGihpwjGqSDctQ8x2oDOvnJ3fxgF8Qk/T2ia8n0Nec1D6G9kqOfQGFBf5XbzWqUmsInNFQKjHSM8iWkb5b/BEKzHbB7Jm+HpisDRLnnxvIbboT7iVQoIeKyyGgAQ8cBmdYTlGmvy8lR8OJUik3QiaCp2iL1zkmuINbC6FsNpAHvqp7cyznQPeJgaS2pOZq6RjNnF1T1LydLlNdPknztSJ02DDMUfCRWwpq8Ib35RO9FrzOkzytfuhbwf9jwMa2IgSUAe7+Qbi5po4edI+P+ZkywHmkBE2ElByENnGGb26kM0h+aysGSyzlLcepUsmFQdlaj0B6k/XpHO/foK7idgb59Y+2218zmNQt+fvI8V8HdNrJf7T78+8gR9cyX676WPym5yEooie3A5FkvD/FclJNtj8oK0bYhxcGqbJkh6JP7aDJLGTMNdbVuNTPvZseg77tCPCqHgGtwFWoO+ZfHr/GrM+TkAQ7ZYz7aXnDQNHEkBd529FTYCSXMYoOsrg06wNh/jV16xWAJ8esZkFw7jqOlPEL5lxa6axUhdMPH1i5X35qRYf5IuQUdu1nUSlDpfvOJGy7ow6JM/GLfo33+wotmdFLe1DOajrSvHOngGAaPO5U1IKc/RkHoQa7yg96yypDc7tj7kY7WQbo0QW2hl/CrZWxz/tYldVrLo1KpoXEkOHuIWdvTY9Zn9xsm8i59GqIi1T8e2XElE5LOurHDZg5CRlLCu90R0wpRqpUegVMMUmhG5fqjJrhdSqICnap1UqulVdkTkDm6uoerR2E+oEZ5NFuV4nvVATKbZwU8B2DtyEUkG1C3Yt3ZTLpSfoe9f2VKqoSWpQd5E4sQ27OK9BxsMA+GuHb2b6sgCMOTRGFtxHmHqpnW1ZS8rWtV3x4mv7lk2jOp7VgT7vCrHTQzhl7rbpYf576nbnVmroxXA8V1vqsacJBs5G1nclWWXrz0jPOLKCpBZ8Oe2vVdZ04v1ziTs22Np0bLzno+zl3LnFKzqmibY3o01/R1p3QnXUwEB60siAYi5oFkPhK+/NFobhU95AgVYwVH5aw7Ow3aLfUuiH6jQvrs49yPaZc7hhhq4NRO7Bbd3VI+l2JjEpMG9z/9OcIARC9Oal3aInyVO5GjYCiOMWvgx76rpGZ6Is9+rN8Y9JUdmuNglatDb0uqvpPJuA88SHECMEahyJLd1uif7N8M4qCfG6JKfZ1nczf8cO5e/g9XaqeaZuYMh5P82yHDzqALXrf+3PIYu+9t4RFHnY2BIdha4sdKSWG+437OMjg/s=
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