bZIONyhR6j3HxtO33Xa0sM7CrKeRfXu1VqeY/AznuRWc/EkRdMy5mrtMWYw+t3IdMN1SlxfXZbYhtkxlfAfTJeunpCQJE46Z69BE3h0OP6R8XPgAlfdpKgqyyvSteNW1VWSIVSrjA9eMvSfJ/OYFLsYt1IUYRkQjT3ez26og2wv7CMfcCNO3ER43gC2WvoY4iniNRlGNAth6+j8s7KHpqBhfYzVxEvkryNAkYFgJEZ/Lqubpjr5eeQh0q50Z1eAQIeY00r72iAjyJu1sTk7joANCr/UVsy/Hcga7GqWAIQrS2DXqrMYNp8x6WxJESJIzZxl2XcUKgkV0UBOsRO1yRohaRO3mB2msEh7zOan/QOTzUXzEzW4C4nO8xQIQKgzEABQuUDAF3ygeY3gnMeE+skNIqzMJ6Ff2diguf52BRz78bncyudYNxU9CBm51VDMJidp3W2NkR1Vh6kYOvkkuOppWdqAw5YPbINLX/3TBn0HNBKtDBEhoFSullXfJzNBOMr0/Ul7kPFspRdvMRqXZGpxSy61X8rRcg0/tCqRo/g8OJ/zRsICPpghPZCNcPSoOgbYDSoo58qhwIpSgd8lu2LGt4YVi5ZR2CA0PwgawPD8U9xy8nU/Ar/ldRGw6Rl2JWNnI9JGOkaA4yGFzV70tIN5W3uzLxKVt6t+9ifp1s2NofgHBUH1Jg1BARF+wCud0Bpj0p0yeDs8uYapQcRS3M7yxR8VLXXAVrKjmscNbbSEIAhxLxEpwVUE+Ru1H9SjfP3L+jIoRD8Gq5vfnVNgAM45MgnGan+ax9mLp/64qbN5a6IbN/5oP0XnUvn/X8T27tOtMqzCRqr67CxTtok6aYzPkM0Ctsht+ww65/tVcUMzSAZMjkHTx8cI355t6W/mvsy5dy8Y7BHYcqaCCEICfEp7ST5XlAO3OjcS9EsTJ5SL+zFSwDVvKmEc9/Ga0ZOkFlddUv8WqaG5V9VVEf7BG/pZuSyW5hDo4bakQWEqe+g1KuwdexSOnkm79xhtegYmCdND6kjBi8MOAvdlEzlOT/T4BSugkWPnUlocwbwCOdrY4zTu9JoF6OwdZe6GrP7OCqh5qutwyqWdLFyy2zEXViF4Xl5gvUNbcP54QyeJrRElqIe8ydPVl80tyPRUCoSemP1oQdVU45ekQB0tKKilOvzbcTqVhQUKxv6cHqAE3ZULkyUbS6pMhQaENN3XXo3tW5jp871xFslFeNDSRUhRDDvcSCO2YxDcAuX7u1UfNPAElwGgM/LqoVmoUfeqMPFKGLuk6YavGLaPRs0kqYlLXZS5YNKrWtyXc86gxjNSSzPA2sLfjpWD0dsjxr9lVyLB/rMPBuFV2bDhNh4IvXQ/umhewlViA8rA3NJGtUJA=
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