8A41GHfRJdn4ae3zwFvF5yioDOixGUK4YQOzJ5MxD+tEbHvoaZmLRVrcNR36u4SoUrmk+BM8UKJSi4T2s54X2/g9kxhbW2ePo13/tnPy9RM8BE4lfavTSVecbFEXdfwOw39yRPthKdcFrjF6G00z9eM5sRjAgDjDw/ea9Ig1Ur3gqLtHoYWSWN1VZYUftai1LoavZ5gqBO4mxLbnDdl0Q4pEJrKeKX+PuesDWS5o5JaKNXIwrS0zoZjqKJWYVCCp6JpFmY5t1Bjhw6n5L+WjmzPtCbQckCa3XkQC6eg3JTUXs4Xpwh+q4wgJy7hpQgMNgWTQEtQMggQF2JiFgeoDpVHvyJd2HSk+OoyoW081tCjAxu8uHyTAhZx69LNnWNwAKW5feNVB+6RAslOJyBjysQhFTyUrk8pC9orjYeBp4zarCMVGEaVduCbLY6+h8cTbATHDdPsilAb2UZs64Zo2K+G2JtOw95ki+BqP9dcDTpXxDEn4JmSXovn4bgo6NlgUUPezISmpSj+4vGNGvQGzxgF4lO7DsxzHio36f9+NBIVPrgJFPBPMm7cdeFCA5lE+YLaN0CUWrEWLljuB4aG8ZUhG5Mp8NwpDkF4v6K0BwCsZWlr6JxkvuHOuvjwWEaK2omOqUYwhB2qCpzbVX88hEewPGcEuX0f2ImEQ3eJuyCu2FLlA2tnwATtMk6+W5dC3oFBPvEDpP+tswrvHD3mU+qI1aX7z9bJCoMuOZ/DXbA2rrMsS5JZdrnMRZxVrepVGwkQnr1QWOrrb+1o4F3zDDmZMoc3BkxAkDgMNMfoyiYWfin1DqR8u8WV5gKYwLrmSKVsHqrv6hPYf+avpIOYngLD9hsPc6wjaTj2oBAVl3/o1KAqZHKyKroBCGIf+RC+JxG1V5xpDcO3XK9SwLIpFHU/CsyHNO7BIfWAnsqQJnZ+le034DyLUKACyuMauENDeI4UiCs8APTsVGM+FUpQndI/na+KnWUF88SxKhlx2WUXfgoGFZgkPLV/WdZMWGEKDRK2ecwvOqtfN0DzXqJrelusDkXohWU2wgyDzGpRuU9LUwalHAJRCzezSqmMAch9y9/JkD+3gXW2X0yrl3Zg1VAwmQFbJxW99agv2KDgCj0d+OyDDuIDBOMkbQmTKabtsMrrcQ/fVbCS73sO+3XgkCn0GrokOz0jNIEQkz5NF1UikH31UruHbG+HnOC07ynDDyGnn/sKzKFjf64s8UXW/1skKi/kxzN4gBzH1VqDlTP8DSpSrU1FekThpDPzLo+3f4qt30j3IuH1U4FWfMo2ISdsmSfjWCx+5Bzg5RVTHkmuT08/hDsO+xEsLDANPNMoMc+s4GILqzDLe/M0j1Ai046eEVD9GF35cMB3j/mA=
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