pRNoeFmavAl7mTJq1Q22gyCTlbyDmptmu84R/tC092UYyeq+Mg/ZcTt9AuKGwxSK6UKmY6N1sc6FjQ0INwTqSszCTFt2EBFFazFqgFxlE+t83T4xJOU6oaEz/2qajj/ExVMczQOSO4bS1gwyY0vyyQhJ36XBel59yKxroZhWK+q8oMKSqoQibXv9XBIR4uUpzt9iIoM+g0iv5j/h/vS0nvT2w1XGV1Tc/J7/+7jvw7HecxI2N3PlhIpelBZ3NCLbTCOpGMfLQU1kcjYOIjzL8u/F4mShx9B22umdnA6uHaGn/t542C0Y5esEXbbBqW1KePGxMbyn2ns6c8NGcyqa2lZ83eH05Lje+Qq8O/thOn16fRNPgRW70IYXuV1+91PW35lX+9AWKV+KtxKtUSHF8IhVLXWK+gqhOS9wZsTpigwlRNLib+aKuJ6hm9mWzZb3RmN8UoGSNSj6rp50wMM29jJfDX226zI+AncC/vBRmyPbHEo+zIs51Vm/y7bfyfwTB4IcKB4/DGlhx7EdYbG3W0cTlIy1zoNA0TF3KrCHq7TVnbV1lqWifggVZIvqNy1n8UGRa+Zv/+S963ItEBUDNQaNDGcWEuwhei/tPcOd4i/nqRcbieNLJlEzH60d0p+s5nJpdjgL3XwfCcAi76Y79pqRJjxH9pXCZov387sXdLiHP1mzM0XszeaA73rbhYRNN1eWgaZt4hV/EtgIKyulXblqldWlDNEDdqss0LcwqododXsmQKbLnjzRzdsfl3vhYc/yfKzN+bCotBWBMy+vG7ZrG0on8e8/4HzrgI0b72N+c9RsTu9KwbBDnK7mDGdH51tBAOJlgRyudMVYcEKhHdSBYwkQv7hf9b0+gA2obkooPpQj9cPVKXCnfEvDNCTuoW7Dv6y7a9LjzLx5HLjSxOHWp4kFQBkkoiCbplZsCo86wm/gzdkGu7SpLaLF/oGUCcap8KFvXVAqHLwXV5E09Nc7tGm0qXp+rm/bkhd7JPXT15rNXlZ19ilEZXy6AfHEsZRyOUbSMbfCqViOvbyAB/bZM73/ZmzrHk9QHEzsH8dD6bD9tiTqzWysmi4U5RbYywRUzJz83cV+jG9xu68DUieXOdej7/OCQ/iucnXN46ROsbznmWc4tPmPWRfJAhap8Ix4R03SeR59ZA9rrFGoM95D7ZBKjFS8JZOMKxrCRZrxxs6yjf56750SHsX8jNEiJr7D8b8g6sd/GTtzgB/xmWQpp1EMuTvH1AxuFNw7fEFV71LJ1N5kxneq+G3QFEcM+6PZSNKaA/4rNTl27GsobbpCwq5kUF7sE5q29xJ6Odee3r/FwAcC+txgwZBqviIxQ4VGWDJVn6OWr8JsPGzslZ7MqYXRQbTE44SEKgU=
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