DzYMoiCOBiEthtcZf0FZO9zv15w5pFvTbnsJiWxOh11U1qyExWwcKYJkFS2cCYqEObm09Ai24S290TZ0xgSarl2jZ3fKZiVoTIPRNGxZz/oihSTWbhN+5rTSf8eblwHBL+ol65lvwMqU9NmhiGszX4mohtkYV7V0ad5G5ZLKPkShn811lX+uEB+hgU1d3pCNx+CsE51f65sQAabT35opa2DyXO/lccnh8Z3f8axEpMyUU6D0jISlSJgIxROgneJ/AJgJ4ma6buHYVbHJb+wHpgTt6xli8uU8oE/Gpg6kWjuKqKlJCuPw+GqFDq5H/eu3zle9XXNNCQVENZe4smCZJzVOFiECcMiArKEybtz9F6WlylqQKfAHKHqNf0b5m8456ZvQhQTIvGK0qpyDC+bjTdHOukq8YTwmrm5PxfGfCmVNQ70iuaw/bZkXULOSCfTI/wZps2E/1eLzijPwSENFrYW/1dl5VEyJcMoibBwK/udNz0cJ3l2mlvuh1x332rS5Q8FNd/hsOjqbzTpK49rCmX+f/I9P4KT4DLXp9rw4pHby6jk43YnhdNZVvQf16poljsDcUzk/Ux26kVtHfjMP7uSk4eLaInQgtKO9+ZZEZAf7/YnVOEUNVxfDtlra0SfdKmeZY6bMZi4Qw+yNIPGDHA0j2BfSD7BT6raSnMaXRwtx6ze7YzrLng6lgYkdTrDlw6IVkkSH75yXFoaq2oyWLqrEdhYZASDr5rmkJpw8kcUGjdj3HTZ5KCzbm+C7HV3PbZRgMgyYu23zzaIB1s9wqPCgVOfE6CFezjdNK5/jzoTA6CazmnbytIxEMtmhyOvbuQvPHTl1YYhT5lmgKeL08MGnYD+sk06hRfmza4XXBACTveOvSn/RqHzGWn98KAzXbkoJkiYGxj8oJbdNduqqT58Ifp2pKYbevSsf1+pO4aLIkF2RPtIAtcx6wtNOHzTt2HXhi4RgB1iqXU6M6u7kYME4zkCX/uEPVxXJjGLt79RpUZchJcHSc+ZOtzrSA8n35kPgF0rJWoAchjKXNJjvk0CUtRpO3TvCC8dQRb5ezjuiEuL2PEe+CBP+kv3r/g6w5pwsC/wV9R31dtYBmxkqs3m2CcmDoTh2yXhCDZ941D8/QC1GkqTqzDhPPpkczoNMFx7tk+OvSmm5CsrmkMaE6LCgICswX0nNFQH1JuI9zFuo+mtXD5alzcJBnc+DnbiEVBe2gorFpsumbi8NQ+g/6NfsKldDsG4wBFb8+VZY9R3AvSgowTMwFrldU/+OvwMqbuK+oPGtcTaMOcLf7ten13XFFA6XgP1VkXJCdbf8bkV+aP5CpXsi+ondDqNof48NITefPuIgl2OI/v+e7hCosoF4xvbvuTHsnAonsOU=
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