n9WEqBeeItLutA4ySpf1H+/NzuGFrpwqHE4HmqgszKBdKLverhoX3jXjthIfXMlEX1oIY5Jf+/KyIFrNWndAahR795UmuwtAnm5jqA3XZkTAUznmUw3a1ZRhIetLYIdyZB4uckkLZ6TsXWbgGOlJ51JxLDyIhddwl4bHNiaYD/4QJ0CxbjKHjoQnAwn8+5GoEfTTKSAfIPsfSMTI4LLs3sDOQSE3A6orQRlj6AUoChQwUlSHEdcUkL0aoUI+TZ9G2h8N9l/j6HY8xX+5MV/VxuwAhliJUzOKeTpjVbq5BhPzfWctIw7yCYdyFHMdh3KuZz98/6l7+ZQn9quBn4iNCPSRofrN0xGrmRBpgN8MGmtToDpyWb7jdFnntRtvNLXBmUZe0MX+ZDZJeRNQrg57oNo4iYXnW50flkJTGUrUUFJMXvAZz9s7gv58QjoP4+0Yx7H+Obhe8SENevt+tcHNpL/no9w1f33DP2vpGYTLf1te2BMURJzO5X36ijUSMQUT4rJu/N9iRBwm/660PgLsh/biZRoTUc/ROH8bJ+otWgwWbpgi978imethc0IGIG0wZgb6gZ0uRRmyusJ7WlWd1D5ullv8FzjCVjaggc5qiPj3DAIm5FjFxvIw7Qn/Z4RhZOX4uAqnd27+/m9JJRKXo+2d5JaoAcC1fr1Fut/Xc33NZmeqMKk/cebzzJMI8rHUJHzXIM1n+XD0Rcl+MsRJiujM9TojVHq4pYJPLlT/q6pIW1DszN/f7wuASXUTjTF3XMWk13aKeLZsW0mTLWNnqxNkPt6s54ux8yiI0gbXeZjy9Ch4Hym2fer1DBrb2DERiNNSMIb/eJsUh9YQqsu9GEJ89T8GK4Kzm41VHrVpF4Lek2TO07joG9nkMC7oEZudyAJMi9MIlzDI0k2dDaysgV838WP1win8CMhwI0/Ubbh/0XmuPiPxu6rF0rsaXuoiqb5U7pxdGMps8EfATFbOx88R0sJa26DfDAt2ptYkH4N1mRkEy3995v7aN97QBjZOqBLPAtX1/V2N9A3CQFUwpO1lmPHMZxoOgP5U46e/dZXj7HG/+TAVQ/1Trmfd6QnkTHUZj56j5Gu7eLGNNOtpud+4qdSkjHj+fa5s4libjIlNdL9Bsa9HAPg8dFToHtwrVt2P5YqBYKU3b4pd8zurAhEd3rwnf0hO5LgTa+mDQv9qYkKb4Okk6MhaDs4gedrycAidcJ3NYx4cjWcyJF9oURyDRww8XDV5uTXAzgBokBSynDPiJ6u1HNd2JVG1+is454Aib3Pn0JWVDY+c/Kvoug5gHE0dIr+IhXQHOYbD/VWgJjUrTSDxpXo4rtyXoE81nD3Uv1ta7o/FZCfthArNjQBUEP1FCNv9DxG7IB0=
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