23641+vcDO2UdzUxFGYu2BxnMHCZOrRnhyXFW4NwhX1d/DTQ4hHAVn2kL/8Cz3xJhbYDbnLEPytgLNCvE17cdpGJgXotcTjCchHmoH67vwG5mKDA7vMlyrfQeS5i2GMgTOpJMqpg35yITqR+icjn4eSpLzRnldn9xcPB3cuMo3atDuBaE/1sxj4V78fCkzUXnfy4t0ALVr/0jkmWWpHH0r+VzR3VEjWAMUe42OfgxYkKGJjz5rGCJnS3Zqm+Y2/VntyrqQK/yg96bThrcHMz1+Z3+MALOToMhXXGhkgNix6qU3Oa4ASuywlI7ulruBdpQuAh/tGzGowEcXS5DBBC9wp+1qEyWlN1ooG+0pN9rb1zhH5Sw+s98yydCRh3OmK4wgoPNki5FTDLjCEEATE2ObCxr1BLYZrnYKgAM4sTascoEMG+T89X1+1rVdxXERS3AzG1bwca7fZDge1KMK4k0XN0TRXnry6kjxkYDuIZKnIO7IriSRjs/pSmLcAPIOz3wUPvA6nnxb9LEkuF4BzuIpytC7YOaxPq9erCRwNobRfP45nMEuaDIWk53g1SxKZs4+mct2zL19Ts8hLMobhgBnw8YlLfFvvYn2UMIRKgSTVjQUMNGABb+9+pAo3Tpxa3IQ/VgHj3SvupjxggwpV7WQdGmoY5dfOsXhATuZkeAT+SJFTFYZLKfznEHeBgQ6+/sviEHxLYcuZ+5mO0I06jrWoeag1FrCco2P2Ih6MEm0W46PVwdl4BWIfkaMrGKFzC5W+Bbf8t3MLuhKQpsm1Qwmodu0Pc9VG2ef9lxn/TPbRpFn+R0XsEoSh0AyZpMupLHNBQkFrQ21TxMPs6+LORLv1sfF/oB2nn50bi7XqwYe4K/uULuNHcMqWsNaPzuJWWZ5wcNHUTZWmy5j6Rz6IWYBiGLZSDGWNvKvFY3ty+VWpZ5x1vgzTjdwB+/Bs5gtZJeHvk0cfOYIGd5PJiJg7yk4LzodQjXaLs7H3Wdph2WZikTIzc243Lu45NNZI7WhmpxgQrGzBV2U3E1RUjMLhttmIO3737OOYoatjVZH5GsGYdjtY2hXAeipG1OYyg5/VwJL4KvunX5ipabBcKQz+aw+FM0mg/Rw8zRcZTj8maVvoWgT7pvKZGiSC1JN9zLonOSLUXnsmvqqiC/db6fmZCeEgcQ5On+OaT2f7goGYFVgu2SIBWNEly29jL47gbDvpVdSFJKbvh4fqqYnsUb7GabDEorzUxqh9pUKfWHpnp2QxfW1zo9ZvXush+Etw6HZqu/HdbHYCzUIQhDq7Mb2r97tHNZvVQJChXU/Qwfh1pRaBkxBYlhHxTqEa7VejeMuEyDMxh/z8An7lILIDXoCJRqcQpjfW1UD62882tA4g=
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