ygVo/SWcDPSTnGkW+1ZLE1QDIc2EYMLWX7yfJuN/7xJElGVe1HwPeKChsHPXwHslhDxR4MAmHBSf0Si0BesfGKCbYVd70NtGH6MPteYyyrn1du32VFh+y7hc2m/o8EyUOUBS6FKTJjm5iQaLsDpdCwN/+sdRvnAZX7Mb8hRPV6grDTIlLhspWOls2E40+fP9lNkmOIjTIgCD+/TChs1YBnmN8aSLupwTjzG2uQG8Dr//PrConAuzEzv9ThdPbsycfEeKElUoA4XynBKzX0jm/AyfEQziif4qg+r2K0VRaZZ4gHTXZODeyRB3fic8cwi6jXHvNnYgKwC/epreQhCk78adgrT/f2ya89Qe/IrcOsWC2UwI8VS0qqI39Qdan21Mit91SbgkMB9mbMjtKQofInIf6ESZ5qpREDxJzjFmmPbkxF5fsPZV8Z7AfIw5yttTRCNMUpmjttaRVI3grap29klA/z1NEQkym5BRSECuZFc76HpK7crNB5FnPvCjXi6/Ujg2P8UBLw7iIoevKXokTXj8OKt8guxNvmUFKGItleeRdn7Z6QianiNnFZKqPMfdgCRENzZqFZhoyXGKi0VS6AffNL0W0Xu/p/HGxVEDu10bYdxxvJxV2rxtJ8M1weCPle4F+/URUyW3eX4v88vzp2FmOj0aOga2MF4l/8w2vtIN/yZ3JTickmuvSx0CGaO836Ng0YJUxQEgeNLSW8Kn86yPt7du0X+hTKUHXDSPXEVeea4g15FidINqeHjsiWcbS9Rz5yQwRFtkDm2E2Qf6Oz6VQiYdasOmFMIN88+0AOD0tilvY2H4guljwOxarUkVq9vIIeXbc3RicYeQoV+nUYB7mOIdtif2onWfpZYXoMdMISgOLH6gGdK+UOZynRwnxTdU9RhnSFFSH2XAK0SHn+LoyMjWV7AOKJs2dCkKld2lqaMdCswacZbpAhU2TXsgT8JpagyZ+vzdphwQDuyD5M32eNPjdj4ZKhVWlwdj3bUCjBTSunK/5VOCVI7PDtpjkZgWas9qM/Pcow/jIldaYU2cga4znjGTiMTotemF3mAEic+rBz0K4DNbku1RIT0g7lF+r07zbhRXF+BrhrKtMpr9KSEtZVjfCIDl96V7PoHMUDCsY/3v6Sug21Npsfv4GAGvQ4HFpMj9w6ieilGQ8OPd4hzL0ZTqwmdyPWZKP8t6ZuUIFsFS56hyv/uI3RAqQKFZPnX4fGOsGRqlUt84OHalJFu/z8bJMVx0570mLnTdzznbtPkjufB06PBr0hESjqoDaPLXbCedDDuUKrxHIScpq+EYKkexSuzrfcBRzN2iZhaonv10toB2LxYZdb8ol9bxDWowi1WJe2Sf/qFNZzO0kZEHB5+X8GU5CdQ=
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