Untitled

select 
aa."AccountId" as account_identificator,
aa."Address" as address,
address_type."Name" as address_type,
city."Name" as city,
createdby."Name" as created_by,
aa."CreatedOn" + interval '3 hour' as created_on,
modifiedby."Name" as modified_by,
aa."ModifiedOn" + interval '3 hour' as modified_on,
aa."Primary" as "primary",
aa."SmHouse" as house,
aa."SmStreet" as street,
aa."Zip"  as zip,
aa."Id" as identificator
from "AccountAddress" aa
left join "AddressType" address_type
    on address_type."Id" = aa."AddressTypeId" 
left join "City" city
    on city."Id" = aa."CityId" 
left join "Contact" createdby
    on createdby."Id" = aa."CreatedById" 
left join "Contact" modifiedby
    on modifiedby."Id" = aa."ModifiedById"