select mem.fspro_userId, mem.title, mem.firstName, mem.lastName, mem.primaryOfficeId, img.ImgPath + '\' + img.ImgName + img.ImgExt as contactPhoto, logo.contentPath 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.primaryContactId left outer join qry_ContentLookup img with (nolock) on img.contentId = mem.imageId inner join tbl_CHO_Operators cho with (nolock) on cho.cho_id = left outer join qryContentFullPathLookup logo with (nolock) on logo.contentId = cho.cho_logoId where opr.fsltablecode = 'MSC' and opr.ownerId = 173 and opr.fsl_choId =