SELECT 
    c.receive_date,
    c.id,
    c.contact_id,
    t2.contribution_id AS matched_contribution_id,
    gift.channel,
    x.gateway,
    c.invoice_id,
    c.trxn_id
FROM civicrm_value_1_gift_data_7 gift
INNER JOIN civicrm_contribution c 
    ON c.id = gift.entity_id
LEFT JOIN civicrm.wmf_contribution_extra x 
    ON c.id = x.entity_id
LEFT JOIN civicrm_contribution_tracking t 
    ON t.contribution_id = c.id
LEFT JOIN civicrm_contribution_tracking t2
    ON t2.id = CAST(SUBSTRING_INDEX(c.invoice_id, '.', 1) AS UNSIGNED)
    AND c.invoice_id REGEXP '^[0-9]+(\\.|$)'
WHERE 
    c.trxn_id IS NOT NULL
    AND t.id IS NULL
    AND c.trxn_id NOT LIKE 'bene%'
    AND c.trxn_id NOT LIKE 'engag%'
    AND c.trxn_id NOT LIKE 'recur%'
    AND c.trxn_id NOT LIKE 'fidel%'
    AND c.trxn_id NOT LIKE 'match%'
    AND c.trxn_id NOT LIKE 'rfd%'
    AND c.trxn_id NOT LIKE 'ADYEN Transaction Fees%'
    AND (x.gateway IS NULL OR x.gateway NOT LIKE 'enga%')
    AND (gift.channel IS NULL OR gift.channel NOT IN ('Other Offline', 'Recurring Gift'))
ORDER BY c.id DESC
LIMIT 10;