Untitled

select
ac.accountid as account_identificator,
communicationtype.name as communication_type,
created_by.name as created_by,
ac.createdon + interval '3 hour' as created_on,
modified_by.name as modified_by,
ac.modifiedon + interval '3 hour' as modified_on,
ac.number as number,
ac."Primary" as primary,
ac.smexternalcode as external_code,
ac.smisaccounting as is_accounting,
ac.id as identificator
from vw_ods_bpm_soft.vw_accountcommunication ac
left join vw_ods_bpm_soft.vw_communicationtype communicationtype
    on communicationtype.id = ac.communicationtypeid
left join vw_ods_bpm_soft.vw_contact created_by
    on created_by.id = ac.createdbyid
left join vw_ods_bpm_soft.vw_contact modified_by
    on modified_by.id = ac.modifiedbyid;