2Fm9i4enUfuBeJpjn/Ei4+8MyFTxVUOLMLLMMXiAArRG6VaSRUjZAogz6yyeSf/5udr/73whBitSwAneplb664Z5dRZaoTJtaRelUD8Z7ZQ2OW+P1cJua+pe18X2xZOA230WSz+VQPmzg29yZBBCPESnkazuiy1lJRob1dN9fuDkaVG5+z1jnP35C23cEcg8LiNi7k55JlZsyNgXnIe5AaizFjBNUn5p7XEDaJy1vUa1FKQvMSgLyUUYtLer8aEcWxo0M6KZ703xcLIsL9hDMhXNalgLFEbGKq/J55/c1QjBkuhDhLby2WaPc3je/3G+wjS+AWFKOnZxpGVFo56JxL3/6GDXDmAY7bGJXThSRxb7/KMf/QcyWYGa+XBNkbbvCoaQokcWtlHzvFgOkxChQ5qhAgm0Gn/Bit5EE0bznbvTwjU7P9HLM5Pkw+W0ScMvsvM5csKTIO/4k0ZuK0vMl1BkhAcqeKLXc2tziHVqHX/8OVDsJo4k/tbI9xOz/RCx2G1mSezRRwcSpsKNo+1lNxv9e/ULyaNSd+Ok+BmqsfrYIehqnxIzH7nv0gtIAv7Py98kK6zKTNyO0baahVVtsHID2bgSe8m4IvsMJzS7P91YTpQsCOsGhF9SpK8dOPZhdZofbtXy6Z0MJYGHjlodke1fpJR+WQfeIWFLmxLSGABuEBfSdlriJHmoogPqoMLOq3TFbyERDwrpkKtGrGe6kpVltVLTj7/c/quWP9Y97Sp9aq2PHurbU+Slvtk4BzUVNMeF8TNtOtedbBlxDXaJ1LGlfOt3JxFzYq8Q0UzWQqFk48iwrbeuXMsRSOetQ02YHiXavJzX8kz19/6D7QIpGxDw+qoLsXeKfLNxTUeID/F4MO1eaR74VkD/FzUeZejOZu5PAKe/aAdVamnuNG1lRUEriPLCKTg3aWSX9V/08EVH1baawGM12OH9UyP6auIFB6YFq6062coNjQ8+fknIio/MGuDmWi+x0wd9Hp4JtrjjLYG6UXv3+ThAWwBJi7EGCi1Su9YMQbhILx22KvXRZ10O6zmY66LP8Jv9kCBSbdGOwapU8aYPlHItFxRhWi3qaTWeTTEhBkjP8iacKfajdrKIYLvCPXrJWpV6cETb+1wyqBr8Ws4UIx+NpokNcnLvZGlFL3zDJ8NElM6Lf0u81Dc4fiQ1dnYF/rhZ5Jq/huUtKQpsQXRbkRHCtjqjnzUXDVcKo5xV4h0yaYhsf51TtMapTh92vpWDmdCQsBp0nEU6B1R5IHmymoFssQt06T/F/S4j1iga7if+nX6QHbRSMIIideoGeLbv4GA9vNVmYRaS/AJ3+8DD06kj6o2c3ThITa4uUHKi7HCdpZV/jEXUEc3NZFMYFN5XmbOQ1yc=
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