# Dataflow SQL Query

### Requester

select t.id as task_id,
t.request_type,
t.symbol_type,
t.oracle_script_id,
t.created_at as task_created_at,
tx.”timestamp” as bandchain_tx_resolved_at,
tx.tx_hash as bandchain_tx_hash,
tx.status as bandchain_status,
tx.tx_fee as bandchain_tx_fee,
tx.ds_fee as bandchain_ds_fee,
tx.request_id as request_id
from task t
inner join tx on t.id = tx.task_id
where t.id > 5388087 // Set filter condition here
order by t.id desc;

### Relayer

select astar_rd.request_id as request_id,
astar_rd.symbol as symbol,
astar_rd.tx_hash as target_chain_tx_hash,
astar_rt.created_at as target_chain_created_at,
astar_rt.gas_used as target_chain_gas_used,
astar_rt.gas_price as target_chain_gas_price,
astar_rt.”status” as target_chain_resolve_status,
astar_rd.resolved_time as target_chain_resolve_time
from mainnet_target.astar_relay_data astar_rd
inner join mainnet_target.astar_relay_tx astar_rt on astar_rd.tx_hash = astar_rt.tx_hash
where astar_rd.request_id > 8765042 // Set filter condition here
order by astar_rd.request_id desc;

Require to query from all relayer tables i.e. one for each chain