2lsyjN5sjrSOFqKDQ2hqEtIsQ4zWVG6UCIKM3yAmXm8luM6NXpca5GIwy7tmXUVFWMASM4IaYrzZggScKH3hi64bAIFHFW1nwiT3PryLxsgK8TOULZBdIeyBkoNr+80sq30uOZxpcXDK+XckWMzzRhANM9+GHejMkei5TKj6FVdq235ofRP/kM37H66AxT2iNrDQ3BOO1qDPIQ5o7gAG4LRnDj3WhB9Qxa4vbOXVgiA6IgpeZfp3HPmdoIm0TXI6da5UiYJIXOzKYzPhmBD+zGhAZukiy92baa2gTClb8YJjVSAkzIvmLHoSGWtT9LxHpFtXEk6xveN3kYJNyyjAgOuMo4zYNi82CAtTeJNuQ+flSAYcsCUp0RxvMfNR9tiH25Xw5DlTC+RL+Q7wSBdM7GifDiJzr20pKapZEt+xQR9/t90C9TaAkTkaSGUWVl0HxE9699OVOj3WdYN1lbQV0qnIAsDQngWR/0zn/J2cz5Ne+IYIEFZ+xK6WDPApuLAo4ljXYcZ7ZBUR3k2Z1AzfyDwjkDlnaFXUlNyXqMFJY7yhjlSQBIHhns3Y2EOgxdHDZIKVRPMXXs0M8xHl/zu46il7kHeQgOUchXdi5+DLLEgt5tKpjmJu9t5H8SUy0ataw4beCh87gcZqnsCX9BQqiASYBEOL+QmOMY1mT3qrmWf2MXOjdhjs6fySpLssK4/tX9lt6sjQQZ1jD7bLx/+SMFzynWj5AOYE2sGCmq25UP+YXsViH7czpoBhld+5HcS2ZTBLZbXBMKygVYaHKZuV2IdPEqPqZLNIHcnHO6ixNQNd3iodc+XCnlE40T60+dQWhKLIQn3hWNalqqWtvaydpSt8cEejedaqG3VOgV3Uax984LRYLJzVD+UuY+SS9CdbliQlvOs/dg8IxxJB3evjIMASPYYdejGryvGu4xHj28xJmkOmL97C7M2tl9OOyYhhVLrD1UQt8Db/l6XvvYSz539OrMtKuiE+cRF7Lxx5TxvQz4YcHVAp8GzPUWnjbBWjHmt37a7aORL4vGNAIoQ76o3vAYkdRD67cO1T6+rPqVr7F751T+EMAnIlXQz9qlYiPJKroFkZLC32+LK8v1dK68aqH11Ou0dezf4Y46ct2bvf836blKbpzCPl/DLafOcjsTLdVibwdNayCzrEwmQSZ+c11VsG2JQ/rxD3FAF7jKmgH31/HjwR1B/HOrtSyR9aJN3Zck5bTj5C/GprJwH+/IVjzYpq3mf23kClNm+oV9vGEj/gJU+m/mO9htjPTMAyF7p31n509cD4/9O2i2eW1PcJnuh6StuJfyLSjR0O1VT1wvD2nzGPHR1mdBcGXPHdOZ7fJfzHsUxGQJXfpz9IYZKPfYISwUsNJhT+UJ0=
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