CIYL+zd3CAcbySz4ctzxufoxvmMoiVOBY6GnC3lKyJAIQ6udA3/izluJTmfleNC+tjFt0ChFIhOB2PRIqa9/SEVrN/BhwDi0GvuzuID5rjLjLd8h+Wu/646hDfJOs4d3s3hGA2OD0SmszfQqjiNVO2Lkb1I3BmqY0l/02bT9Wnro85uhps0zjlQXzsDvzgYR6FMf6DpfypXduKDcxaqOOt55o4Bk1HRx/BN4C7UAA25ESlgu9wlkYRDwU9oXZC5Xm34G8yzzw88ZnhkCevufckQV7783iSRD1EaqEjjnC+gEdXNX+Bl+ALjRUpRqqe8BXgbnlLjK2wY4IlXQqMIFaO+SqhVJDSwdxFNDYHUgTJKiQgLlWb8am3B6TEz9BAQi4a6+0agC/MTTQiNnxLbttscEHOBIB47ze55FZkj5oaD5sng4qu3EBCbUIflxbIrVVqasoDGQzJV5862kJff4MFBq8ykJgNUsKFrSEVGgfIp3IufojZKu/AMQFZWv4l4VLWgMt6vP769EJuzPrvXLiPqV7wIg+bA3jKqKc25bN2nG7Lk813Wy7u8VKxU9wbXen2xkGkPqnAYjtAymghb3laczluG4GZdg2IjzRHrVu63lzRn4+VGMBk+Olx7DfGJsbGhWnzpVXPAdtaUbG2Guk28Az+/DrFcGxTRyOAwVGQOfAGWaJ1dWewfyzWxvnGB6Ce387tsb58YwaCTonV4rFTffZa/hHt2O4EvK53b3xA/gmtsIMhw8XxvniliuP4H8UTQBlxYZRS7ztnpzOjipGVgSbHd+myHj7YyvLoxfdP5dpQC6lToa8h8UAxq8zrWDQJgBF0poIItu1hrYCEaRBa18u3/oKCdlUJPTa9xQRl2/9YxOk549IHS8G4vZbtwmkvaSzpZIR9KjcEr0eDyatESTvpJcxwaiCgx7ORLmGmwyfHxKFA0tNz/47Vtai7Hx/gijUdSKDj1Q7YB4lsFIScbG2nEHP4/ZBwN2f7k4OACNBDt9edG74aFDMPjCqPfVKQ0hAJ1PhxYSny0n4blJYAU3VKi1Ta+l2dZ7zOuCfX8RoOz25MlR9dLnHuJn+0C3V1fKPTPpgQdvAIlyT+RugMThaAlnwZhREC5dwd9alj3N6Be6pFC3fPEYWvikiYBzipoHxrLlJEuoiAx7JVOCnUqN326V0dljAh2LQFBT78Rwzuj0+2Mi7Vbv1o2QTcZoP4Mx38WnW2EesvUL3zJowUdI+iTug4eWagxTnY+2yYJDrioDAuEmpU6NH1M6Eeq0YOV1qIaRBlMZMUcmEpYlfh5TTxoUDas7EPj+LnVX3W1LUFOzMjD2cZJox7Twrm3tsU1RhrfFdQSucf6PjBqFrVaY3kBuSOv/jPCNov0=
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