qD/ixfL1mAj8FpIP6G04kl1oTK5o2Wj0ResIZoNG/aDgc7K8B5SY1Qyhqf8/mMLTzPqKSWOXUtz0jANHtpzJAmsBcLw1ZgVGg3bUQ6p4S6UenjzYLz6xRhhQYd9AWMR0HUOYgUZJz9HDJJFtZ+jFOEncf+5vzItFHbxGpjMm7SrSOyr4kaXtcjNX7bdmxYZoPdQEBtSJsg4h6TIourqSjYOP3zm0cXVJZS4hu1JBOaKI01E6ECPJG8BCS61DiPQgzAXyTXYo/yHlZyytqKsPzWWH/oSvm2VhciDTgLGZ715/VRiQ9zsqQ/MRnkAsOLN54siMOXh3NzHbCnNX93TJkLFKS6JOOGmt1zAaWp5HRvUYV7xOijT/AXbehgatBF7BtLmjQhrQFU2uX8sRbMSzc/ktwdLjQNys+giLcYPyjynG81aF81sz49P9iBE/589uWQZsZz+zjfMp0CrosLh1imElFnbPijkzs24q/nliL+t20+EUbTS2CtQpyAuE2Qat0NyYi0p6jJet95qXfjqYII0DnlS8jWxCWB+VQlJZLBdPsljkAJ5w+S2ftg5Z5stUPkgj+Dw2CB1cuXYA9pCiIV29qJIjmbnvqncM9azTJvDYFSssdfQv4aZJNMajxsmMRPRuTiiSGXgdRt2+UzOKy3WJqg6f+stTZdfGjWBg57BUsdwXaaC2QANb36EBM/4FfGp6FYp5uNex7dKC1wbD/m2HTVdHcSzxNvrfbR14Lmo0n5+nbwulnhnGt+FJdVQkWqYypgr23C0j7TUiOY73asSTDc4TuUPgH+lgI87qensgvMQ1GVCZucaJeSdJ2HKrcjcpfjnfcPm4CHjN1+krW/+mAYbTnArvLi2XwjIWbac07UdIhiL9DPxs5WPKDFwyQQuR1rxnhVo1tsBdZJXZdaw+ltuB/dAq6sACHX8AsYLXnJqOCT5riAzp0KS7pnqiEmkb77U5cluLqXIjbsM7mzzzloh10rGVeI1bBsJF/6MFJtDdkHWadh2iC28EyNImqutG8CMeXB8fU92z0YE1LtEKnyx82dBQZd1rdICIABMZfHWDpYLlsKAjDR1qdWNtEJsSXtROG1cpLchQyYurqlKs8pTU+S1vqCDLQC0KrlRJHQiqCj/TDgN3apsm/+xGgO4MNztG4tAd0TB/LI0EdcG9vt8jDoSEWnh5vVEO+JBrxUlyxkUlG0gUJLXTgIXDmmA2eEZ+GwJq74plUxrSDqtrWXWYGjZD1ipJXsbfZl4WTV1xU7TEk7WEpNI2ZkyWpTErPiG0gwCYfTzZRvh4hD0xSu8n3OjR+RJWg4P5iLAaIW5EL4+HCmF8dopGClUYFeZDclPyG3pimUz9I7vwRD8NdDB9H+sctz8WeL8=
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