P9AuS+3I75pYVoVzF8n5nF6q5xa8gkm4Ir+yrPaBIJLHKWAqaokVNdtliogCZJ31sjyLh9OPbGlMqha6HxjtQ6GM/iPv9eKZ6JGtpf8rSu9ns03bg/ArvGuLl10eaHqDcGWK4+xfnVbVyRmqZK/5yWAgvfqDPqlP1j/BCGuhwRZ3CngmzkeLiF0eWFS1nw2TtT6Nb1r8FB9mmrnOblAShthAZhGhb7SGz9FIt7HJZsaNTmurG2p99NqQL/DSxRkzrI4pBKq2OmlCzFP3dKbf82w39zI3Xz66hy8mEIKljGZ5p+1OS6ghqZhl/5zWhuzxDsYOpLrauofgttCECHgT9pbPcKgYxNKgGyIzK/emg151+zitg1f3yU7MiFKj6erijoOSD137+MUCnICSalateodCm4BDMQpqqzi7IO/s+GAO+BOHHE930ZXIF5wt5Se/kv+cOvywgZTfC2SJD2a4X7SlvuRdjpKFqsAYwfa1WIDkkQ3nEMloPUa7gc6vd/8xUTezw/1BnayWBhqQFk3ak8ergNXvQH4tiE1E7R7QtXxqPK5gjhj6EQdY8GFm+cAIGarn5ENKf5GjYZe3V63qpvdezIoAzruQG26vqHGJT7nivztQusFArXtMKG+ghfO7RxAYMBsbLbxTkCKtpxFIThdnwixr56/kd7RdxVipoEvLUhN4a//qi/mcW6zrZ1v4TbSR5FF1klIXEoRqloiCzeCG3UFS1vOuKoaibEUDo2x3TcJsAzj8aQdCuKVEEVLdrMzz3nWtSac1MMDge0Qak+kBsPaFosUE9yl1jtuEmX+DN1SACbVjSB9eH0ieyKrUeBHB0SnRclMhR9a9fFDk185NXpGpRZl63NnTLwkJiZEomjtBIHreRwwJpFjsYN21aeX8u47mfeK4QVr2l9W2HFIFWrE6vrtDcgPYe109r/s1hpXkUvWF43GpJXQF13/jvdwNDHLvR6SBJcq6y/CjxDZyNmZ2Sdp+WA3GRxqSn2QAxDUYVYrTYTqxaXuq8y12c1RVYPyKTcZYXsVGkFtzLsiIYWomw9W3LRULS0bcD7vjWSGSEqHT2+OyzjoQI96WqIOHq1iCc2ZoMsVQIhpNVujJRX4sTpv1gQyiRhwF0Jgqs23SzGdpNIyRUARd3TL0+mNSqV+FbiuoTSUmBlRjXBr53gKNI6uaDVGfu72ly6eBPtXB2uxmVdTwoUlfbY59RPKXAoDxSaZXHB13zva/Cj8OZXfYfH+L592i1zQtixRvfrICQ/rNLHrYJHjxQPrYuYEw5wbQ034OXV4E/9gkh0IGqINaMCTCxqC1xApVtIj5fpKfTRrD6CSpQJJ4VLzs9VdwQH6EsBaveH9z4Wg+THd7AYcT4DJb25qfYME=
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