sWoqyoD/iv2fU08eXxpr7ZD0r45IZUEvvsl71eRhUhcoFMuaCSlGZDkYYdf+n9Yafkxp0JlAO6gT4+/e+JN9xlIl765RhUHEi/BrWkZl2tXOQqRq8CVJBdHJLWvCZboHaiVd54x71OlrHBSDs+6eeIqe6QVYo6LNnYdDoCtKyj88etKLO4jLmvZuVc/XW+o4TOUss5UrVC2hvIE/plyhjU3gn3oaMgauxb/qAAVCRTAznMPPVqa/3pCgmmOct+/86x2DiHBmtVHbmRcm0q/QP6bPYRyY1I7yC2uFwuq2Z8MZlw13J+PBHTHNtJwNKD8XwQ0TeLwh81+aCy7EksuNdXUN2GwkogHM/SeWeK2IvvvVx+8oWrWjRS5wZukvSYR6lW4P56IWVkJU36wdrFGAqS4s2ykL0k2EXtgRxKG0PH1QaMvun7BJx9eZPvs46dWAqJNOC34B78TLConLUZSFufLKA0xPH4+Stqsh4EOfAGOIn5b0eeQi+BziFQas15b4wKSR64vJfwv8Uu6KauMKkq5HoQNCrItEn6mGhsuraUmd+b1qhPuA+53Gu7vJyzCqdsgRI3jtlzyxnWMNqSxtGWAroYAT34uoYNOK4GiBkL3uO/hiLgion3rgtDGtVO7+z4UI+3hIPRkI0ac1IBsv2BskmGL9mN/aRd2s+7dUKO7q8WpM8hsPb0zyNywyqq+A3UjE5maqzZs1eDVPOwic+NamDQrPE4Gf977Lv2bCIaUNC6No31vKeC8d0VuFiR7z4sjxTZRJj5+ekpApUXAEPtTWU1N/cn7rR70bU/f2c//Us5ca4DnV+cyX/sypgwcqU/sXclOILYYUnweiYOFCXbBCCximzbnB6GzGOWiiG+UwwoHOIEHCSu4Dg3yG90PsCfc34EW4+h5+TD74rMgkOXx/NvnXNllm1VOCgf6JNv8WwN9w41Rz2YEfEsZZkL3QEOyiOQXvah5tILIpXL8xv/L24Mvw5GUQSJ5R9wrG81it5qrZ/6WQzJoN0N2VB4kjbPHhTRL5dBstIrsoyf01sVkR0wXaJ/6giKGkDsGRUJNkMDe3qRqLjezUChsyqWM4e7uSfCkcGrudn6H17BcbWvig5lcnL35pvth6YHKiNp+OgVY+2SFvoJU8RTOaEFFuwRKYhCwC0S6+89hbKrBxg4jdaaCs8xEfYpcz0WLh/FUJd0kEHZwRXAQUPidryiwm0emB6c6fwoV0WMyMsS5Gm9nr86pu6roOelle2hh/v5cl6YEdh/pWzmjfOz6aezLyQD9AH4GdSWgMykSIZndr+opkCrKEW5M2sua2zDUecCZaGYklXurrFUTAPryKXR0r/JNSjWrCxGkU0qHwLqPVbSfy5vpJ6PAULFpCZpU=
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