LumqcfhSdtIJIbVHbyIKsXNyUzQBUKW/D7nF755y2KNzXMDm8UN71C+pB/pkoH9t3yxYhHEoz8dgVmNWDussi7scorIaR3aj7z+RPQih3ceWLbLekhw9xKM/KMpF3tWd1KWLOJkW2WRoofVXVvujmJt0Ovgad3jkoAn5t7dSHr6ydxUR5hDXKfoPResj2GVRdPyKZcJWSM1VCZz7ZXYqHXEvBRylFOdpeQTVQPeCyXZcyDzuTx+tqLSNTBAc0iOjXpNaJfjR/ir/B4/zSfZOFCaRqnGeFGYfDs02mZjrNr0M6L7lXlWEWfAXS/ChNafTUwB4rf+/1cb3w5LKHed3oAe1ad9/0W3hTH2eZFQRn+wX9HXExFBk5T2I1olshLXGRRQe37DTK0fV5dT09UEXg3DT1wPYioeePTM9f82U65woYSIiyz3NPG5VAcMLnFE4a69zhALmiYcsUL0BY0c0WFCSc/FNExkvLrzysmWX+lxhXd2a67vet0fl6vPSCC9rCe3WgSiSueiNjXTa5eUW+AmhL4AHTgeNpgJfvAeSPrUqoSzdJQNZ9v/TqyETOFsDeSmd9IHuhmybtP7Fwcc5F/O5y/63r34MMNhwmFXdjug6VGiH3o+oqsBXQqTGF0vcyZo3dxCCm23WQ5wrXCfHxoeC5HB2xbNZS6JIE/oCUafLht8HUOPme+1BvQ3HchRUs5ODoO5GjNQXVIefvhtLO+mbH4I1vfrKJ6p4YxAskz9kyF+RE+vEn3iKolWP82ZEWZfCsBDkX/k9WkYDkKGG3LwBEjGUnhIXBT9QLTFBYOjXZ49n0Yk22C6zY34APSPYIAU4sRUHCE3vUVML4Y5ulbfSkQQ85hPC8NErlrlUgO69/GSttcT6LF3YcU/RZdCBmmauHArWHXtQBErAMh2X6IkKZQrc7fmHuoh0VhO0GGgsYrt7TMLADlIYpxa7AuVqY0iDhaF+rY3U9Qc6Vc5QBdBlqakiuhAzO+nUkOzmeOWZ8xWrDxv4P2ZqP8aEx39mMTX6kCWVO5Ma9JeXtvDdTVrES5qeNOMJyP6BBr24TlfRJMc7YV5yFjwNYV6OH2LmfUjZVGah3wWBpAsqN+s0SMkM46ckwNPb/mPmZ8NOA5tGGGjG5q1cUMPWG1oEE+XeoOype1FtFpbW0mktcrICmo9PfiN6NdCi4JJJcQBW0HwCFvJGgE8eU5XxscDQSsdlqFi7CjABzEBhag1xnuGiaI5Cfsq9TQq1i6xP10X5y7RTQK8Iuwu8hDW9EhZpUkgMkMCQHepsRIESL3BrIRMM9K04sg9NThDHlpsQw0rviGBxVYqxsBhIj6dy0l2APS2+SCBkJVbrPFiIkL1Yk4NjxvTXkQpbW6iktQHxfoI=
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