1A/UzGeEGFcddIQi08yI1XVLtZ4lZrUz0jopX6FJQikp5ZKJ8XAqcdhzJ7R3wj4ywAAbcv598rPVlxeus1wlthkt9+qPpmxepxrHqxCnnN6YIYyJY0ogudf5QHD6bC/PovFabwGUk4nuBeYmZzQ7ahBboDJ0phSkz2loYIHpYB2D4WBQXJbCmScib6ytWQ56SXeqglZgLwbq2pmyGYQjJVUh3paTucjdgjBizk33qQRh2/CXJjwjtnzNIoe8hlUzNpkIzCpHXghHSwPdeVMMyY3I81IOiGYMPpKMSlbk1GWzVkOAXtkGdeRtfIojzO9zVsPTVX7ZqXnhEfpKssrG1nKhLgTI7xoAboLeHTY0QctBTGpQbG7s3w/x1/74OWDl1XXbnR3iIhKaBJLgBsf9K6HjSu4FxYZ3GGvLgdx1Jeej9nrByxDczWKmspArqKATWW3jjg6PLupxN082qfBXBkQdG0mRJiNHMpfyzTybA5XmykaIUo3iSZ0+igIbJy+hnB9dpU233ay/vU+KZtLQnvj5teuwAJxcYzWVw7yOtP/lI+Hw9F8t7mk6vfEp7jPCmzZCMqv2uNcTxMPsmkpb5lMlqTYppZZuWxcI2f2yWirNoPC14DA9m76U6L6/CbKTmUslk8Q4Cyf/5aVhf5GQAqIineDu36dTZed/NJXsPTyO8SgnG69V8loTrtQJaeYPOC5cpCcwDN7KC4uI3+DtQPhLcza4VriJ9IeOru84FBQ4ttXdHiiyT9r74Zc5S7lSxCvaHa13agUWR2U56Ewk+8b8EDzEIMcb7gSu9DjMFLiuH4sqpThSc3E7fj2KHMJacBPRb7AVWxinNY1ccvpHTMIGuGdnVNZ8DLMQJSFO7sDnjiJd80cCAPn6FR5hHR/CXwyvS2Je9wFce+olY+jzqyaN/uzviG7y2Jger0EkMGg5Zfu+DqORnOJU5sPc1ATrQkHHN/yOBPRx4CRUI4uuL68qC0YtyNIhrotUEejAZMmBaKHW7sTy2hVpdnTcikbbuKm3+VxSRwf/adeFHBmIbBgHcuYFhtTYmdQYCEl2U+1kkJlqKHGRHN5KvYb3Fh1Z3//0zbBQpLnyFNLC+3B6K0NvU241Z1bFERY0plmgd7qnIqNk5zFFhTQ1LM8YacRIdaDPnDqASrrg4dXitZ7SLasLhIH+mnwGDBvgtpKfHFqz7+0AHV0b9aXV1TXwU39qE5pQFGKC/+iOIa/ive8A5L/CK7o2hi2YHZahUHkC/U8aCOlg6FSeUm80rsvJETzOeMUkx0oNQLZHI0jFz56P1XPQBZGQKZaxh1SMu3Gf2BCQbH42c2qsTDQPsP0Jeyloo1m4JWTMYZ1AB0iv1qrvC3FYTPNg1T3PADw3tj4=
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