+HMr2qXS9BWzCLBSuwSocOHGCcyWCb4M3O2S3eFm+ObwzB0ONV+lItWl9C/NR/oFJBHXoWVYaW/+RThNJAVCgyfyfZgoR9dubDcVXo2eYQAICuas2EK/N20wuwUQIQYtRB3SnxxXI6a26Hysqzq/r4pWrft70LhpGfAbTf92GNl9GSQtiwRZNNPru+0vosY3pyUq+F8WBt11VujWD4aHBhvX1YPniUnQwHBfhC+LIzIKl9aZGKGLLZYOLNX258vEW57cxbp0icUKsKZGHWMzYbP0GhCzuI/fyULxpb+0QhI+cZxMglCrLAQsfWvJEJJMWSd5he0DIBwFgCfkEG+w4ljpo0g1qXw3CrMksmZDK41pozbUYr39xL454+6cgHqC6tmKHr3CnrfXNFfTkYA4WvLSbtIE4Mj6nDPwq6lmrfYmE4CBQ4DqrO0eaE3iHzPWVyvz3RU3rrfEqydm0PH/OdPt11VEtxmXAyfirGVY+Ykx+9jueN3cPtWrnGU2hWr+kJ709Eb7qazjYQ34JFHvJhDzMokV6olJ/d4uPEYys2x7khdCFkD76A4fjSGD8kTXJynUsGETYwkSAXTeKFqHYuleuDw2Uvcj0czkkIYTPRcPm9c9mPDZ2FtFn4ZRqP30S86frrAJ352w7XDQkVoXz7ZNZTK3a7DtjTKDk4fEzWVaG7MqRdVj7z8lwAUp5bX6Zi1il/U63/LFDMiUSPKSwKEvQRgT7hzUXl+kRZt0eUSMnmG4+FkrUUsHiyC8rMZKs9ngd3KgUU9143JLlxQWhUT23BPcA+S0Xw+wr4rKr/c3xSTAvIq/o/wakOXThmpuuo7CQhzWK2ubFn9kGdNweHIQzKt5UpCqbO93oX6Cb4KHaIV6stPThAkrVmbglbNsPyZueElsLFM8V4ChgtbUo4sQ8jINqlckhzKNQ6WSwf90bKMFF4xEMHqCWHpMHGAiFCUUec+8yt22uPu07Xjas0WaTW3S52I4WaPPf9kF3cLxIffzIrlKyCd9B7AraoFLF7e5sLdK7BaVWOqd/wUv2L+7WOp5HSeJqXfmzJlXq9cJ9HF4WF4N0ZLZivLx2gW199HzYGX8OyqmiMT2UhjM9BCDcycvB89Y/mMbAYEkB0m7//9Wxyk+7ivqBBIp8Q8xU9Tr1BbfiDmzmpoJNN6kMjbLPh28PCtm6Q7H2ulz2Qipphq6zsaugCIKpVAOqzUH5kGyQjCt1MlHgew6HbwJrXd9gk54QT570U71Gzw0ojlZw/2d9kZrHSuAh6R3NoOE2dM/BSIe4BiLWR4Icbw67CZ9RyDiFh/2fndrG3SVC80QvUIF69pAxnoPWwJ7kRK8ZXKCzEfSQrRShFKi4RgCMbruco21/3zduf88pfU=
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