cJ/CKa9glT8J4HkVDscesLFr7Bi7jfRby5mUrGvG14OOMi4PUhcS1MA3ZhD/XZ1d/WPOgKLAeqgIF4O6+wcunuWi0N348+IPaPzh88b0GJ3xT8lVSXoFA7B+Yhrtkh0uyAmEcuFZXNTkvcoHiNiNrbm9gJcAlP2FsXe4f2Lrda0T6YU0nT1tyf1E0lOrwKrHhojhbcAemJoqsoowZswr8vUPrKbRxXB4OmGwrLT4BKYANT9XwYZ4qRsxIcHeKeRVHR79ZsnrjkX++T0404W6e6NFxlXhCxFUjWsA6AXvMh+NFfBSspC8uIl+rv7DuyDlxW9DyGUOjNcTMllVW7pVsv8l6SNaqlTpnmz3YIf8XNNYxS2BQsiIMWqTOQ6nJX3W616RX/d/G+FeApNPpRmOpUfS0yTHGBPEdp7EaYfACCUCYsdpUauFSpfXSpsUs1R338UYrjtRRb1pqL2oypmZIqX4wlKEnQOvD8JRdM5BilmEgSIEMXnYPqleuaQY0vuJQ4A/dZcyJNq6TxTcd2RsSpAhBRwiS3BMSVSbJbg6BH/ndx3HaXcusckBkRr8UtxPOjxj3kEIdf94mrJSBrhMDkGs8wkk3m7aZREW2DttF5RgO3dajg0HNn6imUvozt+FQ9EkfEbiEmr7EUOIvZbb0ZfZ2YaGYnNts1UkPMLhgJPvf6l+3mpT9y42LHhin/qncS+BZqaSVAuP+Ip7NatNa91az8cYDtjkS7tkeEZChyHdafR0FvaHDJ/RsOP7fNJavLtLx4E5yeo2bgZ03BXKJbW3rn0x+DwWQIeymF4HGDKdNLZiQCpZDMcsQ0uExg36Bqwrvu3SF7SPHghM4r2Nm7ViP31Df4zRh+p2SAV86d/woltbr9y8AVFvAVeWKJtxRTEL8QQTWlIb3tgFKeeZf/Pn8On04gP9i/G/IEoNJr+kg11vGI95aLrKvcq34qQbyqyuw9fuU4l7SAnk3hp8ejHolVdSqfqTE5qOJgq1BZq+TCfarO/2xp5eu+qthMAkO9OcZC88tSuxKxNiTx+6bIPYMGo4hm0y1Nq1L5R63TaGDDi87lfRlksXQ2KdZ/0BTHekWLkBCp4DrzHHa8ERFRD9IjNLJSC7XEg96O5L1f8lJgxC5jFtoIzU18FpjMMiQHuYl6P78mCDwmoLFsGlEL/s3YUm2zfABXIHFJe0OjHbIt6ddf75ZVK1IrpZzQFwReU49SUFf03mWhEun5tljMXbPoigTc0dtiAGjVq+fxOUQS1PbtbDm/oabyZPKZkAAN0G63Gn42oU3Hd1xh/c1DV8m/FwWarwuabOe9LGDvnqwkn9DbOmsot7GLVXzMeie5+P7Bdcl3QdX4rQ3XPckU9U5vS5ku+kds+Sd2w=
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