q0kKPGNp90Z6cfNHzeMpN1vt0VQCPvbR3VMaev9X76HKZx302bz8dKdPdf++pR9zLoCCqHXfX9rSV/YkrN1mN/zuJ3iqdUgfUNvotxWWCECYQPzOQCyjFPn9o8I24WoqgO9WSAWCU+dXkZJZgA9ERvpvPpJ7INZ3Hyup3bVVWOdfy8xXGtf/yJBZSeeKRmATasvGXiuQwgUWUjQdgGTArzCmWJ+oR4ShP6VDdCY91xV8YKlTcFimNzsMwr3IJcoh63YwPlSywGg3EVhHc4eMc8uRzNJdZNNBVwI8q/p/luKCWqZgWiLX4Nziyj7q/g7O/TdEsvGy0t6A9tSr0MehR26TcmF/JXzy86enqSGfX6kPs0ssCcMfTMKnWqNSzlD4w93o5eXNFzvIheSI9Im2uJk3ij07ilFZ2tgg4tF/mWEwTWk8PVWid4YPO/EPvVh49B0QSdRVjj5Rlcd+VC9ZIHb2GJygIqJOI8oq4Ig08QBGg/LtO84O7wvjzegoDxfP2xQCDlwLnqrjR/ztQVVde/tUO/BWw8y0Cn6bh4hpgE2MTOgy52+TG4e7FXZhru4I363gUdXgrLV2UKckHlMMcBgVSXgAGiTSd7j4GJ51KvH9iUpvgM/1j2JgK4fVpUZ6pzWBSXfyF+0j2gszrLh9YmmYoN/9e/0crUZo1bFWXYGrh/6NCc1rRoYinS2y/kJEleGBbegeuNsJ8KLL6Xd9FiQqR6An+fxflZkyTuw2/0Txretzw7CnttE5L0OS1mFpEPMyGRvjvzsyXHqIqPufXKhYW/z9kriDv49v7uqSomWMPusSjee51aPPpisYEJlX2gT9pq//nwN+OgdoH8xpm6gvMJHsr077cxmuCHu+elBh4v/uYk2baUNZsKp96yF5+eI4V+7DySkJf2oSDo1fX9nwgpdqZP5rI2MmQTEGR98ucVF1KlcZjGgQn8jJGVgt6cCqcyR097j9QCQ/9JvRl7AL2ZCxeYR0YzO9SL8aesLP4Uu5SPHASsx5OEfskCCCpMDKV8/21/nFW29pt+S/TY4bboI3VkFpFoCO4Wj9Eu50HrJ7GCad4ssXsD0kHeY9mk0ZxYznCiKswFG8Z7FnbekfX88u9HftKBQkoGRgAop3gua9cAgvdnha8UWeinOsTkDYrJxzj88IFH9ehVaFbPisB91POK+2l5zLJcul2ZjvZ0rSfX3/5IGGr9ct+0fKwD/3XvdYiQX98mEAsXFxatat+5MVZCAZvvbHMQRiPAFiGB0B/prREh7Ex3NIUbobAgX9q6r+ZVcRLgkHMu7uMRvRaip+AotMRn86CO4Xa+Rq8Cz56tt+KOLCtz6tlPKHDs4VjIUZ2Hs/jIoLk+Vcr4bwt6Q2wSXsx7VgcX4=
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