ky/5NL1JfDuTh2o6RB8FB3aHDmBLnJ71kEdWss+XcBASttQZJnVHQ1pXwq+EjAGgWZVgaiuz/SIOdTc7gZvUuJFt9CQ42oY4/22Plmkkn90wBZkTJpVO9FcwITMSYmd4C33NawLoSoQAWPtJS6tMUnPK7GNYjba8E5bUR/dlZ+j1eCzEyUPVthPJJpz/TZiSTg0a/IizXjQo28JPfm7sgBXBF9ceShIJVmW0GYx7WULylfvmrodegTX3DpOKgHIrjw8KYYXwtXj6edrLg+AKLlUeM12lhtaWiFNtFwzp/RgJqSlVbJrTVdt5zv5ZHh2Y12lRYrjCJ7LUMINwK5HOSMzeVO+CnPtPry2z84o1j7NCNdl8gkFspazJV3AoWeXz4kkR9Wy6MsvEjGVRWF5MnU3Z/MYkfhXd7uk8qSXa3k5VB5uFDleq/jeIlhXGwjuuToHYBmX6pPyn0OXCk4R6uk3hvgXhmf34oUwI13R08vuGHCVGATXt7QvxX0yS5YcevIef+d5rR95ALzZ+h2SYdQdo30o/9MA8U5bIjAQ58a408iOwfzDHgJNohm5m+wCRUm+6dcgn1tZ81CVNjxcj49uf/UnrE3FuP91UoiktLdAqcD9rAs9Zkf6JU9otBmbJ3GBwGLXTrdgCARNZly7P/mDnNoRd7EcKEiWkOkO+JN49e7y3hB9UByunAekLc0C+KKpK0wXIm/d/bL4DQCtzBFZieD60XCq8/97EXh6Rmo0kB1TBNJLvw7jZsObPyJomuDTf8eCO4zrEglOz4ZdHxBMW+mNpAS2c1G48TbkKmxnd2mnosHZh2wSnzrrp+P6tjM5l/l21sULHKWEWb7t7dkjHqEwO20PpouQCKgwxSLsBsF891hz1F9XbDmdqupirLdY3tJLYpBlYQYvDnlV9MzxHMu1PzJ43b8pHx5OxOdn6eLeZY8qmCGlc9d0/6C/1uxhvfnvB6TiofLqfNYERQotvD78NDtVugvtogRhd2oGYZpUDJUwVmf9R+rO+mES8mbrrstkb03FxPp/QIsr7wmA1YNffLWWhRB7BkIywzhqAF6eBqsAOm4fK2bRm4uYbQrAmgHeCLqRGqHpM5GuL9MPQ0BXzcuZFsK6zfrMH/B91UcOlVcNOiuCW0RqQmLUDMTOBflxwQNQHaKoeRftFELV7N1EN13K9KHQZsYr7EYff52Uy5moLC/aOWzmdiW8drLfBgrHG9Hl1gJ9mGUBZzuMpMScK2EDIaOhckiKdCniTnK222lSkfRLdjUHt9ekxbAZPNB9g5DNYvc/1XnaeCR/9vp3vXi4rBHKBlC76kfpVaXSefpKzk4qU1OcTuiE1JgPMsnZtxPxnmT/KOZURITG4CqXR7+Fr1Zh84L0=
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