LxS6b1PmmCUpuhvH6Ekt9OGjsIrT96yPTDEKImJOR+z4cndYBCZngT8GPb3Yzfn8ZqyR79zNtsjPeboo9ayyA0gC2FhKBBxSFKPBcf6avH6pfhf+JOue30V7T380MHZbzNPF3Ec7/3kN5CYinV9p7PY3YgLHaJJrJ1sG1pG5MKAz/DE8V3ZroxgzcAKoMM9nLniYcGxTz3VxpuJ21Hxt9OdkxyKpU87Oz5x4pM4YFD7PXELA839bKEqgZfSuDSwpvF+FdsUwRDA+mum2Uw4Q3Qz5Sj74202yTea77uF3jUj25qjMJGBdOe6kjd8JuCC1uLXB0ydQdhEhPR7X4bLHZoM1X/UJFCbr4aFGT9MMxDLYZqKyqJ0r1vfkfQGoIGs8EZor2vAp7QDrbOBFHK8DdSXicUmrzAC/VWGxuXPHs46t+4/WLYRhB4UbqYPGajFU8TJhmdzbxDAgG8AErc7spKYPpBRe9uPwyOKamw3Dsj44Nk2eYgpIrYdrXLUEsKxxyKZiH1FhNYYJUT9SIMKxc1jGGqe8akN+YgDv2Ds81XzEIyKye3WxTtBJeD5+p6rCx3I9p7/eWkm8WXUlAeKprlhVThxTBo9N8YvtwwmOMyMMjyru99f3rrF1qqOPaIg+RpRs4LE1Y8QWXO+M6JNyIl1F8jufgQpUR8s8OWYev9+ORgEsWitALCsKuZ78PlZZmCjP5KtE2jgVCsRNdqBzDbuWZrP43F0Pag1VlGeMhUzYztSuaTd0OSfIlNOcdJZDBzhdhoarufE1CAHSYmBKZDxn+CC2FNi1cFTtZIpC8P75PCDF/WBvTD4FR/aXBhxhLORfQcJ9g1qxseANOOtflOo54b2IoxCsKO2Qpll9DZevtev45q8qFRMKkyQF7gjhj1AQLVHT+fdeTmdNBMa00IY7bA387t0z4uovWyPC9UYD3IyiqavDQM4Q2a0pHc3Z8JRCX6huAUHGmn4vPzA7u3yDTHpU/CAUgfiT2/Du8WnQWVbk7Eh1JaoEQL5scCIa9SS87tEa/zPOQY3YI+IyRw3MUDrL+zRbji1uNbixlrRfYtMHcexjjRWs0i7XurSfvZ9gVobqa4h5mNa38GH4vPYdmi/36woxhBqwb+dSP1SX5uUZDRb/FgBLmbKdDRscpJZ83SWjuyahNumDu+8uQq+FhS7NuLaG6I4zT8hK8fm1pgDQ42x+NBAkwRx7mvdXvdnmBXHxsGyepZ4LTmnClpVeYBuZfelh6Yy7MvUyTE1zn4Cq7Iklqzgb9f6EMBF/QDMVgSeDJn3GF2V+cLgnfjsjrDSbf2g6gWPWti2TqQkVajP+ULXX/l73sovlyGkcDk+R+WjM+jsKwXoUEN+FcxwBF95MooAHtoGDdaY=
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