o1EYjFFe0+irKGow2zWbyJNnMYhmxkbhx0muU4ERUGnuWUQtTuaRD1mvwjV5R7CDFDUFSC6eWmOW8/NHVlqwoKt3mdC6NRzykyzkKBLnrfbK6qmXkCcstPInaTPU5mBjR0hNCY22zZmztNJvd8S0JwiWK5zxIuYaKndIcc/dY4I3NnJDtBL04rvQwvyoxrNmldtuUADGrCg/0pXjI9EByK4+G29Jn2os5iIh7RxQ96hXnf+7itBWPgy0j9c2CjepD5196LeePlPmrNONcPiSW4+TPsmgBvTkzV4oeKZTiSYu9xHthDzcIpsebbkiZttWNzhFExmH5i2it/BPZbNrw3WlQcIgsA5D15RdpAU4qtb/KdAnMShvxe7JFf25mzmt9Tp0b6eERhtgYmeGWRiiSKmezXEoVQ6mqNTTWlLHsi7bqJrVMC1zaye+wFLwu0azVX329OKQf1tT+36GsjW3cOEXYvjvobzqNfn1VyLdTYcY59oBAzMDJBWwMmEvrZ7YHNodSCIu/KgvdnJT/7t09q0yQeZrogmCp+bftEWRW1zcZsAL/ywvbx2iHfi4hsDeA/59mnLcCb6qE6mKR8L7qy+rya06kF07KuHSlcaRd8A9OUTBE23BQTKgWwyqPyO3h7cCGt485JO/s1PT85psmjaZijHMPNnDwFI+sEZWE7yvfbl+vzKOnR2V5gFT55s4v+XXez73G91dfkLH0A5uNfokJcpOyq95ftcvAaTyHwxHOTYf4EOkhEJLiynydvKZMdVzNYZymtnYEG76IFGjGPFsd/SgdskFv6GZZn0a80YB04AA5QzQ2unCde+aaq6TbZv/2LbUC2qNG0Rgn7GBJ/hkG1V0rpSYZc65OfXyc1FXSkx0UDR93K5iD2TenMd4VCdM32bgxjTcPRHtVAW2smdswWGH1MjSlTvzxPzwrLZ6msrm9ml5j7rUQl/S1hq38QMRkZY12onGpp8tDDwYiwDycL5+B3dRG7UWKg6MypMMHoO4WnHmsgouyfvVUmULnHcpqgUdIwtJR+ULhiN9HAgB+OzsWTDTKYe9fy75NVn/HpgXLRV2HC3lDwzX/87BhNPiYcrQpjjztnVfeEFxKIytMGr5/uaeeYLklhzKa138iq3oyQ+T0gH+erQS7K01qM62Km2y9TufzAk24KmnXF8FwENHdDHm7lVtlnF3GxACRscXEkX9jeE2/ij8qdY1x4rs6OhpBesqywz3QfVr2aHJVmhjln3YNe077Jm89obDmdWu7x3RkOcou/wZ3LyOnpbaMPJ9nq0QuWfddr+YVSJZCYOi/sxWO7/ZPtQyOpH5hH6cdkFHdutgX8HdriHoLHWJZVBhJ5PE8nlamyKhj2omPKtKpkJ9mVX9AnY=
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