R4yUHop78profBd7qLj3Xh6yAftz1sbnxSTZhnmbNTcL7FMv0KmNVyEAyC9fxHggQyMKfW+w0ACtp03wqBaAiATBzH+yM32SKha9AwxS8A3rytBKn2YbEKY4VCxlUaTVWCF7o3tgxxEyZckUWeCiKmHRcnlaPUAKAEuXDbTOS5XyCl6NJmEDGMRiaPAV4cw/JgsybpawbMCastJtllZNPHuP74uX6s4NrJfiU/W6424DG79+noufZTQUkLPTZDF39NR3/6oewF8W2SSQZfFc7sMG4jR+dNoTb98y+KJO8LTr5dy5tPSpXwoiu7aK/Vk8tCvowXYwt6uiAsrjYNMVW4Glk8zvtm9NgtjZ8bEzBmbwXxbN7lvnD1OVp+hG1sfpUn0ZyDURP1vU7ikOQ4qQ3XGkxyEo41T5AwjcI2Fu3tN1MiOpV1VQPW7FAX1Q1pl5Aq5yFcgKEHMZwAseAYDY0pHo6xd0vZmDtns9clkudN7jZSlYfzJ7G1X/4uqmJePSdTGdsn8jjCRjqXqsE/TIl0ksajbkAUYkvTq8RhSEvFygXV1JzaQU+bqJH9tif5JxTIqQQ7q4gnkDV+snQXJfJ+rfWrkc2MEbC5LuS+aGg5KipAqq0jJNqH0wmyCozhcDcsp7188c/lyWl45x19VzrDbs7/mJNEtL23W0H+mojYfxcZH+7W9X/Q6p9UTKEVxrKgbpjHMb8PS3zEYQDRHokPXMjpyovY/iim6BrTcBNokenXCYzbIq1ksVnMnTOy3XfT0TDJwF3yt7zV6KlUjqmRefmYEX5fIjePe/eYy5im0fDHQ2Maa5JIxxRgXHvFLKYqvOGdVfJV/fUPxWCIzVDg9AosKCY/I/Rw+UMWwhDNLwn4GBYtd2cSzKq+0Dj+9WHlBLwNRLAdNoOC/0QG/cBPKgNvQ04TnTMK6xH37NYP52l6Ag1qnW+b4YB1h3i0D8mYhbdz7oodq25E3PVvyCqDhiXs/e0Dvhj7CMnqQSPogIqRUYOaxdjewXQvWjDImtLyqyzex/S8MV0QeYPnqq8ConQUHkvZzkeT3e+YIAfVqJ8GXx1EEHbZsOO3jrVZ68Fw98NCLTUpBX9Z0ljHQoenbSM9IgVzbQkrpTHZtA/+HtwFoeM682OLun43DZHLOzaJ9PAoJ687a4ouj1aL9Gk640FwlPm0/pU8umhYrCc7S1Jc3DpsyOGRoBp9c7itD2j0c6isrMcXvNv49iwIHF0WqqnT9gTnPkdvlpWiKyjjLCscYoBv9qWDgm+koaPISFy6OGE3Rln+VSRknHNraNSJYtMsjLlCSbbPigri4XF99utOGAvzrPLYz0956KII4e/VQC/4u+8O0RUmkmHB8QLc6egCraaW1aVoMZs4w=
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