yio/Zy1y1AoKXsQ819wlf1QFm5gLSF9/ixYtgbYVJl1W4rgFN7rkeyDh+eHgbHZuUcd/q/c+ZxJX669D5aEFBGjW2YcPs2UUAtw3TTIkJjo9fQOrV42VeJP4MMCTtjQnDuTBHZBVcKYOW1Nc8671AyqgbnUDzfi3ozdRDiTvawfmxzb8kpLXjU5a1nJO7mBZpds/7gcjuq3Y9vS5fP4ixA1iC8djryjzaJ1Et6hb1dhmw5/GLtZrXUm9wCQ3IoWpniwGwhaaZIF3gAjGyhXz5j93GKXWNQSJdqV+v6otB95pbqRxZAUIihIpNDOkaAQj0LXhr9d6FMus/iZ4SW7u8O18cccpd3drGAUQCxx9zwtlm4xqtJYQnow6PjmiqoASwcnWhwFn6FdFjijxBMMqbmlhAYqvvsnTxX+PIUPuCQTXm4MkHkcdmJ+q6bWHT5G/ZccFeDMB4LVi1FcOqIrXv+yTzsom2w3GMhXrEfi8wx9ijKqD/Uxy30C1TZ5soPRfOO3VMaqNgZpW/Mo0Rn9pNnFk2lo4NKnJ0YU+NpxgvvFlW2KyfoBHPLasMnx+KOVSyVeUWcaTpGLwXJcddTsBWlimtXq0IOuH5LWPVykuf7M4+HOKpLW6YZsvUyaHCMoxas4nRkD4A0Q113LuzGvwaLRJWYo8w/ig+aYj3wJc61nd6alUZeNfl5NTio4Scj5xtdQYw04Ihqj4BhBPlzBRhdXechgHNFncBrYxfN34u1zyrkbfwz1VHeNLCO0f9G+qCvo8hUc/a+La5r2X1atbF6Blr8uKjAn8nrhqqhqoKq9v4O6+7NryEu2t3mTBWrAlx390IPUr5se7951OQlcBmiN1dBbe4c6m6eFbH0Tlqk8GZEJCh1htYQ4H3SqREeXi+N0omw4M8uiXiD2mNJftW516uMG13jqNSXMnT09aQPYOFvtAWYUViaFhdoO8SRgH/em9N6QsriiUvvgBuP0rgryUCGa5dGb5VteHga6XIhvaX/ypz28HOKqqwevqCitVbGbR+4PYwvFjlp3RUY7QmhXRxR9U+vbf+P1YkN7/s8RXV89dBnPz9CHDbBALkbOaUAymihxMqab6+2WCBEQ65DmweYBm6ZxRW0iCpAV1BscMgvArnGgbnCeH+P6JsQ6AneqPxtVB+6pnqmpL9AEZLrSRKWT3RthY3YfSnLZGl50aCjD8adSqD23RYqGDr2Mw0fRB6oM1ZXXp1ZfcpnHCrWWnx4vvS3Ho0EqiCBD8YYxyQ+ufdMyNdsX3gFAODMfuYPXOP/O+KCXVvLtKksq1Qy6Bh/mwLhahJhgSxe5JxIHpO9qAZ3qQA1YO258tUbuNhpHBTOFE8FNanLmGXJ4l52R7nmP3M9c0e4KXtrE=
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