headitmanagerHave these top wallets added to their locked SBR
    Updated 2022-03-08
    with temp as (select count(*) as tcount ,inner_instruction:instructions[0]:parsed:info:destination as wallet
    from solana.events
    inner join solana.transactions
    on solana.transactions.tx_id=solana.events.tx_id
    where program_id ='LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw'
    and (pre_mint ='Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1' or post_mint='Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1')
    and date(solana.transactions.block_timestamp) >= '2022-02-01'
    and date(solana.transactions.block_timestamp) <= '2022-02-28'
    and wallet in (
    'Gb3Hi2csYA7i4Z1aBqycdqA3aCU1L3mjFrDqKwUAV3JE',
    '7qNEu6dQqgiHijriC987jMhgoctiJmXa9hStfWYQVk11',
    'AD1V7SkazkCwe6Jgp8ZujhNGoeiLsYDkDoXnxgZqXJPV',
    '8CAiyN76TSezexNp3pqZNNca2sP3shqj1qsFF3xspcCM',
    'DN15LBU1n97t9B4LGYY988AfnHt3k2fAC3Uo3VFni2jT',
    'C3skDAmVx8yQiQCkTPexW8VkgHg5okUb2ng2VD2ntUug',
    'J3e2SujZKyCVLCoY3QgyCtjvUDKXSwBMLcyQsuZhy6my',
    '2FjabrUJ8tryW3n8wqohdm22s5uxU3dMoXKbsTR95vsE',
    'DyDVe9Wbj9BnMA73bUcscMsxi46NtkAonBBydoxDBzPP',
    '39C1bzrPpATawf96qbjQDnNEPbzcJr4mCw7UKVmJ75dq',
    '9G7cdDbJHmMjh4aMKtoHe5WJ3xYWQFKWY5ywvBDQsVT4',
    '6xE4VV76QpQphFwPEsQy9ddsm6a4WSYhVaq4MfVE39C3',
    '5vNZ1Ae68puDt6vcMcwFrXFq281pNffAASHXiL1iwaCg',
    'A9LfseEGPdBkeD1qvkNqRnSfPo1oYWj9kvEPYZyZzjM2',
    '4CBpmjDDuo1xDoT8BXjDUqGkEViQUDwjkoMZPfRWNtkV',
    '7wwsW6GpoQciPUNzaV7Prf4CjAogPV2oSAqzYkgBTMVS',
    'GymvfokQjHp4hmhiXdQgYnAv3qMPATeNNsJchWhTAS9d',
    '4ggsc2fs6kyv4WsrEZ5nQQUCdSNTDPeZ4dEznNSDXT23',
    'HXtoYeaXPGrU56ojZXVBXjQpMzbfx5ZVpei9A4ijLzNX',
    '123t1P1D96U1Lv1QKgVN8tx3Sunky87sbWxeNsZwQv7p')
    group by wallet

    )

    select * from temp


    Run a query to Download Data