SELECT *
FROM agents
INNER JOIN people ON ( people.id = agents.people_id )
INNER JOIN phone AS work_phone ON ( work_phone.people_id = people.id
AND work_phone.phone_type = (
SELECT id
FROM phone_types
WHERE enum_name = 'Work' ) )