KIl4eOQL1H3+Bn+J11m4Sfxacwg92BhQM00edH6NslLW5yBoCiut7M0qOpJ9n7rGIVbdxQsHjVRib8wjbktXuaHoCoWbhsrLCIPHfUlgV36Rp1tnLtYt2jvkUhqIojs1ceq2PEsze6QCadAt/QVfXUSpk3br5L/CTDmM3DhMkLFxj6uPkhry3klPVBdzaKWJ932wshnjmVPmHG8fEa0IKW9bblHoFFIxdmI362/vAtDGW+gPJc9s2r095yVMcKVP4/vQHrgYA3vVQCG+TpzReD90B1X+V/Ntu58dmTYUUJD45soZgK0mB2YshF6oC/Km/v5gEUtHs/7enFhuxMwyrlxznhuUjrD43Km3TYcYfkR9nY96N68mPbsitQ+Ovdtah3Xgyws9bqYtyJuioIarQKJjVKz+tT+4AeO2O7kKL9G/6LrnX748wlSlQZwCQnk0pOL6hbGB7HyrKbY7qy/dZyW+nUSZ2PfuMYX3O6vo4rF+SWHdP6l7jWE+lL6vNdGjOBPSRjIJjmq5vBmLaHXNWJoIpFni7Cidn4Fk31m2DHB3Bd0deHGehlxpG7I+klmeg5v47u2TCr/YyyU+LHD5a8v0r/mHypBvTa+C8SiVMl/LQxOH+3Syg/Z6Sybqj1wOlYORClVkzn/tjzMVMLK2E4Qpjvr0WRQCxl6oo3qO4OBml16JnFhP+Tb3WNuFpsJbsLsoXwOAZfG2piiHQS+CjfZ1XT2bu2Lc0jXbtuEud77nWstqnDdDXGVmnQSbPV4w4UFz+Hg4bRn4RtfldI6qPV+Qhv6dbNgf5Q3wqO/0tGXDipNCuBQZx0v1FMc/rtnTLEc/lVeVjTqz18nunWmnaXUXRK9mo+3UeOVxW5MHxJzdtlwNSIgLZt0bVkAiS+kiIzITWQnEqVsho/Tfr+H/o8VueobE94WuZVnUeuttud8RjHcX/6hQgQx8jwEKNjB4K4X+KoyDExau1vMT7EH2m1oupCZGO+4mkA8i2AxpJdImI7hn6JKV3NDE2+P9wcVWQAzXAWnV19FkeGLZ2sWgUXrMl8KLYT4WNyV951ZGM3qF3glUC0XsnMvojzZiQ78F3Oodo23CA6mDMKrJBIQB5IM+X/ry90vST2wan4dmQ/4yDVyu7jaCaw5B/ar9i+Rk9yO2Y4B2tREZ2SXeZMoDVD97zbpFio3R2jLAYx89Rj/DyMty1R+kgvuh1oqykmSeseUzbV3h212XSoufNGnzwS78zEK71nmyHCzv28Of/SGppsglaKNroE/uiKHLuXq2lzMFCWBaDEVWVWeroszUi9oqv/6V0VvYAZfLgx3tryOpwlifsbYT/GkB+bWtpnAqCSVvgG6kde15OeMpJNEoZXdh69/lq8jx83GOlD0=
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