z+KOriKSHXhh9KKIPezrSO2ezkIJRR/emjwVerD6CdpkAJS5WwtKXDdOex9U6epfYHaxelF3GSuyDcEOJRNXG0nNcW3SuhU2qfJIYD0eTjGYYyBxCpHYGYmhU0xQcytzrkM3tfbEAFzCoGN2lRqg23Ykbqx0YRjb1bNir6v5GN3DUsy+nl4O9RUiNBudSLv6RO0cfwp8BO1thgXUUEU9BwhCqKo/F9MmrAkjUkFoBT/apLM+RQEHc4sT1jlNLGxADWE+Qg+aRPUiCl4nU/PJf8U36+Go2Lw3c/RZvb/G4CDbRcfID7filEWBCmqQBkEYETNyCOrVsVmOet5EM/dkq1DgGVLLXLob6lxW1iOr4aPQxarVUT+TZcncVkMXkn1kAEhRWr7KzUmL1XNhWaNycAb3QbuOkUyYNCQppPZj3Md5WiEA8oBhjASqL0L9mEd7WQSQwQCOZ0GA9CcDJ4+nNCi580/p7zo0zNwqS8F55tuZr8b7XQzzrHKS6w5Ifdz6cSdO1yNAUuq3Lt659a72ERcveLBrVZkneqUULk4wR/04+BpTb6Vdk1z6nsfV7lw/rynrTaWc7bgn4wUnc35PrqR82xDaZIJDRtH0quQ6NShrdKOh6/nQU8uxVAx4XjnlIUm9LmLGnsWs1JDEm/pd6rrubSD1yt+3I4Gnm509mC9SvbLpFJs3JaR9ci7hx9qU9wh0vky8+apQ4LOdvp2Q/H1VrYMKydVii9NMHOtFGUiIsdeCIpE12rT8f+m8tDD7JzJaONSo7BtORhhmWjHdT0bHpn+nNAKLpOxkQEf11RTe2Mo5Bzxgw9rq5byX0FliHmEwkFa8Jq6dtEg8oIO21Bqi0urxUdkoSy0YNYsp0yG2vJq35kzhuZgSTfsqNLPmkt6LoUVPq5sqFjjPWhmAWI6QbC1VsZrdHQWtkvELTYmQ3sGumQZoyIK3wtugrCF0HOtPpTPyvCep0ntRZJv0kdyJIbSgR/+bfjNfImAfNZYbIYM+3sJ0UZYRbKl3v0ib7vsiUAb5IaeTZbA6kC9hnrRt29Rq+kCWg9Zp/GNbGKF5Yw100+Au03+MxUOQitNO0DZ3eiS+cdLaACQFrd3phYiarPsXy9TrMTIhZDQjo+FinaT+U+cvo4qfEJWdVeSJSXwSrqlg6/tVu2ZUgrFDwVJQFDa54kwSrP1fGid1e8ulihu/OmnnBMvQYXMn/Eyc4h9HN3kblTjnm8VkPK1FcQ4v0yeu2dgawPDtfVSzBPMSmNMvoz1yzbJBuw4cbQtp/8wHXSZtaOjGkLDP6a9su2E+6UXVPC4dOesAnu6xONcy+bFelPkUWqacb2qWkSpyezE5Ju1C84stNAsActgn1YBOQgaWHypCY9T8Rco=
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