IlEb1syNrybF2IZb4GSurpWxry03KpYK3HRsueFDr6cpGevcRABdDKhej6cXEuiSZB/CsXrqC4sKNRKiDPiEZQT5pEbeJoVd7uRqReIPH2F4XFXzVJQMMGYuvf/PdQNRt8gQykHyV+3ogumIWT9QDBmtuTqaOIl98qAWV+vdPfXD6BfiTQ+dgrqWpJWXesu1SbRjmzzwhrzVtrzOdqHDt3L7L9rB1UQZuG3iC6tDZN/h/MXiff9TrH+154aucq8KgVjAXqZlxqwy1/wptgGZflUHMMdgfsBxS1IgHlg+h4oHj/j0Z4B6iaBAHVe50ZZU0gJmMwpkuYhkw/Apiw/UjEH4o7gKCDv7WfLvA6ZgipQDrsOiuB0xVTmXgldHp+WCFiLSHUCM4DkXdhN+GzMYnhWEQi5tvACxLgtv8lfbyHmyLHqOMYP1W3zztSDmPlseWdNr7OuG+u+NI8FcrXSQcIgbwMz1Rq7OYKGkie4jbWfDGhaFfJL5ziUWCfy7CVnfG4K8T5du8xznXGPtnFemX7tI1neXbMn0P6TGaFREQiIticEpofs/4gHA1bMngx7ciuYQGvxOg44QmdpIws8VVQOZAiVwxd+O5lhqmj1wVYCeI0a24wU3ZkDeHUqcit3gfQMXiis3GMZ8Yre2Q8EBnGxgTQvGV5I0tvwxp4GKKz2fm804+k7/DbWU7bePZFlw1L8W9UOxhStFP+hXt6KqsS+2N/oHnPiU0UTnRWL2xDgPLVuUtDXz2NDhcSqUArUh9pw/EhyeB15fuX802U9LNOgYt7rBm/ufqPwi51Aqgl6QmeUnMQqt9wHTbSjPD/k8HnfYRXBQOa3AV235McwNn9S4D9+wRdB33VdNzDAIgWq/gJzCZ4t/ERbQIdYwnGJWcs0YSacImSdgmG4rDirJ/leLo5EBgpFfSCrWL34R+G+1PfdFrv4vDRJDrI293QPxWCkkstQgWjbjZZKDFJPQdqTe7vel5b6N+Wbsu7dYaybMXPGluB8Riuq9jLnavxG4FaRA09v3v+b0w24/0Tf5BZ/65sDoRTNOWJf9hRtqU47d6YnpTG2zt/GskXvF8uGEx4X37WLWhHmMJTtP6AeXM0YmZnwnlplsro5Y5bUFX1RWd35sF1uawDLrLp+gGmU/ta2lQ6vZhVz0XEtnpBMlUSaDOG8bLJneBfeiht2bGVtjJCj2aut4RV2peNix4LBJufRTnJVVU9WpalkkTKqr+FAUyqRWASzd0HfQ/ulzh0C12RUcle79qIiTO/7Y+XWVWLcUluD056/KD3/1inu39e3alL7X0rF2fNRFbGq9q6F6WwBu8bBWET5N7/ywLqL2fO4tjxGXoofbPjHTU5ZyA88dz7RebttgKI4zClg=
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