cmocTrdjr6FcblgMUatGUknkP4/yvyOwt+uqZpcjFQHcV9S4yvFY/sbnHDrxV3n0L3FDQgcXlI/Ni/h3+R4ubo8Ek+N80iXpr26DMXzGtr2jPqlsgpjleh76/4DjIzBkVGGHPdzFQ6EvbIttcsQdmbkySjaKHO5i64pPmlM3Pv3mhpq94qUY9jpSWo+PTsn//kSyuLXL4B6lMk9zcLnnlukAsA8AsZNkdVvzV8hBlWaqLRXnYSKaRzlHnv9Jyt7Rm5fQQr9eKPGLsBYd4XXkTS0jO7tM0KLG/9oEvAkWPVvbnyuGdKKan/AdeI1lpWI+bbi9kjs7244AMrQVIL4y8TQ+PTeaAc2R1jBPyDIjpQpEO3KPCkQW/d7E7Eo2PjgMR9z2W3M/jnDMXECHUnW/QN3zi09gsS9Qxi43HWoeBPf8qvBN1uXAGGNanju/LyIY7hcnlSvP57n4pzEXxu2z9fq/Pk8Mxkeo7fHP0Sqtsnzcj349JBZ4wUEdbdXp67GdSR86AaRHPQCiMbi86Dc2LS3vlill+51XxhmLeS+nVf7bOJ9o26TCoH1SdclSZ9saHM5bR96e6lHzmEJUVvZn0TlmbPXuloSoGfkrihuQEtbPPoVy9D7bgPHFECSHa3NrmRRCvJGzr2ISvYdDeYdepXm/DEmyNtKNSGV2g/2ZijXNSn1qF83S9RS8t4f34o6nHsdYxNcPnVQXUXiglRDtYjhCxVFQgeRQKYxcpSvba4kvjPbpFTBGTlhfhDj9WjgqQh3vdi2ISS8bJ27QdoJOLGDhlTasE2CPe5odkopSrm7NwVqcoFTjm4IokolfRtRWVCRQn4bTZkSLJlQ5tVM0/dJ3gOzb8kERVGDgIPsZUqvaxAFu0b+0tv07Gct+xokbhHNw9vCpvHkSc9RUPzwN7pKrw20nw1n6JVBQOxRF08s9a6eoxoho/c7eV9Ipqfr4cmv8bF9HUrmRwwHNawPw02DTMOHowSawWUpptdBEhVQAS9RZtmmUJt8N/DrLdipcSNgyByfkkzSeq8eruD63ILxsPyI23KZEYi3gAqtYFmppj4UQRs5csGc1HXJSBGeFqRfPxi3MNBXimmFdJOQaKA5ncMwOHrk6YVJsh0D10bty0tYs4jCIexovph+CTnzlZMf/rfMADT9srrortKz2m7Gpg1hfuaST8KvOrdmBZuMP/E6M4zQGZyqP6kBDFg0mUZ2nNkXzkXk9iU6345t+GGgvA21Os4QuMSv6MUcgBVAwXzzN8q86Yt7k/dpBwyMBzJogT2Kx/FkbPw1feTU7kVXVGNR0nwnE5SMwNw1LHm2Bh8MxkTxwWdJ7ooQ72lUZSV86Koy9lTlYDyUvRBDm79/OFZ4OO85yFK1hlFk=
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