zGfoUQNBKO4UOXkNqAeTLEb9Gp0KBk4Ev0xxRNWgoaXioCHkvnfNESi7faGNYdrklNH2W85z9OXvndjSzsjuECoNXHeKg2tSsaqF67bswUEsQKciKmeNcmT0roueehxyGOxilTwKS8c8x08EuP5vVnZKNZUcv70gdqYN19eU9gAPsG/Lp/yAsD5zrM/sIjz1GHl1l02lzAo2wf2MAiUK8SN+PDl4k+W/xpDNvL9BNa0n8MfnKPNqoPi28NiG+Gh4QSY3hqCGNe1X7vis+1SLtS4AwO6k0B/IgjWPQr8w9fRBtSJQZIIsHL18c1OZB7tCHovoa37OU09ju2mtiCW6HCCwNDV9q4F9w6K0VheIi3hDxFBf/U1+WVnxGPv3c0qIBnaH+5MRNg14bbIo03/8srsJrU85JvTVBbxe/Au3B2f+6dztj8ovpJcpI0QwBTvdbEegB14Xf9JIHzVIZaW60pXJRGGvx98INB0IvpifLNy3qHYWyIyWkvbhIEUFS/Ru6RVY2BvyXnFdlE5r6BhlgPUo9vNB5b67ieXhXwhtguszXNshnatDQrFxPmYU4bQ4w9f42KD9BUR8mBQ1I8XuVcPsW/dfZwJ6uHwI73wi8VgdYLBU79PJiBntgxZVms3vwK/XUyZ8CF9dAn5t/2rl2dGG5kSq2gdWj36ecNbWJzeqM3q0rF2mkHnhV9eeJ5zWa4apP7PXnaH1nMAmIC4bOI8tiLhJiwVGLdxkV2PhVwYT/vAtDcv0hcJxO6luUiBlJUGWM0ax3hrLxxC7/G/0ppk9w04qgwoJQPJraoiytciy4lHpLMqadDhxwPF2CSUQ26JI7tmrZt1OFSZ3RaGNNUaaIfoUOKpf14Q/JrmWy/9dtwYhY3sX0kWanppKjCM19nlC+fB9PRZUzj2AD9OS9NVf8XpTsn/4LY4+M9fkox9XYwAA7cwFcX1kiCb+49LGrWFj+mml/VreNdBcXv7qf7Fikox8Syy5U83CMSRhPDrYyAcSd8BAVGgUZiuoLQoEOeavB2Q2KG0LePRCuBtZx9Y+zIXv8EDXJdTSZre1wwa6DzFIziBrcTPQgznr5vYcBxdLs20rIiIUCW3lopW1EbY0H8I8T+DC/t+PII4iWz6OctZr+4RjoGdCR8gsc8L3A47LUY2Gj7wBUhHSFF99adlGN/xT5P7Z2jVqmSVpm5pIGbpT7gJGTujx9qVp80lmx+unKEdZvsvpfqrbnvduTvzC9hd61a5zELOCzzVg7E37TU9H6xwi4kr9uLNAioNal/AKYNUA3RdXZGziXcPu75seQA7BXrfSDvULfLV1TWz6UX4ERcVHp6DjvLZqZYNhOQnKBKoPo72UFNt9Ti6zAlU+/Rhg74ltMAxj8Zg=
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