SrW4jhY2hD5Ecpw0gDrx7a1hXkbZr9XvbeNGfPoxpLrbYF/gJmr1TqR9zLHfnDA2B4j4Jk9mMF/TpSSpltKq41i/zm6zu7Oc+W3EAiVpL6a88mLmknzmRRDPb904JcMY2ltiGGzuHYbcJ1x0YRR7aJRnO0x2B6AqpfQfhXYD9nnv3fGw8uItdide6IXKSPc6ccNgIhVxhkIe0bnKGQoySRXvDE5NkQTNhsyvSvJJiZCGQH8doQR/rMz+5WS2v4zKCtLUv/0I7wfDc7vQL+YA2u+0LnU7R7KBz5icWBqJ4JrkArJ1rzUPR1OB4bAwBWxAaVNY7k4aZXvDqKyVynSEYWOpNLtcXMb7XFsyIsfdSKjgvLpNScb/CHJJMQH2y8TWVLjcwW1aAzbT3oz2ms2q5K2dtZIyl0VsxbtljOI2/V4R0MGCnIppgsXGsxH99wJryJm2HtMuWv+D2Pm4ot4t6Z3EdR9yLUftN+/sSe3vMDfkBqXWnxrII/QTECH9fuv3EgP+c4T2mjH5MAsphASrUP01OJLIEXxmUt9hx591gZAGjIo2xCQERz/5BAK0+0cAQnw4wV8kw5e1WnkjL3E6R/xo33rUad7SNHrrY9IkRC0w497Ew/83XbvukcemrrkYrhq3DZ0A9fWiMxIvWWXroet9jBX4Thxiv3O7g40kiTfsElkzFN6bCGprHJKfJo0VofjG591n8hVNFRMelU5mQLVsQnnREx1hqRuZM661iLRGiKZaf88SHcekdCQh+vVCyosPqh7zmloFPAnYBkWY99+auJGNthu9kIibka7NR8cUXx/GOPbgtgk2Xc0O7foqsYf+uUpRCi4Rat6AtAT9fEQzh8HruFyRL7SKZ3P89O7UW7Fd0qLMmDZfDjl4Ga+guacWrfIfBgKZcIf8Wqr+KTXWtT+A2FcIlAZJA86M/fa71kDKw2Du66Gmt33UBGMPcQOZIztu2WByEOxW+0ZEBul1EF/hqi+K2TwVq0tzWuQfi9AFVwbQuT2emWu16lfKqmpMYvLlWMS+fYL0/zYMMI64ZQEB8zhTpDJA15rpMPhf4Ep9TBqpxIhOpiiPdm3Wsvt6tD+CXJozfmDZJPF4d6TxhLu9Odk0Fu/DPpM7h7pyYGfVix/Fxhw/yB0rz+wzBWDrIW5B+zy1ALCAOKqxqqu67YdqTNsXMXt7hfNcxb0ZmoCJxG2nlWdCNXbsTt/OwLAhOzZEYXINpXWKa63JGneOuh9p/5eIIa6y6VyTp8MqZjYfsJXm7kfz8D4sJMNI+PiLPyG21b8kggAyBsg1h7tfh6jP1juMmsBUZEIpChVNhwIzELSTHFBHYyQrykqRCTqTS6Sr9U7FNEO17x8169fu9d7j7CBXNNlcJx4=
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