8E0udChBKpuvcS8may6hNfJtPGO1DH4IRg0XxUORxKqiac/MoJu8bY+XAe1VHCHPL8vKMTYUfl3mDG1kFKuzWrWGhtDJqxt4srwDnEezOKz/KtRfyFwzQ124YRXK6UPf8fjEE7izuvyPxlH8+Zyp2TISQVXk7qwdO0jDAtKJzcKJU26gnrSSl+2lG43PKAqp7m1qSxr5CHEprWp5m3CYEE9ZKwWvx0fdXUXqO3f4BL6idzomrGdFNaX/F/9NudS/xR92R7WSXSRWuQDrlRZvWS3lzYlnJvF89+6Mo7UxNJt/vwTunyC2rAA+b0HX7MD5TBtwv/DV0L//Y+ktcuP4jy66pSApX2Y7iDKdKzF9HTNpJTcLh/YTwloVLsOSm8IiOAfHltV5OQVhsyxys/WrxnZAVqVjB1PcKssilpwix9Kl5nmjXLatjKfhr/cyyuK5zktwROqo1kfDn3OOy2XlC1yTLYDUbgoqozJ0eWblwBI08xGHgZuWGs5aIE0808kTpktUWCE63EktnSypowBWo7283e1KuAlSFNmSxSOgnAu0DfPeA4M9gnGOY0sqVMCV3G/O7yDIrJA2ggRy5723yB9tpjYEF9Yg6G65EQpSGNe1d774qES2Yfzbldvqyh236JLWABOHrXcTB2Ud0ccf5O7LWbLu7o1tF/OlpnltDXCT8Psk54VPJWrrhlX/ZoO/YzrIeUZukykOQrpc3RmNY5OeEs7r8RQ47KvuJ7dFCBSqs8FQSh7qcikdkmaJWHHA9pefKms0z0CImq2rFVVUq0be8+JpkSu5cfFW/uEtgF6Q8VzMpcpfKgLRqNYfnbwJSIkSzOWqEQF3oyOdlvNQhy1Xd40YE3kcPyYjR64M2rgksbmE7lx7Rcg7EU1SB0PjCCdD44RvLLTPrl/iI0Rlv885W+/apph7/qKEu57ZLmT4bB0QB3wJB5TaW5cvH5XQ48ia/CvPk8fgZ7vLxHJ2E3Tdh4aMIMjIvIOu5fmRN1/OvFjcmPpqChjOd2TbXKQg+xGXaFWvVzIRZ0ECZDFpBOlebKNrttMMIUKulNH7CsGiTK31N9FCz3j1oQcm7UUkNQ77C+WkDOHdTbxsZn3BOPWlIOvPTqYn6TmEPEQqZtAXq9xrKsYevH+1iEFEEZuM6HFjMmZRmqo9rJOEhj84tdr0quItk2GEknY67Y7BcNa50lk19D/c4jgZSI37R2/qQpM5HO5aDIGgIxd06uxeaAmemb+32gqo/OSr9eMl4BKf+qqHs4sHu1BG1H32skqAPTuOa6xo5mfgHh3umhfKO52Jqgeeylew29ug8GYcm3HaGud4I+9E8beQ0zOGgqay8gdvg6isGSbt+uu9/j6vmmKkZ6SxpLKYphASGMM=
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