dmFipz4hBCEPI3O7CRzyEthNFZEwmPMtmI0u9Ip/BPSOpmTI7I+CdIpkB0yAjvsEiRTx44OkyAaenvPxf6/fJAk7qIRF8Hjpb8Ht/chAyA4JH/68xjz/0hweOb0bRhMqXusMiWIxmTI1vm8lwK7wpsKfnuAhgveWb6GxYnn6GPD3r5VDJwoqLNYuG1YwQGcipQUsJ4C6qQRPRFtb+w8NOqqewgkpMAzJ8MDnZxTK941A4s7hcON4nwZd9MaXCifhNC/csrbanZEBZOez/vN9YuNW7JBOyhvngmMlH3plZBFS/D9pdGqyfWF1uYQPjpfvODAbgsjf6FpNVGOYvF9+PvqhwKIbtUDgAbM8WyxhsbR681orJ4gTYUgJsE1gGqe/tCj/UkV229m56NW91QjTP4AUSj3jeZiyL+eeyy2sCRy92BfQDPCgDm7zycUdqMjxEchqhZXGKFzmHw9QVc/rIFQdCQr2fFosiXrBld3JWbtNdWNaD8ybh9ftQxq3nJ/Oe26pVAMubWzCykMn10bfuSFXljiFPrVqwzpt17L+KtsX15z//0D8C6hBwbbpz5wmEkZkH7XHGV7Ag7k3QQWoO2IwTHBZSFSE8wbh8c8MtzY1EaTr1vS7JOJ2/l+tqc+QKdi1hlIAxUUYEkdxwvJqAYRQpK43WDlbQt5HyqXlczDrc3t6HwYsXWYIADMw1s4xNqb2aHmXtkaCgH8TYl7aOKtcXNwjsE43V674jdaaJZO+QIdkZyOBFs4I06MMwKM/RmrtR2Z7EtNuyN2zIcQ2kIGBeOB3W7vpgKGwPsKEFLgI71tcraikg0ezq2JKxgg67Qx2h3Js9W+QAD6TuL2FODMxeL67N6B2ke1MfbZ3Xa+deHMFGThfL1cBjRLC1y3OnlXu+FcnU1H4+JFItat45dlp3BlFFLJz4vXo28CErRIENxj3Se4+6EpKjk+hSsEqweUzQWcITeBML/kYe/6aPKzi6FO0jEeah0j+NNrRZ1k2/LnqE5xRpxVI/JV7gVbMilAg0UZ9qn9dMYlHVRP/GYTQX45jCPHDrMcgR1LdeZtQM/Gd5xLkUoe3ITe2f8jXJktiCS+pA8YjIL1n6W8KOS7vNqlRfCqz2XhSKlqlDzHPYeHCPBplcyeJugZ5wabynYMaN3gsWnfX9kYDLYrT1ZtcoS1O82KB+A6xrGQaI+hxdQ/UDHmW4QOtfKdlHgbyYCc0W2G1W6JdbufAYrHlJPDrfALlRDJLt24/sa1ikeJ00oyYQD9JyVoKL0fEGw4M8BarUpjn/e6a5rju6crrQjrba2q5PIbV94I2BRQxI8SO0+osmRqaou8RQpFjD4Yr6mzvJWLanX9rvo2ZqOFL1mkUv84Hy8tL5icaNnw=
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