UJhG4hh1uTlFpFsb7ejzNdfW8pxz5Fqi5nKVITPqHh55GJY1uy7xGeE8kN6AhTuE71o6OtGIO1yYiKm7g1pyt4pCEzbo0GxH/XZ0GQHXhRlsZPMrX3dTC7hHVMafINKaVYZdKzOVaoSG/MhBKZvHXe/5I2jW7FgJO+MzbV5Ar0l6jy/HUOte8asDpukrO8ndjc6TOf/rIOL9l+LbLbqJce3keF0ecQGRzKyWWRS0JcgHiR9LxDqRYmCZhhuUwcKhTlyl+Tkpgamj7P3CcmCyxaAgc3sQ2WReHoMq4WtbsYKPfVlJ/YvLKZB7zrctbT0pkZczw7/BMX/ZuXywRNk89+2ODrP+NrBukNKW8QlWa/pDvL+7FeSX5gSKYDa90Ic15EzGdhscOu9mzcCaqD1BDxnAh4/5e36w0kBtwGK3QYtNDG4g52XMha7OMwtIrh1hqor3IFA5gWrlZq8/QWGni9FFzAKTlrVAxRpZgKqQrR2ZSI6hSlgFa7Qyb80JPdIRGoFetfinZtl19rAtcWF0+K29GtnfF3Z+vq6KRolvSbdRhDQ+hyJL/6o6ei4kkUsCDg/BtzEceQpG+H+w28UrGNJ0dx2wHJKAxYrfMD/rsuKasNsJJ27K4KrKL4LlqsIwVlCuvUZUeMmVq4z7tYprUx8wtu3vBM6fRAj44dpBYdA0a9MwsSrDE6NNqmT02LWlzJ9Q+CMVHyvFwQZTwxkwcZdvVTy5r0kSMPKtppRjsQUR7Wu7RhoDhV2KH7v+xSc26X3HTRDBRjiRUfND//lnrF3PDGtDsNVcWAtRGsyU7oaEjFBQflsbsfPjw8+2chZHZNj0rgLcSMWj7tUr5DqeGDh7FgTftyJy3FSUGnX72sDQiITswngDowJRZdSPisFEgliV6lagADfHoLTNPplNrypsht1OgfvyyxJBpDERqjwGOYbA7CpSsuaUg7QOx8x2o4t0KqYoDwZukjuaap8VLm9aoO2ISfl5PR/F3lck+X2NxLKl+7XXAw9/UToEWES8iGRgbfCaOuD0+o3or2/Tu4vUt57Ok+MZixZet0rFSbZRM9zSQ+khmbfvVDr99U7qKc6kWdtDLcdAvyqOnwV4EFn99JkrH3M9x8bnPj48EuyhW4TeLs7E6FzjAf067pcr+IG4QolLlgSNPgUI4lyCjNk4NQ1vkQFusOWAgOL6jhpo5/wP8T6Z9y1MEkDuPaGZdPIcBMKTXTHUARqJVLAmyjPKKLKFoTUJCb4J4ICCXXHwwXPO/aYa3zIO+4MlcDWgmwpxVZUudbyxprz5o6NhvQt2KoghnqzQJSNcul68hWHOkfqWlTz4wgi8HVy2+nhOvb/9tYBOstRmyL/UrWWNiOzLBjK+il5suL9Jg0A=
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