1NmJnV2rUStcHeJ/kkiFzeDPWrFR1F2OFM3GCwL4u01jde/8C6g6QAzZn3eW2a6HSaiC2VUH2NOtNmr1aTZInkaX7cpUbaC5D3vnuecFnIeNrh1/NBkb+zppYf1w6mvfdnYEEUcREZ1Qn0MA31Ao8MDcu3IIQe+MbPMpRlxFqTFMcTsFAEvFPg+b0ipExHC2LqYpmMbITZB9Nv/+UVjiGMCLjrWuOi39vKN2Eal4OPLw/M19N+hMvB3y/aJdf3cw4Eg6aq2uGzTR9cNTBJaZpp6YuM+WOQHGm6teYbbLK/g6UCjCyifG8i98qUIz2ZZwxvdd8WFbxtD4djeAa1PMizfeWQkySEQCSVhfcBvYJlOIrtTxsbGE//VWXLKXffwfXfKBnA/15hRlHkzJ0jpXBOQDlGRM1xnXd2iTKBvOYf4VA3AP7PD51faKMvzcZzDjEe9tXG87PiGarUw09IIeS6s24yzVYGYXZX5CXEj5aEqTH1ZstBYVriHDuzcnIYzyAqvSlvFKlRzV/QYDromxUocplZP4/Jnm+9YPTyjywLtg9VXsaDdzLMPooTlq5NMLuhnkTGextFh9L2qN9EHf7ZZwUmma7M6HJCaY+/fxL/MstCSkP/Yvhbq2vQwWVI7067l6eDUf1DwNKalRweuoVJJWRL0ZY03BVbx9gPxQZdgzycLsik1Oc8RF6hUSQP1/s0STW0wlyOInK2HHjFmQQN9Z7SOGPiqTYbF9u4LELSyiQ6WWYpK95+mb8cvQLpkYxS06nzZnY6pHPN1eLn+2/DR6W01hMJJ1wjbFN4/f7UDYFJWeWkq+ShwbN8Tj0/DVBAxqaCpvsvP+uY5yovgQiPSVqhPBbKPIP0kBZla9nY5mFHWVKbVz8YUMvxkzf1bdtQAv3v+FxwLt7Y4qE11exrXSPhalyuuf8jBFiA4L0WBveokj3kh8LKmYkDvtCuyPwhy7UrX6X/31xyi+BFlZdx3FqKe82Vw0ed3WarZpwfiYh6MoMU70PbpHNfdsdqLmHH5jytYzYFdwsXAVxRnljkLHZY2gJQIBvEnv/FtcIY8uKSiMGZ7v2ySCun4Y5XbgfkA11vHO2UdRPqVKj4Ard66I4/sozko/GBQdOHIXtL38RQizvwYI2w3EtBi20TRw0922WmH0N7dlgmH2B6Ny3i5UUVgad8N6Kd4taoOfh10WCthvm2n1dhbljlHsJyXTV75HQSTn1nxJLiumMCNY+9QhKOWEHsTIHxWS0cKNd57YirNwYOqmZQ+xv1I4fNSWv2KjPI5BK0jLdJbBUSlseDoXXoXEiW8PUEBncLOFBSDoE1wqkK4XDvLnlFqBOiY59KPP0sOEnEs/Q/42KX5vk6drUrVAy5pxm0NEy+s=
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