GofKOszuKJAwrrAhoNP4iH0oxaka8E6mAVBcPw5r//tbnFreEwEQswSJomBDJr4bq+9sqSUMRevRTiN/tErXZIKmCNqi5snsITMTqRObRf9Q6FhG+g4tDEzpS5679yEO4gOTmvqooMr5YVTONeqeD6c3dNDWvhMBTAAc0WlcwYjCcCCPo64ZcMGT66+5jNeAWI71mGhr/OOwVPhefTybuS0/Q94XfcZ+d3P6B/Y1FfzetTycPcF27/hL3Q3kQHthsR85QB0ysMHj7iw3W+CzZ9yK64xgfAy2YiFXMLK/XmL8grgzoac70IWX4BuImiSqJmmDVFpBye+qzMFsyAcU2g9++3xMWzvFU2/L5/1/J1tPmIy2TO4vlyq61RBZbJ+lcyLA/hjy+wLF/JmDZ6YB6qu4Ej6LRjUgGmlVZy5LMjIURw33385XLAfmRxtZ1LhHA0DUaGLbECu5WhI4rd5vXPFg4vWP1cxLbCo3Hyt8oDF6OzZuTC6xKgd3cGZxQlFStmSg2Xp5wSNgZOmhJIJtLg1C+Og2CLWNh5NHDT445YZDrlh8qAxZxXPW7HTE9I15dtT4SnFSvtYLAJbSC4RSx3bFpoZUm4DnAx0xHVjYk+c0epIsZvaUdfK2HcWnNVD5la//YsEb3kXD6Uuwmj9uzJ+2NPLS/OXquenJKaCO3R54fiaV6ZZSEn9Sseo/4zajSqsUWcqK2s5a3y3BOHSz9FQ/Yj8jV+SLi8aReLr21aJiTpxz55UJyON6NtcvSl3Z7KijBPgME8ylB4w9Sp9DTpUa0r64+m0cx9rvsd5qh5h425w0XMMsFHdG22iD7pvfj+7jAnN2sgxhy6RT8XAEbNbeMzOwT8WYVzyNhLQ3iv7/2IxwliUS7+HVHRrVsLISBPJKHp1Av9MCcPb4IWWeHicYi+umcdf/QlzDkqfYUk5jNIPEn6LFxOfeTRyh8b+p2QG65jlS8U1Sp7xdZULgYaBU7c4uK+Hhalo6Zw9KgMoVIdcquAfLCgmy+R8B9bWG+/OFczieHh68MaIVjjaxf0Tyf2EuvUCmzUD2f3aNEq7+iGBnDEaO6W8T4+nMxviAmLk7y27qfRFZFOa4rznXyc7FYaVFLWSSU3mfxA4/+qUsC/FFKnx9ICjIcLgJITNmYQtgsme6BOTvHt4yeNMDTv16/r3qaythUBEE4eLJDpLxqPmrHjZ0bBSAl+cQ/maQloC3YiCQ1wXemc2JI8EL2jV9l3N9bfqpSC9ZIhEaJPXsR6rXKqXrj+woK4kzC6IcH3D0Eg9Kwo7Q+r62/lgXDCSazUEg5R+aJ3cYU7BDXGCGwYHkcUPoIJA1vdbagk/+BphwAxWWTmpge6hreAdo2Lq/mTmc4VVXMlVaAOs=
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