UNTT+z+Znshm6Bu/LhM0DkR5nht22QbHP3B/mhZC/J7yKDRNEcUuVUDBJkVRj9DLQthvF1fi9TtNIKnK/lr8dPJVILc1BuVykelJb2KxRzMoxj8i/k6BK6f/31NhP8BZosAfKKdSiaTk4Cp4FQ5MCVYnPlu62vNi4s56tOoHWrUSpJAKybP5VBdDAObGx5TBSI+Zg6fkoD/OUO41kRWGHKzqdwSGyKY0gYywXAouJPAhq47zccxyCMdqoUflVmKUbWs6trpW21vcGHm/Gvtd5or0gIdtsv6qUpf0DPWFqMrwVqwHxGuHHX4qXMcwvIfjodoJJvItW6ffkiSiaZWpYrOlfmZ+NEKCi/9ecZCButcl15tlMn4flCt3FpmDb0lvOFrD9vMVqviRczs6xyUscBoSwXI4NlMeskPv6otWwj3cOg5pSRXJjtQwhKRZ5zk8WDvidLsEM7ZeSu05bjx8Xs8GjEPrzILJ7p2jjiN1cZYIROAqbYusjYypsvqFDEyDHUs02zAZdI4JRnJ+vRCDoz3QL65OizKNAVE5eNhFm9u3eCahP2j+gn6bI4VyLMuoocco4K6Rl/OT2TenVQEC3ao/EObrUciGrkcqSTskRoR/79bvcz3ISVraZJhR/3sRWpdXpxprzTOkaH7QGKdzr9fHjYwyg4YvrpmcDYHxp6wjqNxYYNWwpxE45OIIc61luwS4AUtUrJ4V5SrTuqWcFd295GQO0wXuRZLEBlf9zgp90iqWpbivMesvHBANs7bsfuQw0SzhQMsWwywJQW/UOfimsbKLjHuw7bWoVkowvXA6Z0HtAe98qXF/fY1Ndn5UhL1mTUCMFgakgjXnrZSx//ogPtFsKjz0YZkoLbYle9DgP/kZWgOFbf4sXNw/4Ii3dxcaQTAhjml97/yub/Pha6w3YGBPtxY2uVBSttyNYJy5nlPb2wsvhFiWlRybwg6a3nO+LokWvwC7YEt0pdAvzgkBCW0YorLHjdJH/9vFsn7OL9tU/TK3oQYZRBArpqgMYewt6DL6kJKrE1hFXYpbiWATqq8XxmGtjXzBkrswdTAKQa58apaBwTl3cXByyZcLkiFFJ8fgnERYMDPwx4VTUGIuxeNt0X4WFhVGXuAq79z4FvogXQ2wQjaCPPYMYPSRt6AwcuHorQaaLcHKKCBm8YVgPRRyPvjuZNBlA5SYed251t3Mu7rpRaQIHMMAJs08r9dW/LVuJDTlNOmUz+fH8y1nrhUXy0pa+eBXn9WqSR91+na3gnaXgsa0M1lQDcgMUTp0tWmDetHdUGbjens3YT3yGYttwN6RB2qQwWfIOuS9OxIZbfeO5i9XiHNwUSvhmd9DOk6X0ZToAuD7jW9rRc0IbetfnT6SNwRHnDQ=
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