uLp9g7R4jNzJeiNyG0vHlijtsrei/MNXyw1AGHOwC7GwiGB59sd1zYESmjZptd3hB2fF4/3PGQMoBKHwug1RHbH+QA7EaNSsBuMmKI2avZawutxvOaadhu79/W9SudmLe896AlTkdVXah57kvXj8hKawg/mzFGxVWIdHln6/Qne+bffA8vPynyIFvo3BFp1QemLwC3yFWCD4yy7ac9SahmoMSpBfjWAJRRNqHB06v+AbPQfhjk1U5+S5myRo9tOORTS3gO9zer8gg3+NHKWyg8jTsjLk9uzR7JKoVoUwd3qpH8xyHJEDvQxdb00hx/7Flis+2JxnbRtkTIri/hwnY7nJNcgpy4Ma9UOCFnKLIVdRzl+2CLmBPzmYuSIYKOC5S6D2DZ7CMmbZp6he09fN+WY6z2gs95KISR2rBuCoFcul6OwpqsO1qyTikEkcRjHUYFLGV0kJxhEHBHTDBGUl38LvcHher7yXiq874ugxBstHMY1Ei9PZDz92/IWo7yo38qlwKUQ9lLkq6dG002H8E9lrP1on0u8Zdv/rz7L1BRcJRylz78sUz/IXc0nTD4HuZsmRSIvcqLVwwVgbiW/qJjaIPnQSGK8AkK47gLeR1YRzW2uxgPBw+Y9PWXht3cH/Lp9KXaGWvqbc+S5tef+FUR/WkI0OK9lt+SB5AXt6NuYeI4CUWPgOBIz413BeXrtIGruDrcDLfo+H1qd8eqJ+TAQeDj+VBdgQt5nheHymGIE7HxIxJzNm/r1VRCTFqxk9vJt1MCJKXMCKrV90TireIJXAPC/eyz8q/suhVR2ujw7bRDXw2xUoPxyqRZx+s3yZCVV6NeowAS93JaVcqiK61oVjGvU1/nlBchmapwtl3W1bdTAPJu9fre4JSfLvaObZLuiP9OFpcXO2LLao4b/667/xq95SAgNNYgZiU2NNTmNcJ8DG9tRIIokIP/wRanvKgWCGu2ccSkjoRdY+02Y+i3jOr7U8HBtg7U4z7XI60Lmys2JY6I4fPKUaAqup01qyIiokBEea9NpzqARoFFDGjPV0498dskX8/uS/4w9bn6XkO4NYjIipan1Yh6v6WKAv52aeeEINryLBvg3YRv2XuM2DFtvm6ES0YgxjEK/VzJs4TTR5R7D9ck2WwD+HLlv5PbKxiYy2IDTICQl0rDZcngOEtcD08azGWVzGvIftkcmVBiniGLg4mQX9bqewQWCO8Z59yNUP0CGdc9De6g064JLxcnFi8nogOHwxSjPCJYjErvfuMBtkv8NuKa5m4JqFLubJPl6AmK1egCXbJRYdAiKR6cZYx0eHA6vCuTXZNGKpOpASwfd9nO9pA4M20T4xjUNZcgkSkkGOua1JHjYb7Kx1rrWjkzEgRal05XQ=
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