c9Bo28O0UjMTOdknmqbRzfMZIxFjfglisrsvNJtF4NVUlpeLeOSFmEC+K8gpy5I2/DpnX8KbgSByTOZJmpheLh1r4cLv86yT0WVFBhgzNmANI418MsisMgAQoRvZt69IEUtJygcqfll07M5aCMKIGh7AWIjSYtuUa9w5XQY9ZKGNLXboHY9y/jHu2L7kYRtRUjROvKyvEckX35iCVXFffW7kYLZYHEFLuDeeXg1wAgkhx984R0cz0x7Pf8bhVGRK9mzCCsUMXM67I4si8fjVBQNz6CawDm1pefllSMnQkSEk5r3EYFXW+0deCEhao+OhSXWe0DlXH2SsTh9ENu0POlTxHnHIkK6ec/34svADWLv9OD4ahppBrmq4d/5BVvB5Qd0gEF7bdeC79Tth/wXHrtcEpj0he/6P6lHWuzLSU5n6Xa4BiitiBSgcjxl8XaFq60Lz+6zJeU8BrVt09mWNgH2yCSAWb86UwVgVjNdowhv7qT45tk0bEYFyvUyeQ/rromu3gOxAYMPxd624HZ6N+kgGVio3GWsZmFbwzxGHBVxDAGaGJ29ztv7j7v+D3OW3ioIK9kD+YYIMIUDurtLwBjxCKuajdhO2VbMM9EjQ1peubYQJ2CRgz0c0agd3GN7xuK7iJkFpVvxqCdLdtJK7gSK2BxuOUGNAIjQwbuvxcN7VIuL6HjLMbNAsnFgqSUHVjw5dOXZEJB7SUvRX2t8Pwe5bOC9IY9QnZcnXIF+LQXkTqUar2q9Tvq3xc/L7qXT6zBMpRO5C9vv97PY/03MrxihYm8QILphJ8n4ixjSi5B1nBRkZHid5O4ICRB3wtBRuyK5JK3FGZ56s+Bgr1LNSt1gJUU+MEGw2nZWwt+4et5yhOIn6vAjC8IQPgSJioxZKpot1/Ot/XPZhdwRQPl7xxH2mt8Z9r6JOMfMX1f3dJW+LuuE/m0oC4kIv5WxUV8huvSh6J8/8VBjMDskm4fOxKUYIp2gmFtliy6be9Znc1s7HnG9O18bEt3NXnD1zrSC87buvczxZ0+aF2H3TpDhoVee25U0BeKkPcDjo+qd4sRkvutcXo+Uq/TF/lB7i4XL6uDCpfcVkW74zHXmZAWB2k1Bb+iHFeNfQyj/hK603XCrosWfzkIe/SMozCE9S9b9d6PsHGE8j1VhG/pa5lTTDu3vrS/xUJns+Eh7H2Lx5G4+OIxiepsg6qlrjup7NTbq/o+OBsdsj3LdpU9tHNHsODew/tEYgaNUaiKWd4T/JilUKleARfwabnTpDDS3pSPoFJVcq07avPjk1DHDgoSeLKNXRU31WysVqNwflJUZUttfJkFYIedYiB7HyvlUrNjUfzsd8XIiF/JB+voKLbQGtcySrjMxeZf4woCOTAQE=
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