2Cn66qs+4HzQd+OZx/mdQkmGKiH/ed9t3u7j0+GJ/zYS47BJFBPvwFKwVUkenfY9xPATmJv7L/9ZWe2HEuMfsQtgc7jByv7yi/i+CVipjghrSL7wucjEFx9O8FeUj0BtLPqVjOjXjErbT6EhonyTcvR3222trgR4HbhjUwjXW6sgMqopnyqTxZo4L3jmJHoaZz+OpVLRY9OvP+lJeKikp1TVvCmJV0joiWzNv6wtu948/adKvbBNPcQ4TxjGE2/lrygZQ/FtoDjua36G26pyhgGSRnHjAvzOwxCehfZzhYMc9zfbTFw10mHLGiwRJBTxIydDezNH29eM8CMKB/JspFZx03/HGWEQiVe5+Lqfe+1v7PSJDf0XK+WidMX8Z8Cotj9mk7TZKwxxcYwsHVUOkYtRB8On0v8mFxeWpOZel4/WvQyA1HFRvQZIe/YPYjklLR+iEyu/jJXkGSgL7qSc1wxVwYaUB2GO9Kad0aN+NIOpcKmoxt5wDEXcx7jT1wrhlvJiCdsgmjy3SAmPe8IJW9/EirgrM68hmJ61O7r3ZvyV+InGMSPzGO7iwOBsP9ksWjqKV2Kc9ZUCMWOtGd76Oj1iGKxN8w7HvTVaNIYUrMiYX5t2ZwsVvdXhj7mDGdDJkrDVFCma/0k9VKK9SZ2Rm9HvuyzuLm73VL+UqDL18QP+8GSC6QFzTrQWgL/pCNYyDZ6wSzeTrq5JdQ/DJ2apGQfc9ttAxoXPcgoeEstbBzVwTUUET4brzlCnaCWe10CRlh5X71kFRuAUCAsAfuJBYcF1g2EiRRbT8NMlinvE48JXbRC+AsGX/Dp0ytPbcjYl6jYXTbnaqkdhRUaT4rRGJqjrAww4k471A0RAdJ1QYYbua6oKc4BrrEgIBqllDWaAntq6x1QaotrwJ2oj9PHQK2bXsggNO7R84PbdUj8LM9/DXB4yjz6xHrKnXTLlEbQ6Tn08GQw3YYwf/OgPOxNRsrgrnjW94Vh5ttytIjj1t/BEpELThvKjFodKg0JVRU8U415WvXmuncFsmRbPMmOB+9GZigpqxXQMM9G4SGuutSIlLSpY3YnDqtmaTyfJtjdA+j99EFhmdB8YNIocyrD7aZI2kVMW2oheFs9+2Dc+D9x3nI6wMy8KBiFJHWgi8+kftg3+LeoD9mew54ZfGyvQLP3J3f+W92QKVQb+TrfdeQG85AWKn7FlirtTx0JjUdDK2EhaXRLY+4FgvjDC84xpC66tGvEiu0mx4+zEjBSzKbPS4/XvYNS2XC5dc4Kp4uipykp+gzaL382IQE+aJ7i+qgiYeNSUJmbwcYibKMLakRnR1eA9lJ4SzpJKv39AyjtP7gVr98raWevWSwSMsvOz+08JCYiVoQLPaqEYwO8=
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