TMTLITtpEn4/T0E3eXCwZdtfUMvre7ZJf+m017RN8gxMOLmLNSRT+0lNiynS8WpcdkG4wpXHZKoaV+2IWj1Js5JReFSmckqp2h0lyBfPd7DYVNAdRRmc9ANwN5L0aCxSxgev1GdVZ/mWBf5WOUGpEb9na9wYfUL6CarQvD77Qr2OornWOLNSXBjn4pdwyX5+L/EPlxBo6iPJpNijeGi6rfbuyvcv5Mb1eVuLCMvfaa2qS5SgpHkWuo0LJ4ZP7vL6ToDiSnwdhY+3kRkUsyR0czBVOniU/NQy4SQnu8UV9fHkiOdvzpxexXsoxfyvFuiPporhYrFcRQl7jZN3LJ3564vRkBSm+hv/Mx4PB8VCU+qOc0TxMmdGkyAyoXh+t2U1/Uu58Mdul6UgSJ/GqoG8x6LE0Qw9wbBo7/sEEx2hxwWtTyUj6qti+yyCDktwMAg6DinK7dqbJKRJiUuaXOxzaYJL4fgC7HRxPEyoF5m737UViGBXOX+u7kdh2dLkIpmB0uPyjgX6Gk/Ra887EEihAoEI5A4IzOTB6n8vwcxwY74aO7BreMZD0cMaubwzTIo633DMpYaBN9xRX/cwO58VtoPQ8Nq/sjvjceeQ8HoVhNlPBpAIETYx1Wunzz3L+vQTlb53wppkZxeVwkO2ts3MdJ453GEcc0N2RNrpTaUIHLMb80mVo/E4BrXEkE6zKcr2k+bSH1hjX9GMoq72gGwM2sLqu7A9FbtdaJID/g5vhAGinECWvUsGB0eQalWyuZyz6Co8KjrOZlp/kL+O1/EkyBEd3E3DdRtsfa1wMg/DFlKnjoRxLDc7QQrU11kteP3kQGYpogNjuWoT5xG3KV/k4L8nb+J4SIPomc8fI7f++tQceYm6BhiuwW1Dkw2tqOD3xgqVl2ogzysXmskuZnNzcR3jcebhUoehOGECcCNNPtiVD1byI4soOZzJ2zLnTDMTFIPUwjKF9SNMONcz9MoOtqMIV8TjKUS1k8VRoxacwWG0c/kgFEgy7dnWLZM3050+Q4UVsinqdhK/b0rmZ8JftwLqPz42KKJY3SNC1ZchLaxuYv5NyEGskEelqQ1i2IR0odCjUq1u34yzJZNbiFxtgzFd1IfdWaupolMafyWWabaWnxmLnM2GArKYszxoPnsXQyH7ypNbBkZ7419+7ZfxhbomOzcquJQtmerE8SzXVPICaG6AGfGqRwDn+KLeE90Iqphhiakx5RePEy8JLe7y8U0vcKmllvbrQKGDRHnbzJcb7TJyQfZ55UFi8vpo50NEqaNLGsbMMI29hGg4CkEJGiR8Hzbz3xe9yY5jvVKHorGcIeg4BFQhPjbT0FeZVPRrKKV/W8/6Hf61w/2YeIlDRLes4PpqO8rXlgSG1sY=
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