265DQ/pX2fk4Zr2thMOA3+Z1IIwg1pc2gJ4iqIuNPyrjltTFuWnpqiUvBW6ChyVUUsOPRaeGg6b4nAulCJD7yorXGNAsw1ZfQUQtoVyu+zosWAaULTwYn0nQzIK2uz63MidDbV+G52LdAxbCoXze8c7c0TPVRQr8fKh26EvNw4QF7xdo2LzLUzjXf72E1GJDnukeK1L8+BC5mdsTRqlLs/3apRBua87Mx8uOZbntJlWVWgzASvhXEKeZSCWn00SYzyS1IEZHoMp7MCkGecxVee7EJSVphVZ9DuKZVJ6l3FZH/upyOfNUalWelwb3FHuRF5NWsCxyB/CFszC6ZrbWzeUeX5c8jr9GOIUMunnj+uBXx3VColWql94d5ivPbhkjJcvVGOFOLh4BlAR3LviiaUNeYiUHfBZwqqYUv+zOhsr4J8PEmKyUHLYkhLTDpXQstg7X044PnlSAxV1S1g462X6+iJsAqi0FHvSCh7A+6kHbIlsymPFYgy3OdM6nD8ZS+RVymQjFSvIymB40cQUAH7Bt49NAleMz3u/+fXM/KPKCv/vy+YUdNbzMdBxAWfXNqajm7nCUqUVnzVgBuZKbTfWgAjMwdn1SXNqTxVRnZhFnz8knbIjxX5rWX3ZAcju1Z/LqnU1SkSCrqSR2DdVWQI0fzQu6OdxaJ9k4LnulkYUR8Vld4OY/NsJG3J8DnMaLlUdNLFQm5OQ/zorm4Y+95bECtJCvVAQnEkKMeu1DVqz5nKgnH8wuVHmaxq70aZAvjSFczG00SH//moDzK5IjylQBuG1TdKQKgSG0y/67aoP+vkrZRBqKSAlm2+Krd4XuFyJcP7w7hRGfNZ7jIEVLhe2cW7CBT4zBOEfSJD2+BnONNLeEsrO4MK5UA0WygWYTxQJTa2csJYJRj6TD/ef9Zwa4Nz4Sogi1eNDdbSJp/yQsIlen8AuvYLlyTG4vN8XmCwETDkyrDKsd6Z+FmTkEOiy1mo6+IrOR1ZGNYwP8TCFWf9Cax43Xt/erdm4tp6b2/6AVgJR01SrdSw80oEOCj4FYwJ9XKCRSOD738X59zFvcuDeSuSCz7KU4tBlI64sa85AINbbV4AIkgeO1yvZu/RKMDTn9BDkMg73W60osuLt3odlgWURUIx5FeYSVmVSAkDQ4ZrcNaLljP7Ztq5gwtub8ZCjHZUs85laGhInLWUgk5FyR0oAiyfNhjD0wTpGpVaqUO1mn35R1EIFgOigyHugT7QJCgsEAspBVpsq7EeFUN12G6FgjIjUeF2fl5eNSMhpoCjFQ0osmq9OMC16qzhkJZ05WcCf5gPQH6tjKpEjyWlGStZZMRCNTxfJbB8XNj3HDXXy+WFgugnyJsdJG9ISJBoMzTHSKMqm0kNo=
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