r/JExvflrocpT1iuZHkl/fek4j7ysYxisx+RizW3TVJYKVOoJJlY8kcXnpoc16QYIqLbDJMLMZudmEPNRct136mTZHksGQA0vLC65ie7RqYZTMS/mVmU7r9dladkXTvPl748oMsJMGWJ2z3bFPiCXqVrcKJI+hv/ZAG5wCFQimRztnBj/HzZTBBWgLWS5oAN5/gs9LVY9PHgco0Itl7HxvYuwCI0P6I66YmTLiZHLTfeDjh0MY9YlCsuCWr1KnP52g6PL+gjdBvmOLQ3OFEWMnS5hJJBAinv4SrUVrk7pHkTtDw22tJ67qgCImdkSYVawQhqAsyJT3cRnymmFEpjSBJRIvbE1e37yAddGs800Y5PQ261EQYmfp9cS2awxcL6Fxw9cSeR88jfzrxy5Kh4gt6zH7E8QONm2svZhF8GqYtAyD/GpX31mjzvGi9gf/hiAkOa82Saoryp9Kd0dtFMOksqfrUX7nD5UpElFTLvQz7NtYBhKwU7ulh6CyGEDTd1de9xRIuIYwQi1MlXn58xSFLuxqT9T+8iVSB/eiofYoG+duMM7ikJwfWQNmfN8leFcwVvHL/SAoYTKZs5RDohXPZJOJ6SoyLK2xqVSSZsiPwzAs3b72mcK/R8rhV5GVFwZ0QGHIDC7S30E7Jf8ZT2iahhqLa8sscS6U2wNVvLSmEgF5ltQjn5XKv0rI9GrX41nvz0sRdehT3hHDgLSxj7k9zEIYRaK4dlVBME1FA3TiB4zuSG9sRtBVX0+s0srs7VuOGloK1d5b4E9pF767Lkj7ZH3008vGMPQTKpAtjxB4kRCYfP3lbdw5KRqNCBXB0YHniccec4yRHoEj1ehK9djzZglyNm82htJNO29C7Kpsk8phYiZvCO6SEAvCh5yhpPYMEb24WAEoZj+xYTY/mZBRNRauzf2cb3jBCh6Y/Kqfag+ucOUKaFFnlV03cdG4oMy66C+nrtRngpSnBq7QuCTyG8iJfA3aqtXWuO2Z1qUaJGY/kJNHJCALylTm7cHGlLCLYlitKmXU+s7mlRRxHiHFZlGLSyGNeSAud36Eho3Pt1y0pExMw33IYaLj+gygyj/bbOI5Qb4raPyCtkrW+p5tfeQkarXblm9PWlZ15RRHZeGROKmF450rok3/RZkznJwb/xngpLE8KLsfM2+FXMFaWYN7amObwAHV9Sa/PitJ/OmI+eCrk/H9HxYfSHTXad3gZhbCNQcl9lebV5jHE3B75eGSV8dor92fxxCWE3VYlZUo996V51ROBQ2oYmk7tWfypG5t68E4eUvOZQaJPanXZcfLRFXpxV606ilQpaUPdEqftiJdeGuC8gRjUXl6zaVaN0QYIwz7Vd9sAnq7XwgyUELBme8fRi7hZkL8U=
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