Query editor
with eligiblet as (selectuser as eligible,allocated_tokensfrom query_5738234),claimt as (selectdistinct "to" as claimer,sum(amount) as claimedfrom tokens_linea.transferswhere contract_address = 0x1789e0043623282D5DCc7F213d703C6D8BAfBB04and "from" in (0x5ff137d4b0fdcd49dca30c7cf57e578a026d2789,0x87baa1694381ae3ecae2660d97fe60404080eb64,0xc2843ef84545e5ed7e5d4903e8347f5222960ade)group by 1order by 2 desc/*selectdistinct "tx_from" as claimer,sum(varbinary_to_int256(data)/1e18) as claimedfrom linea.logsWHERE contract_address = 0x87baa1694381ae3ecae2660d97fe60404080eb64and topic0 = 0xd8138f8a3f377c5259ca548e70e4c2de94f129f5a11036a15b69513cba2b426agroup by 1order by 2 desc*/),balancet as (select *from(selectdistinct user as holder,sum(am) as balancefrom(select"from" as user,tx_hash,block_time,symbol,-1 * amount as amfrom tokens_linea.transferswhere contract_address = 0x1789e0043623282D5DCc7F213d703C6D8BAfBB04unionselect"to" as user,tx_hash,block_time,symbol,amount as amfrom tokens_linea.transferswhere contract_address = 0x1789e0043623282D5DCc7F213d703C6D8BAfBB04)group by 1)where balance > 0order by 2 desc),cext as (