IjSp9532RJf2hcbgw28FF4f8hbaKoy/h16zcxkWXwFAe2gt7oKPNhHTczbZ22OfnawwSYyqR8hjf1cl8q7idkbhw2eAFq0BgEO2GR+64rMZjjqTXVfeCXnrLHimR5evEyudRUyq6iLp3/lYj+6Mmmq3eu19kdGi6gv3fMI7XwcbAxe6AitYOCS1CBg2BuRlIfi2Hv9cQCdqZoLCw6NnCd9L5A9r2uSg+ql/S00bE+Ud02+wPYSt3SfEaLg59O5mPBXoDvJxCxcAVUHbxBnZPbxD9O176IUihkKlHSZrQof9E9phdNU3M0GQruy37R0uJxWHtJ5w2/ycmQlJH84nLCBvYIiPvG6uAtACnPdN+JoglEy20ZLz9QGSUU6pYVswmuTE8QR8/dwbsuaNfEC8cQM2SCHvk58RDnYgidV4H8oSy1LZncJvqhSOmvN6xdV0R+oaUp6xgPVnkZfxs0GJiZyn1XRKIPzRSJIbFSQVVn1D00HX538kHtrCT/cLEEqoNeg2Fd1pf+MgiEXldaroYTW28c3mZNa/FeE1dnkuHVYjRVYfvGfgAlzxR+fgBVU/HhjuF5khxeZUY1pDBBC5z+jODIxbxy3pQMsfCOQYPnhvwDJOYJsotGWS4YdmaCzfBgzzLcCJDH7TztWoGpxoXWo8bH94aRB45WqrRAhN9gW8RN1yftNdqBQ6qhdkcOQjLjhMRDe45dMcjjFwjd4Z2zqEvAHFL3HFEpRVlORctQOs3vf44p6Oem/pofv9M1evQ8/datzFAQI/wwwrHXUPfaykvu3Da2OUWgHds3zQ2QqxcXWT51q4NrzJyjJc2A524mjxAr84UPFiPny2nZv6ptmXxUXT6wRmFtLhezYwZ8YqfifgndTQbQB1f00mg60Hw6yN9xvzBzDgYK4CRBIcSFz5qVp2GRXobl3WZeCnVktLwcXvzbxLJi/uJpSokB52dNuefKc0AkvAKbhNENbmDm3X2/8GBK84vVD/Y+KN9zR7c5HgDAjtk0eyUcghkZM7E9HeQUvtofiDzx2bRRkGyWPVFouvOVtM/+YCh8cIvtI62phW8+lUbwHCSn5iiUbFL4D4Mt7fxvNBG3GDJoKtKEdwO2LnMLGhr4W4mHFmTE4PRghteIO4x8WV1lDSFiQ6lPw6sHbBGhbg5AB8mdeEr4Lad1R9I+/em9QeTY44eNkwwYQkNaav5gb9KVf4sxXjtFQIwtX2/vp3MPhF5rU0owLulrTsPXr6goIUId67mzGwqxWMy3n4VNupyKQJjHhoUTWvgATmVdCSwGDsqVpQ2UV41RIf/c6Vk/38UoYLL8PcyZWMocTxJ1ql0KQIKT2i7StBVJ5YGaEGpX4MJRFzH92ACvUz6FxYQJr8K0wg=
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