ux8q32HyMq0kr+tmUAZlyGRwZ+zI/K9ije7Yy+LPoIEfaU7R6DVKtMtoVnR0LtJ1S4qi+Fw7DHY7tdhWptXq0CRAYQ/y19g6qSOh2rCHmkOoOOaRaOE3uCdvB8BWOTf6SRhSt7ZXBgG2omwgx9Rk5+Ac1IVF5LpU4wjz6NughO9e6cdRUu3IV0/KnyLdbZ6cYn3XowGZO8cJtPETBrSjxmXZ/XAagClKWUWTf6jZ7AYGflgRG0TOw4R/s69RCT5wQo8xXRPA7kCHtT3pS2vjI86JUVM75VFU+yn9rPO3tuTuYm3cx7SybOPg8YUSB6Lgqwu6EDBwWnuXOeMENms0tBrYm2Rlfmt0vrWqzDcCLuZRmY2JdugXbw/ZYslvfR6cqjizLUKJ0TKWknrjSMomXW2P75TUYc1HXH709e+ViADf7as2EggtRjppKFXJQPJEk6An0C4t8JOqsjnqLSfPAV4xPE1O42v/S9bbU5SkksDN4HlIC+4zFLqRe2sDR/Vp2sYXhfB+BxEnNy3ZZR0tw8CADrXE+vLMOliuCARdS3IdYKHSX6XxWa8QnNV/M3aKxwyPUnXcHLXC4FJNUezXMg9z/dmMoiN2NVwNFBvROUYYIa9BAFCoQvlJwPwAOWKgmASJhrB9fAssUeFnb4AJSwlhJP4FmWAFQO5cDJ1uAsQXsL5zn70ka35fJ71ZHjoVlViACdI9Bg3F3hARjcBFnXFgCoigu3HG3dLkQg9lCNzCE7qaxw1ey2beCRH7Q12kIJ+qUl4DvFR4+X87oGTV5uSAM5HgvKXwStueYmds5H/R6k3OJVBEI4JjASOv5tzc9UdUze2HN6EVom/HCkwqkHLKpE5QkCydkvF+WURD040VZjvoOwZpCO6bM+Bd+QmOIq6xDc0qOurzwdA8hKseX42qSLkF8c/hEW27p9Ojepk6+9TUdVtcWL93tsErrIRdldhqMamP2FB4lpuHFM0wnv68xsUOIdcLrg9hn3ffPyAy0QUtFlYH71V4lewEh5/OP1nRKKwHPxGCvOq5WMITm6rZqtpGkR3pilMXNNnzmtNmz4xvC0JnJl84MaOKUO0675qGSO5xGCVW6oiwdPrDp7eOcH2HrP9aijdocNFlZvyDQ4JW1JDqlgCsnwLIzqgi6DzydNtzvybMd+qCUj70g1RXiRWTU5l7lnyg7sjUa+I51oLdFgyRa/GWVv7v8bJJEHjRupPD9+B704YKD+risKQSj0OuRMI72tdILo+HbOT/T+397UdqYHBkuGWzBlMQl+ioR3q4QzGiEYqm6Qhx/q3GsWEqCPAGcKOcneFiXlWk4VTQG4oE6eeWcZLRhL/2IMQwj0Lfwc+yGEawK38W5EM20NLqzuGZSYO7SJY=
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