Query editor
WITHbsc_holograph_protocol_transactions AS (SELECTtx_hash AS tx,COUNT(index) AS idFROMbnb.logsWHEREblock_time >= TIMESTAMP '2023-01-01 00:00:00'AND block_time < TIMESTAMP '2024-01-01 00:00:00'AND (contract_address IN (SELECT contract_address FROM query_2358000) -- Binance Smart Chain - deployed holographable contractsOR contract_address IN (SELECT contract_address FROM query_2357917) -- Holograph Protocol contract addresses)GROUP BYtx_hash)SELECTCOUNT(bsc_holograph_protocol_transactions.tx) AS total_transactionsFROMbsc_holograph_protocol_transactions