hCe8aDMh1nTADllFA+7irRyGLUvj/Lv117FaRZ33I2T/96umQOhqdg4TOinwbXbpyVre3UR55ixCVGEgxHReSGuvVNUMB0PVskz5iR/qNLC0lpDNWzw1ophmrZqiS5vs/yDivDlfQa2e6AZ4aWVzTvKO1NGoGGcjNMNehsefRot9TrJScbWxy1wO64QIBO7hZiqgQU2dvSRB3euhZG3lAkyy/ODGOx5bUW1FAIUX5bnSZV0s9rZj8/jd9TTuzHpLYWvfeVAaFU6baTsrM8ULvtbLV+04dqv1EWTrm/Dc+BxIS/039V3uymLGb1+1sle1QMf+HOrY7E3sB7Woy3rAEEiPcn34frkIF9e+HOZVxXZVHmyNV6lwtnhGYohGcAx4gelfuMCyiqnN66xh9wQ+UPH8NvdeGgnHtCVixRIUJu0h3+h9Vx+h5Y8ar/dXeaEwzZ67jWthHLEeD17YP3UVMODDj19xfHkxMF6Xu2iPuZlMU7KQlhvYJZbYgSUxmysQHX7wVql3/kWtJZR3CH1Ao3ob9KAyCTCDXFAEVUAvffAaYyI4HK1tIjwuNBRRVXc8qUsO1VPnEPgtrG2Woed/wNnUsE849XUUOcAm+OOkbL0pOx93bR3u6Bq3ZdZ8FD3z+PQd3eptWzGjeyZNPxwfQjfQq59tul47sbtrQdcZOo7WbCzgxy72mjIgj42tXrHsG0wTytnKUmU0pTbNtVNiPjRSKF2m6bBTNjwJpaxiTj2ohaxDishB78cK0CtKYF/U6xRGZ/MfDtcplvOJIOgfDOumhXDANQVpxjCkGkNH/aKqjkrfTuQGlqA70NOqoNH9XRLfcRoSM2iFgOpB5D0ddyGeJkz3VBhrRl9L00ENDFHy0MyTOfy8DVIQKEiE7CROICgzuWAow9dLuFN4kDVQne7b9I7EQpJjwEbIzSCHXr0ftbONlnM7LRMWbKHSfTePAUy1ahIrZmIzoEYxkaUeKNnm2KHlfETWW4+QGrcNBPLew3tHbWFU+9rMMBtLgat4/wD3dPhFRyP3cvnAzQFA4uFy4oStUmgkwRImb64J4jMauKgcu9KQ2t4kAokyfC/m1YVZHPElStFUTreJa3kBZTkPlbyRGdl5dUnUeJemb+BeXTobpQEXsYTkNQuvKdr+LNb8D6Qq71WjCkSP+aSnzI7vnyeKXQoVj/hYJt3lUCnXn11RZjuuvNrHbI4DvBQDZwMh/y+wuMEj+ZpuWaWpCF6MDrOi8PgDWP8Sz4Q8cRw+oY0xCafUABZL/+zk3kCw8xtJkdNBNg+IJpVMCC49po/YDkMA3ogKLppWnLtGyiBqhHKTYDpjBRK5ZUXNFa1psfpQwIIV46eHKSsA8Gd7FNZMjGxquA1xyfT5M4s=
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