FROM thorchain.core.fact_bond_events AS reftable INNER JOIN thorchain.core.dim_block

ON reftable.dim_block_id = dim_block.dim_block_id

WHERE bond_type = 'bond_returned'

AND tx_id <> '0000000000000000000000000000000000000000000000000000000000000000'

--Not automatic node operator payout.

AND asset_e8 <> 0

-- No coins in the message ('e8' is the amount returned.)

ORDER BY block_id DESC