Fx0M6vjeYxvOuERCU70eBk5J3ciyL53Vp82t6UXxVFY81/hRdF9V7nHnkgQZPAefmae8UyVmo7JOwFbqMUpX5LU9KVf+iu7v2OGI3nfR9T/AAJi+aoafDv0KlCQW4IyHbzITuC26iQlUEK08GhYrrI5h9gg3atlxQOauuZfGHsMpmJgkunodUgo6SXtHI0GLRi9UpkDsAdqkNL9DgvjlFokzl6uMNPZs2OLfQ04uf4F6yEThsL5VV6Qmju+B9Pv5P1nJlM1KGpK8hrpeFcUht1DaUrh4HQzzcXiDMbIEFBDgdO68Mx3Z9QPxyZJcWw+AP7SCBV3JWgX2bKyCRPZ2jeGvyyEq0wlsY7itAriBox+5+j/I00c3dC1dwSQx32G1QutLn7fiwCZFeVeXiLshcwxi9dHd7a5+2i4Q16Y+KMIokTJXTaQXkNYypS+qrUKXa6v18cq/kokBPTjiZ7VCXDkGDpPwuqd/Czp2bdViIGpo0NWyt5wFJjDp7AeKC6TaBWEFPnOteRmyJdSQf04ZA6Ms5nLXPtUIZ+HHyBjNfSxNRs1HerSQkTUJ7lLts+oKcD5a0mHQmGxuuRS18LPjcgL4FNxDM0fOZXm38BvoUC++XxYZqDFtco295e1zKeLFKIN3bM/x3tdRJkdO+ROtslUuWdbyHpm368fagvISnkjDsKMKGETQs3z2M1jqHyp+AnHTmTpYF5k+/9osHIXZZ8uANt4aL3m8bI7DryguWQrK7F61AJ9JH2LLmWMdCwNLvr3z6Pl9xRdcD3XBSiBS8jXaioTVp/85k3TcJP0w+OIszt16a4fBMdMXrO1bMNhyQmyDTYbxoPfX3O6Kx+Zmn7Xl81IDhXUKDKzv7fCdyfOz/nfDKS9aidRjiRrhY+xqU+ov4j+Jy4Hk7sFGPeIGXpQbKJpimOnfaskEPQOGrVR8IRBTkBXbM+yEz47xi9VDW8Y2ClP5Cy26an0W/U563qDewgBhCbZqbOnRkuxMfaiPNE0tWYoKErtXg8FK6yzFg7/w2Ei/XxRgo6jNbkSrT6j+0vg2gW3ApUHaF309ABjPjVLa3gsusD403xgUZ6mzu80nKt78v3NK3Et9hjwVOodY2Ls9ZhHzx0qkaPWgS4wHr+klu7pt/hmEqx56M566rxmKRq8Tj2uWKDu7xTUSB35aRv+WMWzsNmN/T9zDs7AMQfZGbhMyQtEP5gOVoXoXkWK0doGDv6Kx2tXfcBeOR25mDXaYIeaJysL5sdqaicfT2awt2S1izRTo1I9JWwjxMsezxYk+dGvBQZadaUy6nJXonCfD5VU6aGc/EhrXqHpPyHzzY2dd4FmXn4BVBBRP54n0ERpOpv7YT2h/73D9ewjzoLrHFuzVkHC98gM=
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