sQrVsys6+Qz+jpl1PRwguPrG6ZZOdKdqZbjJjORjwbDPIoTfJ5bMhFP7/CZJo6pwx6xdRDoUf22Hjb5Uqlgm/pacl/B+LlL4NhxM6Y1+bcbvUf5+jTD1xY5pNF9bbuhtxsguKOdKFeH6j8Dv1DI7rUWSRdacAasgWEs3Nr9mKeiOk4NYVUb1U+6kJtMofuQlly0Oo1xtk24G65/GcUyEgoFOqOLTLkkHUD62AafXFPfd8Dq9pbfH5nJ4FfhtSHzZaVUIz0naWmtA+Xr6nMdm5JUG8tQYQs8s18BCqf5SkmLAGihKPqBeHI5aR/yx0CGRXg4K4aAVMJ2S4Tlw2RRbLzlrhzrdVy2AeIokBD3brDhCctUnEJWFFgA0eowpiCLOSrsYTImcYNk9EhgCLMqmwkgyxEEYHOoCPFzTmB/Q9b2Tb9l+At4PeJ1KufW5E9UpOfayyA9zMCc3e3QFe4pedk163/baBjUn9rR2Z84ygiL2rALpIANbbPDCAlGv8n61pInAFoXCVBy6rawrs+VKV66HsSJ0nKmKlrwrJoH3u67mzaylthM0+gt8jHLQlaR7F33BHNV+vOLuFXZWXBokAaBnYAiB+A+a3GqBTqkD/CyUgin/zr8/PPl4yrd0RuN2VHvHsv1sbiMiRvfnpf16XvVUgRrSSXXUZc3xE9PMPFjE3RNgtg65pue3cBBLs729JYKwQikMN5n8ye0JXGDSlQYNTylcRYSxXqhRxuC8aQD3zVt/oLjX/a4ELC8byrD0XgM2uMyqs9SMmKhf+0JttB7DOqHkgHHw26PcuUW5vweWsHUPMq0e3UW55UDQ6Y2DGBPqDr1BAjy9K38ytwqq1coMaB9HFYJKliFYDo72JEwf8QybXZCKA0+6Sj6biTw9ScojbyEXUiiIUJrFnKBRmTZBPqmWsvVzZ9IGASOkHoSFNtNFywZ9pgqHRgUm2MHK+SFcJDBOMejmqe+XOpaFD0Dfgckiq/8tEiZDfwFVHf0EcJLV2OlUwZUFCUApBCpmEKWXPS6RChxYyx8ikV1lePa8aIj4Bey+m7t5Hi8NnsSM49xuReBgn/eQngYqai9UkBMQYe4gfYQdZz3I+8Q8ZY5ACnM55cm6Qglfp78nRtY7yWVtgztJDPr/b0ivkJPhxCVVjiKbSDdM6TqAXfbwy0bYei+W4YlZCujNIXNZPgDDEHb7jl0b4RocYi7R3oUHdLo/SLL9601KJhNnWpsyIiCosknBhe1WWqge1qznNIa5mFmks5moDqoGu19ZJBp0OPj6bk3d+g1QROJQOO8cNFndXN91kd9Awk+LJt6WV3cqIhLqElOOeq9hVj9RYBhBbkqOXtZoCMI24AMHBxqLzN23SX9MLsMWfBqcSQA=
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