select territoryId from tbl_OPR_CLientOperators with (nolock) where ownerId = and fsltablecode = 'MFR' and fsl_choId = select cho_zipCode from tbl_CHO_Operators with (nolock) where cho_id = select mem.fspro_userId, mem.title, mem.firstName, mem.lastName, mem.primaryOfficeId, img.ImgPath + '\' + img.ImgName + img.ImgExt as contactPhoto, logo.image as logo from tbl_OPR_ClientOperators opr with (nolock) inner join tbl_FSPRO_Members mem with (nolock) on mem.ownerId = opr.ownerId and mem.fsl_tablecode = opr.fsltablecode and mem.fspro_userId = opr.mfr_bsr_id left outer join qry_ContentLookup img with (nolock) on img.contentId = mem.imageId inner join tblManufacturers mfr with (nolock) on mfr.mfr_id = opr.ownerId left outer join qryImageFullPathLookup logo with (nolock) on logo.imageId = mfr.mfrCompanyLogo where opr.fsltablecode = 'MFR' and opr.ownerId = and opr.fsl_choId = and opr.territoryId =