dUWvZVcj4zmEQ5ss2Uj5BRG+o4LjPHtXEC1SFG597yPDqQuEI8HCFWj6vMc6fc7YApzdHygGqECEXSj+T+V/Xr6DwQoVTKJ9iHH1dctW2FTczqgDM8Ohe5f39Ttdozf/oTfLkuLjqb+4xIXnLcZ78fAXMH6WGqn8gFAkdIlVMuhiZayasYlMespPIGzH4eWsiGjqWwpDOr4yP/2IAY//twx0i0K5S5OgOIODAGXtirPVACDN3WlQYR89QXoVoKxSAyHeuABxYvUsInosXKOm9JV7jMhwanix4X/Wgib4hu8DS12r60RgDxDLVwtSnEfrwxx+cWtnJyC1KN58td8rDr67ed45kh9dTAkiZGzYUdwn3godmpqrdcrEuiX83nBZswKkLfDZDdEJCXWCg+HhGoaYi1E0apYEu8UBS2ojde5gwiNRh2as/gRZBBV2P3fx2EwRzyxKT5TEy/fGTFVlsVDeHaL/xvE3HlrtaWCBTjJkTRBf8uq2yaFppf2IfXzaRVLDrHWxohK5AVtYLLd0HkCsObGwDzynr2gvlOMgamNr1J0SxsJzh546SQ0fra+pe94uGEo6MLPfa4dse25vWL8VUFeF5ljdCTni7GEtW9pZ6+V7YUO7PfWVEdyyZOy83A86Sr/ucvnA4zX3cUuuXPlnxeh29atzSKQHdmb3tVeB1pXJfNDO1RE2xMkfLgXzgwF3QMg095KA+u1p3UyqBtHCjvRyTZIqRpZ1tlRVTfsawaPIDn6Wj+rhdeKZPhwd8DLC71NQijcpOCAqBfi8yDEXlJMJGkHLijh7goG5dw0y2Z1N7haPhHBC/EQ63v/dD4M9bMbKTzhbLIpquSDcvI7Fvm9af2t3vDsxZFkGLFsjQVL7rzItRByF3VK5rQN87pZzDPPFfJqci9POBI2Ois3Sa5opH4nFcCL6rQ9rqxX6A1kLwjImUR0251nZyd1XabJn/vS2WIOa2/rGfs4s+73FAuagVVouuYEEl16QerZ9JMnXGxgkhGP1OB7G4y7OzWDPEOw08kl6WFNh8lK3kOQPCfU74h/nO4ccRl6jqW8km+P2Dage6KNNx5bhw39HC6AWDi8aZ/mLUlWMtWD1Ra53WHbeiWmvc819+AZnALC7/g37IzvsYn0QvL0FcRNo2oTqx9H7Q42QS7yXCqosLvbESczCq9dt10A2rULSrm9qHYNsU8DfydnYoWIEIFUjyt00Sw4i/va7NKtxyfVac6veBZIkU7Pvu1YL+zQvUeHqF3vYWVPZmAL8sYRPMGAqgm6YFfHjhEtcisv+TKVJKHJiNsaqGp7N2ZB/bmU3ZVG3Q8z5GCAFAFWtWYnWHV95recXdZ+HsB8Vd9JR00LohgDdBXjuQ4XfPzNoTAE=
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