U0zUz+E86Duh8Rl5TqNk37KyWLLH5ApX01ZN3TLENII98+xEHmgJIqFc9sp1/a3t3bD5dIIDeKTzJDs2feK4cNxeCphWH1ZAwRc99PYlTqc5BvPz8fqzkoN3VwWjn7eH6FgsBjxNGC9vQPWmgylqz1onqhXbT5Z0TxaDQNbWQXoOAv8RrEtYc8Ag1agmMH4rXPb5ytdFVFPoFuzgXab3FdEMuicliRFHR/A0ytHleIc85Yko2inwm6KpFM9DAxNUD9GRA0b6CNISobmq1BB4uhlo2owhfwZ2Nok5tFCXwlau8s482PG35mSmjd9pEB2U6iOCe5h8XITMmZ4Ib+s0rPH7VrTyD29Tl4H+wrunfGvUDGa0E93uUCVo4b8iog4431oI/RNjMcG8au14T0MUEaE3hV3yvjDL0sT7KuxV/YjiYYjgaCovoxbsL4/OsI3mX7ZLUWrWxv4MGENkdoq7OgkMvk7KiKhRt3q6ehw/2WV+LutQUhwED469UW5xkdR5i5glm7PDtecUdaG4wnT3eduiV4cJJawXZhTPeXzsIz+ftbu9Ru0RAOwO+oJEwALsWNeb536McgLrOmHTUMZSbUJc5caenis8Y05I7/+I+tF1V9DJGCxZxLgOIfFBHadlV7y0XleGbdz0n34VNGKO2pjEZYDPEVmtoaJdcuw7XLsrq7wZ3LBKGtiYSuJRxtZiy0eY3lT5uD3+7b1PIGbx7OzF3Pxll+wxdFPDguUSC5HAsidEy6y1GRBBwF6Ji5vAxYIBjFJdZuSE42E6wKpp8hUiSbfW22lLIpmqNRZCArP8Fqh/e0I7OZDY/yEGuKShYfVZ2oDOIP71D1T5yFCTVcq16ZB2ObWX4QWp9ooBxOxGKtVx6sKwtsSqZvQupVlwqm00Szz8ewv8awVrPIIwdCfgtn/0CtJa29h+jK9WAJO4fNrn/NihQKf7EX3EUZ1HpTTgzU+kO463sBVq8M1qW+OupbX3WCSJ6cK7WKZWrSvuSv0ZxfRQuxwzkNeGz+z1dD9e3zu16SfvKJaNnNtIzADuXlIT89dOAnw6ZMXkHHAmP4WSye4l4E10CHF4pshU+yaUJaLjz1HT9/0ONN7umcJsngapHqcp/EqB8BIlpqVJRRf29OnSlAVSB6e/Kh1GcVR+8vN417NwzjSGgDvoC0luwg6fJMz5CA4qXnB6aniskAeIxVVvp5neUEYBXo9a46EwMIJv1qkygLX4nBJpfzrxd/cBMtBqJI5AT+lg95K1+WjPwl+mRVJjOvggo9rD/1Arnao0Bh8Y8EgTCtpz7XYQTmAWbx3xIl4qcd4qjmexGm8QPdF1b/0QqZVFj6nNX1KjDAVACxPE9VSdrJ4btnBYnPmBGg4jPmfieCU=
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