flVWahLyFY2daLIuv0OBMCGPShK/6CyXnbmbomP/n/X2kf+kyKoZyr0JNQzv8FkuS1Mr6JE8r9zHso62WvWyI+eB6fLcqzef1hSMQe+VQ6h1tNY9w3pyCM1EAYbwSmMSEfoPerOU7vm4nkhyQuYJ8LjnUJbxfvMRmikEZLWotpUjUSRtR1aAKMh1u3EmkNyYSzWrclvjY46UvQnldzrT5x5RZMx12WHYwlhWVVMJPdpazhvKhp5VmtTnktBNRQyPxFy44CQj3MeCDCxcwL4x4yv9Lagiil4YqmVbq9x8XxLn9/+qnV+CN/KkF2Mb4j5vmt80EPcBHcBc9cKk8G1ML1HAJNOouI0oiDE6JKjFwFD9cUEDa9V3BewLcHLQyl4reMjJbyt/1pK93mEVsWlsuysXw2Rivy+mwOL5Tv97dmnjXKRCHao8DjkKgm/3REcG8yINTuzus7lNE8E3oMp5HDKMVj3SWI6kEKQ1U1INakvl8Or5N4BOz+QYGAmXB9hZHnYl/V5Ejp2ftubNE99wjF6VWTPybtY0b17enyIwz5r0Isv3WbFRT9ttXo5Vz+Kgh482qEOAHY32x5IOj6fmA4n8egoHwfjs5AegxD7fpA7aGRujgEvV0e2IuvfybqRrhOLvIc2F5/KLO3u9DfEUulgMJEBsSAv7LDzqA7alQYk+tqxcHhQUfSKvNyi2E1+IiOLjEihDKtDjd9htdEWy6J0RQ2P7ffFe4of3MBBP39jwPLYK6EI2h7id/+AeT6hEX3JXuq0LZzkPh6YvQ7r1DA3gKKKcZtYOAEYBAeGTpqnXEho6lGbhHE8anWGtLV4z0BbzYZgGOY3ou2Lt5hFXFJZJG5oNQXeZhMNWu3pKmsKT3rG3B7vcyAlm3INV8Z8G23UD9urDyVR/WxFPuKHFmjSdb+QSB3d7CXts5oboY/9bu8IBgZHfPwEHuhfnEXiNdnNb+OwywrTR8fNECVXYeNBZpVMVVHgONlnOgoKYs2p1+znBGgr4/9zNWZ7zwkZ/z9yXodG71OeJpD+cgfNWExCrwTrcqtt6xVfv4TvWrQF2iVt/yG7sEV7VJo18FBbZ/NR8kHYMoeGRshoPjOINhau+zB16ErTev1ZQbg/YNcE9LH6uC0CrLy6ABDhrXkt1zYejMFMNgssw2VtiXshsWtonykjK4RXvWZTnI6iq8+UADf1csFnl4UGXI0WG2HYHQ5vsUDmvwSiWKXmXbG8MS7mNOtwRRBCVvmsni6D5NLmdP4GEHbyEYcgjVXxHIYR8QvOtMi9qRo5C1w093hbVXQ+xCrp6Lzlj2kd/YSGMQ6E+fIFVckyhA0fKJh1F/wrRS23qkpkpNuSTyjGwTpBSrL9bo/nvufapd0UMe8c=
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