b5gtJ344BrE3rkYDHEE6qAZL+jPGtW4+BsCzxlZi4Ui7POcMD0M8zna305w1g+9kfQHAIdKxiTQHCE16B9YCnqEHjF4ADOYobhAffl9XWp2NGei/Vv+CHv1nbcdL3Eymu0xGfaKMBLqmziyBHG96HQ/kq0HFd3Z0zija2zxpYln70fHPEO4HZhScrQ7V8gjk5rGKKC+DuwPKodCUDj2tQObW0PyFriGswTKmoA9d+GbcmIQ1l6lTMB13Uz3IKhM9m0ZsvQVWt7w3idm5Z962CtNeWZqdQp6cBdURNxJ9Ljn0ZCfvgCONusLE7wEUc5slU62Ec+VVTe45dq7wMRBx88zm3A0X4EifB1dH5GmX34wR2891XHF7jfvEBcNw+qYwB/fnr509eTLfGuU94jUl/eCcf6BtTi7tLK1tjTU5l5GiW27P0qWXRqBNJavlV3J76TwPNGiWfqwdDfUsJ/NwGb8ph9vwwsW7RZsQSUWCnmJ84OsE64Wj5YNf2JokbuNL1rfp9UP7W6I0e7RSYM5QvkTMjiPkn+fVbRPdmFUXlXd5c3s5ZY2kPlfSmOaEXOLysLMKu6MFJfpDFlBsf/ShYCL9QW4YYwttmKdZV/UsvuOzZmDX+gqfzNHdHJUKLeiosmj+0Rft1jOH8S6Av1zKe/IhDMdYka0v9asxpCtKSShx3xNBoIOwv1wOs5pAJhYWQvAMU1Z66yH0P2gBka1azZnNQeY9nkTGlNZ1XSj98xsmGHmLobozFeHo06sn3Yz5NF7YBjlzw5e7aTeUOvnuuFYHMrwGOlmAJ6eacvcKwZT5yjForgiO3yMTS8yN5EFGwc9032v5Uhwb1zZthbZWABFLRujB3z6cwwG0HkYV0rrDWy1tbSX6q0edABSQsbVhHc22xiT1MmW3grN+AYtEFg6DiRNOqxNI8nGgQc2tjZCQ0pMfQR9ZNR0EtXdoiLu3D3Sxk0wQ7jljhfzITgKPPyRY9p/wO2BZ5LkoWpRj/pKLy8NwY9h6RBL/X6suAR+glmf3f8CXbt453TRjNfAAVnvfxNVTuErvOqdh/dfBfMWVDgCkBQoh/ostgWSGGGDni/dvtp7CwE58Nof+IGZs/wkD3TSwT5GA6AWFpF1vSoMxBvn033As28IB43lK6IRZJvV/84D97LoW2gt0i2JBWAi/BWqWKtaT2thL+6F6w1YXojBl/Ar3VPw7UTOc7btOKP4uGOksMo0IJpiC0Lqcc5i9NHx5rmGRhCIefvqhUfIbEXaJm5PQm58z18H7Y6j716+ooqIAsQi9mUaR/Pyq0Xa/X8e1jK8+cGlVanzv8NENxq6pHfu3Dl8efJKFpSVRsW2+mr3yMDUROtaFfjTW8XqCqpRKEEaf1gWKzIY=
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