7YKrS8h0bm269BZmJxsGAbdePWsuUlJ84VEdy/Tcygg590WGQDxeG9XN3hTO+L4V+Uap1BSCyK3Cm/HTHCOe+sG7j3B2SZRtNjRL9hjSITElunqhB5QWj/gkY5qv8eqFXkGhbV94KHyH0hK0fYeM96ugI0licUN1KVVgxQq3TizYdz01yOQk44V/akscXi0ZKBNgItc2UT9sBlJTyovWlOzraoBFV8WwBrUzZ6wMSfAYLl6aWZQGX71IjW2v5TesCWuBUwfwIYbjE98qd47/tW5iDTmKA0IZWwKFpj7DcZNbMwHrJ+sBaDjDQwXDhxJwX2tfTOIoQwXGiaJy1TNad9LBXnYQCKFBALNamvEkGHap0Rls4NMPyXObZ/TBMn620SUWjJr7IylnXINA0xyC5AKxBBMI29Z1EXgyYjCVMGCasAQ66PeqF/P3+JkQj7ZM6JI2xxBEuFBYy7UsLi7bfVIGhzHGGlCDuipFmAbUHohZ97Dir95TAmFJsu5GEqHdkGM9USJddvwTyWdf8vxUa01ta5HjTGYKNB/rukdCNDCu+Aso/Ra9Zh7Bq+xCWtjDVqU4QH9zLddy9nZk8q4NrFXMqsuFONlyxSKkc87aFcnl7XTz7XdGbAqCRYceWFCTqo/KsPa4a4MsGclJdV9iG14UVpZ0yokZ4g6N/rMOaUwDZpJ3+E5CxVuBrnpgki2vjPj0ObzpGaKAyI19R3pzrXjAe0ya6p22aypH0G3yU1um2FYoCBE/MRaWqdgSco0B5JppDYMvWS33fRGTfxCKtVuCXIznggPNgy9P8/KfuR42jVwWEbNKQ2T8Z5BgV8jcPhGgC99TlcyDAxpLjKYCgp0APQRJ6YjDR5DCDK6jIqMOA8bXe/Tafcu73bjhhU6YNJkWky0/iNkGUR2qbRmk6G82zNxGv/W4TSN9T50jSpB9zDJ1Xj1Jj1SeePYipcia/tfaqgKd/G/VX7RSEp/Qrx+pfy0wM/ygHgI2ywdrP8PG7lfH7i/xJ97Uw6BnkKsQYzdRcRwLrnJzFSv9r+yroBcNOAUXqqRMIJ4H5l0NoODKb9Tndn2C88MdxUo7baLmU+ULTP0KAjo8H4jbIwBEDY+pAO20zMfaO3PNbiXzt9rl0m6th1x0/pJHXdwtWYqxN8B84BFVjjUzqwWeep4WXtNe638VbuXKilxgvgykvTGpRJ4nb9z7fc638SpNw5O9Zk/mnoVPDvvgpJQPt8B2Tblna5gDK69mn8PdLxfFotuJ1x6eiF8Ogpbvj6hXAMxWSTAsg4LI8kohvdWsLkWyW2KiB4iNSVJBs3qphl2FecpETXVUcsE+EwOwnNk++cPQF6nVnbUTNhj/qRuzlIqNkyoocxT6Oow8ZKE579c=
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