bn3h14OqM+JIF1zVQAnzqbY6ynfeOH3kRZpi/XgoSt7Rtj/ngO4B1gu5Qp50OezQ0jnVfdEZ0tEosb4odR1Twms+s9L2qbCay7QDq72WuLqdboSrZkMNpe4oPxCCNhIMncCAdfBD4k1brPYIFWkNc/EGYktVfgQ6j3HYL8IKtHblZduxXUhJvJdZGnoj37/Ay4hJaR+KJr0DQ3x1gz4GgVyd4Lhw587KChJhgaC1Gz/KuqhJ5Kv5J7XVlQm16K+4S1YlyHjPmX3xnmtmkAt1jJF2iw5/e09xmN4aEFtq2sfOhQHQBuRbpleqZ27xnn71RRye0oiG9zAYCHaJ9ytTLRKKN08iUsjld+08PMTqzgHjqAAnWFsbxy7BdNIXePs/9VhxqU3csKxL7ElCLDJh9UjZE3byOY8/zBMzj1oX//wNOKQ4dAnOVUh5IwBvQQdJvfVBuWidQcxwe/80vsuBW7YFxPWe3vv3uVzx+/9tp3CeWt+kxk1ZZbSYKZ5JYkV9xinl6hboKJHfYoCmACcj5a6OQE6Q//I0S2EtqHZRj4KEiip0//gHQSU3gcfIFmrAHPJ7jztJ/7+A4NQfYBaosMpG7PlI943db0laLDEx2G9EQm92+rcsmlTtY7mjcxi3qUCAVVylp2hgdecOx6s6DnD3L271AEkB6mI6wHxskdrVPwcKy4+eBWGfHrJumFOT21qxitIzO9iZJkx7b3sFt6cQcNbEBpzbfZ0RG9u81jupUCswl9gtyaTPNA1wVBu5p3gX5DNNOFDaxTEMnwu6RziIVwWCxuWR4gX7CNV3FP/mtlJkWjW7mFhvxL0Hdo3vDoZu5s7Vw0hHgya2y+d9SUS8UztxV33lPufQ/MpAWxmIiTv0KImNt0pFuq+kdhTnrgZ+EwmHzqcFOl0Wm7VnOdgM4FG7GpPLD0C61Yse8t84glz2RQmY2K87kUvfucrQjVUHQmiwS0PBrDLuuzkPnZz8BLprkwEGLRzBsJ+wbu5a8go/oQ9DJ+D61/6BB8kZ7CVYcyjc/jd7UBo5fIyRN6hsVPBVdP6ElFnVLulBM98gKMC8+K/1RDDSp8ekJkI+V00e4MgmIOPZmCnzxnOwLENgUVnPo59AqjJI1Qcza/zAVkM1EI1kuw248DwZtOzcKG3pfquMEyiQDWb9DCSQh6KF32VPgI/1ZZQSHBh/YiX8ezkcc7Qhy1/uJTtLvWiNy3FO3dKM0EI3XYFq/q2xsFfwHBpBv6AVUKVrX96DN7D7zJNUGnpg2Jxl0m7w6CbmQmM9RoIGTEeakOD7K39FM9SloqTpfsGZD1jM3p8wqhIjExdhA98QCpAYtVa0B5I/efmiKTC+5Z0DK0oENee2BeXo9R4ijyEmo/vWP4A=
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