7o4NwDu3SZe7SyNuHXQ94tWtOyk4GIaD3dx/lJAy36Rd6+/HLfNC7dbxJ4Go8SlBSEw5jiBXOpZ2gRKhgXTgJRHMlO0/a8TryGcWFr0EFDJJGT/Z9O6I7rQONEFhRTtimXjTGdXE2CMtQlrOIdUZzo2SMdPHlI9vvgkUtv7oAlF+eHOyJU+Edk5Ih/9IYQYq2KwGgiGQTm61WmhmJNDH+MDPyjL5owOXRadIjrPW57l4RagE1wTDf9ptm9dPJ4ahdu0udkiD9zcLPd2fK3EGTgLh4TSHn3jbKLYWoRLmo8rEcHqwM8RGjbTiGP47Sp+dmmRt3y3eLP5RAjEte/Yd8ga582PIuFHXnp0RQozmhSST6VKuxzHLvbe1f+p8FtW1zm/C0RepsoDQPlCCoy55EyzYfUHTirgR1m4wS3lpZ8hJBlOeu4kABVXU+fgRr4Jm5fC49CJHJZJJznMLotq9WqVCNK0XsQWJQti1j9ZqDnxNS+zhOMXrkjQeJ7kS8rnafIlMUk2pK43/25UUpePTX2DxSLM1S8XdCzs2hrsJji3PJfmvHYMDKjpjBoYbEIOonYyRthEUGtMH2WBW2I3vbNbO1oqzMgft9nTPKMMFYuOdUWCspRCA6ubvWw/NdtyrG9C6BsCMXTkykDI62rmRJ8YhY9kfq7KWXIT7x/GpT3nTGHfk0O0CUBvDzRvAjJvSW1CEZXG8YvcsBjMMpzXa5DOI3XrOeGFhrhc2t7unXmKu/9hxdeTU8unJgUU7JDUOIu+LjmVdCQZR0gNxE6/+YiVr1erx2RaazC6l5fG0MZPoAw61VjdELU97S3/1Sa1hBoq/+nKEYvmoJLgUHlOHVZEcZmF0KGxUoPxVgav09f3EKsbDEvrXVvk8AnPkC/tXLhSMd/dFF3pt9z5HRUhCK5UpdJ/IAKaZP6V1yslPEGMJcrbzDEOoYL5fBQZLKSyd+kViHpEyVyQDGgt4OV20+BebtCMUUntA9CU0+mvT/UsgEEyySuus4nYgJh4oORx66cc/jJvrogwAUDktZfew6KPtqO3eSeD7/Tvnox0o9yrwaOJs9FB9FhKDhYZfQqTU+Hmz8imxbF02YjtIH9Fl4T6YLKbrXLwuUi29vG4OCd1/AaMRFt9/W+IiDNqTaLFQuKEw1qTrddhHGNxqGvJSaSmGRGN1mYDvHVP+eOjyysVddoAkBqD9tkP0Lt/+q0DBDmLfFeZCnYpgkF/FeBFxjR9Qu/tJh6juw7cWR+x/U0En4YMQja+7seICXpZ7iYDSFLk2fFcrvpLka+b1BUQ7Pd5gpC5Umt0M/WCH27YU9zJ+psdsKfog34XG1fJADDE5DmAMU5/Yo0ozMj8IB/BeLmGh5mwMqrgWa6jkFpA=
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