ZdwBbik8Qcj7pir6iPcnYbKuz/jUP2EgW9JgM8lffY47d1DBgTNs6RZ04haQz9mXn56nqIf2jM/IgOc5TwlGrzf7DcUMl913mhH9nmNND3+Mza00KGxE63nm8DWAV2s++HKHyW4E0vlBdDlnHlKFyP4UiMpDz2XfQRxsGOIoA2ANOSR20jX1aMH0bcPmTpUNhkFBCI+9g9OThUZpFSZOM6MskYDi/KDuSzWepRF6FCAeNUna7/Qy+wDuQugp9p1hM9pBXs6kqrWyMNhHw8aYZ0ocV0nZo46Zs6PGyl+R+LKCR6Q3KEm1KYxvIayL7YI5W1ZuaHBkQxx9b+PlxlTLsjTkAaEUw+QYz/szPSY4T6ke817IZvotKFhIkTO7NuTTtw5GuCCbhmF5U16gG2wbHGTB9KRYIGxhRzig9bcVJI8q3gecmNx01xvTNjQ+MCPWdAS9NTESFBwn5kdYtQM7Qo8r7q7CPUgLWfGyWa5/Zp1LTeRkksh3zvbLHQHGysfGr2X3iT7oLDuT7j1my70M/h0V57uLxYbzcjDq6AJGZGfXfbLE1ZFQzlEQQ1JtiIuWev0FUDCrWhM+lMgy/njtr4CAdoUDkNxmt6gn5WjGqsyi5mLx9hF23eSzdbPES7+Kvv9qS21cPIc9E8GYxV3FxSdz4dEyE5HP0RWcwKG672Kft0fnKrSud+KBoxvivm+XxvnCXO5D8cBqpk3J55VsPoXmuCCeptjA+EiM7t1JFigmmiW0wDM17+t/HcvLBhoLfH+2SS3kxBSJOLv720z73uwXn5uogSaifk6PAhOb3QBQRouoEswo1ieXILCYdhIiPM2lrVlKdtKw0EPWBUZozyXDlvJGKUH7fwD/p34FjCMG8+pn9LZjTpKHe7z0TQekmJJJkwESI6nA+5vPbKuLXHmvquQ5Guqb8C/b3zjh800OUY51oUJqfp7/DWFqi7BVy/A9rzaS3xksJKLmT4FKITQbf69Dmycy1F/J0l3NTICsMj6NlRKTrDr8Aqr2UWSW4RRWsi84OT5tFvqGtdQNc/H3LFJHLb42PQ6Oai1Jw/u7G07U1d3i0+W2/dvPyd8ys21liNFOGGf0j4juQT6kX6Ow+fjTJfKLH7Tt1wNhzcNAz/o3v0c/qOaahWsMn4ibVmLz33hs4cFc+yBbxFys7CQDA9+gEv8UIM9gBR/POM4XH+CvAaZ8tA/dwP/ZcXvUBrUm11yBAFGSFF4hC2K3boWJc4IMDguF2OQ3aRPJHNd1LfTMChKcK0OkBGbrXgAiwJHVJbtBmC6MPsEip37FVjO6zgpwajfQRVVMhRs+x8smzIEpCy5GVHJfGbshlS8PId7r0AhjPHWTEqOmcoEKzxu0lJbj2kkHgn6ITqo=
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