select mfr.mfr_name, mfrImg.image as mfrLogo, mem.fspro_userId as userId, mem.firstName, mem.lastName, mem.title, img.image as contactPhoto from tbl_opr_clientoperators opr with (nolock) inner join tbl_fspro_members mem with (nolock) on mem.fspro_userid = opr.mfr_bsr_id left outer join qryImageFullPathLookup img with (nolock) on img.imageId = mem.imageId inner join tblManufacturers mfr with (nolock) on mfr.mfr_id = opr.ownerid left outer join qryImageFullPathLookup mfrImg with (nolock) on mfrImg.imageId = mfr.mfrCompanyLogo where opr.fsl_choid = and opr.ownerId = and opr.fsltablecode = 'MFR'