Snipermanaging-violet
Updated 2025-03-30
9
1
2
3
4
5
›
⌄
select ADDRESS,ADDRESS_NAME,LABEL,LABEL_SUBTYPE from ronin.core.fact_event_logs a left outer join ronin.core.dim_labels b
on a.contract_address= b.address
where LABEL_TYPE = 'games'
and address in ('0x32950db2a7164ae833121501c797d79e7b79d74c','0x9d3936dbd9a794ee31ef9f13814233d435bd806c')
group by 1,2,3,4
QueryRunArchived: QueryRun has been archived