Ck+2yE+G/8W5rmbr0qVe0lHkQR/yLn5v0D0ROegtpjP/kvG7xyD1JGPCgdSzxXQg0R5cPq7VxMPcvYr8b3poOnGnZyN6ILSacNE0wkN5jbdhCqzoL7YazShbs3ABfRzbU3GGafwO9k0MV0xuy+XmEMpk3Jqbzx8WsCo24JoKefZFSlwDjfaOt5dFNR1dBwer4Scf8EUuL0a8shKTX/CaH7UWWb2MbJ413Yav5vvZ2LCx//s5bOvuT02edvkrSJvae8JZPr5bvBSf3MtTzLXmK+L2h9GN21fYsUO6CUfE/oC7RfbRFgsIcSdA0VGFGGcJOI8n/5E4+vCninRj3fG1r3nUJ9bcVYnFy0F2rlKZ5OeazIFv4KnQTpd0Qbgi21siII6Jvwm2lm5Q6HMaZW8JVo+XFju5UjfVsNVHjQ1HeQqw8XNPdacFmt1/5FBUONbbzRsbd/rlWe5s/o467b60xjh17WhThjD5wMgCpZgQTPFqbQObwnN69v12ES7icr1iRjUkMfxPpWHsIQv1mLRnJWWvMrZWNOSvSkUFQmtnYOAAASHr/C0fq9d2ikbz0Z16LHsOKgCbSuML44a0spYaBIA8RZqgMnI7QEzbYiH40Xxf2lxN7mYWmaifsQsALaBf7ns48Xvr7nrMPgGt6k/h0Wff994sMnMk9h3oTwazNCPFnp/+HKx0h7dlpF6a0J3NmRXRRp5fli0t7W0GmPnKcKqRPNyAe/B6QKoGeL16ZhgUJig9VrdLG92oON5gCLKjewsz+dVFcZ+jkVSy2vFUo1ny9XLI8EmOwAJjkqlBiNIZuKtlXGh4vi+QwgSYjVHrKrvwCEJCXOnjEPeOJn6THBaWeRZb97ALGjFJ9mjX06ch7hgh1IOhd8ZAyrTU0Zf3bxPYEYvgzQiJHs1pd+vngdlRNyvHEvJ9/FRA4WkmNibEWEt38Qjtz6193ZQYnrMXbGYnpuYvPEhpeyGP5aT7fm4Zvp31ENn0oUL80FK9sPyRnLUZUxY0IRweH9z6JUb6TjIq/rFuzOOvRQ914zRwcS65qJg7PqP/kfqiQ6gCZvd4HR+Rko7xvQdMlosinJCHbUtQxYrC/g2sFq3O6G9If7xS5jSZpAB5S0RPXooWRFqEA9LAJX2ykKBgz8AvZd86jEb1bEtq7vb/6m8hzqwS/ymwIK2QULcsvAZVpGFawuLzKqIhro3A+IQfpvXx8wjeDgg2sKXaZYcGaDwlJVOjYAiSJQ/JpMSNjAo+tIFBJzYpNzdaZ7yep1TgVjvcBYSrFqiduPvbX59Po5AvcdEUu2B+xuUPp2kQoqSbzkOn7aQHCBZbwEqI7jjvlGW7ebaw7IkXLFpjNGyBBM9OETozwgAgihd042LERwoGyCs=
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