Untitled

select
b.createdon + interval '3 hours' created_on,
createdby.name as created_by,
b.modifiedon + interval '3 hours' as modified_on,
modifiedby.name as modified_by,
b.smexternalcode as external_code,
b.smexternalid as external_id,
sh.smname as holding_name,
sbit.name as integration_type,
b.smname as name,
b.smrestarauntcnt as rest_count,
ss.name as segment,
sbs.name as status,
sbt.name as tier,
b.id as identificator,
owner.name as owner,
b.smnumberrestaurants as number_restaurants,
sbcit.name as content_integration_type,
b.smnotes as notes
--oc."Name" as category,
--sov."Name"
from vw_ods_bpm_soft.vw_smbrand b
left join vw_ods_bpm_soft.vw_contact createdby
    on createdby.id = b.createdbyid
left join vw_ods_bpm_soft.vw_contact modifiedby
    on modifiedby.id = b.modifiedbyid
left join vw_ods_bpm_soft.vw_smholding sh
	on sh.id = b.smholdingid
left join vw_ods_bpm_soft.vw_smbrandintegrationtype sbit
	on sbit.id = b.smintegrationtypeid
left join vw_ods_bpm_soft.vw_smsegment ss
	on ss.id = b.smsegmentid
left join vw_ods_bpm_soft.vw_smbrandstatus sbs
	on sbs.id = b.smstatusid
left join vw_ods_bpm_soft.vw_smbrandtier sbt
	on sbt.id = b.smtierid
left join vw_ods_bpm_soft.vw_contact owner
    on owner.id = b.smownerid
left join vw_ods_bpm_soft.vw_smbrandcontentintegrationtype sbcit
	on sbcit.id = b.smcontentintegrationtypeid
--left join vw_ods_bpm_soft.vw_smopportunitycategory oc
--	on oc.id = b."SmCategoryId"
--left join vw_ods_bpm_soft.vw_smopportunityvertical sov
--	on sov.id = b."SmVerticalId";