ssxhSLdM4MCDcMR/WMRAmj1vwXsV6kI+A9HOgyoTtwHlBZqcz8NLbMwzbIOE/XmVSE3iPZb6k257dQrUq/JlStwHtHstdPSu453cRK8NG5LOzd/WVctWD4xJcqpVZORdLxwBNn6L2Al14uOyUfNI3xCtKOXGy3ILbgFVbIOipdOka8bdCX0NMuQRRs2GeWtQ4Sh5LPmV6ICFUNk6gYGzB+z71qB9Z/o3YmllKZOJwXxovf1+pDVIWvVByNKcNLiOZIF89zaD05N8+oZRYKs+4RvlMmSSHlsHupqU08zo5MXYtmGvKlbwsal4PrX6mfy8kdU33MiKpGqi7aeHjtSCDTb66MsN1blfL78J2qRLn6flmeigEtuHShwNpZpn+gz1qqsQU7iEk2lhV+scGfuvLb+kV1ZZjpdLl7fr+tithhaYCSF2VHse4hJdKZmwVoMwNMRBciA54k4cLjyw2yfa7ckyZICasZg8EgKX5/iqbRn7+PFea66yof9b+w06MlBfEKS4okYvU70UcbedvaSO2CYdP/MB1VG6JWJqdDYhsrg7gvzsmjLH8Cop/6EYbSG+GWKL8qV97ikGoOGgE+LDCfNpjbemjmXY/piVRyYOMyVBaSWAsunQ1SvllNOrxIT80/Pr3VbTJK4j/RB4OtCf6fJfE5+5lzUmQoDrRhqXCQ+OJnjXW84b02a4qhO20NwW7cRdiEFTTJnxvP+Vedrlk62/3PHcPiNeey5ZGbcd87NSDbfoKTE1Tp/6IBt+6P91aJiPkN5cfQ88o4r2A7lui31O1iMSSjD2Ji6W2NBni0T8vQAfJ9za8Juzk84aWJVNWn8FM2UWbOttZzwZQDbXS8tq4g9kCCdcVnhsr1zVbnDWgiIf0Ce6daahOjma/fYA3uqO7vGIKM3OYw6z2wgwXWPRn6zSUxREDVfprZpAibHnPMbAIvJox0Foq4GjW6JjDtlRGWuaJVR9rnzFSe1tSYlON9slPvsGkxt9Nqc0Dm/qwFyznupzD6ixyUam8bD+VUVIwHjDM+zPZUOd3+JfXOi7jVFEMIhQAONOYJpWqpzraYikQRIYwwltSqlqEw2zz5hpsZeLjmnl5QOATjgxCghyurW/lsCbhYtQkMZ+o6C7N8QAYxrJGoemKXiQ0x8svuGetRMj/C5Oxcp+JmzTa4h6IFtpA1EY03rW+fmSt8sbOMMquy5CMfo9/f9AwLs34HouZd0C/w/a4inLTh9HEwMOUzyGEsv+DUdciQpTACQC0fJxkEcP463ZghLP5tGPYuKCHkOvE+uK41LW/Iz94HPZ4z815wRh0+8hxdIjh3sr475sI0SBIgoFVwjYjdQ0ZH7YGDdYSXwd+jH2jBQ6T8ZjksPR8I8ZX99cDTw=
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