NdguzdlRhjabB/B/t25tFOirwevRsn+HoAbBcXlwxOdOPlTBEjDOTARrI0NonTwdjIkcTTW0i9Wb5JHaVgkUECacHDjD/5PWuew/QQqhJhMrwr4GzJpjxTC88qTAem2SN4JOdzHCyXhoXPBhP2xt7ODGqTO+MCeLZ7vxoLxECJ2yXg5i4Wtxs1HNbnWqRIWOaknuf9anWaB1l0FjgDFpZYfmxKKM5j0Tz2v23/cDZegM4GnTaygz5Fp38cby+Tq5ozP2m9wAqiEltj2r/sUFRnp981RVL433mB2e1bf1/w9UQgHvI5X7MRuX8rF/tbW/jJUOVm6HhTRxLYfve8mDQIBIJYPi7stZ2duBEX/0o9h+hjZUa6y93zNnf5nd4zr/PkptMvz/mCzGwS4u9gxosDRtEXlCCeDlYBI7J77VJrPY6PLRwn0/cP9DT372Q8Hqs9ySObzxysSHQuLD+4vN/9yc256wUCnNjHCMtoGMnsGntRnE6LeoeAJ2lofGb4lU8cV7lvHjjZ+giGr2/ZaTSw6c9Yl/8kaj3MHR8iXO1TgXxMVd9tMFxQL19kH612K5LFWl8Xy5xycVbyPlUqhE2MYFOD+nT28+kDwJ3bw5B1E8tGJED8Et6KRwHAjSKMAR3r5G6fAJHN0GXxquaS8BdPclX6erxKYXMXoRHuZrwQasqYXbN5eEFlp6aVKyobf9cYmkMhWEV+MzjYvZQWKLAFVL4TqENmDc8+07p8jpygBD7fdGFAkHM3LQHeRbvwI0XcHJ0nMZtwlmpzc8SHCDwa7yjEguf981S6q8KPEKA++tMC5wUrzoBnQshjStZWEmGJRToIxkd+oFoTLYK/i0EFsUKGYe9aHr8UFWgfuFaeiJqZIEXAsUs/anTdIYjAW3uI8reQ7KAMLXJbpIn5ZzaFmwfzsP9lAqvJhfvaDD+1Huvaq/ioC4ts7NbnL9/0OSXuvMcLC2eVgcGNN4wxWi0kXGLWDcgbqGRSt4fsrzBJMZa168YWPTEIWi1MNwneXuNMrsm0MHtKECwOeFHc7rSirhvav2KqX9N83ZdV7VfePgvPxM/lMXI3fJVS5Z9ghpjDVu4ubtV4YPZ/z58+4Zt5A58g6H1sZCFg7wBqhegq0nb0LJFmR/hIuMaSfOrj12iLoWxWaK81qbgKG52AcHj5MDRiS22yj6VOBoWCHi5NLcH+d90W4JGo1HbTOR7xG/qXvdQJO5TPUdjyihMPtPfefJHDFWRHhnaBBicXDaroArHCBBRh0BdkscHcJs2BtJyqNEuqRVoad1okf/3V25sDRfAlclDADL0ChjXT4Mvd45oUisoyryO2RD71KsNPyRTH16NvJOpypWQFnvboCcUcSQM5hAlUujccxYFws=
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