select opr.operatorId as systemId, opr.MFRCustNum as accountNumber, opr.companyName, opr.address as companyAddress, opr.address2 as companyAddress2, opr.city as companyCity, 
opr.state as companyState, opr.zipcode as companyZipCode, opr.phone as companyPhone, opr.url as companyWebsite, cla.name as classificationName, cla.description as classificationDesc,
opr.OPRType as priority, pseg.Description as parentSegment, seg.Description as Segment, cui.cuisineName, dst1.cdr_dstname as primaryDstName, dst1.cdr_dstaddress1 as primaryDstAddr, dst1.cdr_dstcity as primaryDstCity,
dst1.cdr_dststate as primaryDstState, dst1.cdr_dstzip as primaryDstZip, dst2.cdr_dstname as secondaryDstName, dst2.cdr_dstaddress1 as secondaryDstAddr, dst2.cdr_dstcity as secondaryDstCity,
dst2.cdr_dststate as secondaryDstState, dst2.cdr_dstzip as secondaryDstZip, opr.cmcCompanyName as managementCompany, opr.gpoCompanyName as GPO, cnt.FirstName as contactFirstName, cnt.LastName as contactLastName,
cnt.Salutation as contactSalutation, cnt.Title as contactTitle, cnt.Phone as contactPhone, cnt.CellPhone as contactMobilePhone, cnt.Email as contactEmail, job.jobFunctionName as contactJobFunction, cnt.FSPro_UserID as FSEContactId, opr.num_units_lastYr as numUnits, opr.seasonOpenDate, opr.seasonCloseDate

from tbl_OPR_ClientOperators opr

left outer join tbl_OPR_Classifications cla
on opr.classificationId = cla.classificationId
and opr.ownerId = cla.ownerId
and opr.fsltablecode = cla.ownerType

left outer join tbl_OPR_ClientSegments seg
on opr.OPRSegment = seg.clientsegid
and opr.OwnerID = seg.OwnerID
and opr.FSLTableCode = seg.FSL_TableCode

left outer join vw_CMM_Cuisines cui
on opr.CuisineID = cui.cuisineId
and opr.OwnerID = cui.OwnerID
and opr.FSLTableCode = cui.ownerType 

left outer join tbl_CDR_Distributors dst1
on opr.Distrib1 = dst1.cdr_recordid
and opr.OwnerID = dst1.OwnerID
and opr.fsltablecode = dst1.FSL_TableCode

left outer join tbl_CDR_Distributors dst2
on opr.Distrib2 = dst2.cdr_recordid
and opr.OwnerID = dst2.OwnerID
and opr.fsltablecode = dst2.FSL_TableCode

left outer join tbl_FSPro_Members cnt
on opr.primaryContactId = cnt.FSPro_UserID
and opr.OwnerID = cnt.OwnerID
and opr.FSLTableCode = cnt.FSL_TableCode

left outer join tbl_OPR_JobFunctions job
on cnt.caJobFunction = job.jobFunctionID
and cnt.OwnerID = job.ownerId
and cnt.FSL_TableCode = job.ownerType

left outer join tbl_FSPro_Members bsr
on opr.mfr_BSR_id = bsr.FSPro_UserID
and opr.OwnerID = bsr.OwnerID
and opr.FSLTableCode = bsr.FSL_TableCode

left outer join tbl_OPR_ClientSegments pseg
on seg.ParentClientSegId = pseg.clientsegid
and seg.OwnerID = pseg.OwnerID
and seg.FSL_TableCode = pseg.FSL_TableCode

where opr.operatorId = 1450915