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 "AccountCommunication" ac 
left join "CommunicationType" communicationtype
    on communicationtype."Id" = ac."CommunicationTypeId" 
left join "Contact" created_by
    on created_by."Id" = ac."CreatedById"
left join "Contact" modified_by
    on modified_by."Id" = ac."ModifiedById"