W45nO8ENC1Q5SaQqsZ0xCC9agx9shvofJIdFfMg3bbYXN0WbfvfdkOrUMB3fti21pLcyAWj/XjB+oy9oombZ5oSD6cUWyBgg94TJz5cseEU54MObeG7ROnPSS1ZZCif25eIXwObfVW2MUqEi7lqCip/nEEHIwvtTlzsrbfikjSDLnFq51RPfdQCVyf8CEdXrz2dMKNjn9g2gl+aFuGhCXQBZ/ZbnoKTInPwfnqlrmRC9Df5Z9nSDYibz5/RdjiLqs/MMj1iqJyJB1CVmcLSgZpXQV8Iewc5MUjkLaiqOwW6jQ1Gyz/ziizVmdZKjiTJxFYMXdf5EvK54JRPA1fjII4/55XzWzib+Q/J68Z08jFr9b7jB8KUhwWIvNaWiuplX9QImPf3buRt8X2WIf0yCxO8xEI/MUdBAK02GqUV4RZfNYwD916jeW7/Acb+Gn9aHh21iinfoBiPOyXrBvMu3dSbBozWGdCebfTXdMdVYStQwybhx8huZxA/kiyXb2WNcAk11dB7w3sUFfnvWDXlkXYcsXfIOT+f3I2Knr4oQkViAu5t7Hr8U4nGppDqzCG9tgUmAU8lJVQvJJ98IE579YUcUq2+X4/Wme/Z7ZNgmCMtIQdY0eAVTxkthDBwsCICU3EwjPBLuiwk4RaCXlRkGkf916ru5lMbv3ipgsnDQdKRgeuJRg7/W4uXzg4E4Ekem+VN8u0lUuH9ZIneiIzzs5Q7WTtIVQHkIIYyyXlNyW19UA+aipbDs2xML6W4uFyNuPYj3AYlL+vpzUZVOtAYZ2egxnecnXIS6XgWJmTMa3Rk4bp29kJd9hlbZTeS4+WpnOxj3OK1Ar4QQqDPty/1I+yrlNOsxvzLeFbCCUPQquIKQlzsI+r3idcZLDhzpv8UyuYjAbnBjKRvOz+9YKCvprSPzm1M/t25BQYnjurkQ4SyahQkMJoBkhlVW6HxJD9OHR/tWpQFCul8mZIPSxt9Zv3dOZJ+wVyD/0gpvtQ7/VTqS+z6offr52L0k4IbVn1rE3cLr7VBHLh7AzuZ7O8DPNeRNT0ARQaz+WuWWU0FocYvaojEVOVNrIePDpiRO2YhjPoaFFgwlcGNQen4wwsfidUPzY6+BpXznGAktShIHE3yprHVBz12AxoaFcAy43IOcMnp6oBUK98c5DnEBHIYwj4WzWwM6skpsC6TjdItin4ksUVjmo2qj/BXCNZ9G7LC9wIkf5Y9M+hz3RxqjFf2bD0yY1GBEsG9MqbFf9gL1f/TvhqABW8LIUjxT9FQ6+dmIGnNS2Dw4mGyGMJM8pVwJx4KtBSq2zU7tXSyvraejQXBl9+a1xvhCzUfYP3eU6Q6vbpUgIY/A7piI2qeRtqBfFqRA63FjBa864buZ29I=
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