create table awight.t144489_duplicate_pairs
    select
        count(*) as c,
        contribution_recur_id,
        contact_id,
        group_concat(receive_date)
    from civicrm.civicrm_contribution
    where
        receive_date > '2016-08-30'
        and contribution_recur_id is not null
        and trxn_id like 'RECURRING GLOBALCOLLECT%'
    group by contribution_recur_id
    having c > 1;

set @base_url = 'https://HOST/civicrm/contact/view/contribution?reset=1&force=1&cid=';

create table awight.t144489_to_refund
    select
        p.display_name,
        p.id as contact_id,
        concat(@base_url, p.id) as civi_url,
        e.email,
        c.receive_date,
        x.gateway_txn_id,
        x.original_currency,
        x.original_amount
    from awight.t144489_duplicate_pairs d
    join civicrm.civicrm_contribution c on c.contribution_recur_id = d.contribution_recur_id
    join civicrm.wmf_contribution_extra x on x.entity_id = c.id
    join civicrm.civicrm_contact p on c.contact_id = p.id
    join civicrm.civicrm_email e on e.contact_id = p.id and e.is_primary = 1
    where c.receive_date > '2016-09-01';

mysql awight -B -e 'select * from t144489_to_refund' > t144489_to_refund.tsv

# Snip base transaction IDs into a file suitable for fgrep.
cut -f 6 t144489_to_refund.tsv  | cut -d '-' -f 1 | head +1 > t144489_base_txn_id.txt

LC_ALL=C zgrep -a -F -f ~/t144489_base_txn_id.txt 20160831/GlobalCollect_Recurring_Donations* > ~/t144489_recur_job_lines.txt

grep GET_ORDERSTATUS ~/t144489_recur_job_lines.txt > ~/t144489_get_orderstatus.txt

import re
fields = [
    'MERCHANTREFERENCE',
    'ORDERID',
    'EFFORTID',
    'PAYMENTMETHODID',
    'AMOUNT',
    'CURRENCYCODE',
    'PAYMENTPRODUCTID',
]
f = open('t144489_get_orderstatus.txt')
for line in f.readlines():
    mapped=[]
    for field in fields:
        pattern = '{' + field + '}([^{]+){/' + field + '}'
        matches = re.search(pattern, line)
        if not matches:
            #raise Exception("Couldn't find field in line: " + pattern + " " + line)
            mapped.append("")
        else:
            mapped.append(matches.group(1))
    print "\t".join(mapped)

python search.py  < t144489_do_payment.txt > t144489_details_do.tsv
python search.py  < t144489_set_payment.txt > t144489_details_set.tsv

create table t144489_details (
    merchantreference varchar(255),
    orderid varchar(255),
    effortid int,
    amount int,
    currencycode varchar(255),
    paymentproductid int
);  
load data infile '/home/adamw/work/t144489_details_do.tsv' into table t144489_details fields terminated by '\t';

create table t144489_details_set (
    merchantreference varchar(255),
    orderid varchar(255),
    effortid int,
    amount int,
    currencycode varchar(255),
    paymentproductid int
);
load data infile '/home/adamw/work/t144489_details_set.tsv' into table t144489_details_set fields terminated by '\t';

# Transfer last details over.
update t144489_details d, t144489_details_set d2 set d.paymentproductid=d2.paymentproductid where d.orderid=d2.orderid;

# Remove the already refunded transactions
delete from t144489_details where orderid in ('9448589551','821897420','9435103601','307928929','5490476483','630520923','7320050734','6745362076','3647297338');

# Columns formatted for the globalcollect_gateway/scripts/refund.php tool.
create table t144489_refund
    select
        d.orderid as order_id,
        d.merchantreference as merchant_reference,
        d.effortid as effort_id,
        (case paymentproductid
            when 1 then 'visa'
            when 2 then 'amex'
            when 3 then 'mc'
            when 125 then 'jcb'
            when 128 then 'discover'
        end) as payment_submethod,
        d.currencycode as currency_code,
        d.amount/100.0 as amount
    from t144489_details d;

SELECT *
FROM t144489_refund
INTO OUTFILE '/tmp/t144489_refund.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';

... then ready to try running the refund script.