bXDTKnzh9ZPNLFETJ8VXNHGx9KyYj7oc3MbkltGMmxUr2MW+j7M5me9J/20XP+C/QLvV5XvPm2JqeK/8ayGanCEUf31Ebw9KBfsb9Z2iFbwpygLxdSOniOESLlj8tHjBb5mG4mMuS78Zq5nSvENV78z+MfRPedxrnG2BluWMyBVnwpa89iriGMc0k91HTCZYj0B9DAEPJwQ/fbFnNoQ47Xweh6JKZ4Fc/A7lHvTCPAV4P5yJWoHjWFioVqiHXjn9W8s8Qmk3I5wM0iXv/UNQp0vM6piDynvCO6XzSBqxCSVXBiIUmRNZlf1qTEKKRAuz1xfKQ7ILA6vdplf6e9s/xhfG6nyoGNIWkPs50w8P31x6ETERvghoQPgblIYo6F2gCAUmbzfEqNDwJt+VqcYuLvBXRNjCUbm2vF1uS4vyKt7cH7yW3fB+XlD3CVQo9VHQrKUkqPLuzMk1404rxWyrZ+v0jjR5LoIb0t36pFMX6uzzNOXRcBVJyblTf5pQ/rGoBLTHuvNixD4ZnyCHRVd0kMu39ahr1rJKkh+CCKZvwQFXnktJYU4lgxINQ/bYDwz2tfKgGsl8U7QiNUNVZDBZagEej9uJinpJcVfli8nkDXJMuoLZyoY+Z+95mkmH+UgYyFsUOSYI45UmR5afxNiUt3vdVom5+/O2J2bYoE68QXuvy8OlFe9T1YvJZd41WF4L+E2geRjJvOXu62BWvUY0O/RAwlRhUacn70NfuFqeyeMSi0VjtrHC6Od28xKcOlorWSq5nU9f/3XkxHEYnIZwrAWnA7xLtuiHAZ6ZOJdV40ryAYZ8Oozj7IzjHZlCkEkpqVkyk7kJswPI8yJgiwHdFe8eRU/8bEl5YW765vGg6BN8AAqMWIi1G3Ki79y1/gMGe1OC1J8zY1qPdRsLlNbA0hIMzbASn3m0WdwwLB7v1PtxwtwC6kH/dp4k0AvhdeLA2PQ2Ntw1jWGu8iCJR380Dm0T+ahml2DjLuIbiKmuPH1SKKWPRnqtHTnaj7h8ZCC/u+hKaZy9f+hN5nDYJ2tCao1s2tYNOCnZJx0TDxcd2Ue1RXqmRKniDhfkbO6mb592/lYI/o42VgV+DxeqWOs5lSpFdCohy2Tu42wiuhqzHqIxlfC36jrtyZ5qVgpt68c/mmiuM4DMN1KvXV+15/R6sSEdZm7CAzKejmdhHZ33cgISKR/QamUdYeT4wUP6C4qhsKGIOHEcztWxDmmFaP+g/0Tfuz9nlDeY+MseZDgiX3SN6WFICYgtotDubHQhbxaaeqS2gE/KH3R3R9/nZYCzRyqHT9JdxZ8+rLD0ILX05c6ifkAWB807a/fWEz1V3Yfa5XyF2/oQJ4Hyt0k4ahKgSljp281JP0rCXxrJxQw=
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