with
main as (
select
block_id,
transition_id,
f.value['value'] as user
from
aleo.core.fact_transitions
join
lateral flatten(input => inputs) f
where
f.value['value'] ilike 'aleo%'
and block_id = 2401524
)
select
distinct
block_id,
transition_id,
user,
from
main
order by user