L27d73QRCIUFHjoNNeuiXk97Q9YxFSWGC8CS7d9EiIfPPYHpNm6yuAg2CYj9nBAACcYwt2m+cTrKK4jA+zx7dGul5xgrUd6Y3SOTyQI4bNdNKft2P6iU4FM+PaIj/v//KNDhDxF74/q+kS/9qcc7h8hV+w7WxyVcquF8aJTxlyZZ1Fl/fFXrVdjLZj8gW6ocHlA68B8TreDxmwYfYBEXIZhPUrmpMvctto7IMZ3T3ev8W2krVFB61kJPGXP6Gh792Ft5NDm70VFWev+fnDzqrH3VZ9uxAcdGFO1cxgJ1zsBD7gWLhDhSFp07DYAmpIQAjPuUeCP/yFj6jhlNlyW11dGAFwyDSOZQX2Vdv4s/ZIighqpL7IP9uPgoUwMJ+2z6JtBDoKsDwNNVawXTwrJs/vCNpUOjpxEsr7jYX0rvmlW8BNat839kkWg1fhBwEsxAwRrqrxPeu2hR+dCvHEmEewLnY8xyWPkpdu4dgAFQUzHSR1ra4/Z91IZfbHgCdXETM5z0H0gB+3BryCC/FcD08JtLZoVkZbKnbqnpoOxsahgv2kg21gIIK/v1KFA9gWiAjRCdy63xK9yesomDuEOmap5uIUsZwCVBNZYc0X/ePQuKZO2e/1bGF4Q2LTmnfb7TOdKq7I10KCbqpwb9R91wjsIGzmBrVFxk1IcRpxSqzPFOcv61hJRIgKg7nSOplRSxKlGrrHzcAa5FQFhLlrFNqQHkBj0T2eOjYFdMU/rih/VtyLzDftpdlu/GSk4SUfJjHZJw3wPTnXeMC630cxBu74W+DveFsWkXgMNDb+xDYV4jEcksu21eO/dDgZwVRV8Fp194Mk42sNue1tcU8OlkIyfRdsTrYHC+geFRZ7KNhMwjVIxcT977/jt8AwW+r/E9EccXjD+P6DuI721ffFlYxLfoGbuDru925iO7bj1+6fBXbWTfuRw3DhLfqr3xGrQwaAVjC39hOnAp+KOc8jCOmw0WShd1q75csnHGqpUkmah4atSbOYg8cojh/oslaARej+ROFMzc0jbBJlVAiq2KTE2HIkcmJlJ9UJ803FbJ6QwXS0fFgo1qCN4CmUvB5TYDg+KtE+LFo2YagNMjAbhroPeQaqFU7ZrYqFHaeRef4xe54DvdyvL4sgBBaL8fAvOJicQURyGnXzN+KfYCjmMkOxPbikPWffV7X0HnnBQ8VYMf9LftRyWrxbPslaQBAhCeaXUCmw77Vlt82338z/hHIFzxd+u+P863+jDYKy8f87TZu97WScGXtu0lgBdqejHpD4sXk5WaWveX3l9pqaxKsHw59iD26T6p8s9A1RJ5oKYkdgw6Xe0VS5zg4KjESi5wjk+fMYW1LArJcu6ut7QANqhBw/pBijMNkeskye4=
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