dwhSEUeoeRJwcQhV+3aT2V1m5+80VzeaMIE2qWbGiNgWswzBcR69b0EYee7HjaV30djTn8zw7Sle7sLIR9hsREztNHEahWtNevsk7/fl2VUFXePSMxEHr9c4myw0oNMicfC1R/JwrcyHFRDTupJk0M4x5QAUnDYYDBBFSeSXNW7rM52j8Yp+op6Kg9i4MnEhqbcQHhcqFlJ5l/204kXtfZAg285rqOAnRdye6y10OUoqU74m77Z3EvT2kAgsztZQtTZdvUOFll/noBkwNOOqaA0Jmo0A6RHisLNW4b7pUdwaEGlwv/aAy8j3avcKq/6hqyCk8eTyxsjWFOkTh7wnGiZUJT6eXMrTEjEnuc2SV8W+f8+d3yNbKwpxmLX2NrlCAvNlg/WfBmNCeB0FRIXlJ/bbWc2XfIumq2L+PnO8L3ubKCzRHnkPgFTFZiCZrRtv9lGpOuWiHJtFV7nMl4LmtEvtXMpyKySk5wGhFuA9c2J3K3Ixnvy1a7iCnGHuUtnTv1fvQmPUiqbHrToF6uhgiCs8Sqff9D1pJ/0GsLnxVqfu/gq4xs3GSzD57Cvh2S0ojbOjD9fDHi0cCbdJwle3VSwkx8ZSuqJ0w7QfZdM29RJVopv9b6mHJuwX6atEOh91uq2xyN6vaeDipGjraZES33aX/R4/VWEN+eNIGpRPB6RxF5G7l7u968Hm5lZSUchz5BuoRYSPPC9v38qVDU5HQhUBAiiKe0yAfbAPWgDu8GhNUI6hAVlg5Gpqa01dvMQk0zbaZ4J0GpQhU4aflHuykRYXUaMUPvVrnFt9v/bPpq6gPC7dPX9wqypLDEIQPBdSSg+1jHRqBV0xobBUoexBRfWYIUsgjjotTdiUoisrGRasIcmBi8r4QeR+2jC6fni/CBMlh+/ciKWoSkoEfM9iMKvIgsPSyiV77MrlNtdg53CqKlO2eVimc1YmvObO3TUaQ5nm/WqaaidOGQT8ai6cE8Ykb/HYU3G7SJSeflDdtBd1dIhjfq+7Q78acWAHNlAU4qSNzT7kzMnRuE/mms3/GC0ODr0ZycuQ90QmbGW7hBTlPstmyz/IsQ/M9edudQw9f32IC9Vr7ylGqhpZcgGKrBHUSWsQBeqE1pXgrWGQ37YtUQiIH33tHAUnJ9dUJKmbBI9xnJFfmguj3Fyf93AQrmUd48aozkj6E7opHgetDxvME46hfFvgflHTfHr/qb1NU2eFLeV2Fg82iGcvtH16gnpWPAlSYey7bbqSrdzeVtwtSRXOjzmqjXPT5Z6ldvbGglYa2JGKGpjpos0DYBhtUwkd/YvuUZgfMkzKvRNYyPV0BVF96mAr/kyYfBx30MGugOF+qC8hC3RmWUIZl2k9hg+oT8UgD1Y3BaxY7LY=
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