fMR/Kv0m24xcMrF+WZ8H/9c/EdSOuh5B/Xkzcpo2nwa2foc24Tjvodf9lGUo6Z/oWnxq8YOB9cd6+nJeCBKPzA5cYYQb73VdRa/J+qhfrLvDZXj4OzV4N+aXwFTg56wGETDRmPOQZpDP3+Rt6gNS9zHzkUJHUzjGzYvX9ZN7mKS+VaetRoyz/wPjPnawIB1mm6v5wcky4S60pNXuZ3HIyrW6zgU02Wvp7gmS7GVGcqw7v2nq+aY13M8D+rjrl5dFINF8USL+2hsPH3vGNLSNKcmHlvSLWOI4DZvusdE7vypZul/aoUGbYAJZiiHOL8y9BJX8WfnYhk2EKkr7ZC7ItiNktDVQwT3ooOfNbIUawrt/HM9ZpTYD++xxIlcm4sDMj8ocx2mHWrN0s3PzsNh8qzaVYbGOzrlxMbmvWcwMibJ8H240RTnN7fFxhJKrP6ywqM90kFu9gu+kHgZF2CKuXmoxsES1LAI6S1W6Uw3lpcRX2TfHOx6PnNfXvqL3Hdb7Nv8FTVBOXbarS4+e8lX193CGGMcZfSLgt/mcXmLXzIB6/Vv45xbl/yPan7iHfeCUkqM4KIeoZaI1rlrOVqBiNEJd+JEpKaLAY2HEgcw0IUjfe7UJzIoWgntiVbz/u9xDSyFd0qoMVPvMw8sM8GRff5EqC3q/bBGBAhD4/sQb5qviV5rJV/TnJKx7ogJ/lVAQdnUpykOph2rjKBtHOQn1JsS3+9mjB0OuW/MWZ2ibJVlbY9CF6MC7OrJplIb0ll7eMr5aKn3b2TTd++P1tVX9UjB5oumRPe48nysiw2SaQq+F5wm7xIrdjqeydo2zmH72qtSmkMLjQ5PT2n2B2U3JdTM16QFfx75Wv00PSJXpHU8SYdOl1hXQ4dR6osrIhyOS7R0O33v3ka/N8F/F0GQtNAo9OL3i+whYTamXScolPdb8n6LWx++8mWdRapez14NJeo58RIW4ULdYD+/5rjPv+qbyNJ2JldbKcK8R5STVDat0+tVOaGRZmOUMwuGsEg/bev413ILjOMKW4nQMXP5AAp0bQPVC+1dwUUKDNGc20EqNaxGNH+tY3Vz8tJw8z0/+vn/e4RPdIUXNfcwj1Higudjad086hbgaUIPbfqeq8mXuQMiwUP9qwtfWVrFk6Repx8D4d3S4wEqVoiZ4tdi6b1NoGpYGsSmvG+cHTn6lSW/buEeOAToN7sYhO9UAyCJiKuH6s16J0RpoEgKJeZldTi5rk85zVqRHGwImqQsCad+WSOTiKWXcIrpiOER6zuP3SoeNor4FKyLPyKWUZKHdPJV+6nHf3W9/C3h89cSVAKWq34TN9V17E3KOMOqaw0X0REqPAagER/I4gO8mUQW2gh6sy8BafhOJQJ0oMiM=
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