De5w07JnUEJOD1tNJ1UZlqTFRsRb6K3tBfWt7qZQjuJ1agTe3Cvk+16IlwOphjZczX1J7xaz2GC/kVxrBsypRkcV6N2L/lbo9d8Hpg29wcwtkQXPXHbz2sOg3C7srqWpw56IgXTyjjjiUBqZ0TIEebU08NspWVXzL907c4MMIExaQSTAdekNhsGl8FkIHA5azva7j9IRXX4d+XaDCcQz90h+lenmP7opVYdKrBrcSnX67P/Gg7BHde9YLxQq1jdQv3w6W5bdOOsd0GtTXAwZq+N0Fv4wxlYXV0qtwgPWs5AUOQtUQHFfD4+c+qwPkdM4xuHkB2J6GKbMv+ZYltGCBgSyZnSS9ouMvLST8jv7TOs5oVIuI+4mipgfIzOHg3l68UaDtcqx/ww+ZGaFfzQz7ig+FSl+3ulyz4X/B42129KJ+z3QGlnmMpF0Q4tGeKltyxUmyhdxlS0MTY1S6U7CQf4C1Tt1NrLlc+g8auZf0lEQsElmwNKcXBRfc8S6Z9n2jNYe0NWS395hbsVNHlXTSQdQt8XzJxbE04MzPRuzhjheERgERJLdPQ2IUIDIWfoHCmtx7YmQ6lYJPQ9Mf6AjvDxSmZt3+tD5Vpmu1Hkq2DOEO+uNeDOb7k3o4EEY45rK+h61Ko7yeOGvRd+IlXZwoLJpGALkHY5xtW8qkHifURMe0Ly3gNkPcwhNBMx84PrqajQqI9okdVN4VDa93mS+5pl+uJ7ji8dESk6ZNq+p7ZbSr0QRNPJ09O4dYigFoS18BviW/a5l3B9ZbttYbWDY/eoub7qazOTgToge7/yKX00OrC9j4erk49CMxWXYsE/5714UdD4F4AOFWfs3YTMyq8I+IDNkRnBC8EBiN+2bcc96IGe+TNbFOiEaMEobwylutnUe4g7cZaZJLI87xR74jGI3zH4ChmNTaAWZbraOwtlOFtykqAiKBlmIr3mgnY5Rdm6++DsF/xKS3hJt+8CdrCftjHH+3cI3suJYgBOHhfJm9b4hhH+FmzPcz/Y/Qg81Ph1a/Ti53z1EZCgtQf556iHi01+9qugzUtKq1ZXtX1KGVyxMd9/UGVO+0rpyD2gO9vHZ0KM6bcP8byNDEw/1n+FhUOOf37mv0yEulEc6/YwjXtzAaCJUDtZ2YX3gKLxREczkCcVhK+qBIFzPbUuVlPXmAKKOPJkgwVdbz2uXeSSE6s0sP1xkQ4jIE3kfzd6QiLDxy0rlq0ZFh6Wg0/UZ1utNI0G6kdLEF97MGtBaP5ehEDN/jYEYuz9aPDqlofbej0RGqFu6Pe53Ni07TaqNtXocw110oaHR4P934+zO3erTC4YVatT4Dmk8WePnn2vupqwfkDDBAFhLf0/XGT/aDsYTAa1WYVnMpyDqyvQ=
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