SELECT people.firstname, people.lastname, role.name FROM people, roles, eps_people_roles WHERE eps_people_roles.ep = 1 AND ( eps_people_roles.role = roles.id AND eps_people_roles.person = people.id )