AephiaRQ - Mining Fleets
    Updated 4 hours ago
    /*
    SELECT
    instruction:accounts[0] as wallet
    ,instruction:accounts[1] as player_profile
    ,instruction:accounts[3] as mining_fleet

    FROM solana.core.fact_events
    WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'
    AND instruction:accounts[4] = 'GAMEzqJehF8yAnKiTARUuhZMvLvkZVAsCVri5vSfemLr'
    AND instruction:accounts[18] = 'MineMBxARiRdMh7s1wdStSK4Ns3YfnLjBfvF5ZCnzuw'
    AND succeeded = 'true'
    AND block_timestamp > current_date-30 AND block_timestamp < current_date
    GROUP BY 1,2,3
    */

    --/*
    SELECT
    player_profile
    ,wallet
    ,mining_fleets as mining_fleet

    FROM SOLANA.SA.MINING_FLEETS
    GROUP BY 1,2,3
    --*/

    Last run: about 4 hours ago
    PLAYER_PROFILE
    WALLET
    MINING_FLEET
    1
    HckvThzaqE2dGMgL7QMZpvijzNEqXvCwc1LuRbUVaynuFYTsQyRbTSYJpDB5jc6eZ8eexeDbT53SiQQReVwEbZ4s4HppwmmW32BFF5BxzCwcv8tRHSCGE9FRPTLwrfkGBrA6
    2
    Dp16VzKVBCC6mrmCw2kCBQqKyys9BMW7GCVkvVcWcMDKHMhdC7oTUeZw6Vu77N2QgYd2JpYrZUGH2qpEh25MHpPL3eZpBdw5iLY4CffgodSMB9MKvqys3oVbPunc5hN1DVjX
    3
    4QDFnMLvnUexEEvu3C3aGrFoY4nhjET9YvFHoLXVmZC2G7rCtW3n8LMNvA7i6y4Lmknc14xK5TQWNdz7y5zHDi4sDkSxQp56Xpnzig6TwLTKrjEP3R4Vqrbzd2sn2TjDPEYx
    4
    Hwhs5RU7SLUpeJPZwiYh9mbtPo1VRauJTJhKz2fb6yBhGrLHtGvVkyxCreFKFM4S4ZmHapLLSygMHqUtZmgL7rxHCaCAM6UiC14dPhyha3vDAYKeTr1EJ2cvDwYsf1ZmDYxi
    5
    FXtyF3qvDDGq4NrTW4AMudw7s9X3kRUxoTTYfsA5D6HB8fvJhm5p7QQFLRofFHeT1bjNDa8FppZZwLkb6MR257CpGk7deM7EFPunfsZWDK5WtR2JicpZPF9CwEWK3FkWE3WZ
    6
    EUQeqr35qZHURrhpobZyApQ2t67aq2C3THv7ZB6TjCoM6FpG4MeQQSKtWuBSgrytkP5N6ucSC6zEg53MnAZf4s3t9WAmZdTMdkNSW69UWPTcPpcDVfz28JLcM1yLDeHgDoa2
    7
    E3fTz863unZTvBP8qs168kP5jdqcMiwdU6gxLJxQMj3P4rbaxwc3NfEpqZXETGaNo3obaAsqzNziicLVNSffT2aV64dF6y18HKtCghBk1ouDv6nFd7TtCViLtr1bsShZurxL
    8
    DEkj6TfW88WyrirEByqFTsoXfUfAcEnRsriQY7NEegAn2p7zX5VA4QfsBkhxkFujhe99RenBhdRS1ocu5mzNJtwG2SLpMhjxNmaeTeUrTQjdzDMAmKdE7BtRRwc548N8RwGr
    9
    3Z5MwAbpw9cX8g1iXLD8iAyo4pYyX9FipzhKdSVepuv79zGseuC3VELAsyGrH4UX6Ho4bc9DHjT3tno8kNjAdqhc2CzRpypamXKTKGBTegQdGyZzFSojfqBcbqAP5pVrMhNn
    10
    8zH76X5gHQGtYWVuyrqV55wEjeyXnB6wwTeNvXxSkkBg8DvdfCwuBgWe5n35wuZch6RSYeixQWWAEbBXPokACDZF684FjjARDUXc6h8mGG3qrsJTka6fR2qLiCFggorhXQyo
    11
    E6EU9kmsFS1JHzY4AqXeQDMRAFjcgPAk4T6TBPYnHGZjAr43BrdPMfxmiQvk5v18KZr2uAD1jEtQQ7AGFxqhcbdG57mbKH2JBXodXnoDJFuEV1fQwpSzAfk7iw21HBZZE4AY
    12
    HUmgEebQnh7CDVByo4Vz85JUHXw4ashNcjGmfe3tPzmm9Am7uMJdMysZ9vfp4Jq51ZG9k3EWWhnYuT5f21343N87GYUkMFLxZCXVSg6fzyK6Z2oQC5FJt16t35eErJtpnHYu
    13
    AJ2snfS7NfLDJtiBfvG9Kodi51X17rvYx4t6H4MoSTydXiqZzgdK3Q44PyCVVZEaDgzwonroEvsEGMCpdyxHLKqGUwrBvsNbTHZD1ADxQVAMLCfc25aPLFcXvB8qq47qtud
    14
    HHT12Pj8gEZQa7wkfKJscFctWHLki2E84X6w9o1BDa7tHiNLuzCtrQ3L3fpAGDVvmveirUr9NrfeSBVpk6q1wu6iHeyeyAhtaD8gv7PTLHmCq84sdrReeYRUVS5x2Lr4HZmf
    15
    9RHZYBrhHr2GnwBHdjtMnzySDvQpUCLyM9ASrh5Du6mx5j4h2pSocNRNFDe8x8vSGXw4GqcyRPosS2UTom7rYzXqG76NamEvABf8BNHQKrSA5fDJfFTGTCzHYFptEfCTqFj8
    16
    8WBtJ19Nu5QxB9zvL5wh9GM3jKdSKHt533AHzTGx6v48AFFxj6pKBYwQqvi9T578WV2WsJduybmJBqQ78qqb629DPXaT2Fbcq3nARSeRj4q2pzRXgfhSyJ6VuXVpKhSdB1e
    17
    6uhS13txSQsVYJgPiUdk3HW5unoGhf4ZQW1UFDDX6LzEDv3dWayp4aSLjHq73THenXVFRFShXNCt8wc2xPumPw8ZDgK2euyRXASE5eyNMbZhkaZfitQdXst1UVzAbHHRg42c
    18
    4izccJWvLaJ1zccuz7ZCdwKGN9E9EpMej4kLAgkZd13BBzE7THXaYQNbywwk1zhEeUfhxZ3iVc2fvU7wkD6mRdRcC1h3GrauDAUMn4VBda8Eu2xTkhts7qz7oEkJPFSActxj
    19
    6c9tMmEWRzzC7b9jnKT4VQT8sycxQE7PXyBiGTNG1VLS4Romg1Cf7fY1rUnRiBEUZ3iFcq2DXbRVnvqdrT4JFsf3Cc956khPYGWgBTjXjggQmsGdk6uPkse4subDG5wJcqfQ
    20
    e31MkxbQAmMTq1tGfXSWWJhUHdt7ip6fRNVUK8Jf22eBgHVxDMmQz2hH4LzDuDbnz5Rw22m3PDgkjjiviPVfdEPEpzcmY9YeA7vZYKP8jhLVH5m8wDWLbWYYHs1vNx1HHeN
    ...
    7074
    987KB
    2s