BEnCQAu36Tbpu7BsWmm4xwHRkxL24jO/39D/CuCRoGvOjAKqEJNznCo7I1c1LwFyaB5YEH/CwilCJh/33O+IcMpcR7RIMbaU5Sf2FenJjP5NZHoqlvoVsC0g2sIHAYuir8EH20gwIrIcLYBwjIElpZMLw5gBoGW+9wusQV9EhrbRARtwHN2X2BrsgX49kzLmrBIXv/EiFDO4ACJZdPc0F8XLT0FQDc7avAShCk9RwX57awdAuhE+tdB5hXCYlyjn5tqc8F3ke3LE0rhfFi23Vz8UqGTg3IaGwOM9VRkDLdWyCtqDr8gYKwdtZSp1pYCpvdzAnQYa9hHCib2OcHnHaJNWeQDTJZQOrCxxrtHX887twdwTbV1fP1sMy0HfEbwiSKeR3l1o5GvWb8oT6/QB+w3PhLMHRb8fnl7MpLc5jTOVI311t0Ct7ITgbRwJFe3++xYFwCXZg715lCBqyQ0PrCSCixx9DaTnXwjr1gtRDTx1A0JoHS3D/4i7mI21qa3dYcj0dQOFvG18Asj8L7OpfzZqI2J4far+lO/ch3S8lA1oeq62rt65qqttXTpmhzyK3pwWW86PvGjvZZbHyTc+Od2OG/5ZgxXDN+915g04/wXpyaMVY+pCPgRqxGDyPzRsInaW5WGxXs9FxmS4N3U/k/Os2XkBwKcWoqN3BUOhy4xLDh9FeKJ/dyNON+aAcx79pVS+A9Q/OtjQ3VqRHQT+a1sKhLhMhMdAJdCiQnwpH2yM8/JUzDwDd1r+SKFzCvVut5wH4W4dvtLbtkTBQcrW0ViDinuTK84eiIJDJI6a0u5NYjvCfdt5LNCi2d6OqASj0FRPQ4RgjeuJ+TiNUShLRARf4IYSPRLpNiCLji30Dtw96EZ2LaqhLe03gWuhons/h8KBLxqjEymlUzm9V0+m5vya8jRVPUXnum7UuM3PkL0WLJoR2+0c5Q3IsjXPxkqfUYFpmE0CBlw9GjeSKX/thrEVOJU+4HbmEU5qdw/vqcC7ElUt3aF34x4CJv59V67ynVEczYNCOOdKiE5oHju3+kgvrGoR/H3BPd7NR6qgjDkYQZ+w9/ttsK1kCCeohGwFZq3xbIJrbIeyYf8DHBPzDshHOMLslciaB9ai3ZZ8kkkhFh4IMDKr0WPy3W8HrwesxamCTQsZRjJ0unUGeftZK6rdb/kcEZwU3UeAShsKgO1ZaB77BzdWCoQymK0RzOOYLcsDxv+Lirl4lqkaM1R0aU/z/ePFs0lw1nKJA/iFPOxtR/lW8ZmX5hHF0YKm0YaoTSb58WRW/7LjwQ94kcVbrQqnkuaRLZYUTWrSmOp48X52Sf4gZJ2wxFCMnS1FlRejrhmQWbDhKukKEW2mysSqP4eS6jyYeQSFwLN6HTc=
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