lNPpAmJkf7jheuEfm7LUOzpIU1uVKlFBcwe2H0oNa8+x4Povt3UBW302Coq7eRs9E5jI/5JYvONEwXK13zkb/ezBne/Ajx8g25UjE9T/LlzQNwNcIO4dRN8OcQVVshb0ecMhmX0QPWQyAtgV/s8Wty4qiR5H7UH7NDnfIleFl+CzwetnDLoL2h/ly9WcH6pL0SikXIe49tC9R10ky58FErAwFxk80mfuh1IZtDQbSYdkzKWI32wFR1WdI7FJ7UYV0aYYQhrCxamw2umpq65rW+znvW/x4zvwzsPloGKkd2AQPpryJ/NzN1gzH0hM6hmyi+Gb4/9YMK6KLlttwQQdoyd0qOK8D/M2sOlgSexw1hzcMJ9np3SrO46r6YZGV3GZAeQa8cZHYhuBKi9kRGM9rgvWeWz1j70o9DtNwaEWGzY6wMzlKqrJy/XSchjFjMuu7UJuslkxnGmrmbYF1eiLmn7LYwdc1o4JltZqHfx9FXg2CQY2GAPeCAPkB1vczrU/6wsU78xKa/i69K0mY7QzO8JmcbsTLcng1dsS4K0OTTfhQgGobQTJVy+ZOLhC7f0wPaVC8HqegE5r+h4/f6zo9Zfl+eo6I7h0raFtfHPc2eSaa1BQAPX8WrFYli887DLAZ9T/7fIYCICsbguxCLEnJS2Sr+v6pE638IoTCP5wd+6hQmvUwIsI4VzcIur9VaOBzQFKcsrl7j022CvB9ceRyElNmFjXX1G0SA344LrQDkY7g+cl6u6DRJ1Q/OSzT1rBy2UcKBogJXMNh7KndN2Cet3eRpDmlzSIA/Cnn0ER5QrEONeQPfHUgT+O6dWSRIxUv/m0tTbRFMpGIcBN5sh62/7uGgQORz1L1AJhh3Dgws1Qzd+tBB30pmDkjRkXnvseUratlLf9hrvjutEOLn0SUkeZE+6D+7mnuteNQcEBaIrMN2Zqqk7ErnlIF/kfJAeYnOEkEF5dQIHnywWwdzJoBnLIgeMZhqMBFObmvww6ggZeEByTMCcMUY+onVntdvpwosPzRKBap9EaqeXSVCHsgHEkEwqIwE/of8bKvYPo8tnbdTqoncB84IAg44yfj29EQ/Abu0AQRAt9vDngZb9i1hz/n9xt0qNK+/8vOWdwl5cvPxNrU+rj0r7ATtPA/i6Wr43R4A4PjyFDcSNZkZgzSv9ezFt44Qc/IuDmv/A2bBtk12VYnUPzM/qmQQDmYlUYO0wjdnHYjwiNzZjqZcMT1p7j5jmhatG8JmlqaUs9sGrCaD9oQqXUsz8Jl6b20kDC5MrlJjSzWn1yy9AJwctWupB8KOJsr9dXOtB3Y84WEA7rDkpn0gTnhK1IwVjXTrSbammsdfXOq+2VSGKSaC/qnV8sIGjfTxwggBCbCrA=
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