PCrY3zNvSIP/QBp2m1QUfVrqRTGY+1y4W5D2H1YFJFcHtKLdH97/YhkgXnV+/b6m1hip/7XvrhztDPrPxOSGUa+NLlLHqxd2oKtOzlLfE0eyQd4qHPp/s2A/FvI0UimZx6tfi/r39PfFZtHRe4v0TMIWdAMfaYyTiuQQvQ/y+VoZ30WWp+hOhwY3i8xIrlkVhMsCYg6gboLPmCA9+y51blrAjG8OMtdURF3q5jeqh/Z0aKY12DUQtQZnSBwxXpVprBvaUT+zAWT5+Dh/YhwU8fJyl/h7pm8L0jRpJrGkZYx8coiP0fPWTyJZ2a9gfCm3V+u1fv9RJ4hdHeTWFM9fl+jQ4jTZKeaaCpdibgBlnaC2SXHALBkXrchA88mD76UOjCGNxMY2axY0J8gweTmLY/KQU9JwSX0C8NdMm1lMXMK5CE+P1Y9jK9sw+ZCQo1fbx0PZBjJOfOlptutCrgS1XgSdPMXpwTd9osFQmIpMAkltxt9/qLgWcrCWfHQWDkUuf+0mMTKfWvBLxtuwqPvzK3dXqzLt035IhiUdI5FiX+/QpLmvjkx7m+8nd9v9OsKte5+uPgvYZeffEsI9zAUU0u6W8B7amZnJdmlZjdJkRL5VHKLkf0FsA3BfQ+0anSm2iSg/pWDmRRbyHWQqKWI+zcjEEHXPb1wxwL+ifC9uXH+DunbdftG/H2R5WyoEtnJtcRTutkaLV+xqGh1KLjRpugLkXBB8HUqpeDsgqE8e3yZQwzaqMg3kuIvF5+xwjCclN6c0MkHifZlCDmb1b4NX00Nqc3MU31hQD015ke1CQJOlSCFCeQvv7Z75nQydDARWkomR5WNn6DeesujAo+TwMuMoeipimQulOv/01Qv1mecjultzHTwz5F13+apREUY771LXiDTUPA+Xxmf8ldUgg/DAvB1W/z85B3WGwsBC7yZecvlgoXT68rzgqLiI4ulWfgmtZEhTetlyafDq67ImCpMzohFOdD+T9R+qOWrUKcIsO/ZQ1OdN0DRGW95KxLGhmPi9dDUHfWdydlDnQip/lMd+HdddbZMIzPGfcJ5Vh+AtwT9XcMT39cyv/FZUTTLjYjxF9Jyq5aYe6nHyBGDxT5PDPd67+D8tgdAc3i/cN0xpGAbmuWrhTYGNhWlzn+Wa7bMpeTFXxQzWgC7ptWKJx/T/EdiNe1vnec8okuSFVn+V/kQDfDEVxUQ6sV1gi5V/atTbq+SRCD3F+Do5t+k9JyYDsFAdoau4cXnA4v7F6eWvCPwwVmUDyn2w8iD15gnTyB4Y+jycVr2IQdPPLx0tehN6b7GtG8b4QCtW6d26lGto+8QpJnl2EOgScHn/BPlvue6jqHqVTCPkjruVeekaUb0v5jh8VAK9zkZ/i2w=
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