aOUfbFUDx0sai6n5rTW0UdFkvXO+eZC5uW4I821y0EefaqbV61owQkf5tST+WSAZi+oJ5gSlhYSHQdLZHrtjYuipqyJ63oH1mHqdDMbZPHCfs18ONi5tTVZuXOrxGbDqzcxuMpOdAF8c8nAIj1dkmshM7M/8AuH6s+b/Vt9nAa5Q3UaiyP7E3sFz5aCttYkmgnos565echAGhYjzJGKfZC2jJFIhI3GYDb2y3a5d4Hj39Fl289i3tK5HjQavQhLBOq4xuGx00gLCnfal8hQduqYBRcQLI0JTN8X7j231ZNcwm/enml6CH7fMJmPb8Ax5PXe4+kY9Jn64OAYXjRpKT4GwXTcnAb4CBDSz34PaJyqfDUUEEoRcDFlYy7d6TQFRl3yP7ozzqfJ8Q8YYvQUcZpxfx1/aeHsFBgrA5HLuEHvrbyqoETBm1l86ok+/MRRfo9tZS9sF/xK2WV6howdpTKj9sXNGvi5jnHMIVSqP4Yfwr7t7yiYO29392WVLeFBOQiYh/q0UjcP4eBMy6EJUTA1MaHOEIg2rWTI9MoVJzOjZl5TcgfQwxzaTIQomL/mn03oJiyuSt4K2RUV2nU0hXIgpK0Xi8f5CzlmrrYzuk8tojgywfewPs79es4CI1yp3xAqj18okkTYPg8BtojNpRqJuWHpmgUQh/jg7229XCMpHaTPAjoyMRGOhUIBdYvNT43NT64dajGtIVQKHDf8GF3uuW6b1cgjTbDXCsEawqURB5O/31uv9x4ZNhNWW6bcKqqpioQoMvq1uYw7LBUN51z194gtbB8JiEV92dimr6oRNe7wLkUwy5tHU9jSz1AB3d7sEsw9upNIt8hzHXQJuQI5KBxmFp7+tfVPGieyYEo/h5TY4Sj4XdwdFbpOSyoH9c4RGkNrV6LTSZ2at/rECaWuCQVRPSsWfhI7gJHOo5ZpBlJV7V1zc7pZZMuvsWoPAOeOhWgciRXt3NYM7yAFAcrXLvj6eZPxgVJOpL1XJmMaBcSf2RPk0RYDd5JTN+Jy7yZVimBB/nTRPT1jiDGUrMv2p4o898BL67g0gNQdr/KMutbwiKemGcmKaEGFYWv8FfjVYEEstr/Ruh5ilBAkUXfHEn1xpc0e4eJ8j3gI42KAIbsQbpJ4254s9Rqmg+RJhoJ8L7dcEo5NFP56mgCR/AiiHOqZzKE+Ryk+CKjWj+ebw+xXu6oKS8gYBgopMp80NytaTaOX03jShUzvVWQwqL3LGIMV8POjZHGnSMQiyCauQuwYyChltWeBf0cSey3W6TVasups+rsBTvXv5pYxOqseQ/WxbtUbaKY0oUmDgps7CW/sUj7uX093jj8HKjbR43LEdTGjSgbOwQDXOgzYRdwqG87jJreGk5gj+CSg=
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