uo/Cs+jiASV51m+wHSkIda8MoPAqjWetd3zdRsh562CD4GUH7mBKT2xKdRw5hjC9ofvsAmqcm1uxct8wBxm2ODNcdL1kmFCwbjdlNbhFBDqKn1+1GlzUP0ZhUsxoxI9nlG72lU98UH+M5YnRQ1c+/+oEuYsAdiX4b0fXEfrpSIYML88vGPNW6AQ//UK3m+KPgzzXGZ+balp805QegujJjNHJXDckh/iPpoHfDMwdluHXpY98bJm+qtqFnM6GiYMGkQXJ9jzme2TuYSYleRh/QAescnD3J1UI9aFtmNy8Ayiau/GUA2ikB71cujTKYH8J97Rj9kHZdazlsXtwplbFqS7n3T46O5ES1wl8ArZf30Z5Tm/4KI6Q/tV7/qRMbte/Sue8kH2ArZ1RbPNA4983kkLDPzJ4Q+RxL2Ua8eOGjzxen+/FLvwSrooS7UgpcGztaUG1f44IMO9IEt5DcMUwvqGls9wktoFpeywyrE28AYSNa7h3eKqPBmP79ntuOG8qYNpxuPvUaOLJ7ozXlYgsteEh9FMaOd1qNgrwWV7maSdRlE3vIZFmPsfj5KDeTPIprJkC3lypmv8ofo8NHLET8QJ1k5NlGdK/uhSRYdpvir+NWezXBbhDO0pj5Df9/xlkqgU/TDTjXH4y7xWzba3kxM0kpzPXN1m30E8A6eHHA3warjZJVmxO74okUuzNsJdSvfwFzlAGT2mlYB+eBzpbE+87TKEys1gCxhUv8sC6fbzyInL+wZdvwxOSojIeakdLSyAg/R+zQ0T1GWf+jep+s9JKCKHDh5W+bHuEndacDLUKySdLwmuvt5sumozDI0fRudPqQ1jxE2k41O+FFgoQVrF8a5xvSzrmapVzcY90EX6KRxBp2I+CekFHR/CkzzfDAHgAZ6RhZarcLtyG9EDUdgt0fwXTPZhC+5uIyAZcoqhr4QzQZoCd/BmnadkFVqQyTwf5bDw7GxEsZknYvmjsuQi1RWoalmZMFa/x+eU27KJOJm96elbE4TKnhR4qfcmiy0sDhWIPcQqlocQwUuXSXQHH9Zco79kOqvLdImRAm5SiCMXkHlAlWbGvBOqncKAQI22jRfO5FQ5pWQafUiTE2l9Ccx34WyckpQTlrfMFtYi4lLkkFIIiqo++k18jesT8lrbrTozr/mLkFAKzRepG5F5IixgGE2BcTgReyWxBACLcjO8t00e+UKpVBv1t+V7SKFMZsR8fQCCxHN/y8GDpyqdWX7FJgdJV2SneVt86bxF8PMTRS2dK/cuiRBS9wtzVUI65xATt7AdW03vsv1rFWPjss51fsXdULPne2JEgWaX5zndTAPmfaINgvlG3xKJTOUMCN5N+pCYk7Z0Gx0W+bZUKqqBEDm4NpQvgMqg=
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