select all tx where operator id =xxx and contains any xfer (hbar or ft) where withdrawal is from account yyyy since date zzz

demo1.graphql

#https://discord.com/channels/1011406343053254707/1283157792626311281/1334129547582505000
query TransfersQuery($verifierId: bigint, $subjectId: bigint, $fromConsensusTime: bigint) {
  hbarTransfers: crypto_transfer(
    where: {
      entity_id: { _eq: $subjectId }
      amount: { _lt: 0 }
      transaction: { payer_account_id: { _eq: $verifierId }, consensus_timestamp: { _gte: $fromConsensusTime } }
    }
    order_by: { transaction: { consensus_timestamp: desc } }
  ) {
    entity_id
    amount
    consensus_timestamp
    transaction {
      transaction_hash
      payer_account_id
    }
  }

  tokenTransfers: token_transfer(
    where: {
      account_id: { _eq: $subjectId }
      amount: { _lt: 0 }
      transaction: { payer_account_id: { _eq: $verifierId }, consensus_timestamp: { _gte: $fromConsensusTime } }
    }
    order_by: { transaction: { consensus_timestamp: desc } }
  ) {
    account_id
    amount
    token_id
    consensus_timestamp
    transaction {
      transaction_hash
      payer_account_id
    }
  }
}

backlink https://discord.com/channels/1011406343053254707/1283157792626311281/1334129547582505000

try it at https://dashboard.hgraph.com/playground

example data

{
  "verifierId": 26027,
  "subjectId": 24739,
  "fromConsensusTime": 0
}