Leg5CFTe6dBDwfERSlBnnc+vlPMPRY7GG2pZw2ctu41kDRMyIe/SZ4qcGcCyNbwJS+P8jGPrakn0cexZeAhwuiWuUDn12R5E6FBFOu3zK7jUOryrgCS36logiqUnOXekXlrD3WvBdNMP1sm+5GH8vE4x5pDjdPLQPGz8e+do3r6s5mZbik19065+wAR3x7fz6ONocQ5RgN9FRbdV/H0PO8z78rG3uLgGG6JC42H/qDuZgB5p9rwuCLacGnzNGkMV1xUDsYMKGuHXtutn73J2mI4QB9okmMti8J7SmXYhxIsGUmJpCY3nrM98wuh3Z5Jte3Nl9dzW/gZ8JBg/+2uDKs4gMknaDOH0BcL9l6ehaqCiNUZbVqGceIEI1HgCxeJwt/uavJW8FKTQc4UdCzYJzEAwU5nTTb2VBqW7e5tBeKjnUqrzWWKgzFzPm3fsVbK/GIn1SGo9m+rY0nU3VM4QKKJ3PTzq5dpskQj0KntA3LmlJNX7NAsOf56vetVgW81hwxTwtZIrK2yDKiUZ/C0Wopvbf32ITn5O+/UHA1sw8vp7fWQlPRYZgRia8CxWssYrf2xBjb4Bu1W6NgvLALY6pqKM/qRC4moH93mIwOJPY9QmJRayjD8XrNsdeRNfWkqjNvssC80ZWsVd9FvOQmIGBkCaro7F6OtGxo+7Vqmvk6sRybCRx6CFG/vuHwXKevtVNd022Fh9euxY9E0S3x99BYSjbyIuRR7c3f6SodNPddIjg5h3GpQwqF3Sy75z0N4YFVezGzaKIUm1oPMI/3pKDVITc8JZyL+nqYOYyv3zb0lkWKeMtwRS18AxI4phmhmciDt4JK/YCy1DqwShbi3Ooz5Y9TmxyXVtQVxhmaQRUB0OfWue0bZ0/vNDFmY3sMQZ8B3fj3jCyNm4B02LN96rxzWnFjfQD7OeuP6QTTcvohlFYkh5nFWLC75HvoYQq8msqRUVigdO5zZd4tdKCJfvJOGYISnzfCeNJXIvvlWYAPuRHEtsg5vwMHM0oFnTsb/itYMJr/7UnR0bBjNspJu3CNRDwnPeobZcxHwUY4aORhbNilsLbTcM8WsYiWemGXfogkkgqK9S0ukpjbbcE44JCrHg4VEcyHFMmkydAWWY5PVbzRTEm89jB5pObZ80IHeGvrLYpw4VlyAeftaEXwgEoztXxK97/Pw+Jx2kJ77+TFDC4qjsOO7RC1Y9iDSWMIcBtPvfWC1vkOXGYxFnalbRP0VeJQhYW+VP4Y/MfC3lrNrxVszwDPRZb8U/H+5USRzaQ9AmGk/Ysgy2WBVBrSxwHP0sn4Z0RXusCPynqBeSbM1B2yeZ978m0Mt1CCNwZa7LhZ2ifneHgP3jCIlhGLwZehDJkk4rUxf5ieJPjDs=
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