dOCVT0UJqu9w4vJd9k/0Dovjzu/hfxcckBJGezkfW/U2WzzWcR3uPhiHldNCstPrAIjK/6kXEg+OjT7qy6H0/UK8jfrPlzt+ao7ckVS9EAVnKbeziwqzXuL0L/6zQw/8q0TJv7rZBatY9DHbX2T1fyWJ8LNmB5TSdvg55eGnstPd6IcOi3HwoaLl4nNY4Ibr2VUET3eIylKdRraIyWrtCN260pHLEsRX/wF2O6mrwVFNm1NTepFv+oAHVVui8X96P/AGJdk3Wo0r3ndLq0k6HDf6dUQjMqaANSeYpM1FnB/scTFaCdZA5LLzCUkASTaxeH1b6hEbzQVFPTTkMZGAQm4HD6vgdUBauVxpavHQbt3J3r4TvUNO0+T5X0nU18JW+K0Olu+h0JRBk5FLXNBw0jIrKb54a9f/LX7ySyAi8Ynw+eWhPktBTSn5PzNFN2QewGllmscf4QgUW2xECbFoMsdh47YEFxdoG1RH+EJTy2r27PDgAz0s54AQWsptLNHXGrh50V5xrLjI9c0WTtoaFOhMXXKoUu5hTQOH8uuF1Lvz8tO/+w/aeJcEkFkCqVtOW91cwemFuuQH8Zk72nkdZxe0CQnKuWhVxeW8s/lZ7dHHvMjn6asBcHhUpNeuS0siIoGy9zkGcsvtnoXgt3QPSESA62h6MkBnD1POoEGSzxF1Zdz9R5CyYbLDMGOAY+3NlFKKfVxKv5bQUH4i7RsQuquBkem588ssx0sw/BA2pT11FgkECqYzyEQKdNV5kwaCfpA707mKqGM6FvMOCLGhKDfxdvtYhd950V2M9eHx3zL1Jh9Uz6wKA+KkTmb/HctvxiQrpvQpvZ4Y3sIO83yJIqJH7KOCBaP7/5MOsfaLj4Nqfo6PkCSMlxCEb2Uw/k8q414xxpUgRFJvkYoypds3vEWzcWnM1QuOQ497S0XiZTf7v0RaGi5foXi24TRPK9iuMaQyOfnvqcdVfvKjk+lEqc3EOn8PEvbCbQGMLtBOfmVym9SRAzsv6cXO20wQwM5kRZ7mFlfnZ6Iq3JEQ/qBk1AhGfQDDmHxE/6fkprG0CmLxe9oqTSkiYE/6APsVaAS/WLxTSEAcTHmrQSm6rlWIfzNts6FsB1xQEusfK1ofRjszuOQaiS855xGOP2J/MS8nA8pYg0yAuO2myWkvtDvN8EPI2rAZvJL8VWjMIjMGkVqGdSf/bFAaawjhm4fb8QqJlUh3zm/mSL0rwegznY2U4dORuAfbKjc8wAJnVh04LlSKCxL4PBT9ze2GUJaAaRFs5tfsnMvZwSpriIeAWe1qHxFBxV5h8k+UAQaZt1KQo838lyW6QKj2Mbm8xiyoZjfe1WYuakPp3sL5BtjQnc2ji547y5bXId5RqlLKJvM=
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