VMutnNuPjyOaao8S5OKf75nItNLT6VpiJdjfjwEfyAi0s/lVGM8nykVwr6gPBbcWKe9+nMszssGl8f7YD/LvSvo+yrzJfAW6xhQ4TX63RfKEabVJ6Hp5dyxMv3j1LTs9ggbdeuJe2axvJ3rkCe/r4DtXYCwzs1hYDpQ6kR/jsGUMqcJJF7O71AqyFk3KrnWg2YXl0+YUqND7p+NxYmmYYB+W+WtqmB6zpRhLaDwhMyd+F+drmqqZPe+DECKoWDoJPBK9zcVO4Zyt8UZdCrCyEY9/rhM3P8pGEfo/l+YVGRREKqV1hQKYzWCp/yTdInkVrrowL/gS8t7AeRMVyIXe++jC31IrrkCUCY1xWvpQPBM/UFn+mCz+xxS21ddjmLMtfZw9Y1+jaVRVQPMq3kzMT14FmqJWLR3NPoE2VSh+KHpdkbVbIkYzP8IB6AgCALz4yOCB2BuJVfW4gvBhEsTdWqw+l9XvVek/okJLKVB9HrV/Yh2m7mCocNQ+vgYlGZGqMtKzrYIQ+lb5Yt8TnOFv5deWIv4YXVyCLgM64iBcrLt7PYQ/JYmIQYCOJz77metT4IZs34X5h5l1bklrGLtYj2cNQe8Vr+qzbhCP8x4H9gqyVkdrr0jgdWbf+0xflX0SNfx//Am5wta2TLXEX7+RLUPnUgIjWlxLGHyJmbiy1+PrXrY/WR+rCIRoFHumSMN7n3d0f1RgUicRW1oYyhkFXWzndvgfHVqiJ+Dwr/IeFdLfN6UAVcg+tNWeDpBLnk5d0ZeUBCjHEnFTKn2hIco/8yGpxtaHXkvi5j4Z3MwsmlvW0Ushyg0WVA4RU3Scla8Blh68bD9i30lFDIBpgg4uheKj9F5XVwbriEGwRoMuf261DDULZPLB6huNPQFKp9DXXxsEru2IHp5PId1K1qK7+C03RuCa2TbqqCpEK9BrvgtwyoALuRw4XEG2Tz7GSPEMdxpQlgT88j71lDygIM60xboOJEAXHFL3iI10iOoRIBEmMMKug/PAwC7B4fwnEYeP1bgBwiT0cF8fzP5YTmodJJLT5rLYRclb5YCeid6qFillM1iHv9jAkR366UiT6yCBBbtiY7sYPUf08MQq03ysnkRjfsKkx2/oGeEk+fT/Uve6Y6fqHpHKqIx+SgLQf07QS/WesARk+vInofNHeu4RNKC4q5+t6n7LQ4gisKW6cnIp0z0wBxeXqqPN15Xs9g7pjbEpVtEG+JLd8V4MFtLdScAITEXFBnN50vScoGFjehG1qLGQPAP+h9HxHXXCSi7paAwY+Geojo9qUKo44SwGVc41Frs7POP7Aek2ONrfCEQmvBhXQCBuH6Y5g3zQyuFrZDbAzuC3xbcXREuKmH3dhlNi3Udn2Mt/NQD43cU=
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