PdlxYQe00boVe65D6OEvoNghI5r4/fpwUF94mwJSkG9x/6igbyKoYH//PuTL+lpCGRn99kdvqe7ZGTVqA1RlCe0Lxccz/JrAOcrFFpgZuCDfFy2daTkdezPCd2ttqbVw5+trH54B2LQVTT/h8W4KHDecZpFt6oRTjYBScajnDm13jhZTxqujaHX4Gi4X2C91Ewf1bpQ5TZGAU8YrTGvy39mN0zBqIe+RIhad91jRJuHktvGaxoGcP4VspqD2muX/50dlErBS4HkdoAGqtBpg9sLaf13H9SXva4tR0nROZKW3LKqKaCwEY/iZLes41bo5UdEzBXKa9KKPmAb11RjCFBISn9JU/tKHWuIElR0HHNBGxZIWv5fC6tKRjNzR42bHOyM+KCBNwXaNKncqUJ50ZWZnSjfiusL4NuwkULwqYxAVFtT8aDLLHZ+lbgGJfshderIN2KR4fEwqrQKG2/bD3eD+xilLoefWCmzCRUpTnimktErARTQTww36jzqzpKUDTVVij99lXjDj9G/oEB7+kEp1MdpGRl42vpM7WzoVkEhykhTM0fqhtuF5fRRyBOHy6/HBA6uejtRwRrlfOR0fOitCl9PNujSrXORmOPNHDq5vOgn3fSw6iUkJfa0sdgkV5gZ+Jor8NVKNiZ2ZtwO0HQys7snvzoDMZnZxhax10ndRyv30E0Vr0luK4sQxDBx4TNQ3JEDtOKfx0ksUWwuNhyGqTJhy6k6Q9JOX81uJoGjhJvin4mHcGeGD6JBBBg3N7gBNsoeOn6RaSyy1AGHDMPQEuy5rlEsXrZPW0uQW2Jftk5p+6p7giD7IPwbl9/S/SnzYMlkchb4mh4lnlZpRl3Blc5pz73VHYYphS9LM8TjznDrVR7qlFGoPv1aXkE0+MKsUPtQwe/CgAUr7HrdvUQ8I3nHzgFNvWNpDwVx+56pXIeTPvEBCmgaeaY0Y3XMlWocJGXUlvckrayfn19Zq43itsTz+JdeU1jA12dZB3bmvWt8BP2zEsCbyPWUqY50wFO4qD53OkWtNc7+B3D2dy/kV/y1wgiTD8wNFStKyK3p6q9y7GNtjpJ1Hlr9bGFmmnGZpUqibM/p3tyitjXsnDmeCDHwA4lJojFheDHNmMU+y7VgopBESFxNvj0Rx+qQVAxxKC6FTNvA7jhe/Q09up1RrP+iHxklyvaq/foNvNubyciF9Va9QBBQqsHAmujTgFd+bNzBa/D3TGZ8/ssuJ02Wy7oj/1ttxMryabiB9g2N41DFiDeDzm/XArifaKyJ3fPyzcxlmTAWc7clgOIcfEbRiRDzYg+M1WAga1wKJakXxIqn1HssXAPFoa1g7Pyvg+aDWmQ1Nxg0BhXe/ip76K0839Cv4ae8pKxzS+Fs=
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