SELECT -- block_timestamp,
-- DISTINCT
DISTINCT event_inputs :account :: string as account,
--event_inputs :tx_id :: string as tx_id
event_inputs :userClaim :: string / pow(10, 18) as tokens_airdropped
from
ethereum.events_emitted
--INNER JOIN thorchain.liquidity_actions
--ON ethereum.events_emitted.tx_from_address = thorchain.liquidity_actions.from_address
RIGHT JOIN thorchain.outbound_events
ON ethereum.events_emitted.tx_from_address = thorchain.outbound_events.from_address
where tx_to_address = '0x8526cec1d97a68c0e69420488d04dec5f101b46e'
and event_name = 'Claimed'
and event_removed = FALSE