5hJSm3DYVHqv4fPxptliVZK8Hc86CDuh2pr3u9vFNbcdwt1t0Bc6Yo0URwqP8dMST/LEYgkLi0JiiO5tedVu1W7wZD4dVLKCaog4dpmlr41/Y6Y7ZnKiVtqvXY3JolVgpvziIims2K+xDbCI5h3olqvGHmyIoDshNLy17J3a86j48d5fy1YuPWKAvk5A3Etqq3lAx0VqfTc7ps2dHnaVmc6pxo/A/QO9d6lJsV4YiH8MDKcH/uxFLy4hlzG3xGkhcUT4yWng0vqt7L/ClKiqJDXK6PX89LcrU9PLFV9v0P317eOxX2SOvONIJIrpbWwPE4bOmUm/JgJugVNmSmgJPi082Z4SAT4/8Jeuny8geAwPoINHBJAn5+GlqYVytMyd0yRVmXKnv3pxuxXXC3m8FBcKzpl1DBkon5aoFvqGs4j/ISbAX6tAe3+UMsqCoIwwdSw8owtxUdSNt5PpedU07jIAqgWUBVRYeh9aQbncAXUDP2o1cy91EgjyKaqSRa9exGwWvX3WxdNnOu6e47qCFHcbEUfwYKbvcrhiOnAgr9+fsd+gUimr0QvRjF8ec34GjaPnmhGLfoURaK1StYIB7rowlBEH0YDkaj2HKScEx14yjLcVTpitKSAeGe492n4Uo8pgvgzLSy3/K2ti8AKN3T0eFQKm+oKm5pMiVIIGTtH8ihxdMydNFGdCYzvQAgYbHCYPhdgvf51CFTz823SuL1zX0XU3t4gw+qRJ0+Xo26GpLrW4Ll+kw369OENqzNLh5XEuWamL15xzb6XiVNNgtxJPGngLKlVMt7H9iHoCkPWZVm9hWC9p8us2OBSuNgBsI2A1o4F4k5R3G/GCyIvEORqH5ZQ0hZnomZxwWeo/cr9F8nUI+XWo5MgP+yu3TAtsupR+fdlwikw061fo1s2AX3fIt+cFSSH7ZQ/B3Z8o6cXX7yhuZlJUpc2QdGU2mjD9FLWj7uaNB4ZEEJiiV3evvQH1shjPhTrhSzG7DeSEeV0HQ/LDQvKxTB+/aS9JaDIh/KvHE72TJUx+JhWtd05ErdW5dFB1R3832zsifl8S7vD2Res4QOrUuHgXI6Etn3WlLgVOxLaLC1Y/uKfqpuY66YGQUO/PdAy000PHutqpfn8caFdtUI6+yxWQywSEK/RLwQJxfL/yw7vRYL4tllfEEei/A1ABLPUiljcAVCMvkkLheoB6HACbSAqVyyDhSt9kbWAA0Ui4olU0GDhvTzbfbSRZCEiay7v/uzWP3ZsQXuJ9dfuuYDmW/n/85Y6nXbwUmGJsV3dwTGjaTMgD8hKCkyqis6UWUBqrNs6qqJ5vQXtgKJBm7Y3Zgo/UyR3KSbk5+MKMMzWgNlt7jNft6SWUl6lkAP3zDIqZmgZCZ4S9ywdsJtV7Ank3z8q0F0i789XHGbheu56Dtw3Zh2uNy/IEd/cRn/XmS8c3oNmgYvsIHRqm1QC2qQrjQkCwl7rr0f2Md60XoOqANJlUXqy12YLeTqVaDwAbuZtUQhmBoj61+PfO0RfI3v6Q1O/C60djhUuxZfK1u2lEG2pPUmrgzpxHWSNnU5vhHmfLNsmBmaZb0i+jzjh2Tk6XJWc0DAF5vNQCtg9Iqu/KuVnUC71mUjAlm18B0Ad+JXvV+SqaWzTB7pZZLiqZ+FVww5ulPZlhCDA0DWOzb0QufEBIgP51qyJyIg8/DBLGxsav0CvF0zApE6ROQqXZrH3+YYhpu+g=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100