QSMsCgpABI9MeheqmsQr2Gq9OO4U/FUcVsooolsrCje9Am16SPoCMrd9vfUh2HgZxX761izevdQRJ96913xg+biuKU27EVSdTPeGaU9SSXzzB+ofCQC2a4fP9qDMPgctcLd7YeMjK+4LdeQlEgWET0YZeyFw0jBbAXGpxN8vWUA6MwNi/9OSx0P1gnpEliMkXLXEEKILH+afn/gxXlEmVdO7qJx922ydAWWhyP3CQyiggP4GrHq79wkQK+SJVREXh99wjR9+4UyeflsMxvRCMlf5e1aK9OM0/A1Ueqau3JfPHW5hwRGirE8UgiUH9G6qbUHR7+Phj+v9HTXxTHkn2Uxx1mRoinAYaK3g0XxsstTSwmM2VauLDgw3Q0Jmn1r4/5W8/uTGpiLcmSbu7Bl43ILOlLZZV1xp6DZOIOUku3ApjSROtZnuDD1jO45fo6q6kqtGzQHiZWNDsl/rcZriimhq7mJekq51GWfekXkp4XEL7i10vVtomOonByvqZ3RbUTe9s77ynvKfBSGrIA9W9JUsroFvTR97tSt6jMKpYk+1nelSftPtyrKEBFfZ28D9LmjvGQ9yXbWqTFhZ57NXcp6kH3hXcq2ZtZK6QrkVRpnzF35RCKdGDMUR/Qlo6xVDDIznqEC7jZLEOur+Efw8yjyMouN1W8u9IobfH5axozcwZ2ajOi0e6BD4RPzWy04FzzTeWLqSfzpF2QnDsZkJpgT1Y5S50E4YTRBR9XEkzVJpcDz0U09LVa/s9F/A/u1r7H/w5mfZBPz+nBfRgkHPunWeUwL0/zEPYPjLVrB8YWlDSXxBArN9R0BGHL7sng2VRFItHLjT6+XyYT0FyYZmN3WKSni0bVaN9Vpk5oGOiTcVdjdOqa2mH1+/lR15bMgPqu9hxkYHcMarlddRgGhw8uoG7mr9CB3ziIHnYnF3ifxBD1ua/uiDJPw6QUQ26v2Ob1xwWDabtqMM0zjD67NXQCIO2h1MUd+CsHonFAlcZiwBK66G7gc+U2MJBFRNCAjN4NF2OtHn4cK9/q/ou9tTBHzSrGvrGO0aIC/E3sPiO1/uTndvpT8PF0+Tnn7AflOAVMh47vnOdgLG+xbVa35KowBjCcimlVjmSsrFXC8hGF5sMkYnFf/hokNFDRdU7OUIox9qRX6MVye1kz62I1Jv+zZP8thdPVdmMBw3uw8aB0G1pH9y1vmIarLBd76lok2H9HOX2qYYKr4syFfRz6xQh/3YiBHYyupW+Yj9MgIIoYVLA8NW7Udrpb3PiIYbMgdG7a5OG21+OaJJ5Dv0+gSBe8T8xMe9DDCWr2Xu23NON0oBNF4dbUtqgP1sbHD+ZPKOUidBDoY9xub+uGWuC1NlB5MiaNo1GKm96v2DRD//fAT28otT7ibXloiHRu2wZR9mmzEOXkg5bzeocm746wUYuDeBMpQhOLpNB1tf502x4MguAUzYTrKgtHDSQuf2D6pnuyd88x3kPn92DXzAm24vkb/F/DPNQKQdKJYWITgesUx5l7Kgfi6V/BsLrZt0Hwf4m7gUYqTwvel7uh1vZQPhnA72CvIyq0fI2E6AkVpjWbIIlhsEPpMXeh6IDqxiUWkPz/zedNEGDP539hS51o2YadNmB0MGLQybK8p+PRuSvn+aERv8DRBHrUX5GDOObo3Twgl6cZHBbf5TVf3l3ijQkwR16kBjYqpiAdvl4omGe5fnIzac5vIgBsAkXY4=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100