select ownerId, ownerType, claimId from tbl_TPM_Claims where ownerId = 709 and ownerType = 'MFR' and readyToClear = 'Y' and reconciledAmount is null and archived = 'N' and claimType = 'D' and partnerType = 'CDR' order by claimId