dmSykK1Cp6EpmkovMr50DglvMDdre/Dj8YRVAfggQuy7mMeHHAJ/KtlfbQigMCsIOO/f0xFMVQKt08Aakrg4qkxR0mWCiqSrVtIm5HF6MbVYWrjBofVaqQs2wSEcUJH6MHZlZ+8wN2pxo34p227JMyAF+QkDKOBKCCRL0v/UMOgyxAExNwxKREAR8YrU7QM/JUGpqW4XOcr8JWgS43XzmwXXB38ZDJobGWKz04MuZFERRKz8qEPh66nENGDUw1nlJt27CtwNqRg7fW6BLe10vO8g4S5coLjy8oduqOQYpb+6GIXVCLTQF9l+CqDKkm00yswrXCPr903dvb/x6atDK0pq2MNEzPtbibc+iEoGOIYzpKy59Z1yaUihYQ8EWMvuA6zkq3BxctmYbThJrn/82zbGOCwDyO7NOOImD0xOnS+jjp22rtqptoYZWkrPD3ErCiNZEAZFwj6H90hBOVmdH8U78O7jAC7J3zZZUyFrPRTu8Hl3IKR/uu70wobaMMbyA0p7HNXPZPN5FRZUQOL9NuGsQ0ARRw7CI5JI1Pu6SOyiqJut9M9Zn8tZK7mSlQuu58P8T0dI1ko6fDGf/ddt0hHCBNKRyDr7cKEYEez9mJ3A+THe2VEs2ZaEaBbk/OspqVS9d3aKtcN+BaZiL5Vy/USh+CkHmHIXwbbOgE9oqtB+Kd26g+6sWa1thVCJAOryq+1Cz7vnoK1P62K8Mf+1rsPuJekFE0lkCTOWYuhpSJB6A29DtVvSXJhtjSh0mm+wnk6Rnz3yW07TETXV8sGB2l2ySdPFZZD74OR3d4gjX3UPwExsW3/Ig+gUFDxtL80xGUsQE5ktcPgWbSjyVAKRc7qTz6+67UgXjFgTCjdVTvmNuxiYmqtlmrSjdhX8C+IDUt2cFc2/RkE3MRS4SgsGeKLOxsizl20ZjHSKw/GVJqc6NLOdcPYPdWBgIW9DqpbjUjAC/A/jAJzeTxPYPGCxfP7da07N4tMSt1WLWb18DldOfhzcolH+4IMs8Qzg0M9h/MkLkomLoLyexhqzNYbkqa+DuEWustOYT3yTAXYGWCaqtzCo6e0EPwZtlCZCpJ1HUCLbQdAcWbDqUvnx0/oAkWkvQLQIIrK0iaPmGUm7Y8FsteJTLIdrFr+cdeXLGQcS7lbpP8O/kYok2odMa70Tcv416zpwVpk7mUvj8GDXaoqDxuA8kyDJ4zvzth+Xxdss2RJiYtyTg2TS2f11mcw1ovOWeGv0TtAOs+oTqmU8ReR7uriM1jF+FwUyuJkmGVZB8DyAzevJZEAeQXYpZMDWAPu2TNNe7cJmkkdRDvtgS6bzxMix69SPKtcVq54RCzzatVUwQc5eALUNRZPX+f9jba7JBhh19BEnTPnMLqc=
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