N3jp4kidMv2PicSj9D36wNnyoAUq298P9dgMiQpOHvur6cPHC6mahs1W4Cs3lUABODY6/I2NqY6Q+jxxpGYkFS1oLxWIhndCitIsBNUXBOU0GcVemAW/MyaY1YSDGnlKfovfjIfBQ72emLaNSTt5eCiu1PWWdZLpJ0vAYDqsL3lCd7seORK2eTW44ULuE3vyFANGbVaP1oBzP3QZNzj/HKssDnXUZnI9NeLaOLe6fTheEQmug4QU4OLhWOp6IatE5DN5sDlGTBotWGxN9QMPXXLro6krLWDpbr6vGxHU5HTzPrypoo+LoonwYUSW7338190L0PTuPQxIda/PHfUbID/Vy0rRIz5DfapW2AO1rA6yySEN+Pjrv2jDG/9hKJoxl/fdfnOBa4CIkW262q7fIFSg3tih/SWdPDedM4pGoQu5Ird5TS0WhHf2u4wiNWD6My/VlS1BiBq2zKP9UzNl8CvCDByq/D61ZehHBqLPNjV1yP1/xytU+0rVwogecIlMwMJgQ1TCXBGchtxzA1cdsqBW0i8sigw65Uj1QuJhpix+lKn1JSj7AlrtchNDZDv3QzFW+G0gYkMAas/MkFsAdnA4GpcfkJEuD2qz9IGuv7oKFV+6rSp6fbz7xdIHRZ6+uaf1EdW7eVajGC66j3F3b6uMxQnH3wPQFGqMes9hTYDexo++zavZQKmLDBkUPVniPvXX266rRyH9TIcEtVZtj+VMOJH92OSvJ8lUtk3V9RtAsS8gJI2NllmRvWpeFMdxQ9UubL9A2Ir0sXhKqQ4jlrydcZOGveil0fO0Squkj0XqjuY1Nic4ggmkYqQoN32WJepV7R3MF/s7JWUbuLRkdqA8GNqMmvoMA8CzYSPqcfnNPcGFGiKcW5Yh0bh6ikfXdH1807NzkC/T7hrdwsIOgq1T9fRp5J/cU1NI7uf+JEU4Gwvg934sxsjdXVxwTOb63ljnAABRUh4qvKhU9LpXtTMeQqADipTWYy3He84Q/3/F2o9A+xIsTJbaebDdt9TFUMg/v0u1ATNK8SCHS5G1fs9Bu99uluzh4AscRc77EmpJpiEYS3nnvqYKnkSMbJdXGv3wHnZpK8hlJTe80TmkPPqvyj1LUTQMpBJc4RtGfjZDQM9DvDo24jJLq+tDqtgTFPRKf3D0q7U0yg2ckZk8HZ+7B4fXfxeEFIhOalsHc2mU4rAStnY4e85bk0nrKGyztcOFq/oMjtYILlOdGLNYHnaSLftwXHnPdNznivy3JR56ns1RkFsaVyMiMa+OxL9jCWKztS7QcK2qN9uafTepQ7tgGXr+tWTzq17FoKl3U/lj8OJwnBDudVzknjcQS8YMBPBkg1Hae0wLVnUip2IFjiGB4fchqBHEjL7Ev6w=
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