33axd6qfsLB/Zm9H4ssksjSdYqKVUR9IJFao3JCjfPuilklThzx+pj/r5K2IH10Si1hoUwX6cn5ZuC/ceNjPntxHOGHQYbxjhZPrUhcdx8RDNITCQiB4qGyhKvdp5QrdetSg6kIb6lZzCAJL7ibQ5y49v4ewXisHvd55quxc6X9msDXEsUUPDLSKkmFQYSypHejnp5oCyaxJK7h4MlSXOv7AQi/JPczy1pXQ9ck1zFQSnwtrhd1OqDwUqgxfLamiE06J9ec22PD1D7dFh+AgHEPOD6ak8iAdf7JFiX8p38R2EUclVfK1YDDit6AXFX33ifgH4kGkVSc100JADcipFBwfjk+YgIsPUEY2EL64gZwCcC9Tc+L/silhxzna5BJQbW8aAltBWm9+aJdhgTU0dnPsqp9UJVKeUAgWY7Hz5xaJx1P9WlndtcG+WcOyHrJE7FnoMqRYCMhjPp1TcY4MM/WAuVgjK8G5CQaH57bF8/byP06FnAQSanjNgdbZADlQXjOkQOfI4KS4M7pp7/xJMsNUeaWZlCMxl71dLmZ0myKDyxiuDzimbpvuqx2FpqWAUwqOKiuNKQ/f6wE3JKkvC0KyZGsDgLzLdGM1G7g64QG7rNeok1mH+XdfyLR9TsyDA+cSCWKa7z4k1qlmNmUGkIP8R8VqMr/yXIGbrlVRNm+zcO0yCgJJ+tk6wDs1GYoTTfdRIl/sfp4fWWVVDcuLXsaYmwi0SN4qzrrigS8eXOTehEc5tm5NrU9dk0Zx8xVHEujgXejnOwzOZMSDI+axu5Wyt7UyU/gRcfwdEidP702O5lkQaku5hQWSCaALXJRNvhKR4FapFpId9keQy2q/sKZ8IBDrA2z3HHDRbt0g96A4GvrlTmXLZ8oHcdMojLGgSyJRjKrzNwprbqIfKQn86Yfs2agrsmmtAN9+yIMkR1o2s8pED2cuWL+MATPOVcUw8uz9vid2QFHO8HvuBD/ehDwu3xcZ7uvsZwfTO11ZpvsHoaRKsqr/pN/rTC0pIDAWItWFSalJNx+nSPOhcd6Ls2RTgCwQn2y6SzVZ3pxQ7Q9xWV6+mMU0/VMoicliYBUnR7t5OcCjCvReKHi1S9dKk0UW4Cv0P0V/BQH+nF28Go9qfETBXGlqg7RM/pz34NClxbSyafp6mtwfCYZoo3g8JWW5ZDxf6DgcmLbdWNC5mEQw3KaHB61QC6i1YaweYfw0muk7B//2UwfPyvxDmBckUNRpWTHmdcsM3k0qWmHPVFyaC8GikIK4xJftbMh6Wu7ZdZqz/RZtbeMc+BBTU1gArv0nFHn801qh2gw7S8q7Frqa/qzG33ZmfHuJJt1j9oDX1hujDdxC0LcxCMKoE6iWYtwZdl9ynb7Hjmjxvtc=
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