iwiLhUjA8d41caixt+SJukXq9cXNQ99b2RET5kckM8MhO4pB7hPmYmnFHPxk219V6fuFhRv5qkU6okfKPxaKl56PRPKvk2LKFsJU6R6t7mdij8DIKBSNlMAjmowayEt3AHZ5Cl1Hz+a1mUGdHoO2F+xP6oTSjkTfgfMldVjT6XpwM63pqJblA+dIlHYRi78zhN5+lLp7fwakF8BxyeZMBim5EnoTdZFXc9zZ/Bt1LWNHjIN7ZxkBjL2yQ5C+Qiot1USGVRhOWLFdfMyPuhRuBNp4xqT9nQNzp19PlxkxeTBZYXdZrs+7pVH2fo0ssgHfRgLpBZQfaIEkqzapPfQPZf1Ea3rIUSc6htep0JT/gzHrBpS0s1kgm3cKGsqUrTt82mOjvkgw8h0JIfnjs5XzQH6KAK2otZVtZIo+a6e2nzKgXFRUWY75x+hraqLqwAADLcFSrnD02L4Oe6IcAkT2O3Enmkr/gMnhHYIbR2GL8nn13Sp/r2jdD1+0B44q4ODUB1ncZ6AImFlerPUSEvuDD9c+cubYdBYsjOApMS6s4ylfmH1MMgTxpEYXQ/Qa9Mg4qqznQqnyWOeL2EjkK81HToztrsYzP+P3WrCQd4qRnFx0BdiH72/KobA9ZA+vdffEPqOmBZTyhZ3yx3J+YjtldNRJBpGx0FoDHMROynrr8nTaqxp8ADdMIgzlbctsZcBTS0EGHGd/naoPjBNaL0jAO9OmYeVQeZw7sXw8i+fPinX56QKWX4lAu6tP48gXZJb5TIS7e5mC7DkCZHG91/+PXEIigq6oRH9kBo4amZ2CXQSc1qWdYN65Q9aY1bN8wiy93grNdhCiSeNJT5Vau+OG7tbcOIa3RuuZsRktCTOX58UGAewTZgAMplrjs73eefEU9e57Fw7nUgmNgT8A0fsWMNe2/7Mm10lbNYyH5A4eE1SHhynwvG5815hswGzJ9lqbpx4SvlMDGpbp2Xu3/4r12AZDICtKPJEU53PsZmGUh9SgO9UBwbzMl7Iqe+klYZ89ghj/8t7guNnp+2gjOD+NSuVUiszuWcZOkbo4l06Hii8ZniucQLet3DLC0NIM72ctAuL+lieJhZrOC/czHe8WrFGBt1BeaWvBVGNzK1j4vCqA1FSPc8RjfDd9mEtKW07oULH1hBqB00sLjpo0TLtX3PdpFJ6zTBxebAaC8BoEicHDz722+c/zFrxfrbo4bcPJoh8pKGDJXH6TdfL8pSBjfLWgRWAv2DLkP0x5ezrOUBjxWo7wVixECovngafm2aEUAC559l4dETDMQ2/RHKr/Hf59CE+YIQE3swk1DF5q+tGA8NDU9VVMuymw5Rc1eGwYegHOTCG3TSi8lpUubana1piwm7MBXFulRyL5KJw=
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