NVcAKK/DvJMfa7WYkETMZGnHdyJKX+5470WIHCB6kCEqjirtbk71ZwYwe73j+wvZZTsAdPt5FBs75OE/fNQu7DEgfKicYe7fYtQhoQJaqoflpFEOtGEgHpn1L2TIHNHajjQXn8LlZvSpLQmkK5dULRyL2yi7I/jCRHxjGstyioqqRNvhiAeJNL86blYdM9Hnf4FMbhVA80vdhfZHaoU84VcNvf+LQzngSi3RCxnoiNMMPfTtQwVkQ/ywoPjDZClthvROd6jgMDPjOCMd+ie1bfDZScQgETX7Z50NNsQ19I20G1aegKOn4+BxWJ8mOAtzJbr2t0KDbi9/hptGltM3ivsr6RTHL/AeQsiRsHZ/JWnX002/oCSbc6Dxmo1IeBT7gye+27Q0eaMk04TtOOR3ltvXXwYmmZqK2HLeFwzym0yPhvYyRghzkJ+pvrS3Lm6fy3khFIXJykyLEVKnvQuVXuYt25wWKYALazcH5A3w4b/WEGTUv1Ewoqb9vuZuGar7HiK3A9A2GI9UBdcruqj5bUky/4nI0PlbxOwKuhOH9Lv/STW+Hs9J6MBHuG6Q36GsyzFwft80gd6oiQr6OVVRXrzYPhW0udo7vVKIfiIn+6swUufjFjhbFv6EmUY4q8Mllu91DHLLONIHUikq7ZnTY4+AQyYQGv4cx+3nzWCWsf/Dgj/Lk3Tr2yFi/hqbUTvXXk1ev3s+puAh0ULJkYSRHqEvuIY53N/9Z/5Z6VKsSWlkDd6aKQr44QPQUxTPBv3Iq8ZAYZwOjGsvDVuq1ow5jNjt2vUzvj/xVg9ZHHKrTh6e5oifXLnqzyPVACtNsfe3FHS8814sx8So17bU6hFfNm1JrHrytGMSCIjKfYt8HK43EZ++2psKPpsItxwCy0OnwT132IPZmp27ICeGTwHj5Gl7p8Q6hVof74l5E6j6lPrUB90SV7CmOA8lyLLaOQs8kXNkDFXWP7pDVN1fghpAUdTiTnmbLEba1ylsYkhxDsnoxcUJ/aaHGw78sKRC7B+PBtC/GUnT6lzbKzrpV3Nm7PGNuFYA5mFDN2UD6vxQhw5y3d9y5/qOALnjbQr0TNR2Cr8yGM4TjPrQNA79fH8WEI44XOgS1I11o8QVyLwADJswv+Y2Wu0Qygu92s4+HuZ8iOFz2YNHx5OOu/WnxVF/LxrSCBuB3KV++fN0VRdFwbm8RiindXHfSayORJUAoQpacKMwr2AuDtQ0wBdeTvTIkZvREHPXPVDdFm8lOs7w3/w4KH8dj6wy8SRB1RrSVp6bzlew/peXP41LdHuSz/M2jciU71AbWyJahP5qcUUvtSqSO2ydAvrMaX+hJubciG9OEdiJ2jJToGkW23cvoeK5LcIDb0f/6/gYX29oG2A=
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