H2vcUg+PTNCgTw63Z2WJMlLPrJKg1zkbJnCuuB9JHeKgnBqZWw7guRlcoeFexQQodpOvjnxMDb/KAmhmiM/NUHgZpCxm/w5ZWxwzZMH2I4xo8ky4R7qT7121uZzNwStgHB3SO0bHa94OXeoxHoSnC02rCiegvQjuIQz4qRu8rrPeEZVXxihNjAhUKBtB8a6lANG89lYn4Samq9xBJCouxsnU5IRIU0tjDsJVTaybqayze8H9SqmdI9za+mCO5TghNB0lTISLF/bC6ckHxlyS+QhWuhFTquRciEOX77rrWhRhDoOSanl+Boifx7n+l3x+zMKi9W7lsu1lE6f3PcWAT/P+oSdLp82+2HMjtThpuf0AqEFlZE1Zj08u7nO+eIvTCP5dLiA1pcNQcwP/X8qPWVajBLm36fkoS5Mh7Frs3FHlLjGxqKQdyPL/OzjRUHRKhL2gXNk/xwtRQ8Qys3OMjCR4LsD2HevWnbCAOtdl6wMb7c9ivq5iXnQ6AUXb4DoUENA0ZFgyMOvARP0CtCMUKgBAgzbr8Cd6Fkbs0dEFv1YGg8bykyAfiDf1+BoIrIUXeLZInYOhQkmgvCSUhRg82bORMwmki3qcbtLfPrCTb4ItzFab1cSXmy7JJAAuFUEe0ujqzryAssrCbos5vaHTFKi/RxfstfkUKGnTMiLFzjIuiPN0yRpv7JpDk4XCoQWrHxwRqm3EmATeppT7AOVz9o783OcX7c5YTiY2HpPXnLfC4NGjj+yc6NUO3XtV5DctfhJ7qKyTwg3xnyzmfqRdzfhzyHwlMHKI+d0kb71Q8eIwEOPa47+phJXJqBbDOU4wmb3D/M5nDMzSE63hwhWOH9sxuPobPWVykAtFRXrNVaVToKSZHJfyUtELdxEWKk424E79vj3RmxIoQ+r6Zuhmp0NrOK1SDQRSw3xPI8OPAQ6PlTcAwCzN++MFaFHJ3YJVZpgV2QuiJ6WlVR0f7DSb3evI2PE9mR0BcDnqrivq0o4SgDax7lw0/jQkyw5ArCYAK4mK9iD/fXfsYbUi683d4QTdlCaNmqfiG7m1SVa3BoAxUqKwU+sD9mXfrLSYyX9yDBDQyLEyMywycnMgr0rwcBCZuoF8tLv+F1bnNbv6c7PGNamyaOw5ufTvVVgxyHQEFT+wdCJgEdQexhRWr1lEpiBOCir++LkSqnQSXXfGeIhnL7sfp2ovFKcqxfUsUSguDZgqo85yy1+oJTniaA5YNxS46B464Ld8oKHVaXY918CvhryjkPamjyMJTrLkRqxBFdCkTaeHjFVIJ8C0VHAb5fOZbqU/IxHC6ku2Ru1NKpv7OMrO3SVlrM2FYTUfXSYrZ/awIlG8tIb71yrQOTxwUWMdts2sFGOPDk20DMU=
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