+YnMEqtgSuWRUSoAzxc0owM/XYeapWQ/M/tMdb42klukWsgtihVG/9KVD1xcZvcleP4X83tbO4uwnz29zCLpIMnGt7DsGosUaQDV4MBvalan4ubwr5GIOWW9pgpz61+FY18ACzdQf3FNkMmG73K+IWxdCL0xrEnk965XZsP9muRHZ8KHvAhTAt2EzwLagoRrTOTgKA6dYR5X98gOOkPyI7hsWoimqHrs1m3E56f7lStKSPDnui4kRoJ8cuhmCQSzvv+mnhYJQhNxXKF3khS3gPqtuqiXoHHFevjHFYOO1uz+fzdY9pp6f3Pwylj//I315IqEgNOv+BLJD+04naNHWkBbNtE3sFdmsaOVWwEUtbecoyfgLlUNWma9S58XZhES9P4pXZXE2bI614hvTiedcTAfBAkw2Va3gIKNC2MH6WVaFQdPJgRQZHSXs9yvIJ02VEuAfCM3D2fw7pKNm9Xe4Zhe5DI2e9Tl9HAmVt8w6cXD7TWJwIoBcDM51ReeFmzMHo8YUQ2QqXo690kyKC6a9WXURTsbZEg1hff7bFWce9UqKMIrIR0z8Pi5m7s1+qUPLuQsm5EI+5A2w4MhA9vkJoxzvJrfqS7ct4/f41ubcP4YmLHx428+Vs5adpCii3EZ/mATLoXsvmlQb9NQ6vO2CuoJxMY9iwbUxTH0yWr8M0Fw3LI3nO5IcXJb+FleAWyGNJxqnIMx41+3geje6MHjlF6Ia0xFsng3tjAsoUkuWmuNESbNTAZtznyOyCAVt40eHHNwkF34DHMyCsACkALTORdbeFA5s3G3ZSzpfB+bkSt8mhuSyhAdvaSXJBUbTWUF8Sk3UqtbySNfzB63ICTCkcBykt6bVhJPR3g1644ZDJZSc6OF4uvlzp3P7saKhazmegYVbNoHDqy+0SLVkchOxr+GjhAKcp8mRLCijbHLFhuVA5Ww3e7Ekw59cvWBh5lueHcHLFKiRBhOyNXT7C0gDJxr1vk39ZhhSCh3ZrXyueWp7AKMA7C4sTZWuYKxb9fQle18V1WLg3yokp+ATDT8OmCVksOzUPeJaiE8PQYhekmRlyBRqUICKuWvqo/FYCuZwy5hH+Hdt2ofVF8Uz9mKcXayRfxxt6n/LsCgYXshi7LdlYr7njOo0EcYSizpGE4VVxL3oialFgyiENG5ahwpTcgy6OxicP+E+vzU0N6gxexytAQqaOVv05StbvDEqi5kzZE37w6mj6i0vPQXNnJSo1rs8+rwcTTOUaLdI4yYh9v6/smyKokCjFTB9bQ4lYnK6fukgtTYBGxfrSybsxjDVQOCPN0931WJKGA2HospCT6duD4MG/LMs/L9AxVV2EjhHiRyXEbjU/kIbImMIW00l/Gm+EBEPldybsRwWCw=
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