1qvOpL6RcYMUGuux0sc9NzH+8UaC11xj6oW3xRJckVckDyR8fokinv3ZPI834lqZft0TY+FS26/jW/Kq7SERhbW6bHXAGw7UuUDcnrOWgO5rikIir470FhhJUIyczA+xxwfK9Ys9Tt7SVBGDkwrhmCJ3U2yhoKl+JqkNVxoVDHNGCuvhbso9Vsj/tbAMwcsGTnP8lAXe8kVlzp0tENAVfw7+oWRZHv1wG2OB7k/mokH/IKfK62WZIzxJx/jK+9ZD06VK6y2NEnBPieb3KkKCxuMy0uXIL+tbEeBK3lPLYUYEQ3KYWc7DQ5dZV5vhcjjPpCToOHfAVUmDbkIsh0DDTFI7o/Rlz6JwInjxU8wEDevRqoAXuNTfiUln42MooFhyp6R9GqpRiDi2oTx7DwOc+bPo9CLoYuPfL+NupHttE+YpbQ7znnHgW+/6qy7JxRZOg+OsqNLZtzNKbLbzVEYwZgui5w3gjjZqwLLspdwS+WlvW9BRC2XCGbS/gj6HDlUoumzo3SB1y++GsoFYBZAHPyXIh50BpwMGrW0uTUpkyPxQYfE2ko+P3Wnx+D9lmrvR5fsIsXbxzP5wVTADlq+xDrA0jeV3fqu69Vh1FSFW3DGQx41HIf7HrGyh+10RyZzXalgf3Mnar/DcNgb2+xIVH5+h1LqGb8qKj0i0drky0ISs/AxrV0FDCcJzOqdAcf/yqSMerCYQOqiFf97AeXF3YdROMSQ3kcTWxEphQ1D8iwta5FyRVb3S2v3V/Vg2qJpWRxBxEaaMQzsiX3wjSBRdCEOZrdqihKLyLjUL3CLr+cTLS46I5Q/XyHW3YLfAnlGYF2zeKlRkWhrRKGbcYukoKVHhsV79TE6jonzfXJIjp5H2tqPum7y/1pz/RV9o06gqhP4YqM5a5xStzWuGQ+Qg6HgUjYtS+1qNM5Rvvajx6CcE1MvWRU8qThl/oHNfxJVqIuZqqfJ9agjKq+KuRdUdE9vf/S5XR52wrjylpGOz7R1mxtLBDCK8u+of3D23QQU1QaiJ9n4JkcAmsv7s0RRgE0nXMQisSCxBFOJ/J/fRD0WKTo/4JiZWRwg9axP5UQQ+1p5MyoKvNDBZcf3sT3jNoEs85KPC40meuVzfuaFoX+xBo+cnAfarcWZv96xPJzlLtVgan/ZCX9hTtsh/+5f22drjn/Ko1ahRaU6hAI/yoBHgXxmVjyzO7wjR7j4bbx/ZW6jEBpVHbm2heNcQJJk6C/JB9NckuBMwUubrKm5y/5iIP6+1pi6kyeMFRYVaGZ7Pmx/CJDypUpmCCn6TsM0PVCC9g/GEMLFVfaEt6wcHraUYZOmLOxEwSfOVAdB7tNoo5+xr+ewlARdgCakeT8MCCkyd5iBgk/QHeM+Dfg0=
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