select cdr_recordId, cdr_dstname, cdr_dstcode from tbl_CDR_Distributors with (nolock) where ownerId = 1382 and fsl_tablecode = 'MFR' and nullif( cdr_dstcode, '' ) is not null order by cdr_dstname select cdr_dstcode from tbl_CDR_DstCodes with (nolock) where ownerId = 1382 and ownerType = 'MFR' and cdr_recordId =