9j1e+FUvAKL1FthZK6Z1rp2j/1HZ445tRFiSEubS8CVlRXMQHQ7ZXzjTrGU1J695IdlRYtcrTEsBF83unAQZXcbqos5LbnrQRTbVpGnVisM1xVE+CuQZPzDk/XhfMVGptsYZlpeMYPOfENbCR/zk0yOh8LOd1xNIT38N20clYZJy+sZFkCin0F0I3XQBYIL2AFumZOviI3j8IPY6SdDCNly1fg3Z0T4dPAmVK/AhxjC4TgGXh69qfgnaNM4Y+wholFJO46Hkci0kVoIOW3rtodyBHYWZvURvHjUAHI7BlrBrG8B4b3pAybjIzF20kq5KPJDtv1Arlh1FFju5MYkMxE1sl1bziz9Eu2Hq5CcNCGtlBWpN1IWsacPtQf3EAEHTmPbnqthsDMHOHh/qT556Y9p/zTPH7+HE0VbUnounePi5CEqogiu/N+55NBv0qOxUqx/tQj1pcLaH/TdPN0ftCXxe8DPVfrxaj1hcehHHMeF0INvGqAfNSbwDIMWQpnj9+mX+EGwP3UeZlQMqwpKkMoEmODqldTIGtFC9B6lt1IYS4BcHeW3y91G6T9FOG8tHpJMGyb9UZUU2jrmqsmL/dkqoMypFlBvfanoc+N9o/WvOpwRgSnNAsOPz7nf/munSbZMQNC/UXUBiyM5WExcjFlgHVc07QaKnFPyEmcGEzUzX8VWNLYqCuXo689VeddOf225OmVTTTz5feBRR2dgszNP/iu0jRMn6IjanR7fozdGaX4w30ZB3id36TERahku9VQVaWF/r7hAILlDG7hpZcrNWQbqSeuVg83+OSfnDlc2VU6HfoXLShk8ad67nMGAenRiC0bCfg4tE6DlTaBRo7T1fUbN6NKhDErHwNoLu8oZTHhI/bUI7mmpG/UOtMADEN5GDXItDW32rNaR5RCgaqxQtieStsr0aVUEIppmaCKaYIEN+gp5YdzWlVpma24Zq0xMgjYxFQCbzHu6IB9tK5q4irQMwOpUMoxZOkrBseCPCZHshUzWjNm4JXNz1ko/M8BNByKnQFAxzbh3jPnewZE9R1KltT6fJzcPF0pUvSMs9tYXrYhw78EaHz9fFxOwsv3KE9S8eiA1t2J+OAgDE6b4q7agiIyLfnD1oETwziaHcwKZBb2UDO3Fsn1vswESgm8f+xlQVVz8XxPojFyUYZA0q1D2U0RqmZpgsWobWjzFNMEaxOwY8uWe8PkRRl96g+D5S+vXPqpTrFknQ8dXodygCfSG49FRTuiK1UVD85s9vi0eo/HpcmarpB/WQv1Rg3X9rXdoGoOXwuDhFy3YPADSIG5yPie9o1f4cV5kZLf9jIqLqG+kjjflPeXGzQvKzhry9Z09Yve2heKeZcMN4YNF7X3VrLXj+YHksJ7s=
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