Komo0BWNRt2HH2uTUuz+WgexgWYKCc2cl42GXbxu440GcHFSNbr/ngadp1Zi/JnS2MzjL/Ov/MV255+3XK5sqkpEAy7aruUcQYtsxDEx7MWSt21tqumyIvujZcll25FMsSDVtrjxOA3Xxx7I9Vqm+u7RDmHZKptM54jeIXQI6FnQAoPvqesi9sgyrROqO+wvN3RGU7fkXYXz3CHCQ5/gm2ew4ng45ZTCXHzIOsta454JIyIb2McoB+iyynRr8bco7GmqGKtJBlMNaYza7Lm5N+CDZsqfDmcZB2pJ+9h/NVdy6EZVbYxKrPUJ0s11MWjokKNCa2PoBOZ/c5NcU0e82G4ZKDQA5Y2MPBxApHpV8I0JopnpRDmnKXRZyuslS6VtDNJ6Y5jHILG0EWN9OfdoJsLdY2Ae4t8aMMLqIrcLt651iUXLNqZZQk7CU9B2kDlMvk3QsrTZpkj9zVk6fERmEDZyicZydiGXrNwiwSdnDzSDs/IDRm7X8BfeDE/hqG3kn4e5CT6jC5fOUsEkhAlSme1KUeC2nu8xMKtb2eraXuagne5Sa1Y3hE/3D1674ERt7h+oTQ3+yHmxNbXBGJXHrgGRG6XbfwF1x78SqH2hG73XZhWGPd14f3z55aFqwl3relSTmHPmrtggikleRk2Hl+fgzth3d0jXjVVMbHQP9am2JZtrSEq+7vAYKunp6uZRKPn5WXz0GUmmrzl/oKEdO8Rn0Gwy5vJtKFVPBV/BZuBwd23NmggCLMAlzJbb78GKSZd2MEakKYZSLjuECsdmGiZgU3MJBCUxErOUEwpLjT/P7l/QXVRkQDNxereAzJw8ifjby/VI5HG7wn0O8KvXhgmM8UnfkQjr9YHaWVE2GXYzNRd4EHhAAmcTKODWEFd43nL0cvkW+i6GQxy9Hebv9LEjqCpXe+z+nod5YYwkqLxc8L0PP3QQuFX6DL2bI6+nfezR0lYFygM/DOLxltcNOdRfJgn4ho90BhmjJQEfSAyH6eSa/2psBjzIkhYTuzkFrB96KmRGtPmwBATZn8sktG8z3VdfSiyfl4b/pt2MVvMs0PKuJFPqIGCQnQA1oy+m3jSHG0jzf2As98sbKBlesT1zLYglIXBiSO5J+Fun8xdKAsGVR9dZqSDzmDabC9ZzthceFDAtEczg9P5pbAnXQ+X7r0rMlzNb0QFp29pIrtKB9yJepziL5KcPHWsoE87cJ4beX4pZdiPlPzbLXUMTKB7T57IyQF7kyYXV57aiQaeNyytoLcSTvQsTQ6xliSTqcECj0BLKnSAwBrHVKG6XP5ZVVkytUtDzUtvgjX5vdVXqjXxr1PWIEOdtTQJoeEFdTz0d0jfIQOJDmCvBPM2xBxWOk135EWKMFrY60+A=
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