XPAPuy6FSXgl98DBY2ygHSAVGu0ihu4Qj0n4kCIpufQzpfm2ZPGeUEo8UpxdCZotvJDWwhTaPAIM1C5teGy2ZcDH7Ud69QFuYiH/N1my++U0SlpcpANfX0IVkrM5zMoJ4SENJXr/ce8Lmg3pZGC/Emx2hnHrTNhJLrt+qGbWmXDA929JEqLHBPUADLpFleJvOF0pxS0a6HVbg90SRxryTvmlfMEHprV0+Y043m30OmaZeA+wMp0W2q5DAVImIO/TGJF2zxAi0k4+cweDbBuBnU3WTLuSnrMiDQ4eGnNkiHAXNcXXro/TvDae6x7w1LmgaeOD/FEbxTSzNXOyiYx3Y5g/Uf46SOX1coeIFbGPBlwHj/+00TYi7tnIprZvLgN4TAW9xlFtxHyoGYViD2D1FadxVLyv+g86GBL2tScKVHga+8+Xv4OyCLWtkP6Hgsl6BpdInZqmT1n0gNsr1rsz2sdKBq/p2XjMmPHlt5qA9+BwrHXHMq9GhwwfCB8bVeUFrZEidw2d+37n5AQPQGOucMr9CMaH8wJ11O/GsYOFnzUNk84xBBYtjp4sEodF5ic3WGENFnR7LK3V1xo4hmgKzcbeWrMIpRXIXDKuwKRyX+CJtb3qTF0kFyf2g/aO2FakMP9QHTxwiwV39AJGqQZymH+DKz6Lv2pi/cEFXi9jfy+Z5cmnI77pNnc5WNvvDZG3UMghiYnQv7uZ0tL92r8SIQWXxEOFNHB16xHWC/GNHnLfCdm++MgeBE5H+VFtEqz3Kz1yZWbZhn+pOHkxWuIbo0AFO8tQrKlqZHgoTv/XTFxXQTYNBQ3YCGufsQxFHtk1nUInJnBopKQyv9P3591x7+S6bAlS3jXMWd9EO5HqObdEtOuBG5GDli8Wz9GRGQ74yKtiHWNr72Qe7NaG3pq2kc9QIfa23cRLEnmN5+ZeQbKjPisD5rZlUjj7lsIdIw9oWr8obFCz8AYt2Nd+gzO+Waa31/JAAfuXqMff/2xSFsFUVad7l1PWseeEV3x+us3yrFIN08fdMZmyrRE4mVd+WZ5mDJoUW8Q83EY22/QOHvVxO0h2q9UiGfwS1DID4x38EJtVvYdSG3iCCrInQU4r7FPsv4gR3rvtiW4aflioeLYcqBxY1oprH0pH8lIF4PGGA+ydFa1P+/CycjTOwk+sBi0yct6/nSyWaZHBYQ/+38CLcQnyd4BmERTNlFIpd/hgMFnZmmdqAjH3tP1AlgEhFkNtH0LNpVErwr5YcbtN45oJ8esCOR+VkDg1Zp0HIYmktk0DtPDrOPXgaNZb9rBsv8L1D/TjkqHaj7/CaOtBAco2UuvtrXAu3+FcoYyqEDlsWSAe7dmDdo/b17THnrLGVUEShWMdeBhuOIvC6DQ=
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