iNIAdhfSaiPY9rkjbtj70RhewvJIGxL5dVMWETk7vyDejz4dJaST9qiJ09Q8uaSU9/sknrelYs0b7wkazQdSoi6/kIeic6E8LJsDlUDPHASOApvruv3sI9PIv3g23UAHSuJre5FUa0qIebCjr+MZAvMkms039axcBUxi/tA4ANXO3BUIRlJ7E0Ukv7GbrcIpj5XMAqk8aVE4G6ePWYSCzygEukB74M0+zrUnxpgfJYJQ99SFUjmwWC2oVUkCYfI5l2y2m9I4kC7vHBmreUlT27A5ex5ItgeD/TmjsX4YgI3kMbCbohG+53ZYIV+lCxW0diqVuF5CdCYCA9p0XJhftbCfVBHjK1Z+yx7OH1nHAzuj++xEuMlAc32FV+8qrXUlzwt9nLrr7asoneq/23DUSjZH8kJFGhUYtfUNfa4wvVEx1M6pB1QqubfO+Ha0N4iGqdGqbgTT44E99VdD13lODFiGGdp7hck00pYPfpJxWEsYU4sccs91chtePzJYIeHNlpHxJStIZJqIih1+LfOAOLwfsOou6zwGmlsdUQ+jMrf14T3dTploCAt8nDN8N3QzbVYkjuTasGImw/8yynuDmuRIYVPRPKxAUueVbsDxJ5aMqM0wzsK/RhLFwQ8AH8o7vpjzFOmrNx41rPYsh5cr/Xvii1RJyo8PqJLoNGu+Ln+8T2bPoApVjU50eGA/Wi3Uv7ABHth9gowd7XCGWTOVpMYHwcCih0YcQAvGyPZO7btM9qE/yPV6LvCoi4eR8bZ03MLhy6Yw2Jz+5dXhp8RC+kYu5SqJCAHiCmZUKLYBh7pU4zAuUO4Dmc4hiDwyLX+P2BlitlKbYO+RIjzxSUYvKi0rcGgCGFBs2Mu3zJvcT3u5NJrhz8bK9Zy2LcFL5qKjY73ZPdKfIvMmz6ME6IkDrvDoGneq8UFk4SganHaQ+VdgPOHDqgqFIEpBhg25TIKOjuiLzzXTQDdk+tDjrkaqih7ywevdeBTfBrlr7i1yRRFiTzrFiPdingY/OVHu5lA6Ng0tYWo/JShV6VzLs94EgSPD9KJteY7+PRAmT9Os9YYdxixmXfzpuPlvCUNLXigw50XOv6iQM2DmTirga8tIjoP0m0hjUva1VEWO/KKEQMZlT646xARuDdyMi/PoeS0Xsv2aRyYoGybQA2uXc7dN3SqSd3qicEVYQgD/pLswPXkA6cj8MhXkOLqBgPs+m85A9aqXjH5gUFeOz+aprCn6PjVpmuK/tgMgeWqj6sInjBZtsTswBOvsUrFcJD/bLqtXBGTxbiXxpXMiyPJniGSXWfOLshVNxWnrwbXnSyKiWWBelIsnRDE0HYMCJa3HVSqsTFG1XpfXFjtvB66frcAcJpwr8cEp/cG6dZ3ttBY=
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