shaharblockaidscientific-rose
    Updated 2025-02-20
    CREATE TEMP TABLE attempts as (WITH transfers as
    (
    SELECT amount, asset, to_account, from_account, block_timestamp, LEDGER_SEQUENCE, transaction_hash
    FROM stellar.core.ez_operations
    WHERE to_account is not null
    AND from_account is not null
    AND block_timestamp > '2025-02-24T11:58:34.000Z'
    )
    -- ,
    -- attempts as (
    SELECT new_transfers.transaction_hash as new_tx, old_transfers.transaction_hash as old_tx,
    new_transfers.from_account as scam_address,
    new_transfers.to_account as victim_address,
    new_transfers.block_timestamp as scam_block_timestamp,
    new_transfers.amount as new_amount, old_transfers.amount as old_amount
    FROM
    transfers as old_transfers
    JOIN
    transfers as new_transfers
    WHERE old_transfers.from_account = new_transfers.to_account
    AND old_transfers.to_account != new_transfers.from_account
    AND old_transfers.block_timestamp < new_transfers.block_timestamp
    AND LEFT(old_transfers.to_account, 4) = LEFT(new_transfers.from_account, 4)
    AND RIGHT(old_transfers.to_account, 4) = RIGHT(new_transfers.from_account, 4)
    )

    SELECT * FROM attempts JOIN transfers AS new_transfer
    ON new_transfer.to_account = attempts.scam_address
    AND new_transfer.from_account = attempts.victim_address
    AND new_transfer.block_timestamp > attempts.scam_block_timestamp






    Last run: 26 days ago
    No Data to Display
    0
    2B
    1139s