dZPIsP7C5jXn3/hJUmgRz9z5jU/P/bZObqfn8nA0yR+xT1Y3er9HauIh+G/VnSgwI0o/Ocvf5TsCgBeP3bm/ohF5ET/ONC/iq8Pw3TzdGM8c0WWxDH6Qtc1WcnY+a0DURazSLgL7umX1n9jil3JIqi8zLEY+OLshLeeIjDhEjPl44V60yE3gjtPUiHiWALY/tZ5kM02F9i1kZFNEXmK7v5R2d/0FcjRC3uCdB163rX+DpKU0/J8M+KP1UTOyhSJmuBTBic2giDhN8p5E4ksjKYCGLMAYIdYLdGy4y3rjvI72js/Eks5PZIKm6zGmWRYRHTaMOBgHRu9YYsILvF6I6IBLlBbkSvE0eRoAys59SA1yqVX1uN9q8PDhQynSAnuJUvr/lEyfAgkQYHRW6sbjGP7FxTABBE0XjDOIdMGDe3R/XBXlGVDyQVHGqcBTIJpmxt5N9OW5TCaH8370y/sWLfjOZMKr95jnwsI6oKNfG0nrTiBJJBPOmtG8MxItVew2kxKBGxTgXrpVq7ECq8Z4SesHOJxEZ1O9AlOdGHVnCxnrPeQCM6lHCmDHXHMltY+kLL57XCZc/54NltgdYyI6Ed2LjVgnfBiX+4+VnT5cRtdAsFbQD61ea66su/SbobDQ9EwTM95SVv5IvzyDoBBWjM7IUscfivsx4slUlZhSD2bvMNFng0mDRuOQlhvt3ByQrIpOGxFIdBFKR886L3T7wx2vlwg8NhDE4YE2LkRvBMQNAZ+gyMn0WO0T/dUgkCf3m5hBDtxJ/OugeIWcbV+CcivwqI4YCVeUzeJaUj+MX/EcMysRNq5K1CkX3qFlva0RYitLD3HRySOZ/1IgTieY+ZXDNt4o9uq8r6Dhe/sfqP3TSBSn2vBR5RniRc4uo0hpPqHs7rHXWBBHXbqlOCKYjItmLwn2bIz9DogikCFQNmccM26uxrD6nobb8KI7HEnBJ/TeHX3Jd7NfBSx6n+1x5f1j5BldJqVCo1MqHvdCrs39X3a/TjrWmIuDRphWkqGsdCP9Cii7D2uuLWP1QR+ht7H8G5Exji8o0MpHooHdQCvXo4glkqT7YebZsKgw7f4+PptKAod8wby2LClRXZq7YqFoQEklx7AOqSw2eUkh5KC/YxT6RdF+0usfOe6kuunw2H1719kt+2wxQHhi2aWiSOYCWZoFC1nsAPKQD56VHnXTcY/TyrxljfEWpy7vKK/q+1DiljGRkKMx3kVNUSaZnswQoDMCKFxrS1Lf2a0hRTOxyu7jC4S5HPaAERltAXv1yr5WIW8bKbnyaGtJUzhLFoe9VCU+OpnKt0AMVnQgGHRgX1iabbZ3QVr8V38fRQqQ8p04l0Ewt//wOx6xG7q3DJ51n4CwvOSZgVLpP/8=
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