M+kX37yg9fPMSA3V8JxRID0lxspex7eDBDhIyNE4E9Fyyv9cvtFBpKdvTL17HiXr8y2Rh7TPloZMb63EFB7gYEj2dbbr0uZt7iL2K3PvM2Yvu5IHLR6S+MI3JzXQJD8GIoBAzhRbqFHm7ihC0paZJeuXplCQpa+O6z0791FzauU7mvoK90L6UKmmF/xSaFsW1GpeZNcSK5NYJEYOJkwVHa3+Lyl2b0bAGE+2m3Jmd0tntrn2VRUiC79HwlqgT2rtseXxE2yeKMUVYbS3W5TK1yakLomysmmM0j+6pa+Pyv5JnKST/ph4kL8YTx+Th9+jiF0WaTvsjgQz51Rh72X6LZU1FKClE43lRv23YNZ8QcgO82Mc88K9TfNUSx1rzGvOVenFQI6iuFYCWvp1a290MngEncT4glVLuvYPQmEyQml8dOlxqsn+e9hJ5P3PC1ughQ3C2lgJlMpQGIqsFKCverfT0zPKmizWye7uXVJLxHi0cEkstMjHFcdGB/6wFMuqtOufyjuWwinOqvvTdodq03RLWUdsQfWNzDA9VFSMysyyLo/bkNQ4f6t6D0YayQeSkr2PX1BsySgmr6x8wEyzIKg1e4QQ91Ifpn0/mns81eG7qj99qvLBpBlIkrnVRPMq1bK3/ZyIJNSZq7HldrvgpsT3x9W5c1EyMqvjuSkos5I3Zsntq3VTagUypY3NPbTpTzR1pBqGPYuXGXNOO97BUstF6safNa9JdjD0uGNHGskBkuyTkoApt66bsKOBgL1LbFVguyUKswdqkJ3CzV+fVxTUlC9KqzDi8N/wXouDo+KniRxMXrpS0tbcNPhDhY9P+Qyyoyt+tjBLN4clMpxyAV7YUjuabQgYzt0fm7qxuofjNN2HgxFIoN0ERr18Aq6pXEQewl9lBjldOzmAC/3AtDovQPIgwinDniodzQVewWgUsvO1TL9670ogyZ2xfogE2kFU8TRlQtQzX4PK9vgRO8etOh1Im8YgHhDRtUQ7eOxRi49fVKWukHNt/ufxrfavbrxv2NvYc84t4BIGpg9aV10vaFQDeUEEfK2gs6/Ah1ztZPxwdJLTUfQ1r5U7N1TaM8sFikNlC0Ubw1tBSGMubFqz2AR6qT+Ga94cpOZgNcdlpe6fWK5+o9eJe9cTiNJShJ5irn91RHmxloLLzOo22Y1gsePOth/4Rb2hYqZT4wGOdQjafmjv5+3qzWtAzqxCQMb5qZDj1DjQwezSNOxAY4Lj4UWwKwwso442rlIehlm0WIxT2rqUKtWOVZ5D+wG3rw2895Q/pUqQ8+jOllDuSs9OWQYi+Jh5Tp1rBWV9WNTLKtIx1sFzr44+eNX1dp8+dnXPbtfUQu6q+VSCcptbEGcvVMICVQNHQt+Ie7k=
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