4lSr7+W2IZnRHlY2/aE4P607q0fPothIu44xNYHCRTE3BEO6olvGGLc8tYgi00z9LKOg3Cn+rvuA3hfTBddgvijRTigc7SqdOW3I0Tx5AnBoTI5y9lFOsWr5imzzqk6BnHUYia7yW4T51pJgUL20q8M0OU4N84zM5G7abgPaZVaL55BBqhYzU/c623u80xtBuHgBuG3DvSQJFd4tQfq5gjaRQQL6emO9VOgUEV51y7M1XgyvPPt309rhtI7zX5RqACZwpaVzU9E8tdriotToLoD0YO7scj5xQrAfg97T7PaKjVMxcwEVDkO/1uG3SojJPyC1DVX0rsleudbh7SzsOQuv7rhNjKCcPdoK6V0ksLSiuJoHDqtoMDfElApTeDl6BH3G5m6FobNCmeJL1KQcKVgzY7Yn4ZmHt9zqC5CeE8vnoeNDU4wwaO8EGaghK9tHCfrxO+JPt2KpHLGKh7uVDOTwuGVdfT0j8t7bqjXZFYgOYET4vjDTzkVPGp7vat+2+WJti2WdUw/RYUJdCSCaDmQ+lETQu1FVYV2+RZyc64gVJv4H8cpoU9ZW/CqZ7XRKrltIibus3rJ1hyJ6BpFcMe8CNvFx56k7iJs6x7PKYX2r3MAEsMrfhUWAMjIh5jtlv/m9nXlwoo/sqLuRuTgUBPNWlTYCwCJJsQQdd9CcZ8vanvcXcdmGxoS7UdTGcDBwrErJkGtUBE8w/OUn7JNAWGssq59mg0znFClLPKl3wMaqTLJdi3JQ8tAPA2SDncEbN5kP+wcUIrgzjNsRXKW/Hff+A8Pk2xpJBJeLo2zBPg7VcWVSVOwMDTRvwYR7DP0KiKQyU6n9DFPQ/YsJS+Y4zw0kBQD2XFin9hzaxqWg2Wv1vmnZLt6SWQqYalUqU3og81QUJYf8NcsWWWKJ4hcWsKCMYKZWrcAzn81jRuGxI4oJC83mq0d5BKU4SUKZKseHE58vAwE3K/0yI5LKT4d7t5O5IMRJOlkJasSwgG33sMOhbKU1nrlj+ZtXFUyRnPANh7XO7VXD/pwXqpuUdhSXdb8U5rYgn8XOT/w3SVehnSJ6nP1XakpYWMlnDN2r7drpoiOvl0eVA++5ij9SUmHSTDuqoTianzDgFeW8JxeYFIAvF9mlDn/Y4BiaeuJ7DCK+aKTpqxia4e9LnQZ+mBM2bGPI8Rv9gUCWWzKvKjVPQvWkwl/sJwloVvNbZbjVoUGabLkaQAQsdXstDYuHZZM6k/jPh3U23INAPFSj7mrahZ73U6HCGRhil1GInd6pM1lqhPlMwTwweBx6dmBsZJuTUekikfmtALKGZOHKeV8IgEly/xCSrBV3SbASCunUdQAYJZq0RM/jMP8S34fRR4rpL5FWL+gLWJoUZeP9l7I=
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