ez9F1BkRUGVTE/ysWwCnHXavozfPS2zC9P2X0pmhnNtNwyCgB5qpgNI2hTPI4NaJk0TNPgdrWwfSv0sfbhWs4WiO7LN01lbxeP6cMd8EujPvkIxi7t95Ecq/bAh/Y6JSIZvKkB1D5haRcW8jVXsfXq21Nv398v+fFkCbv946zdRFdezZoQLA4VGe0zS+p9tHeEFGfMHiRANa9qtaXMiVwiEGoplf8tMJz3jSslWZtpOQp4H3bcNQtBQ4zOHl5ekoxUF8XkWyDXev3BPVFRe3hwQNVbGCZkR5IADU84yMsw1gYxhUeAh3ZSnBaKnmUB9rzGTTYrghAJgDbZCMp2fMg+IJJu6wyLljOau016GR4hpzBSzXk1vmdcIKBkz9s1X4SY0Kur2Aphn68wcMfEHCxFLY7njTzSyNzUNS1N8+JXq9oPEW7MvidbRhpu30PUrQzlP+Gq5CYHkTh0OSqyI74lOQzMiFBvQCpn1DTmaDsUMFERUSPueP0GqOpCLtI8/JKy72cZ9m8xKVmbqpp+YB/hPhiZ3oI0IqO0w3Tha2BoQG8MEu5yXPP/VNidrxzlyZRK+83EuKEEHNzd/s2wM9w+K5nPWZZZSllssOPIQCg4rrZRYQkImbujYlQ4J11Ps9kwCkQQJV9lprEQBymEY4YSs7DXi2kTeYMdIUsZNXktO95d15zSzT0rsNWbfv0Q2dVaa/VQ92Kh4H2/QmrUYh75xBhrnbZgZPs6p/DnPVagqYl0d+A6DsWdHLdkX6VuB29IkmS7NU0Nfila+nvm+OydhKF4x7Ctz+oXEW8FMfTWbmDpyLRY/MPP26UyfakWkR5ufzhun+lwGzLR3Eay32fnCRU4IYSyH9ijh1dmWi6pKdSgoc3LpHwJ1esaHc28j9U/TsUkIhntKNm2BJ6DLjsCwDRfAP+VTAv8Kh7HHp6uz8L7yu6dAD/JlztEuNpWs42uHcjy2OyRnhptTG1sbt3Hr4gknUVnBO0VIFZtbXg/CHVLh7DAibMVSBGMiUUxTKWKsxGrIGj5nkYRlDAhEM5QyAbv9r50uv0ghyLmlGuiy7WhLCm1zFvEMfXU4IKFhXvF65Z7RCBvFYFDr95VQ8owX6w6gLhGuC3d1offK4h+AKG+HBT5e9nosxFQWeKlepx8KARw47DDnXFY0Dmc7ekDXkWGJQppG8CueX8jeSzVILDZHUa89fMTXZ9142bpDC20jThnTmExZoawgsox3yjcvoG5QfvtcPgWjrANfRJAre3JU9ywkquiR19uUmHJ+O8sQjB0ozF8HLUD2dIgb6pC8a0SRN3GkrApRwQCQX4qqSY5i/czY52unnjrrNigKLL0vUwgCMvWs04jM6N0G2UAiTi7GTe/Hs9JfbfsE=
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