hpLleM/+Rt2kLEMFFOwtmRJs4B7/Pk4qdLmMwvTdIa3rtw6drW/pvljomvPGLk9nzQCniBLPSjowlfzgQGDrqaaPWgG4Up0x7uBe+IQqJZT9WcD9Slu9JAQemZkF/G25h5+I24efTVNUJ4ALn0hLoZgEWJh8YMxCoIma0ywsiI8qEARnVi5g3aMEglUx0BJaVRXWzqC8el7GTOqVr/+VlUbTFOGuZ9zvY23F12Wvrozkk/Dv8GpNB3qZ4dN1DJPmmEZE+cP0J6bgXzXuJh4H6ajQOIuSsvckusNJA+0carYmLr3TpXuQOqHcOqTAKXyPS6sVpvdb3bhiLTyiZk9g0bO1g1C9UTWq1swy38FRqnO6LYOsXxF/fopBWmM9hHkyYmGv2hlF1U37NCjDePHJ262I/z2cYwnLDS8JU95Lui4jCvQQ7lFWzj9lPSgTAIx7wdqFBGHQ0W3UfNwHzeUfgD8O+z0mf3LPSr1eTvMxmMMN94dMh60XkZZzOD7t4zKE3p5Ao+z2RqybE+d0Rsz5QXEwU8z07b9ylIxN+42jiGD8pwqtbB0coq5b6g8bfO9dP9pxLfTqhclmtmE8d8k71X+6U6EPwYHm1jHUZzQD2op1fHK/+NCrcDhC4NOlAGW1pBqEvBYJwRgf9o806ZC7jZGq4aaYLppppwpbAT5zEMC5jGZVqoh+X90HqVFSaYE7HnTziITmYwD/1PaH3TWyByWqzT8d0brmfSr4QWrzpjporkXEF2kdl/PwfC7HFkSS85nL6gNaP2QTGrbrmg5Bnu0+ej70sNji2nEPOu6rhUX/2dzQDjHzcAFA+he3e3N0K+sUAvwSIDDiISwBu/2mq9URjQ8I9Qy3TiAom3CtqoY6mz/lSHtiniFT5BoZ4Hw6giVKqK9RSSqXDOa8fEQCyuvp0WG2BGQNsVmrWzFA8ohUODUhwqLDRfOwbUWWp8IBXjc9vpeCeIbfb/Ut/OL6AXPAxHPGcujG4Nh6fkoXTOWYXvUl5B0Q7deYuBrYpPz2jGOwIhXE3ualh9JfPZlH3IkdU0IjwICfoctng83R+++7F2SF0LGEUqZLC+d5Xu60VEoOBVg2cXR++W8KBei4zhtyZjU44cbHoTeso90djNKHxob675PGDCHn5OH+vnOQcIbqfrm4FS7FRBHY3eCmm0QSbVE46GLoHMUV5gipE1s7f3dJ9SDyfqUU8Ois9qYQabg5QW4N+ABZzcYEvP3NM6/FyKiZqmAP+dnzAYrB/X8mTotN1tx9pnp/bieSXnMGpsqYF6GAikQ+u6Ok1F+ocA5SXAA81w5y2d34HjMzs8LQx93xA6VWS2WfynctNn4LSOzVHThYccQmt1UHgktGZEJEWvsgcGsen1M5q2k=
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