DaRkkhBPCOr1ZHmjxI/PXHuIPuuxhYWI+kAmPI6oAuK7md0jG4Sl0Drv3T/sK+6jM0e2MPv0VpX0NSLQ5kI8SI3xgjEdVYbgdGoWKtEcn1YOcOtxKz0InabtyMJnA7JHMFAw/fdZajGl+hNoDofvpxz0kcX/F59kRN1E+MiYL/93K5xHSIEAHLKyXgsuBowi16Q4CvbWg+x6IZKTLU8UDuhTuMniRan3DkA6eutJgA/hpe+jHRfrBGlcQY1j8LpJux+cmy/566nAuu36W3YIP9KATu2EHpKMabcersqR69l22w6lPjR7LkWHh/uBf5KxytBEMLh4pwSeOnAYNSWIUy6sXfbYTpHEWb6p3MwmB3HeBFI81xYYhQ6XYxOwm9ZyukMxaBFmiKwLkEt/5xMmyUhVrj9sDdEpBU/FTAp4V3S+PIHZImP9CxmWIKyFgfBfZQ0rEoFwohlUUvSgUycVxL2I0otzmYixWs8l7YZAbK0C3u4s+0YaJeXOG/GW3twJUXfo8JhX02LCjKd15c4drA/RXI6zsPRoqLD0/NfXqnrkrM3dQBCwj0SxpwYXPVJ1ZYQffvizzxAYBcOxW3ARJ9YWBrLNQ2ST9ZibnR/xcPwjfXyZ3/ojoNQxOPOGJmfvoj1NAestCA0LSr270Jc2z35pDteQCKQAK/SwpbwbuxmEBrP9a8Pt3W++afrYD6s0iWAyQboMuoNUkoDcwSqOezuVnkKLnIox9ivjIhyyMVuC8zYn0cX0eKjw1+qRZ0G67XCYIB6Nf5i43MFz7C16/Za/hbX/U27kLz4zXtvFIEftsUbLbVIXF335lb9I+xGQRo3EW+RYXHRZRlz7z8QKJCRBbzGVlerasN+22HIgKHvFOPtD0FJRgPAkD/sKro6uV6D/nFCE3hwgMCIBZAa1MIpGVESTOGZVroVNDGjPKDJQqvxwuf+1j2RPMleRFTP/BVKqX5/DUknGKLDVR8wmA9ytGPlaed5AZJ1EyVSQWl7sX/+bJFff5kiEU6soKGxm/I0xPu5dTubD27ldSOfUlr4ztIM9tz9ZldrDWPsTnIVylr/ogN6ZY+25o0dX1t78zhiF1fcImjIWSHHxL83K5GJGvAXE/bSsmoaMBqpl0pIIbEpOx3cKjaak1PgyqH1dIlG8RxsAySfdDtucCx0SF501UZQuxm8nzTtd7rzM+tpQBX1cVSAWadszq3aB6t24IJVkHL9ljbucJLav3xJ7jfEHW0DMJp1LkG3NsQb3z/594RkYgsHuOpNNwL/ptE4j4PSVyZlI3wiXqFI3r9TGEbGaW9pb4DT0e0hlFaG0YaZMVJ80Dw9wtFUus3bGFpjUqbQbwuDIsEfIPCUNMS08C4FznuLLyzWcY+3NazE=
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