PR1nFXdNkMY/hkEQavLpRYUezSsnC7xKN3MaS5YNGz2E6bSamiK1QHbVezazvjzzjxnLTcsKqIZlMqnzXh3cGvrTDLYOwlDvdBz0ug3rc7d4ji6Kv12sa3qyxsFrGw5REIyXMrFc6iJw3HPYtiGz103yRrMt25cnotHiO4cu5zoYGenpTw641iyZriEmqqb53LNZ0whtwSBOzSy7BmiEw/DKwmCGOD5wHOGvHXPMxZPVYcweGfit9h0kFbPZrS2ML/AIif3ahu2mHnL+ULxl2I0ZOBs1ckzNJiyDaQmoxXALAJUUbVS73OXAA7B4GiBdLRVk8FZgHH817h2TU1sRLUjBoDQ50mvl6bUISdShXXZCi5+iNtqUiqnUudP6VE3X+PrT9GwoGCfMteOCOXnB6Xs9GrYOKnDjo5jcK5U1kuXCv6wAj4omQsJBkJrrVDBo/goemuiEixit/pO5drzQk1P3UkM6el4e6nUpJ07m/wmOWa3roS0QAuUAO26NXi5pSucv8r1cTVskg09qwUe7xnzX8zaxy4asynyD3/woOq5sVFP0dbLRnaAhrtIDjDnqCPOLpv2+8LwOZxHJSAXSBVnY+eRG1WOkvhKnfgJLvhF2IdEy5Md1D5Jo/w5Z9mljBa+TqkyxPtUeZRhZAYU3QW6PQCPUyD1nQD2fpG/mdPS8/hwhjktOiLQvo7Y8iuUAHtB2Cz0xgNmpud/FG3dahWkUNwPGUfeT2TYEAPmACAK4KQzZ1Q1hCKf0GxBXi0QEj1UD2wWup3btVZYlgu/U62c72Itbidp631feuEmwMZtD+b084qBmArXfuFm++RaUK46hmaR1QF4bAOZ/8mEAbYdgrCqp04qMoD62qNFT6vw3AmDIVmIox0Ig9e8Eqv6KOYm/vQugk4qiVjgMauOoSXoChCMtQta/Yngs9Uvgy1jzbH0KUD+ODmC/7S3mX6p/J0PNipBbGNaWtrOH44onIcqqYUrM7w7F8D8N/VjTLohWD2X4lFBRCrTED/feAkj+/+VSOvgFVCfHY8KEQs4hzaKrzj7+XIyYlxok7voa0niZ7aSYo34RVyX9Rg0mKkW4sB37A7mM0r0iq1IbRdq1YBiijU2dJxPZRLC2EIEumGaPx0Wu2JBA/89OLUGAes62oxi/Y6qun3HhDO9M3vdp2Hg1HsvkerJO8Rau33YYP6n+3Z1KvxgwY3C/gxulqHVA++CVeDuA7Fd2c7y5jQzrjvuPlRLTFu/QJPCaZO2N00dGDjGfDj3rndIBp4m8RQBPMjo/DhAhoCrXJ7nP5djgaXGW1fMuxsqvMbIZ1ViY+pdr0AwberBxuP8/H5ryKLVkT6dqBNe60Ze/iu/PneEw7PQkBpKB5oxAlEeRQ50=
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