zc/GCJOdW1m5qph+d4TSehr2YMNqCgvUnHdJRaaPp8aXIU4Txi/kiLJn3gxcUEEY+4chruZ6WAfEN9PD3MFT1x61EMyOZoYTaanXloUxgLdcrnqbQUFyzBJuHmtU7fNj/5OPHGNNB7poxtYi/ceHiats3IsLejW7p+/O20F1914BzAV6MfUjy5GcD275UiVvfn9hujo539DHmXPgdlz6AAs+NpegmfunICZG/QAZ+q1OFNn5+26mI3doEz8t0D/0WE6q9peKdKDhomeGUotgrWy75978sGdiCRB6VNy8r052yb9Xzx4lCyISKmKSfioe1XAVsGsJtRjtmfxNK0jlOdOEyrMts++8Qe7EZIhVHJSfz5x5YNexda4egBovRaKJ/4xf6yEamHdchUBOIECexPhxDpu0S4SKJauHk4CJ3s8K0Qgg3B/2Wr29Cq0AS59cNZAvJFN1WLbHR8UNg8t2N6l/YsPg9b6RPw+C8PqEBaSThqeCZXq5OBH2CTNtvr79lLpirZc15qnDSJTlA5WFYtbh9qdXNpSGqndoKqbHdQRa54A+LXh3yJiR9jfKkA6+5G6mJITpNFt++GydSWIgzNlsdjbc0JZeptzu3yE8FDQ1sxcbcxKghy3I5PxLrKJHBlDYAJcIwufT4MF/yTUci4cJLYoYdhsgGk3aOHU8XvbDGafp+jn2HveYbi+AvkADYv8MhyT73pZRayu7Y25/d5dfd3BebAkyHuD6CM9DYS3oRhq1qicU0Zjw74RKP7S3pojG+RAMAqI2QDmJ8FL7rUprbbXa7R/cLVm0uawdZtwRHSKeMyNa/IAAboBW5hXixInUM18U/j+eG/0GQCL2wW9kq4Ho/Z1xL9qMN6od5EDpFp7JADQosoEWjj5MzA01u3ZpmX9Jyjs53DkFikPqmVT3KMOwchRvgaUpjgYMWi3sTZQ0wdqgADqliuPj1IliNe+5Myps2Sd9LTb4Lvm7aDUhhbmTmN5kZ8nQzl81ZLdYRbcFAjM79upLe6nTcM3vP5LBAEAPndZozGNb2o0Ylo9vkJKIWNWusn+NMYVJiA75/9v+DEqCZHPOXKi8UBEhqoyBnO6m6U41DfSvtacF/jNnJ4fC2i64dmyiVpVPZfQts5WFPvQsLvwFYHtcaQItQEOHihOopBZ5QmO79moH/bNlIJgbndnvD4a992np2h6GBH/61nlVqsoJ+Rb8xyaka0kV7qcYPP7Us0xY8JlvhYcqCpr2V7SBalifdh6S7PzprA6x/RbR0k7yGB4KcnZxpLec3YAcsmBhnmwLQl7VPxw2yxajXC2zzBt5QlQwzygClq9QggKCA/lVNZL2+LaKleDvzZbu6LE0gUoCrxak1VSY/E5nDkOz+IMGp24=
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