SELECT people.firstname, people.lastname, role.name
    FROM roles
    INNER JOIN eps_people_roles
        ON 
        roles.id = eps_people_roles.role
            INNER JOIN people
                ON 
                eps_people_roles.person = people.id 
    WHERE 
        eps_people_roles.ep = 1


##</code><code>##



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





##</code><code>##

($_='kkvvttuubbooppuuiiffssqqffssmmiibbddllffss')
 =~y~b-v~a-z~s;                             print