9BsZjwViNtxR41BfpmWVruuP43be5tho5K0lycj+0BUcVd1RLmxLURJ7BcehNHue4NPcnaTXqfQpLoriVzltJ9kVdkVN19Uqu+qZOuhzlM34g/Oc0g4E2E2G8FEXDL/6PFqSq6p6xJc3GyDlgxUpCT02Ab8yNEu7llKDGr9qPjkn6Fxoge6H5D6jbTMuzcyJHK4H+IXy4mP6O3+6+3+QNetOl5YvsrhCXxB9VHalJCGYtZfscLe27bhW4K6PhExomFZ3Ge/mq+Iqt9oLtE8xEIKj00l7H39D6fLD2NP7PmPVXIfkAGQi1YZNxrk4TSdn8332qp+wUXW82cNePYHEUXPiG5uAO/F2H9Nd29pGEZ05QdNkOdEt0ZVWPEc3mYOzYNE3jadOgVvKfsfbiiEyC9rWFs8x1dF+Dt3g5Jz/5Ua5j4oZZCtkqQXU05/eUXMAm+SQsqBTt2A+6tDmmuRgQWrVTHG0KR9q4mBzHIFO654WFj2RbZ6EM1B32WEdiUK5iVUVW0mX4nvbiS82JIrjtJTsLPbz3BiP1k92sAS1mNW44ArplidOxhtU8CkuqLSKXcZJ+Ug6H+Q6DdZ38mdwi+rdlS7QWx/7zlDebJA9f3mPkAiULUYYkVqCZ1M4MRoeXZ94rE2Ij16t05z7EYEpTula/yb0Gt2Zwx2tZOez+gf8RGdc6Z3HrZyBfzGnQuwP9yf2UVZ+X+FoKEBVSqrwIsy2PH1rE78NZssNt5XYjKTe/vOu30yKbYUsKTRA7yHik4mtxfEGl8/mVoeWaDgq3tH3zxiuGDcAEgCqE1VLKkoRyk5Fgbw+lDBBdQkSh9X+cewiw+Kc3HSfln56gLlIcS9k31hEZbcqrMcM1/z6pn2UTooRfnV4MI8QvHxnwCUBBf/w4iz8WVxcOd5MPHES5yqX0jOzASyZTO9dFLvb54l9rIMvmp3X51QzriosDrtFioXu2QHzHhXCiT544H1qefneuzHbRGK/Dye32E0JoUZBgJmlt5gat+vGQaQjjGErtTrAdYyX3f7k95p6cGTwHRctlUA8MGWSCKVKKuWnceEuvakyKdyccWfAPEQfk0rEsn1HbaLou9r24SAW0TWktpUakw8OxV6qzBf/Mdv1TEtA8uc3pfLQPY2EL3K4pWbljGxRbPh222iJJVMTjmqRK8Eg9SswQl8ncoObfFMz0ShoVWckdfZ9qhnfFQI5aTGeUdNd3/gsku6cLyKlwW2W92TfD1lbA/wD+OtIqN6szm9aEkvSvU5acg5LIqhiHEwye1UzV/BfWHJLAcfamCqgKePUE6SICUiZcYcsBVw7D+Nc0QVv4m0CtnUAC9XCsPZqAlRb9T/cc4DQFMexxUOZP1vG3cGvR6Y5v+/4wRI=
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