OxrnSJ8LM9vHIw4j+0TH92itcuiNwSgehboHKVyRGowuy+CzWlWdKMPFmkH7hmEMQATljdhtcgXgiwOYJ2l7d7n2Ih9V9qopGcggWN2sjOgvOm/dk5yMf7bX3HLkKCkqNEG0gmNPf9vbyL1tAvAH8HN43xDdPRAI6bOwUybyag266gIhoQM5pDUeDPnocWNnOE6YBBbTrcSlyrnVc77TJqQR4QK4VvFYnhLu0ygbwD+5ifco6e036xRoS2Z91v0qNrVpt7n6oS7jhMaqxCcJidiSqqqtHfI6oRLLYKFN+mWUrYFzlb6HXKtgK4hki3r02Aco47EWhylMAjkA+CfUQR8zFrdgOepLHoO1K7l5ntdiMHS4Jc4lZltIhCizEch8nxscV+5k4gv+ZWbrYRWIa3VfrYa1uanACc0oozmVJktCB/2yftD4KzV9Ul8pgR2shSAh0WkmyK7YkF1ERge/oB+pVyBQe4z+1QcpIE0LPI2UQ5RobLiphlE85s9CuLmlCDBSTx1twRPJBeGGc/RmRQf9V8Ma/Sxa/8V9Zfl/7AhF18f0KXGGDiYVE7xq2EcnCIxhhv3eUuM+sLLTHWzLtEEU/M+fXydFYaxexbhMxhyuJ+WGDrs6ynvDkHxKXhrgbWfn0ZhspSHbrUB2S/G2BE9AUgfJDbqKqT9xspZDGWDQaRSKMUSKPool7oBbJqivvtAGIGJoUDUPlMzSp9lzXTbpEDAUKqcTAnKb2SMTBIc6GRiY+utbDmZJg3HfPOHJi8V5lGCGjKoG/YcNW4kvzj2j0/yeUOsxfr4VzLyCCr5rXnrVS0C2iAlOJd/9CqU9DAiQB5dhgjMangGLCFpXM1EiRP79ehgrLQdQ/1zv0Uz//Qxg0VwcgwbLC4gxPRUEohY7/B99A7hnby1JpEKhO25H9AI5VbJPMd4VP9oso71R97OCtX6jGqMyE3IvVaDXxWWdlo3g+huM30pAitLG+DdqxfkmTUf20Tb43Y8Hb7p8JlY0KWAjkFj5gHil94tlCntRwmf0qnNvJZvTLtdduG1Wyd7DSmueB7+3te2nAzlGukroCHqi5aZRtdw2lGId70lTUZaEg8VqIbpOkQjgv+L7aqX3ovz7UHcGgTY7oJDS5qK/ak9iwi9v6OhjTJIlqSCnDLmPviRvobP86h9mtuNE9mTkntxdLIvqrZqZ4MzQ6JmCt2LTkmQVoRxUeIJsiuyub5yKyprwUWaNUD+lyZvr5nperqbgobcMeq+41drgPzHjApMjHIXaYshg/x6iAEmHsNuYe7v02+beUMlja+v70JK9rAxApaO4LChE6wVgmI/I/5VFSGwV2BKwk4hbfeV7KAWH1O7P4w5Y94Zi2uffkwSfWS4DDPSnm7g=
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