tkBN4tfng8BprX7V2iDLhrzJiyp8/c5DfwCMA8vhSpfylvRy7+800NMzbhhhwXxQIWrOcntQ9+C1ttc0Ql4AKK1qsRQ79Vlb++gpuiqHrjtMwl2b5v5tIRLSqwxCtNwSaLNcIi9IeIWvHtlehqkAO6xD0utqnqBdT81/0CuarM1CRb6QmqXkhZ89zA/yQzXdQVe+MkBm1x1Jje/x7dHjyWQXqA0xOGi/M/stm0JI71Wa6pPWTNldOr3lFQj1ktkRO4bBJ41wRac0JSn3ZYqhzEJZgnjdK9/bp/sIJQVx7vz4y4d7jp73twje7JSdZxnaJZm1E11jyvejszzaFvrPGlzTz93aysjjyXyb+37AEYUUixpktI9dn4czS9Nq7MQOlgKvzL97VKOMPyJn9LO+/CihEqXiPzRC+ynmY9Jt3wXb1YXXaVlEEbAzag7M1bfEzKRwV0hjVajPUeYyKuuHaxOnAK5C17FrPrXY4qQ/RH0wUTKZhMnCZT8NZMkD7ogizGImA1z3HISg3PhcaSY26CT/RUIpeV1H8ysTeLc5gHgh2YZa6OcfBTvKSu57vj42FVv88NJEXOYV5quOkoOeYrPRYbqNoLAsQ5xwXp+8136yA/cxUqZFshy48CID3ksq1mmfp7ZcMaV1jRK2U+RFaxZAUlp/Ywlxlngov1wFMPuSiIuNnn3y6dy28Jh8Soe3V0Redj8KSmvKd6JukBuy5XiduCLCljJ4zDy8SO4Z4MqbQSGOzszEuGbNMkbdDBdyEyQcJLNqBFIr1/O+7FNIGOjFEu4vUYVdi2xwMdqvbkEMePoz9WMfdeQ6AOQNmUhtyypZZ8M5BmbMMTrTVDfL0xvnr11YvHou+XB06rNU8Y9Lh13HUR1k4mTYHS3oMWLt4QCISGAriM5H/ksQgA8FHi6tcnfkG3F+9T1g0cEI7iJdzbsBXGLJ62mDwLYhO0i16jSH8vAmCsKiB7uoF5tJdnJmajUSTbNN6F5c0pLihybQ3d3OLh+wYsfs1tNTcHnwEygw3IttJR/LfHlpVhEBFD1+/ou/rB2TPqZvSf4TfSSHOkSsS1u949JJTMsQ+yqpJiipSeDtu3NZe2K4ZpGlzPe8m68ejKLSjPqzYbUWWNMBLAakfye7iI/Z6zLrzhxUuiwi1fVlkkxGnm64MkB7qm4epzl78hspQkXEXOyKNlIYKidWr7gZ5pmFKxfWb40DZWBAcdizElyf7Eq8F6kfYyoHefVXrP+VWUkjZzDIj0rbLk0DMSJlcP4WXDxqCAf/6XIH3zMWcJRgT86IDObL5scF3MlXHsy1jJ83jMoPthZDdzhZk8M6GzgBKfsxeR0xcqnAnArEOnG9FAiX4ERqJZ6GHEFEjkG3xeEauU0=
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