Mrv/JDJ/BHqjP+HalKvMKC/fyywMTFJNNKWqzzE7VuokBQNIull7wF7l0simdEh6lDvct+hQHGDhItXyyleYy+1vGl7P7AWwpb7jHMbDPaav6eI+4ZnxwhdlT49JxKDC5LhYi+rA8pyTTkCck4QqFq2H4DIpNGoVz7szoWR9LSr/K/FKdSU8+9jpDLnQmLBChjzAd4vzTZQKYbWdidpy/iG5DFZzdytQmNCtsxLwAd4tA1CPXbjCnkNpXbWyKmu3P8339x9Flvp0Lw1DphXIBR+ikXiPad3FC2uXaU6WFAvPqkoL2Vh4k+rNi55l2JRJTBWfpVZ28D8cIi/QwKphU3n7DnIoydGFF+OJ1ORcY+K2QVf+RXpEzaGfeLLjmbNhhGkO+yZflSb68dndAMhzmMlj8/QWycdStWg+7fZrqwvA0R82xYJiAs74reNr/7zSkp2RjSyGUZXZdug++xZiePLc9hYmxlZk8Oszc3auiEeOVpEn9FNSM2SJSWCjVqp5bp5jXCoHPuTIc4SM2lOhfqTKaV/nDyOdulRqZGHCjCcAylhPAeY5RL62+u8b3UI7n5IIjE2PjXk3Ya1EmLCjiKg1nrEHJVKeyWFnwIc5IcZ7/zRK6g49lYxfgbNu+d5gUYYQOpDXBF3CdYC/QHzoY2P7gHSwcGIiGzVFN9+xHw04DWxcp3IZdaYny5s3EeJ4kr9wFOSDj6mCBFMNY1kA7oHdkTlrKHHxX9Qka+BdhCW+lH1C2DxvJuYx5ONdI/FRsRokKOKlNk8XlcnI9EYlsCw7cNXxWqGdu/G/4atlt8CMrQmqniPKtXqvj9mjuKLc08D2StXHs5tG04kaMZAYbXa/O9S+4U+VFc7iUP/q24wZBlk+zx38r6jYf/5j3ZdNgPUYhShXih9C7ZwYHAblgyap55m64COu4D8RxaBHy9Kuk0yXP5ry7eOpTVLfAbtHSxsF3osTeINB0P8VKujNetGB3SxsH9zTA2gEReOUsh1Fv855TE5U2KHnZ6PBewZXiJ68P3RaFRJuyP36T+g0MKnk+IPcpGH4D62kjKa0SBTFrq312jJCufnGyup4fztdbyOlys4HdmVIID9o6iiqaZVHb6Cbn9P5JxJMr/BfRCPptZBebFeYB6m/HPWu1c8XMTHhdijT/Aet3n/IZ4HKDQVi2dQZHXZecwp9dtXa3Ia0l93s1mPs0WBd+3ZId/rf6uqEeFQQGx7lHX4Dn7QRb5y6KPlmD8M8BcoQyIeFkjMSgElG/H81fd35+mM+Y4xMAnED9PJ0dy3L46+IeW6S5voJik6MRVGfseJgdss0S3sT9ih5bfbqjXhT1HEnGljaggwek+qo0/4a6VX0DBsIROSB/5jRJE4vuCNhLFE=
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