u/xtcu77JYdlD5I5ltPXV0PICi7i3cqoh5xOzjUd5x2bWGWGv6TGqumoE4KQ7BOONyLXWzCOgmon8t0mNNZKoGJ6AFeEtVO959cwjARCAF2Q3pi9I5EE/RQ7T+bP5Z2C7V5Kpnu/oS3RjO/ZBiW391FUKGl6a6QJSukuvC4pACuvqIL4rauB7tVK4ALaFXVi+o17faB0zDnqwf9R5YTy+PxwLk9ITKWjGjuMo/TEJW4h6lbRJPkvbimO5KHR+6+FYrSdHigia+7ubKYdiMWofaga2wP7xlqXAbZdkyzU3R6BblxZRLkxNen6l/Wue8kjhbiKJAIc0uNJi1An7alwxA7bjjmQUbWzl09auS5h5p7UCjY7Mff0baWIGGBdPRoVp0i60dnf9XqtBHThpUisxTpCBmYytZJmyASgTcjbAof0GfuTA0TiDibjxgTYW0wwRqn/fwtQizqKGP/D6hFcs4QcjsH1FdMk19fOYWhW9VgiPTD6v6xuvmB/T66ZnOyDY8VlsyvTEAAgrXiHbemr2bXAXwUh43rcvA0MmG99vgnT7bmTJEYBrQt5bwS3W3vfWOc5qJPTg9HBpRNpDV3fP6skpsYYztpKvQvC3IER+2ckaig9s60LKCKJFOuuXQY1XxvEyxOkjMPacyzLzYNsoCHDxKhK1+sAfq+Ledxqwsui5SLsNqKnuz/GJOwu+qf9045MXOO+Iw8ujdrHSI4baBJhcim9WhUuWaFqJxSz/hHCG/cgjBw0HBFGHZf4H94SJHzBktbeIZ1znvgzTTCBIFxHtvc3mNpPS79ur8wAwZz1dhl7ZId8DMHg8CJWLB29mp1WRaBeGySk7csGpMdxyN9nGk6qQcM2mvdAE2Z3ISHO1Yp00hE7MtpS9/mfTWLLnEhdomJfTmOnPHk3BlyU0FR0N1ZM6FH1nqQ/i4qvvKmf0jZvqQ2Us0UDkvHjTgVGjcV0EbMlwQOIH83rlN6WFcmTlOGOGPrYYd4cciPvCPdkbOSLj+a0JAyy3YKeECG3SP/5nMxs7zsWQG1B8UP/m43FxcVS9R8vWdokMTbmcgaCXuwGIEVpAnvNUXBw8h/7bQw2byTMu2gRH44kp4H8Ctx8F6yAwU0v0/vAz8NGZn2tyqcEyXNXVM3ciXHAc/O2GY1ltEQfT1B8kAFVFu1ohhAkWTTBNPYVDqybkY2JkSWdyQTsPkwVGf3nx6IW2rp1jn3Z5kQ7I3Q2JpEGMbU5SNkceH2zNgdCUcigx6t2tiVbjV7tSUywf7OW4ZBCQC+BpqlRDPrBhT8lm++ElcAJgf9zKAHWVye0n8rGPa0Wlryx+jTXFvVKO7ELhE80IolGk8lZJaKDYiDyOV7kN4vqLkcO/evLZbqG92kPpeQ=
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