U468c2v0aDR4U4QGUJEoxQLRAGnrmdVj0IJNq5CeSosYLfLY3aLdkjhLlmf45nfYeIpkZlbC8BVIV4CNo344319XQIpFJ7aaI9ORX/2DZh/mnelJwWlN7Ly+VokUg3Y/Fy9uB1Ed2J1olFrm7D4Hvp4xKsYYsoEum5Rv1TuF5c2q7guJ816w4oyVNunIpC8JM+xnl/7MXaNIp8+FDCwB0dLan9b6KGRbKhOJxQoSA5LTwWm6VQvd56bgjKp2ASfWrH2cnosPX6emLb5E12/9VDNM175uV+QeKZSv1U7t5YTIvH811axBReRL26BKbN+etzUIzfBi68jey+q+/gtG9zzC3SGkqKoJpvlTUvmbjduoYzI6MCfbToxdaZ005q+4SndYHy35oJm0b4AzwMidMLNXYZawODBADYK0Vq/3VUDncX67q647Uo/roLpE6S0kNj7EeCQbtYWYzSy28oi51D5Ffkdpwm0mPApAe/6pApZCElHz64C2TR8AnUd5am0+m/1QpUm2pTemfY5+RNKXspa5caVupEteTVurzD8zn1QeRwBkfGNx6ckc5J2wZVOcGBdiSuvQ07nwRe+XjiRcm9Og4l6TgwQ0vEIPVYyB+1217mLZAxK2ubrNARJ5+VxmnOX85/IaLhkYEbPIoAoRqy1nAjGr07upSjG/1XdtThaFLHZSBGGtyaqHKpInRNJ4jonU4Tyvcpt9WF3uQ1rcby+VAwv4m5cv0Pss+/wqbVh2Xld7YnogMiYb+QcMKRhPeWmjbEDr5mBzPV98n3/zWvpUIvy6J7fhauCNodubFwf/hhs1wLAbaM8AiDTiKH+L3g1/wZyPbrXpyKjbZrjQriFVQ/rLFYlXsklklJ0qjnaiwwhZPvyMlQKtDuEc2I+dXaRnQoWIkzDTMHMHrqCQUk3dZPGVJ91p/BVfG8gRItFwF0zPqdbxnNnthoot1dFUDlJsRcwd1aXXFltTvnw8Js3G7ii6nqvRkldJzJQW0HJqnWxwSBvVMgrsj5/iZDgAOyeel4qviaBzgQeMhnT6heQFbc8Qb3B1IgBf3AE9dZvSbZto3T76bgFZMmnfkWRr9PKq9X293yNATQFaVpIFqSx+05+ladpAB+UA+P3eBhkiQp5BqrkxmF+MroXdAmp3/C9ZXuAGjyKvlRrWAXtNXBny+rx3j8BYI5PgOyrajIj0c9DHqlkYotcNGGiMMzevNaxi8JN1esbUCLbvUmJc4MriJerZGpvZuwx+sQ9dj8QqXQH4L8yUwxDLpbVweN/BvpF6krvmWZhBGNxKKvWkikRniBy4amLAW4peqV2noFK65BwhFuPB+BdgaJblq4Ed3iXEoZV4/G2AT1aBYVrGXMpgW2DWeeX+mGelk2I=
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