select * from person left join per_agent on person.id = per_agent.person_id and per_agent.active = 1 where person.id = 1116
ERROR: relation "per_agent" does not exist