WEIx+JF+UDec0W7uaynys7A3ph/Y0bPWKeCI0Cjm4ccjCWulKkCnI8ctDD2eN59HdkIz39tr01TgmbicFMLH7Ow/CHEuYHmZk7AVLYpEc+DoUVTs20htPwPS/VC8r6RjkKwHdshjSPFmv+M9QCs5CWBhxTBxBUewEH7wTcUZ769eaECRzzCv1Wq2jXgie+DTnKQtNzZ8kvbGT6uMDMXy6nlceLjDTPbGZ1iRGhtCpBf9EF57ueEIHxrRCMBHkymKqT4LUouBQilPG6EdzoHFPdPxmTO57SkRXv93kmECVegGdmfISUed98bw3iLTF/bPErHIz/5U2A1XX+kv7/yRyhszIROzcrOANsbQCRh9OGWjBAX57S1mceUm1OW88uf8B+SHfOBy7T9U7/ziZQGWDHhmbm0NgrAMSs9UUX2oawGsXOu8AwDtjfZ8LVPQPUgT4c0mPxSaTp1KxW1C1vedfjS2+zgqzCZMS8BzPMat5Lu6Yk/NUqDANqYunzp4am+l3syv56nf1N5uQmfC1lWRRT6j1PZBIMlUTnIWXR8CPbHQWQuZu26yqOyTu5gluzfiJBxGkzBfzmf6KdmyXqtyQDMeipgM1L0KgDkoWVwVR35jyfBuQ5KzVVOf9GrrFN+IiISPTUr2Mb69t6DoIpC5SWkjTygXL+AIy/S42EhJkpENQ6E9i33kU5o2ZzvihtJcaK4YONc7AcdwEHv3ctLPL+W2SRD1coPLrimfDASFyXeR4yq7jCScXW7W56uSzMgKvruWiSkjmTn/+f6BngJ1UgQXGgKDJMa3cbmEu5vLulIkMgRfQrZFGE40LD3RR+uxcmjmKNrz8s/5cOChmj3sBwH6AXqvGm4jE2lXWEa4zeMQTmOYfoPW+/RxrEV2bgfNTRdbbPMP8/pLpuOypMEmYgnrSpYHcCwuQpUoVys13OkGzaZjEHt87KfcO0bn0DgsebzSYIQjqMbMWce1itymXKyyOwmPgo0jQXIiIIBl2UYRnrLhYB0rGTWO4SW4M/k5sKGZ18cqnXN2eYFywGWdEhulcPpS3KtQRayny7ZopoHW8+/vjIDLzDsbKSes6EgIdx7zg4u3uoOAms7ofQc0OHXK4+rkU0CbRnK69wFymThcFQP6uLsdaWS/uDflr/GGHLLThatUpDBGGqamk8PhTH/4uYAzMKkI2rfanO6foO5tVvzvvWXa6FgOU00j/6piBliJL0HdQgqEgPRLBN1YtsgJOBH99wmP2JVpWUQneeKz/aJLmjpy4yzED+1tO1zqQIPgo98Ucx7zM7+8NVwZwNjFb7aPiBoqxDgXnhP4q2EG7NMTP43Kf/eFljKCObcNOcGlnu10ClDOU1lRQJ3MWzm9O/h4RCTX/pla2WU=
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