---

-- ==========================================================
--        UNIVERSAL USDT SEARCH (EVM + TRON + SOLANA)
-- ==========================================================

WITH params AS (
    SELECT
        TIMESTAMP '2026-09-12 00:00:01 UTC' AS start_time,
        TIMESTAMP '2026-09-14 07:00:00 UTC' AS end_time,
        'USDT' AS token_symbol,
        74579.65 AS min_amount,
        74579.67 AS max_amount
)

--------------------------------------------------------------
-- EVM (Ethereum, BNB, Base, Arbitrum, Polygon, Optimism...)
--------------------------------------------------------------

SELECT
    blockchain,
    block_time,
    to_hex(tx_hash) AS tx_hash,
    to_hex("from") AS from_address,
    to_hex("to") AS to_address,
    symbol,
    amount,
    amount_usd
FROM tokens_evm.transfers, params
WHERE symbol = token_symbol
AND block_time BETWEEN start_time AND end_time
AND amount BETWEEN min_amount AND max_amount

UNION ALL

--------------------------------------------------------------
-- TRON
--------------------------------------------------------------

SELECT
    blockchain,
    block_time,
    tx_hash_varchar AS tx_hash,
    from_varchar AS from_address,
    to_varchar AS to_address,
    symbol,
    amount,
    amount_usd
FROM tokens_tron.transfers, params
WHERE symbol = token_symbol
AND block_time BETWEEN start_time AND end_time
AND amount BETWEEN min_amount AND max_amount

UNION ALL

--------------------------------------------------------------
-- SOLANA
--------------------------------------------------------------

SELECT
    'solana' AS blockchain,
    block_time,
    tx_id AS tx_hash,
    from_owner AS from_address,
    to_owner AS to_address,
    symbol,
    amount_display AS amount,
    amount_usd
FROM tokens_solana.transfers, params
WHERE symbol = token_symbol
AND block_time BETWEEN start_time AND end_time
AND amount_display BETWEEN min_amount AND max_amount

ORDER BY block_time
LIMIT 500;