OnoW46vIgNR+QHpICQhCVn/uDtP9iZZHBA1AJVlYLy4a37bYpuhPLzHYPpBJXyZbOdjoYHOX6JK0/vWzwVMenM/8HkSOpEZ4tydd4doiYCnOAi/ECwNd+u99NOdYnmuUOZcVmJNavxy7ehOFcDg4Fn9bqPS/QB31Qo1ImVVW8qsPT4xAMqg0ku8nTc6qF6k6YYqEd3HErWZueDtbtUhP1qtNNEoA0Dvd6ap6NquarcpfweoTbrSDSMh+sx8kk2ueyPxjMq5au61ctM/pU4nYoD0PFPDaMlvofRVAVvPT+huhXCZ7MQ8ufIYv4PusO98nYHbh4OSC9hWQOl+MwbAVDqIB23E3BcksRIqgnJiHzxs7JWiK4rTonghQP/o8KddTeUwyJ/6kopMRFnvyRJSXMTOZkvt9FMLaJCCsQsSApwKznyBsJk7cMBeYyzcVV7VB7Crf9RegZRE9IsO39uIQdJmtYivb/3ct+1KjDYzHIVMgqQvEqh1fORuae4shvYVYZ0gyTk+7laUs2I6CeX1gzy0kYYVk+RWk2+e5HGP4H9AlIxO5T6bK1G1oq7IBmhLUnEI+sCQmqVpV90d+FnP97o7sLGmK/Sf5Lt5Ya4FB0H0aru/RwHEaN4XHABlrbIBG5n3PP5SBKezxU4UyooRSclgrTZWeb7u7zwwdXb621rOM/z7CjKPaPWPNwb42RVuc0h91m9oPsAvrkC5mnltg7UerF3JO7cNiAJF1KfcV+2/ZLWubcU7Id7AibS3NFr3ZEOnc34Fv1ji8WFtGOchSI78WGwJpXHoujvoi7NhzfwnAOwR4RFqqXgt+77Hao15A3U2JOX2Pc+WSm0nrlF+EIps0OOAJc1hBpp+kWTPuxIsxtEXB2U2Kq/sFvVX0pQBhHpvtYWYnI98m35EsQ78s9L/KQ1hJB3kp4DQsR0TA3YmWsisNj9Za1MEAQuD5IBBGxQGq3ouhztE7jyx1z3uoFnUOjtvdjBP/OSLnn1EHbpITbFrP9cm+18Xa+PBc74gtLU+MnG0hSxwu3r2Eu2rvW7FYs3mZABEWtLxMIoIu8kBFwqnt/DLBsg242PjbO0dGQ4Dnvyylc2a+/HZL+JdL1V9JX+ceuE/wuXX7RZnorMSD46Hm669BMO4uHLmoWZviVl+awXq1BRUlg4C7BexCmNijzwcu5sqGOhgYXtykXDZiLVhksD93fXKSR6oc0Q37H0Nt1MyF4wxXisJjytdVPtjtJ9pr8YFay4UoTg9sfZ1bLepZmyXOMb0u82FlhadyYPoA1uULsXT5joZYoa32yCNfy5Qq4d5IXCwFfvkCOIdLkk32/0Af+M9Rj0VDGXqv8/ygVUDzXhLFd5lJpx+Jp4VGiwLs55En4liGtnE=
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