WapT8IIQ9r3e1KjJZrJNCyy/4IzVqtPvD5WK3itlmq1TlhkM6xxYtR++EgAjPFfjtZg5zH6R5SzftVHgjQCUoC6vpja/pPNCCnICRpJMAgMCWfS6dorJhVUoAh+quXW+ZOJR7dOpbv+PfphltkE1RkgLtSo24/jfXaocuac16f/VJuVip0Js+DjNln2CK0hSPu+KWymbBBLgz4nQADz8VR5J6+Hk6yAnY2ABl252WNGvGlSCOiU0eTR42wcI7rzAZw+2QnkTNdDP3V3m+yx6lAPMsOqjPEBSq1kvS+9xG53alYm5Wrrct7me77qLSwTUizoAXcVPm6E2TGUTYrwqXcTYhfJNVMyjrON6HIU2UAve0jA7hXB8iMlhb6ecyofFstmRaetZFXWB/uttdkHeajy04VkNmYVgGs8aoJ+scWTeYqzP/UZDCBk8skLFe1XXMI/yT5JHDhM6MhM7Fbfm5NIYPkSbZ8A1eDU+7OgwYtlXjEHM69L+aiG9TZQ8zbQ8XRVlfiuFFDpmRtpnXMFFI5RzLeBD/NXWzCnZvon3nGLn3L3/X6MLoKDhI4Ca28n4eFOJorC0zNTp+tbb7wQt2U2q2kYliFgYZZyB8laNqsZ8z+BODLOnkRBSPZ3/t4GyFsu9aHJjmRVVagdiOCnYvldb/TiofVJVQRZbHy7TU9e2dp4kcW8yjAQRmxiGaT4qiLHn2KP9P5tUQ/ji9gJATDN3xREUn5H1SvtH7VX1Sd1A+/yyoK/8+KKPdx3zfqv9/ivYuXMt2AGcHoaFoSQ+gnMZptxCzsW4zgFE/N3CWQSrIsiW7KvwG+CzCGZ6CYOtthlGm3BPrU4u40zYZgrx4o0S9P/qTKIuinDtL+yr4Z7UU8+J/JZVZfRrNJZ4b0WZoPaygZQSUn0fdQ6Q4DeXChK2GdFH7vWA7q9DU+R3556B7bSOEXhLX6DjpuXozW4AYFp6+kol1uvJ8u4+iY1dTrhut4btpk12BN5YSwxaC+RfnDzsCjZnlp15Ci4ZPC3LefMn6CSttV8U65y5TuPMFgIohk0lpKaZ+WurR/DHDHSKaOMFMp0MSiBzIzp8Qe/tFla7HpbwzbhZ00ErY2BfrkeXgfu+Fwajgtn1BtdT27td1gmsTTzPMvzoAtdgPhNIDyJG/bz2unyxGn68IXcyJOo0C48eVqp79uRq+Wl2AcSsrShTWJHpc5Ue3y1IHleaPE2EtxGZcrIRDIy7UseUPtwBvPP4qRTb0Rh5N2Z3D5zVVgbKd0U8Rcge6XxehcR2zFoV3asqsR5RVz9NlZVz/wuuw18M7M3Ux0iv69WEP5QUXOjg4peN2DvsMlP+3FTm04vK2O+x23b5scraFIyb+mUr3VVnu7IMokqzBL0=
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