l0UF9BVKfQ1+LzzZE1foVWGJi6xfjVFRJqbtPpGls9kEZar/VznfE4j3CUXbssApHCoif3a2HqfjxRgb6bULVwTrrXY8PgnUijyxzyoFF/OBnYitpPy43YMzKG2bAgWfw2S1RGA0WQO9nhTRdsPef/0h3Nhyqrtf9fSlcvApSvKq11aGVgEPp3GfLAqneJj+UMKHPZQad8vg4tBvWvbAeW9A5iZSh4M3ZUaPaXX3ti+3e0udUF3/iGi/EzJWOHiykO9mvbJEsmaRf9awy6xW2GmYbim9tqslHoR7ZpBSRufZBG2Mr+85rm2csGZBJlhlSjHghpOuZ25zt2zKjOLZUD1UsOQwS/vOCQSejJutqPkO7JDTyzruYSqYPxSl6W5Z/yWsyDAvLEsjw2mE9p8gmwY2mPlu+0Lj3ZlBR0EQoUCcJO//fev+/uGa7M1xBgYUwd801fkNKzMfYdrc46sl9VxmwL3q5EsPY1qKLnZ37KL0yAoefTBA+35ZL6bgMqMhWTw07HUXoEO6C/ReXHUwPESg+Gg5xoyb0gJiIPM0icqlo1ck+Tk4SRK374BoP4vPAHGjSm0wMwmQvVhS2GLoXrI7c42OIq8ka1B9jw/p3YRZHIOVMsuSCa6N2FnhVOhstG2eAHuS+qoHHTvJGJBkabvdFw85jIWGe4cqk1AlPSTnNYQTfEYs6jAC0uSpC3QYcbLooDNpIFQQWe7KI0CkKv0RvRsqiFR2iJmExeABAs8nMT87mKutZKe1R3w2X40aygoXlJuCp/0Y1zHYZNUmze38r0Iv27gHkD6MgYOroyDiX19ylyUDUBpMlzUv62x6mNhF79suGE94RxisVwBxX0ArcxDpxgBYLKBPRgdUeg37V/FxSROZl7MYN+yHKI1vZ3+8I4/DBsp25o0CG8Kla5szGktr+Z9kCpyVFx4ZWqCKGoRGdpTtr20XHlmF/xk9+VM+fvRUDjRdoistnCQLVeKPYalke5BUnC8KteNX/OHM/Uli3lMZHy8RtLoPvR7VKRUkundOqqBoD08rKI+ag8tSt30ugwrq1EyKMmUnsgwhEbAfNhhuI5BYLO4uV2KJhsbBUR5RtjM57Uchzzko0I928C6MT6llBdWkncvYSlcFG0516Rx3sghKcoRzRhtgqIag5gIWsHmGHUxWCjvvFmjjdwt67VA67tVfwGeiA1UtWKpdf/0dh7nSZIw2AhViTri/lMaxzR1e5WhZ16AfwizlcanSQh+c1Bv5JZ6N51vrHOw9HvAGYg2jq1PJXQ7XNhcxpjd8N92oPgZ0awcbO8KKKY9ukkEIOEXOwjR59iaGRN9SseVOtinw4w0BA0AGtsqL39cON2hveG4xTzD4I93S9vpmD98XnGWsj80=
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