KcKvuttHIC2mQZZndqZE7+KTL7DOlsg5/eV83tFzHJf3reiFPz8ZZQ4sR/ChFwHTUTrsC/R/bDrPtGltX9nvBkfM1Am3+iwyTDUJpcHBskemsrddNe/m4lNqHL1fMpU9nb/POkaxkBGqCvLgu0lbVoRHbZNctcycE8SWWEP7kxKpacq/T2hAYnTxBkEnwGp9VkbWY/+TOw5s6dX5lSeG2OYDKQKSVU8Elpbqd0Nx+IUZU7chm67SM0wBOTCx/575Q6yRxdlJRuCCQQVP5bxaUPz6Vf2vbZhIocBv/0kuRbuJ5BEUGoQpcNkYBEuOMnPAhuibNMH3JvxHU98geYhIDKWcB605mtswPMV3dICB/cpO2ox/50eJNbKzqBOaY3EBn6fkcl4O72uWO2RtRLBO8TrIDw5y3y6S/XHvNz2ZSP8x+7gc2O64QMw6UxaKtUOU5O1KDJsWhc1EWv5ZKl4Nt89LQCca090ZSKmnU0TdlrpalfSxzMtwUalEk+IROBTreQE7WGqkkVtOYDm0X/qwJEUARylnheo2ni/euSClLpOB9n9OMd8X8oyjsB7493elGd40eikAgBcIAFO7GRjORP03FY2wnsaaua4038nAKaZDA3zO8lRy+VhZoHVCBlvW5lWNSuODG1pqZuKZmuwxnR0QGhQWOVjjgN2sEPRYk2AWg7DeuyGi98uQtjl9nhcgyhu3fY1zzvn3V1EYtoQs09tYMY1/CJqHIzriEEsR0w1QdTxls4dPcbB3emj1vVMBn89TrCrqaf3NxIcUF/lYDOv1yoNa15Aa9vtoLiIClxzx6rPKUSbKObH1hm4p1PiKJLYy+JYD8bvayx5igDUced4AqZzu7TuNdmiQCnhPEpSHMgpc/IpiLVNNl8aNOL4a2g+yzjoYfv1jJnx1qEG3WWRiZeI0qlPS7Kj2RYSW6mJrdT/YKK8UZWDngfEaZYkZDWfT4tVyjgp1bdONGksYfjDQgCjM1xwQg6S76zffIB1ax3fc3kTBkJJkwLkZQwuVUNDmayCFB+shWTAPLfAWaMX5GDnsDHF1RZ5+7FXHwRaj2yPkH6J1acLscIosFcs+fqAjVQaes694tUFjwP/9vHv87XdwyHCYblCVKVebSWrMxRK3k4vBvbEjxkPXLYA/3+7eukQJT/bTEpIiWCRTiXWLnRPQfwkmVja8QoHSnntMWJkjK5Yz2706NTKE9Mrbf+bbV5+gHjbyJHDyqlfEHggkX+2I6vO9EVJvOQmxybp3dwX5p6HoMiuZIExmfz6FMvKnAMtrxA4FKS8WrOuMsZc25+ZAJaK54YkaXR+vLXKMbf7zkGX1AG18dAiHFbZxTkgxhlnXsafAfWAh2W7BBhxG8yK+Y0dy3Og3xOo=
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