0uZ7l82H1m21OXkRj7oTHfHJIK4RywtI2tzjvyNbDex6IR+iKOicvxUn+Sip/NorVv0ifJZPoM/pvusaqAjt95tsa2KbbHf31gG3hDoYlKwF3fV6G7xZAgu/0uzfAXBv4yb0rcJho4JKkUhVd7OPjOtRA2z+T4jAb/8w2kUx9bp/s2wf6pMx4CQ8eMeFUNgz6NWBTIJdlWudObqiLhlhe8tKW72cg5tlHnJphYqrRcU0VO7cRo3993ug3l3fB639w7EVHW82Lkr3+0+o1l9FJQTTR2Qc4t6gSnhd9iqpdMW0lfrCmGyy9DjypE1ddxq+DFdUhQO8KZBmSnNFouvtMqgL/NTaNT/boe9r/CBAWoCQIInE+It4jhKpu62CfYCL0bqHoURbTQhVyFVqBUgSxq1q5TKAUKw48Yg5ujaQfEjh5ZXOGgKDrRktuI3qMc7igF7ZRs+uUVH6Nzkf8lhAI9aVt7MxgUl92CSde92tB1xkICPmgBm59FtmdFr9NHL61fJfYzgsaomJInxmGB0B0LXprTI27bZ7Cfer/jzX0bJdhXRZQ3hNSe2nB6ydQvlx3XifdO44ujXGIcK5N9+k16s3PIMrJUzfatsNHjGMVfeb3ctseICK2+X/RjSkFWy6cywQRr1mDqI4239AvNhXMcHWz2aVbC51ruFzIy34du0zym2GfsgCt4TZH4CBya+IcqQPBPbe0C8HWElfDGO88ezZwSU59zoXqDPYxrgmiKmrs2JFmX8nMLJeeYuaO99VLI46W4AWbzD9h1bwAy1qLEatyz1TVRitD67TqlHupKykmLjTqJJ1NKyTVhQvhDw6/ir9tNUy9Ntl3JbEOaWcaYnBtIekh7Z8SibvKkrEmnLW39Uff1t1zChaM6qU3ikmSzHEp+4BuNZvz48VpEoqGwBiwS4dsN2N+Y1h7Sh/34AWiAu5yanbkEXocO+9v1uqSeQ8Ll5MjSqoVFo3w3Enp62UGJbUmQbLAv3WwyFJY3JlgVE2QVm9Ctx8MzAWTFbrP/CgZkI0dTqBAD1ZbEdbhxqvZXSfa/g33vy9pDn13fJUoabAVA3VBkQ3vTBk+nmComLt5TGDhDEsFy7Sui1DT4ZRO5FqK0bCZSnk4BK5cDFVvXykPkLr7Pqd2ekFOoWwTn7ihvppminxwTgLQyfmiHQFpZhaqLZqMnJ2VRvyx89HOtq9YVOyB/MvEgVHkvDL7xIA8/13GJDcP1rQxjSXKwODQB3CaiuhiMBq4vxo9sarCwlbtDbf1OG+YV7j5LpuATkZzdFAVEUnlxA3K+UZq+B3QLuusCrvW7dfALDCoqMu3XABQm6PHMDhsbMDQxPI5GeQqVsUH4vQ6sPL6s0CJdTlgSPwdxEkxfkX9lI=
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