1Y78YoNWK2vsnVJMc/tvWAV7aGepz2tFFtOBl2yHgZO58+og+uoLLQTz1u3zxKCZzUtyvDL+hfW9sQz9iJUfBLH8JOjnsgiObKEKYXtfA3JgUo6aHpL4chK+BKzo8UyVdlFiflHvCRQCWL0tybKfqLTj6+wTUVGEZ3W1p/u8lx3gjPrVLtA7xlojfsmx8AvFrIfCOcVR/iHa6qFbOPBIdF2jh+A2cQWBL5EBtluynDpqklylMgIMNcfSd6EOy/Bi3vHVXxHYAoyIZAmOzga6fTNA9mQWZ7ElY4lv70wtkMTAX8+tCkY5B4J9UzfrmJh/3C9tYAreckMbkuHtnUNqHj2cKn81LLsEwgIFVuB6zB3RcyLj1ibi7vMGrucfH1zAxe/ws4SEb/Twib5Wz6OaJBPvYcHjhK3pOL3VJm7VyFjwtmWGUQGqe6gm7jiQHhneKf/TsUcl50HATGUWFhlCc1Lzhnju54zkdxLPQ8BM4QIhFXjzFVJE9qF6Jw7SGJjmCK1tjTplk1HkVLZl3Rj3mjyqreTDroF6oTsax2nmU6j7eJWTA01sXhXA0YkyN7Xp/tO/rbQODf2UmtLuSFpbJWzA9zGrMO8p+22drxoVEHcDk1hjGdACewvZ6bF55UiMZTFdGQ+2OVNdZUvO/U23I4s7HoN1ii6i7e47hqx8dNetfVpWqWsROg/zAh1K0532gykMEJBgmwWnLRwSbqkqnOKzaP4JarejgWlvAyurO8T3bIwXZwPSPbWCHHgubPGSQcRh26SjCCtS3ajOl2Hoh/MkGTUPfvoixHww5fwQTa54aTGWSbJEqzacw7x7HdO5E2dBXZzMCO1MYU8lCIkRk0wFylweSkzZ5fdr3a0osCqyIRWD/4sDnZrcxIYJUZ9s0nunB9pRh0tTf8uQm5HGPuTqo82DXG10kCbvIvCd48nEN/ZC8ulQBe9af3acEAID/gNqXk4iXnTwoHu9UBwd4bHIHmIgpI65cBWES+V5mrSGhsFxpJu0XzhvWnGdIuLQ7z7AabctcDULZ00zm/wz1tuT2wvfrrCsTjbXVuVKJBG6vE1WAw3cwtKiQPa6ecY6MZWk5V9Bzv7ly822hJfX3sF5lmj75P9zZmK1q3ipH6nykzVaox+xoOK9a0GVpTVSO5sB8lzAI2wc/5P2C1R7mgv2nGOe8Ew7yxqGsdSn6C+IYOk9fDRvwd4Nyfcroh6gNh+HnvFVihn4XXhjqJYluJPnlr9bUyMRzid6YMsJIFIPKQoa/K7OLW0OmQkq6PMkfbNGvigFaxZxDE1vRwQ7dpxfJc/4aZ4Oy2d1oCsLWWzLG7jRc9N75LnepyTxvIGOfxidYjjogYO/5dAxNie8SxaGRbBUMXR2MswMFtw=
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