CASE

WHEN split_part(MEMO, ':', 5) != '' THEN split_part(MEMO, ':', 5)

WHEN (

MEMO LIKE '%::0'

AND MEMO NOT LIKE '+%'

) THEN 'te-ios'

ELSE NULL

END AS AFFILIATE_ADDRESS,

TX_ID

thorchain.defi.fact_refund_events

AFFILIATE_ADDRESS != ''

AND (REASON LIKE '%fail to refund%');