select fse.ownerId, fse.fsltablecode, fse.operatorId, fse.lastImportSource from tbl_OPR_CLientOperators opr with (nolock) inner join tbl_OPR_ClientOperators fse with (nolock) on fse.fsl_choId = opr.fsl_choId and fse.lastImportSource = 'Trade Management - MFR' + convert( varchar, opr.ownerId ) + ' - ' + right( opr.lastImportSource, 10 ) and fse.fsltablecode <> 'MFR' where opr.fsltablecode ='MFR' and opr.freshnessDate is not null and fse.freshnessDate is null and opr.fsl_choId > 0