select cdr_recordId, invoiceDate, skuId, dollarAmt, count(*) dupeCount from tbl_CDR_InvoiceHistory where invoiceNumber like 'REDIST%' and ownerId = 54 and ownerType = 'MFR' group by cdr_recordId, invoiceDate, skuId, dollarAmt having count(*) > 1 order by cdr_recordId, invoiceDate, skuId
delete from tbl_CDR_InvoiceHistory where ownerId = 54 and ownerType = 'MFR' and cdr_recordId = and invoiceDate = and skuId = and dollarAmt = and invoiceNumber = 'REDIST'

Removed #_r.recordCount#

select cdr_recordId, invoiceDate, skuId, dollarAmt, count(*) dupeCount from tbl_CDR_InvoiceHistory where invoiceNumber like 'REDIST%' and ownerId = 54 and ownerType = 'MFR' group by cdr_recordId, invoiceDate, skuId, dollarAmt having count(*) > 1 order by cdr_recordId, invoiceDate, skuId delete from tbl_TPM_Accruals where ownerId = 54 and ownerType = 'MFR' and sourceType = 'TPM' and entryType = 'GEN' delete from tbl_TPM_AccrualHistory where ownerId = 54 and ownerType = 'MFR'