-- Note "refund" events in block results, e.g.
-- https://midgard.ninerealms.com/v2/debug/block/8819298
SELECT fact_refund_events.block_timestamp,
block_id,
tx_Id,
from_address,
POWER(10,-8) * asset_e8 AS asset_amount,
TO_CHAR(SPLIT(asset, '-')[0]) AS asset,
memo, reason
FROM thorchain.core.fact_refund_events INNER JOIN thorchain.core.dim_block ON fact_refund_events.dim_block_id = dim_block.dim_block_id
WHERE reason LIKE '%insufficient funds for outbound request%'
ORDER BY block_id DESC