With dac_reg as ( Select DISTINCT signers[0] as wallet, CASE /* WHEN tx_to = 'Gxfmp3UQaMn2w5p7t594V2LWjG6yuzBK6ggvtKafXtop' THEN 'Quimera' WHEN tx_to = 'DVNcVE55LZny5dBUmV7yGb4xejXvhANdwAUuuMHf1iY7' THEN 'Aephia' WHEN tx_to = 'AkjrZ2wWaP1aqJHSTPcpZsX8QVSQGNSJk9kQPF6TfCTZ' THEN 'The Club' WHEN tx_to = '7FwVcbDZfQNDSEqTzkggUyGSoQb2nEgTBXZSDFiF1ab4' THEN 'Rome' WHEN tx_to = 'BiEoXzZ3omnBRtZQvFWZgDVf2b971FfsGrTVMt6FitHo' THEN 'SAI' WHEN tx_to = 'Etvz2TJx4EjELwP4biXyy4996GXefnsW6YQ1W6in3e2K' THEN 'COEXIST' WHEN tx_to = 'G9knehu73MdtexUN9oQ5RZ6knhdQoFU1uB7qZdth3Mrw' THEN 'The Unseen' WHEN tx_to = '54mp37xZzccVxrZZhax7bzfnmKU8u518MXT4MM7p9jsP' THEN 'la mesa redonda' WHEN tx_to = 'BXDsRM88dGTiG8w8W9S5Skvau4b9n288b6wvBHkydXPT' THEN 'heimdall industries' WHEN tx_to = '2CCuCvtQSTjwu6uezcaFAZY4oUPDdo8TTxgjURrUrwpw' THEN 'polaris fuel' WHEN tx_to = 'Bc9LYXunECxJUwpoUnoqSSNgmQGcN7Vo1F69uMF3NEHr' THEN 'regnum stellarum' WHEN tx_to = 'Gy8RCP4WNUnNfbf14xrmpnp91eHgrK11Jx1oN2ieToUy' THEN 'ec-espaco continuo' WHEN tx_to = 'HknTZVKYqTif8HAYqSwQGNbf5eeBbpSB4GefBhmxDLof' THEN 'nft italia' WHEN tx_to = 'A76sRd1CZCYMiA6PxKXacB3CgGktRvegALmfFAkw3UBG' THEN 'skull and bones' WHEN tx_to = 'D6phF7VQfukJFUEi13UjcRRhPPc9fP4gz7KZqHTJ8LXP' THEN 'bulk' WHEN tx_to = 'JBXZM9ZtX2ndsFZzwxCRRFrVdzfXkQvWaRNZdegvtyPG' THEN 'the bounty bar' WHEN tx_to = '6S49UP2ocwsQrt8UqFPAoeEWXjYKchbXYMktyQjpK3N4' THEN 'colibri espacial' WHEN tx_to = 'DyPMsFYJbtXtnuSjLDgTEzwXRTaMdTEQPzvw1tcioXFd' THEN 'solaris' WHEN tx_to = 'FwGBR1ohJ58grcZpfVp4Mw5nVKXNDvpFh9Z1rPL1gnbT' THEN 'gargantua industries' WHEN tx_to = '2GW4juLBY5JpQxSohTXtPuogFgssuMuwGDwYmoUbRq2A' THEN 'deep profits' WHEN tx_to = '79eDKY9nZEM9wKkPcLyVoGpifoSo8WGFk54yTzUadx8A' THEN 'dark matter' WHEN tx_to = 'CR7WRwunD9EW5SuQJCZDQNsAhoYD34kYYfvf3bDvSa1f' THEN 'hologram news network' WHEN tx_to = '5mfo1gjYabuyCqoMPPvdyvDhwid4cssu8uXXL4UnF6nJ' THEN 'eclypse' WHEN tx_to = 'HveznYBSUCv5Th34yW8C5yrutKRp6RKZSUgnJ1VEJ6dq' THEN 'nebulartv' WHEN tx_to = 'GS9aFd9wEUXEhb2nntr89VNnJ39bRUVXQ6xmYMjGp3HB' THEN 'star atlas germany' WHEN tx_to = 'CmvBgv3hxVGNrVNiuibDcGdnUn4a4hRTMQmUrc3e4iMc' THEN 'project sixqq' WHEN tx_to = 'CDnw43SCGmeoAccvV1ZxrHnmjjkSFWtPwgaMT1VLHZ5y' THEN 'onifire' WHEN tx_to = 'Cok37EEaD1mXVc1vqTFu9RLSj96VEDurZdhbJDAU528m' THEN 'la republica' WHEN tx_to = 'DdSrp1jNAB7WW9cXJoJRdeBVKhy6VJvChcV8DCLFsv8A' THEN 'afsex' WHEN tx_to = 'HzbKLXxc9Nb9RCF6yxbQP8i5jJ7snrv3H2piwcdK37cN' THEN 'syntax' WHEN tx_to = 'B1midyAtkJg1h96CH7EaW1i5Y8LicfjpRBjZwTWUWrKi' THEN 'final frontier' WHEN tx_to = 'F2jFYocCtWCJimHMCBzBV8m84aehFcYdBjbvPxbKLtBv' THEN 'great merchant group' WHEN tx_to = '6Wp9rGBVyrhPmQLsgoAGgRfXYKEkH4epqtrV1W2ZW5kR' THEN 'vorax' WHEN tx_to = 'GkNYLMb3nZJy4sm8xzzMD8gdUUJBifVj7PD1M8Q3zcUA' THEN 'ded' WHEN tx_to = '6WEHYY1AQWmvPYcc8roiACJWVFepDWKDwCMvsMkBvvQg' THEN 'galia merchants' WHEN tx_to = 'A2hNpeFzcN6ZEsQJiak9maWcTbDkTnGFj45ZGTnUdouj' THEN 'interstellar alliance' WHEN tx_to = 'JBzzieSD2VhuSycQhJZJchpU7hHu3HFF5Qz2iKVVGTvh' THEN 'cabe' WHEN tx_to = '61oopV4navB8GNixbNrkcGkHJJofK6c9pWB8EvwuapW1' THEN 'flares' WHEN tx_to = 'H57LZxDbbdxMss2zKBcpvANecRgWapYhdWdDqr4d69H2' THEN 'pioneers' WHEN tx_to = '9jKiT9DKUGLJPuHDBhptpZHNYf31ScNNZTSJVLugoYMK' THEN 'shadow loyal' WHEN tx_to = 'H9u8XrjgcjJ93zjQw8c2KY99zaj2QJ96QUUzLfRbtjaM' THEN 'coconut bandits' WHEN tx_to = '7wY9LvrtmKUJn7crCviGLYMJ9nDegYGtK7Z7dcAFhN8S' THEN 'the hazy tribe' WHEN tx_to = '2mjekqJ49Zc8MuH4Dyc97tRnbncA4r7DFJZDHeQu4qhR' THEN 'nexus' WHEN tx_to = '2xRVKkcokGS9CLZJAEKaomogZrf5xsEc1eZL9TqrF82Z' THEN 'the angry mob' WHEN tx_to = 'DvM4fFqcznfgXVw19KdMvHXMcM19eXEB4GB5U8CMPMPv' THEN 'atlas grace' WHEN tx_to = 'Bu75bsavPDCFQ9htMQaGF8W599opJGSjTb4v1vjiSYDp' THEN 'astrocannaverse' WHEN tx_to = 'AK7ogPQaVEEqCo4Mv26D9hSVpGdb5Grtiijpt5RXmK3w' THEN 'deneme' -- coexist WHEN tx_to = 'ZGdHDnyxT4KAWiPBEvvWrdWsYBsiZwJ2Xr3VAwopaqZ' THEN 'unicorn corp' WHEN tx_to = 'QEQ4eUVgbtbUNy6a8MeB1GDf1Adt72QGYHo6Tw1Bp7u' THEN 'horizon' WHEN tx_to = '4yWoVKxDaTjarxU3nWpvzN73vWYxfXsh78b4BeDFxXYR' THEN 'bounty hunters' WHEN tx_to = '6QXENtH8CZmN5KVC1CNLTv2hQrgQvLANU85u1PSQUmNY' THEN 'megalodon' WHEN tx_to = 'Aw3HA8w1uRUu4ig77M8MPno257EyL8VPZAnahHWxiJk4' THEN 'brazil' WHEN tx_to = '7Vr9xZy94DPfoQev9n4d1r7gNx1CzU8x8e4zyU1BpCc3' THEN 'parsec link' WHEN tx_to = '6QVUvigkumn3e1LHi6K9pVkeX9QHF5cQNPChLKjgVwB2' THEN 'zoe ar' WHEN tx_to = '34rL3rTDfFwmjK7dbZxHVN1hiM47y5ugsE3U88JWYm9t' THEN 'scythe' WHEN tx_to = '6kksSeq7JYxEXPEqrF56A26h9zgVxVJL5Qt1uu1F8BAy' THEN 'lords of shadows' WHEN tx_to = 'FB8fkGe1ovMxn5HiPxAB2Bz2Q6L9uqU73pszZHRZkpDN' THEN 'puri' WHEN tx_to = 'AYwgAunGYdTtJqph9wv2eZxqHMMMgBGgVPaaMpPrcDCd' THEN 'leeks' WHEN tx_to = 'PMsmz4xMxwvofni7FaimDvPfNTWFSAVwzoJDQVBkPEg' THEN 'galactic hungary' WHEN tx_to = '9p7uaSNjBDEPxY1g6RGepVnZxWGonBpoN9J6JvAz49D8' THEN 'catain - autonomy alliance' WHEN tx_to = 'ENK2VjXPYUrUFtiG9C89w7763DNL9amVdJU4PjtqQG4g' THEN 'tree' --- WHEN tx_to = 'Csc1pPc2va1wMYBajU8CYDkGRw2S6RLRUAfeMTo7xLdf' THEN 'Hispanic League' WHEN tx_to = 'FNakT4wpcV6ArAg4kTy2R7tV292NP5DWrUs8Wok8NshZ' THEN 'Phoenix DAC -Coex-' */ WHEN tx_to = 'CK1wTfm4kPCYu7edpUrXgJ845Yr9mjVyUGhvzhC3GBYy' THEN ' Navi ' WHEN tx_to = 'Csc1pPc2va1wMYBajU8CYDkGRw2S6RLRUAfeMTo7xLdf' THEN 'Hispanic League' WHEN tx_to = '7fnknWYWVrDAXUvPQsLbW4fmC9utZ5RrU2xPB3JrZp7K' THEN 'Aegis of Satoshi' WHEN tx_to = 'G1YufYKYLhVN3fgiMXXAjDJxmAKfR8hA3YvBCs6MA7nA' THEN 'The Shadow Corporation' WHEN tx_to = 'D3j5Bo8N22iHULd34P6freabgnuiy9Jy8scPNXanaEKF' THEN 'Ninja' WHEN tx_to = 'DJMnEWfQ7bNk7d8CU43DtsGVQkbCuewcCUXHjezcmWey' THEN 'Snowbird' WHEN tx_to = '2mFkPwiKnkjtqztt7kVwfb2PJcpn9sgMNbrYJLmJhYXz' THEN 'CONX' WHEN tx_to = 'BgTGp3CWGyKPknmBtUwe66tv2jRDe3TcEhf4Db9vv3Yq' THEN 'oskie335i' WHEN tx_to = 'AUQJAsyhiq3k12NneQXXyPe8mxxrHRLV5m1W3vMUW92T' THEN 'Fede91Roma' WHEN tx_to = '3d2aUUMhdbxhTxkzyzoHs8DztzSMowp2iG84XD7uWS5Q' THEN 'SIRIUS DAC' WHEN tx_to = '44EzM9pWSMUQpb8pufbo7X6DcCcJi2RgxrVpwAaPMRMC' THEN 'TIRRYARMY' WHEN tx_to = '2xRVKkcokGS9CLZJAEKaomogZrf5xsEc1eZL9TqrF82Z' THEN 'THE ANGRY MOB' WHEN tx_to = 'A4j7RLCifVAzzwX3wKoLfDeF2f8qtwBjybTsCx6B49tB' THEN 'spring' WHEN tx_to = 'HLFBVJFxueAJ8VK8yTqoWzSWCsAeJ8zoCe6Y6X8MZPPR' THEN 'CCCP' WHEN tx_to = 'D1pMZRH7uaxapLaCFQE85t9HzDwQs2qifxarw8aqy7jS' THEN 'rotanevJK' WHEN tx_to = 'PMsmz4xMxwvofni7FaimDvPfNTWFSAVwzoJDQVBkPEg' THEN 'GALACTIC HUNGARY' WHEN tx_to = 'BUQnQ26bEWj2ao7DMj2JsAGwXtC2zYFsDJR4e3qJeRh1' THEN '303 Lotnictwo Polskie' WHEN tx_to = 'ZGdHDnyxT4KAWiPBEvvWrdWsYBsiZwJ2Xr3VAwopaqZ' THEN 'Unicorn Corp' WHEN tx_to = '4VVhjKMbm6C9ZjbmsakuH78VQRWpuTo19aR11NeE1zeS' THEN 'Brazilian Mango' WHEN tx_to = 'F2wdZug3z9i6vm4SkGuZxfCa4SxfydBE1RmZfirBD1Uq' THEN 'Hossein' WHEN tx_to = '9WbXUuLKFtRamqr9E3DXZUUvyEcULV24puBvJQU23PWd' THEN 'vebster' WHEN tx_to = 'A2hNpeFzcN6ZEsQJiak9maWcTbDkTnGFj45ZGTnUdouj' THEN 'Interstellar Alliance' WHEN tx_to = 'DpyAif6tEjt8iPC7AiXwtJQQ1pBcoyoKSszchpEy6Aqp' THEN 'Of the 9 Hostages' WHEN tx_to = 'Bcti2A6dnwaTYMKdsJ45yTuv5bPGm91fBM1T52XXuTHY' THEN 'SFOTU' WHEN tx_to = '8QTM7gp718uJu73W75Ky3etd54oEMvW8kvxbcQzfdzeB' THEN 'FeredeBoys' WHEN tx_to = 'FymbSeko7YY9tb96mNgZaTQUhPktWUrCxWJt9CAB3A7k' THEN 'Crushridge' WHEN tx_to = '925q4p62L5gGpSXHdbRvfqc8owW2UAbmoaQKiSfaVojq' THEN 'SPAIN' WHEN tx_to = 'GgY1BiuEfj6GUReN72YgBaTPuzgcFBn896g6hHQyda7M' THEN 'The Sith Order' WHEN tx_to = '7xPUvjUmNC3pQ7FZkqRVmBsX8oJsiHaeN4SQiHTtBSN' THEN 'Galia Crafters' WHEN tx_to = 'GViEDDvDQUnU17CVSFQp1cPhdQ9qzmysqJ2qkASvewdy' THEN 'Moonway' WHEN tx_to = 'H6u13nnxfpdtbLHqzxzHUw4Gi5XfQEqr6hG7fk81Tq9o' THEN 'dek4' WHEN tx_to = '5QujbCymzuXmGhbzwQbjpzhkJ73qveN2TFvbD9DiVu7C' THEN 'Star Atlas' WHEN tx_to = 'KDqpMbj9zQwiXJsEgx7bsPGhn9MXuHfDkgVWNWNQbeB' THEN 'CaoS' WHEN tx_to = '3raGJ8mEWzcXZtn3PsRadoc2sV8VeJhkxbpTWxMsR18Q' THEN 'CLOUDCORPS' WHEN tx_to = '9p7uaSNjBDEPxY1g6RGepVnZxWGonBpoN9J6JvAz49D8' THEN 'CATain - Autonomy Alliance' WHEN tx_to = '5PXTFFwxryfSiKQFK6GetpdFLPgZuwnoLGKSViN9r3m3' THEN 'H2RL' WHEN tx_to = 'DMF4LEHQbzvbiG4P1XzDjnt8aJKLrPt1jfLqWMy5f3pU' THEN 'Dragon Corp' WHEN tx_to = 'DT2Uw3j4ZT84iAgK2dCvBmYVSWVLKn2aULC7QbRSgwNB' THEN 'Star Atlas Citizen' WHEN tx_to = '5XKi3ojdWSdgBWeDq1ekXKyoutmXGP6Q6VxrCQ7kMecn' THEN 'Astro Syndicate' WHEN tx_to = '7itxPc2MJTxu5BzzQUKmHmaZ8eDQncHbJj5xe9xGqitR' THEN 'DreamMaker' WHEN tx_to = '2hn66vMTT697wUEKTe1wEmfZ3j6gJvorDeVJj4xEPANK' THEN 'Daglord' WHEN tx_to = '54mp37xZzccVxrZZhax7bzfnmKU8u518MXT4MM7p9jsP' THEN 'LA MESA REDONDA' WHEN tx_to = '9pECRxaCmoeJSvNxjNkNSvmRNJNdzqPiqukJh3XkZVDX' THEN 'XBorg' WHEN tx_to = 'EyZPhF5xAcXX81p5LSwqmqSN1SNsqaK1kB1gggH7kKev' THEN 'Metaverse Adventures' WHEN tx_to = 'Bgjfg4vX7UF4uWN1peSdrQHD63f26vyV1m9yqWrYz7vJ' THEN 'AregonBG' WHEN tx_to = 'CS87GScXPhHcg93tehtghtnCoX5xkkrrd3jxJWhgWrfH' THEN 'Sky City' WHEN tx_to = 'Hjsz5MDmopBzsbza1CPoVwvAxDr5wDETE9qVFksm1Who' THEN '13Nobody' WHEN tx_to = '6ckaiFiM626xseugyxC3W7bjtPND6FQQhdeQZNawSXLh' THEN 'Faces da Morte' WHEN tx_to = 'AgVZcjP1z3MrYW8gyW7NTxtxMZ86c3FxcPSgnZD8PU12' THEN 'Star Atlas Brasil' WHEN tx_to = '2BvnMyGyicqAC4Qtj58W5SSVbmhiYrePH7fvgKp57maZ' THEN 'UA' WHEN tx_to = '7XCh5Mv9JzK8iZpVGVcB77jDiG8WJDXrS7WpfVyRX3Zh' THEN 'MYRMIDON' WHEN tx_to = '7r2rUCF63RqkF75CJPxTakze861vqyKzyVBKwjdGT6i3' THEN 'Bobs Boat' WHEN tx_to = 'HyADg5n3LNfKrjr3BcU6DpTdaJshkWkPrgf56zR6PPP4' THEN 'Melif24' WHEN tx_to = 'EMjZHBjhfsw9AjLmRvBwMgGhg9rRnVdAJAfLw17Cyroi' THEN 'Space dragon' WHEN tx_to = 'EdoKfAoqHsZk6KnVmmhx22ex78pSGEiQ3yLPc2pHm7w4' THEN 'Shrimps' WHEN tx_to = 'DW5mixrJgjwvn6MEMfk57AfiZjWcEDJkXmfoKs7Mqx2r' THEN 'WINTERRACE' WHEN tx_to = '4yWoVKxDaTjarxU3nWpvzN73vWYxfXsh78b4BeDFxXYR' THEN 'Bounty Hunters' WHEN tx_to = '8wqbMHn2HU9PBdzSX7iavFAdJDQD5bjgv37zC9iRNU66' THEN 'Crypto420' WHEN tx_to = 'CGYUMSgztogwNCxtSUvK7cq4ikz9m7RQV3TN5s6zyHXG' THEN 'THE MERCENARIES' WHEN tx_to = '7zP6HkoZjT6j5AXzU4p62XF8i84EaMTCwvsXJFg7usxy' THEN 'ASGARD' WHEN tx_to = '6QXENtH8CZmN5KVC1CNLTv2hQrgQvLANU85u1PSQUmNY' THEN 'MEGALODON' WHEN tx_to = '2yk2cq2xRU9PKoSRyBsA3r5T5yr224njCNxpUFoGYVFC' THEN 'WWWWWWWWWWWWWWWWWWWWWWWWWWWWWW' WHEN tx_to = '3QPphb2bgruhusBHptjzBjbBeh51Rn3VoX1mqg7oAFJU' THEN 'Cyclops' WHEN tx_to = 'DFVboWLHDcmvvddoiHt5CNRUnzitxqkDG6xebsKkYp4i' THEN 'EBKAVENGERS' WHEN tx_to = '8Cj3u3mMJ1iZWAsnEsDjAeN3fhMQ9qeQ1JzHU3E5Ta17' THEN 'EGGCAR' WHEN tx_to = 'FfyzAM1rEaXBmxfmNdndL4zFSVtMCsVeXF2wt87zWs6o' THEN 'Almodovar' WHEN tx_to = 'CVzSmPxCn35VpX6sAcDDUg7U37Sm8axD6VfEREMADbtc' THEN '3DAM4ALL' WHEN tx_to = 'Etvz2TJx4EjELwP4biXyy4996GXefnsW6YQ1W6in3e2K' THEN 'COEXIST' WHEN tx_to = 'GPHns7Dz1DmDC1zWcCgjNActDgZ4A2E7BHKZs97VNtSR' THEN 'WEB3TOGALAXY' WHEN tx_to = 'EZvL84RYyW9WVFtGf89KLPw3h3meYpB5L5wQsxP857xT' THEN 'Metaverse Adventures YT' WHEN tx_to = 'BZZQ6f7SbbJ62ZuJ9xA8hJZtgFjMb7NkGkT8f5dnPR78' THEN 'AEP Life Forms - ALF' WHEN tx_to = 'CWyWoiTCWEc2AEaBdw61qfCvctuCsYHKvCSTmyMbrXCu' THEN 'Yagobah Industries' WHEN tx_to = 'DgyhatVENAFxjwn2UcQnkbxyosTExdAAfKxez7etLGNe' THEN 'KS88' WHEN tx_to = '3i1fYxSwJEKM91DB5LFw8XJREeWAeDKxkLzJqBGvdMZw' THEN 'Epsilon Alpha' WHEN tx_to = '4Qgy3LKWXqY3bbR4P6SLUCrRqKH9vj4jebooc7cWmSET' THEN 'The Empire' WHEN tx_to = 'Gy8RCP4WNUnNfbf14xrmpnp91eHgrK11Jx1oN2ieToUy' THEN 'EC - Espaco Continuo' WHEN tx_to = 'E7PQPfM51C7jK2ChyV7BoMiwWWNMEnpy2vXmuAFpMZYC' THEN 'Mercantile ' WHEN tx_to = '5oUKgJ5XLtYJ5VzVo7PFYbh7XBGvNxQAMDfUBAxTC1gK' THEN 'GALACTICTROOPS' WHEN tx_to = 'Am5hVwEqapKttCUA5QhBGdA22DaQEvSKuf9yanmZLwgy' THEN 'Ash Enterprises' WHEN tx_to = 'DhhwvaZxyMv8qECykEMsEFehGKKdm8iwaRGLVEaWZrSG' THEN 'MarVeL' WHEN tx_to = 'Ced6uKiL1xY8yFD6XkD4z9S3Q22YKM6NSTmGMC5AB4Ax' THEN 'independence' WHEN tx_to = 'Axr3iKu7SnfixQjVXN596v6P3rKPVZ8a7A4aEcf43mQd' THEN 'RANYANAN' WHEN tx_to = '7wEy9vFasFsMuihJM12m2h3uqXYqJk5KGgtRcijVjYn3' THEN 'Le Vagicien' WHEN tx_to = 'J72tQV5WYg91kUxWxKUMGkZ2eMvF8BzsPWZo6ubFGRao' THEN 'COVENANTS' WHEN tx_to = 'AMkgHA4zxDyB5Sf3uCV5MQzAzSNVZYZtQVMVLN5BdZpv' THEN 'Sheikh777' WHEN tx_to = '2jD9EkZR1bALQXwrgWpriHbXsrdnNLwdFVgtQWwvPc1s' THEN 'Tester' WHEN tx_to = 'HGdjmTGRyNTFjrvoT8o6cKT5xaj2qhCC6gotoRp1VEgF' THEN 'Relentless ' WHEN tx_to = '9kNWVxzjS9CooaVJDxNdqJqPc2CZ949kxodEG2SWM1tZ' THEN 'BloodThirsty ' WHEN tx_to = '2pzTjhc5UPAnMEv3Xiz517jtvnq7ADMDu7R5kRHU2WNc' THEN '' WHEN tx_to = 'AH2WkEy1aS9NHCzEpojPiXmR85WJBpketrobTnnpD98W' THEN 'StonedGateKeepers' WHEN tx_to = '5uWMwVWYqASTtdA4XzhHnAcWJ31oo4zB4w2gKoioinZq' THEN 'Alien Busters' WHEN tx_to = '9F7yn7qKbKdVVasjyZqfqc6vDzN7t1dC4nuruM9s2iwQ' THEN 'IIXO' WHEN tx_to = 'H4YCeEhgc5Apzez6qER5482FAMkRAyBRV4UAUfZWAd4W' THEN 'X' WHEN tx_to = '3HYkGcKGVTBgim6Rv6WiTe3iQT8cxPQmMmc6Z6SywEwZ' THEN 'SquirrelGym' WHEN tx_to = 'An6aRGf318Qs24FESZoncf4iK4WfrKY9LRSM4gBw1Xw4' THEN 'Outer Space Property' WHEN tx_to = '2u8ez4MuSjzeoy71avdoBjbvTurBBxkkg3ziZtRxodCS' THEN 'SineTriCate' WHEN tx_to = '93VyXGmLtNKyheAccKirWhi7H5GkYY2UBe3FrLi1K2su' THEN 'Xenoslayers Union' WHEN tx_to = 'E2pZrNRVNzT2PSVTct4cdAeugggZAPxxgfxPFpGuG69o' THEN 'EX Nihilo' WHEN tx_to = '7nioxQ6hUU7JRj2dKyyvK6v82dWzC5J2UVBktapkGuFj' THEN 'The Mandalorians' WHEN tx_to = 'BHwRTH8GAn4W6UN6Yn3f7gpyQYEAcJscDsKrz4FTEEgg' THEN 'Intergalactic Herald' WHEN tx_to = '3QnA3KRd2Xe8yzZDoeWcuN9osja6NKSNG4b4QnB3rkHw' THEN 'MUD Fame DAC' WHEN tx_to = '3kS6FB9DWLFzNrgaFAbJUkoQr7KAz8WwupkNvNo9SNbH' THEN 'ONI Fame DAC' WHEN tx_to = '8EqrPNZcf6zvuoFrHpdWLZdo7ptXY12zYukoE2jAwD11' THEN 'Graphtronauts' WHEN tx_to = 'GfKWv4cDnCcVJNPZqJC6Fo64dgJL6nmZBxJBTFnQhNpi' THEN 'gisco76' WHEN tx_to = '2GW4juLBY5JpQxSohTXtPuogFgssuMuwGDwYmoUbRq2A' THEN 'Deep Profits' WHEN tx_to = '4Esv3hPFVgeHXq2T9e6RJYctcLsJS6ForzdYgzbvRf1h' THEN 'Mirror web' WHEN tx_to = 'H9u8XrjgcjJ93zjQw8c2KY99zaj2QJ96QUUzLfRbtjaM' THEN 'Coconut Bandits' WHEN tx_to = 'bXjBqGH1huGFp4Vq2LMpREKGefSDPdWydgRoyuxwQ9p' THEN '' WHEN tx_to = '8hn5Zs7ah67j8qpTFY11h1f2MKu24adJwsd6bNWUCKcV' THEN 'ATEOTALO' WHEN tx_to = '5Lc3rdPVVyicarE7NMgjqmZ4jNDqNT6wvg8Uuak4Pj9Q' THEN 'solana2themoon' WHEN tx_to = 'GKA2rptS1PbDAzAWxTNt6cCMCdCeV1eRNddArmUYcTf4' THEN 'THE WALKERS OF THE DAWN' WHEN tx_to = 'FRaoC8HkxWSQEBDpD2EQEna6JAn3niaQMdGnMTG9wQYw' THEN 'ONI EMPIRE' WHEN tx_to = 'ErHtBkjsFAHqmsLMCNoXLtqVmBTEY47xnHhdTzryeVbq' THEN 'EverVerse Royale' WHEN tx_to = 'Er9vp5rQsgNnUEZrA2avr2uiub2ZXMRkfY4mDxHFd1gx' THEN 'Economic Elite' WHEN tx_to = '41mHWZQt3LJ7bRG3coMa48XdhT5CyiHQXqYDyHPesMvC' THEN '' WHEN tx_to = 'Hr2xmCi1u5KybzSHeqpvnnMGpeqNEwRPNjnvjJRgima1' THEN 'OnLyShoW' WHEN tx_to = '916rcLHN4zaQjb1vTDCaAARV5EY3LDGcUXiQMtVbTG5J' THEN 'The Firensidus' WHEN tx_to = '4B7ufphXiTug4cC48ZLcX3fQxEarmDZmw2isgGC76BWF' THEN 'Simply Irresistible' WHEN tx_to = 'GoxKt9rWyGkh1PTrDwYvnALhkDkq8av1QSRgxTBCvV1Z' THEN 'Los Huasos Lokos' WHEN tx_to = 'DyPMsFYJbtXtnuSjLDgTEzwXRTaMdTEQPzvw1tcioXFd' THEN 'Solaris' WHEN tx_to = 'BiEoXzZ3omnBRtZQvFWZgDVf2b971FfsGrTVMt6FitHo' THEN 'SAI' WHEN tx_to = 'G9knehu73MdtexUN9oQ5RZ6knhdQoFU1uB7qZdth3Mrw' THEN 'The Unseen' WHEN tx_to = 'LDxhKM4iERN86sDpdfLiCSjTr8gJh2DTqMVArxoR664' THEN 'INVISIBLE' WHEN tx_to = 'Ek9a8CuYYLdEyoAvsPS3YviXHoWjJb72ZNSLsSxRUoh1' THEN 'HyperStrategy' WHEN tx_to = 'Cok37EEaD1mXVc1vqTFu9RLSj96VEDurZdhbJDAU528m' THEN 'La Republica' WHEN tx_to = '3Rszuj2r9igbnnvo8d2QKU4ecvS7aUWDXL1RtwdwbLq4' THEN 'Star Horizons' WHEN tx_to = '78HgW63VAqFMsn18DVVE2TbxpfcewjHhxx1qFNZaF9u2' THEN 'EKETOR' WHEN tx_to = 'FoTwDHYpbvoFUQcCjD9rqvv7LwLJkAqz8z94bMFNmh8E' THEN '' WHEN tx_to = 'H7Vun8LMwj8wsuzzTjE6HnN9SgWX4JSSRhBwKPQ1ZofV' THEN 'Fazzy' WHEN tx_to = 'FYqfmB3EbCW1GfUXVxNFms9tsx3zywf682cCeqrLzdKz' THEN 'StarAtlasPeru' WHEN tx_to = '4twwT7jsvLehzZYrrm7zYtRi5TQwmqJiYn366d9TAYKJ' THEN 'Mad Goons' WHEN tx_to = '6GZtq2YkYnTcbJn4FfQPR7cqQJ8scBQ6QmS7HPSDqqkW' THEN 'PGITU' WHEN tx_to = '7wY9LvrtmKUJn7crCviGLYMJ9nDegYGtK7Z7dcAFhN8S' THEN 'The Hazy Tribe' WHEN tx_to = '774iNELuGpYps7LeZRet7gbkjJ9BbNvDGTz7mfeT1doc' THEN '' WHEN tx_to = '5o4MiuZYDJbqDMnKRtGPkhfGGEv3nULKSHQzb4QcZDCP' THEN 'iran' WHEN tx_to = 'BwrQZ1UfWXkAWU4oH8L9bdW2qYjCsnH1LpoUepN7JoQc' THEN 'The Degens' WHEN tx_to = '7PAKDuky7bub9emSPjDLesUQY9mSTDmoVRVhrpeJwKso' THEN 'Balkan Knights ' WHEN tx_to = '2LJzF56iEXDr1HHU4qpZ1z4z6ScTqVFemZiNdjiqNwVS' THEN 'ahjin' WHEN tx_to = '2McDk2z1FY1hZTddi8ffcpqRbU79zAKBi2vsX6cGq1P9' THEN 'Dark Army' WHEN tx_to = 'ENK2VjXPYUrUFtiG9C89w7763DNL9amVdJU4PjtqQG4g' THEN 'TREE' WHEN tx_to = '9PdDfGLqWYSJcvL2Yb3CKfTS3hvejKyEq4gekeZneNjL' THEN 'Whisper Alliance' WHEN tx_to = 'HtSAeZzdBewa16uPvGn4FZCWxp3jxRoheKJeMuJvh1Cs' THEN 'Argentinian lighting crew' WHEN tx_to = '5mfo1gjYabuyCqoMPPvdyvDhwid4cssu8uXXL4UnF6nJ' THEN 'ECLYPSE' WHEN tx_to = 'CgQwaAVg4Dpg75f8t2rxb1BdDkYxUAh9hbvsKEQgGy5G' THEN 'Ives' WHEN tx_to = 'CtEDMzwFbBPBB5GPaWeatAhVa2McXtJNA8wKi3BqwxNy' THEN 'CYPHER CLUB' WHEN tx_to = 'H57LZxDbbdxMss2zKBcpvANecRgWapYhdWdDqr4d69H2' THEN 'Pioneers' WHEN tx_to = '656HMJgJ8Xa5KwGJpwwmAvbHPmsRUiwhzCct5qK8qMMG' THEN 'Leo' WHEN tx_to = 'EX5rDxw4898UGhNrGUK5xqZGt4B1tWMEBAB3G6wJK1bJ' THEN 'Tsolum swans ' WHEN tx_to = 'BXDsRM88dGTiG8w8W9S5Skvau4b9n288b6wvBHkydXPT' THEN 'Heimdall Industries' WHEN tx_to = 'EikUt56pfsBPaEoCjL7qjkqTbiGph5efE46PhbSg79uG' THEN 'Interstellar Parcel Service' WHEN tx_to = 'JBzzieSD2VhuSycQhJZJchpU7hHu3HFF5Qz2iKVVGTvh' THEN 'CABE' WHEN tx_to = 'G765KAKC7NpDceMqnc8rytyJaNAqHEVWe4uvrMVApijx' THEN 'Subgalaga' WHEN tx_to = 'Bc9LYXunECxJUwpoUnoqSSNgmQGcN7Vo1F69uMF3NEHr' THEN 'Regnum Stellarum' WHEN tx_to = 'H4axZkYN9GV5Jh26M1UVVGCGy8eHKSLX47SSYpRRtXwH' THEN 'JambCorp' WHEN tx_to = 'CztBYeA5ZfRwTczCFmToCZPPt2ytr7rGQ2yL3HaGc6Cj' THEN 'flicker-star' WHEN tx_to = '2bsHL4JdGd8ePMXqgpHbyD6KKEniU13sTLy4npZ4PPxX' THEN '' WHEN tx_to = '4NDwWqinahTavGacMmhSygvJhHTwq913H5H4JPnRnGef' THEN 'Social Experiment' WHEN tx_to = '86DpjaPfcSD6HoWoVo77RJ1YQ7AT6AKpKUGboZL57oau' THEN 'GALACTICO' WHEN tx_to = '94y2s1uaBNNhJz3fBsavJuwX3ckVk3wvN5BYoVXnkTxM' THEN 'Bing Inc' WHEN tx_to = '2111tZQPKiiQomaHGquVuMyipP2QGvuh7ymDe1s3RV4e' THEN 'Bridgewater Bandits' WHEN tx_to = 'Ha1pBhegN2qaYXmKuDTuWiumtho7woq43b2jxDbKpiaa' THEN 'NFT GAMES' WHEN tx_to = '3eQgk2HV7nSfgMFNd4Yyvpy3kyL9X7JLDf9YsGUUqXLK' THEN 'EL CONTINENTAL' WHEN tx_to = 'EVwRE1EMeJdWyYZFS6TwWrZYyBM1KzK5eZwaZa7YBeRK' THEN 'FENERBAHCE' WHEN tx_to = 'GduJeJ5c5RSyL111jZuEQvexNSHgEpQtq58c1wkinAr9' THEN 'Legionarios Hispanos' WHEN tx_to = '4Dafs4PJqB78bC7QFQvHzdcvr4JhanGQvv8QNZatNJhX' THEN 'ONIGIRIYA' WHEN tx_to = 'C2Zjjm4dRqtU5DdgGcTGWVjL64pDK3xbRSTiPBgw24Pv' THEN 'Beyond The Horizon 2620-BTHMOB' WHEN tx_to = '81hnFSmp41L7eALLrsixHLyvvtiwC6cUwTeDFba836MP' THEN 'Colonization and Mining Guild' WHEN tx_to = 'AVBySfXBotEdLcx8UGByZkxwoWtsehN4AARZPLv1bU8C' THEN 'GRAZNA Corp' WHEN tx_to = '6QVUvigkumn3e1LHi6K9pVkeX9QHF5cQNPChLKjgVwB2' THEN 'ZOE Advanced Reality' WHEN tx_to = '6WEHYY1AQWmvPYcc8roiACJWVFepDWKDwCMvsMkBvvQg' THEN 'Galia Merchants' WHEN tx_to = '93LngHgUU55yjwZyPtsQZXHVpTYE34TD5LnXheLviHhY' THEN 'GATALICA' WHEN tx_to = 'CnAoBU7UisDYS1yErxDkMjrC2L3Mcj9fe77znsWSJRpJ' THEN 'unDeermine' WHEN tx_to = '3fZVBPpD83NBGRSFLLLX4BFcP3mcfjsQ1UrGj6WPNnW4' THEN 'ZERO G GUILD' WHEN tx_to = '7FGnsvA2oNmNYLA6dJ8x9r53arBfGkQGv8jeMpBTVZkD' THEN 'GaliaMeta' WHEN tx_to = '7revLmYeBHSgSDW7jyCJrouBkx596QnjK9WyXZJZ5o26' THEN 'HYPERION CORP' WHEN tx_to = 'B9JH2TjuoyGrRZ349SehFK7iFVHP8pxWVJhegpQmoatT' THEN 'ARGENTINA' WHEN tx_to = 'J2JbbhNaqYGZ3enQADHR4N22bkZBSMFDba5k3jB84vvp' THEN 'isshoman' WHEN tx_to = 'GLedsFDFnhNANosFgQk68TTwpZaphBHw62AQrj95ynUx' THEN 'Garp' WHEN tx_to = '4342uYd9UVqtvWeSdGQ6SGHLG4FLr26B5EaLECXKCdEf' THEN 'SA Frontier' WHEN tx_to = '6Wp9rGBVyrhPmQLsgoAGgRfXYKEkH4epqtrV1W2ZW5kR' THEN 'VORAX' WHEN tx_to = '9fnfKQ6he3n7zYQsr1B93hYmCRkgVJtwywL9ipRQwajv' THEN 'GALIA LOGISTIC' WHEN tx_to = 'JBXZM9ZtX2ndsFZzwxCRRFrVdzfXkQvWaRNZdegvtyPG' THEN 'The Bounty Bar' WHEN tx_to = '818ZDE9eDStENtqJhkwYHR3Tuym9LqjcKvrd5nizEKPz' THEN 'QUIZMASTER' WHEN tx_to = 'FaLHjzN7AqZp1FFmEbCHLqeLon2bDRBgXJJD6ZFZFWWR' THEN 'Empty' WHEN tx_to = '4q3ErhR5PUL4YBbYws1KqvXi4FCfYAE9TRiyqnvkBcHV' THEN 'Elune´s Dreams' WHEN tx_to = '8fXHMGUC2FhKDVRoVgXGYXeJzCsNsGLzvT785uxKa7te' THEN 'Mbryans Deck' WHEN tx_to = 'B6yu313YhF6FcQRHmiVt9T2PTVVdx8qm5Wj54vHmDUjF' THEN 'Support' WHEN tx_to = '6daWmVWCW78YxTiS8ed1ZG9XQTwjgfdEmmrcbgnK6GKF' THEN 'Soyuz' WHEN tx_to = '8QkxwfE2dJbqrpgjKpjXWV7wHSnyvjtdqtrDZCetCKjd' THEN 'Star Atlas Brasil' WHEN tx_to = '4j1euHr9TRiMiBcpxFkgRSTAghQ9LStCVh1EVgi8WBUs' THEN 'ASO Tech' WHEN tx_to = '9pcCvP6jEpPbL47ryLB1WsVNTVcAgNxCR2KZULXMdqHZ' THEN 'FiDream' WHEN tx_to = '5XqbpKWpMaNtd9PNSz9Qn2TdxHUqgb4vEA23K77ZpFCj' THEN 'Matrix' WHEN tx_to = '3cMrk7vQhc9VFYFSeq3PoTSUPTaQYa93AsaAf3VoGYtU' THEN 'Samurai' WHEN tx_to = 'HveznYBSUCv5Th34yW8C5yrutKRp6RKZSUgnJ1VEJ6dq' THEN 'NebularTV' WHEN tx_to = '4gJso9Kpjz2ctGH9hp3csYQ72Z22g5AovDCtvMfNDc6C' THEN 'NIBIRU' WHEN tx_to = '6qVrB85GRSLxxjkGFWBopbGgWmvcyPjHaoBK4sBdx8ry' THEN 'VIBRANIAM' WHEN tx_to = '7vaHkoFhb5R8bCZbKbFX5wYEPmSZioxXShzBaBXJAFdq' THEN 'L´espace gaming' WHEN tx_to = '2CCuCvtQSTjwu6uezcaFAZY4oUPDdo8TTxgjURrUrwpw' THEN 'Polaris Fuel' WHEN tx_to = 'J1Z3LwfvBTnJwnDsYAjfKxB1R37ynpgQnt6f3HhvmRYo' THEN 'TURKS' WHEN tx_to = '6S49UP2ocwsQrt8UqFPAoeEWXjYKchbXYMktyQjpK3N4' THEN 'Colibri Espacial' WHEN tx_to = 'DkTCn242jWPmbcNJZxFyQpnXxioDHoyHeNdgkb7ktg7S' THEN '' WHEN tx_to = 'EQgdmXzLdDwM2z45VVNNdvde9kAwrMFRfcvpqsq9LnCf' THEN '' WHEN tx_to = 'DRCsmAaMRxHi2vsFEddgqjM6DbdC5MdLd42JgyoGWpkq' THEN 'SACRIFICIAL WARRIORS' WHEN tx_to = '7FwVcbDZfQNDSEqTzkggUyGSoQb2nEgTBXZSDFiF1ab4' THEN 'ROME' WHEN tx_to = '78mhX41ajkeYfGtqYixf3nf98t2wrKZDsyp6PEGeodmQ' THEN 'Mudi' WHEN tx_to = '3SZGHHqgWfMsUJFM2JyS7H9q2ht5Ms1k9z1D469RzSvo' THEN 'MYRMIDONES' WHEN tx_to = 'DAqeR6mw2bUoq68BKgV98LYdmNhNGYA3ucSSGHYkmVph' THEN 'AFH' WHEN tx_to = '4H8om1WohervcKY9SD6mkKpTWU2KQatm8XJPeYhJWdr3' THEN 'Money Badgers' WHEN tx_to = '6AYJDp4tAVWMVZwZCPj1RL5RwSaRYEgfr3fUt3osrhqK' THEN 'Cristal´s DAC' WHEN tx_to = '5Y3SizL4LLKXnPtvVrZjgGUdkH3GT3kqc398K2nDyDCu' THEN 'OUROBOROS IMPERIUM' WHEN tx_to = 'AZExhTEcyhBdoHJgLAmnv2fre6xhiLVJeyVpFttALfbA' THEN 'Amarna City' WHEN tx_to = '9zbJ4fwUP2E1ZBMnrZC2NFDuqumGWYupequthZqrSPXT' THEN 'InterstellarCorp' WHEN tx_to = '9FWPsXKaCvfUdjy7xtXdnQ42cVBj43PA4GNnqBkQ9fFc' THEN 'yamatodamashii' WHEN tx_to = '5CkRnrAhtQWrasPBBMBuEshyf1ZVzXCFKab94bgybfHw' THEN 'ROMAN EMPIRE' WHEN tx_to = '3CzHbFhNUCEVcYtBpFpMqaGJYdrw31H64jbyJZDC8uPc' THEN 'BenTaYFun' WHEN tx_to = 'HknTZVKYqTif8HAYqSwQGNbf5eeBbpSB4GefBhmxDLof' THEN 'NFT Italia - The Consortium' WHEN tx_to = '4phx9itpvPV3GGaXosSREkhuARfWQfeVWmZ477xXezsZ' THEN 'ASTRA42' WHEN tx_to = '61oopV4navB8GNixbNrkcGkHJJofK6c9pWB8EvwuapW1' THEN 'FLARES' WHEN tx_to = '7Vr9xZy94DPfoQev9n4d1r7gNx1CzU8x8e4zyU1BpCc3' THEN 'Parsec Link ' WHEN tx_to = 'GKkRA2wRPCn7fm8rT5DmKP1kGQ17eDwENMUj7YZePvSX' THEN 'Hubi' WHEN tx_to = 'Gqwqi7YDPxBKP25RTrcwBHdSXHxUa1Jq5YrSWkA5zPvD' THEN 'USTUR Fame DAC' WHEN tx_to = '51dVxoYKQESsVCQa7MXwBCYZBo6aRQPJm7eTAHGtmSUM' THEN 'Black Hole SA' WHEN tx_to = '8sVcbhLMY6phdjkx2wgW4UbG8mp2FJh3wihEkmvNXuGh' THEN 'UN ares-divino' WHEN tx_to = 'D6NNdHXwxUv5Qe49D6mvL4tAyV8XoBX3KYwBunrWh3q1' THEN 'SPANISH SA CLAN' WHEN tx_to = 'GCgNV2mMXrmuoewFyJRPdZu4FVXARFqwxS5Z4WMRDUYd' THEN 'DenkuGalactic' WHEN tx_to = 'ARrvxokSPWkWJi8HfcHziNhAvuZTXG3AsHBFrPsz2s6S' THEN 'Oathbourne' WHEN tx_to = 'QEQ4eUVgbtbUNy6a8MeB1GDf1Adt72QGYHo6Tw1Bp7u' THEN 'HORIZON' WHEN tx_to = 'ENZKG8qrBbh9NNRYRqfH742kSJnboBQ8s5WGHA2tRE27' THEN 'PattayaPirates' WHEN tx_to = 'DdSrp1jNAB7WW9cXJoJRdeBVKhy6VJvChcV8DCLFsv8A' THEN 'AFSeX' WHEN tx_to = '27VaKh2MyjDhiRo3BVoEAmYhLzchmFX3bQNSozjqtcx1' THEN 'ATLAS' WHEN tx_to = '96kPtJUsy95R8xNdytCj4sV6MNtatTT69fqgbPDnZEH1' THEN 'Enhul' WHEN tx_to = 'AT1AjeDuPfuQvnenXYW8YWDohDHAQW9go8ch8bUYD8Lt' THEN 'Vietnam' WHEN tx_to = 'FHSHEiBLGiRDTa2UZAvMGNZx4noJou37isUFAsUSpNK6' THEN 'Galactic Corsairs Coalition' WHEN tx_to = 'AQTtCPvcNV7EZ2gmRgdHuRzW7dKP9GhXCEhP7RSz2acj' THEN 'Galactic Federation ' WHEN tx_to = '7iEz9ETnEhf8iJDRyZWgs3bZ46hSfFSizqmegH92TqRv' THEN 'BASTION' WHEN tx_to = 'DsE6K41YV3e6pBFHohWe1m63HFm3FBSiRsRaaEdGmiTm' THEN '' WHEN tx_to = 'Gxfmp3UQaMn2w5p7t594V2LWjG6yuzBK6ggvtKafXtop' THEN 'QUIMERA ' WHEN tx_to = '6aaXiMywUzwAR3fpbHMosh7NxeVNKUXimGvr4m3BkTGS' THEN 'Tenoch' WHEN tx_to = '7XBdNdgx9r9fTRWHy9dPT2Y8RdPmHYPG5FLib65Ziyrj' THEN 'Starship' WHEN tx_to = 'GS9aFd9wEUXEhb2nntr89VNnJ39bRUVXQ6xmYMjGp3HB' THEN 'Star Atlas Germany' WHEN tx_to = 'Bu75bsavPDCFQ9htMQaGF8W599opJGSjTb4v1vjiSYDp' THEN 'AstroCannaVerse' WHEN tx_to = '51cTJt5GykDpx83swgmaTrXGEtppYHS9yzHs9inaFvKN' THEN '🍆 AM I CANCELED YET??? - 🚀 ♧😺 ℙｏฬᵉℝ𝐄𝓓 ᗷү Ĺєｅ𝕜ｓ 👑🐲' WHEN tx_to = '6fNDx6WywPpn3U2tHV3aYJoXF9j8XounqS1PZQreUSUY' THEN 'Nasa Corp LTD' WHEN tx_to = '8uRrnSWAXfGs1B6GHxv7E1N2tvP5HUAv5ojaB8XEKULd' THEN 'Crespo Corp' WHEN tx_to = 'D6phF7VQfukJFUEi13UjcRRhPPc9fP4gz7KZqHTJ8LXP' THEN 'BULK' WHEN tx_to = 'Gigbspa54WMpVM5HTVKo7dD2Fajf6Bkbd6nD8Uzc3MEJ' THEN 'Atlas Corporation' WHEN tx_to = '77rDxCAxcvQKQJ3RtcXAKDtBAYqmkhnLGuQh2j7cYYGF' THEN 'GoldenEagle' WHEN tx_to = '52hoVSpFWmgQbPDs7cdJ3FYnQLEKqqy51Rw68gQtq8B6' THEN 'colfood' WHEN tx_to = 'HWhkV1JMc8Q5ai1B75EMgHNwRsGQQswCXP4SMe8zB3zn' THEN 'Astra' WHEN tx_to = '4163JFn4b22A3FEGsKFGbttVibKASQVAGQ19pooCPoTa' THEN 'NeonArmy' WHEN tx_to = 'B3YqJqwULqthYWPFva3zRtwsmV4rgmhucpjnYsh9KRUx' THEN 'Jama' WHEN tx_to = 'Aw3HA8w1uRUu4ig77M8MPno257EyL8VPZAnahHWxiJk4' THEN 'Brazil' WHEN tx_to = 'FQ95Nhqfqt3gPfvn5X4rkoFARJu1CZC1zSuWXkGGHdeM' THEN 'MADRID' WHEN tx_to = 'AkjrZ2wWaP1aqJHSTPcpZsX8QVSQGNSJk9kQPF6TfCTZ' THEN 'The Club Guild' WHEN tx_to = 'G6GJsfCL2ziPB22WxB2oaiujdTZbsc71CtDcp37L8zRa' THEN 'SAT' WHEN tx_to = 'mNW2A59YQH3eyqAEJxmamoWqEhbEh3vgCDCe3ch3yZU' THEN 'Photoli' WHEN tx_to = '4RwDFpY8c8jUENYzaG8dq8gtokS2EL3ZPLvjwuwHVy2r' THEN 'Love' WHEN tx_to = '6hxTFWzU7EUSvxqpJBRfjBtYuc9VgoqqvtoqyMnkHpnv' THEN 'Der Einsame der Zeit' WHEN tx_to = 'Avmqm27QCd1bcFbgp89rpo44owoQ2MktunzqDpdR9ADj' THEN 'Star Atlas Turkey' WHEN tx_to = 'BbrtBGbnqigECMse31eLpKBy5dcEexcHdboGScMXCbDh' THEN 'AXLCORP' WHEN tx_to = '2o6Y89LtUMmow23i8UeQwC8SqNksj7VoJfBybmMU9cdq' THEN 'vandelay industries' WHEN tx_to = '7UXNqHqHBZS6ehRzf13sWqTZrghGKyJKW6awrwm5vUWY' THEN 'realfriend' WHEN tx_to = 'ESKwmRQtN6b9PveQefUjwd2CTfFoYxLhNpDPCsQ6iGLs' THEN 'DJANGO-Dac' WHEN tx_to = 'HunUq5Xh4xDMhKBQNoViwZgF5CzXUPpsRvQ6UhwphjMU' THEN 'Hexa Crybe' WHEN tx_to = 'HGEvt56UUCuzFPL3xcvGdCeqfxUSrBV1WcPDzZnm9uZB' THEN 'Freedom Fighters' WHEN tx_to = '47Jcu5UNwZhpbvAYPexEbZW8SCoaPmKkUC2h8Y7jv4TZ' THEN 'Intergalactic Coalition' WHEN tx_to = 'A76sRd1CZCYMiA6PxKXacB3CgGktRvegALmfFAkw3UBG' THEN 'Skull and Bones' WHEN tx_to = '5m6ALpJTLsmHJkPEjXPZrGh6zhs2nyt72BKLMPY9pDP6' THEN 'PASA' WHEN tx_to = '9Npsz4xwDhQpmAxa27tJtVhPSaqYoBqBFywjqDDaMi3j' THEN 'Star Atlas Academy' WHEN tx_to = 'EsdYLLGyL5ysnJBXUwjkehA9i4zTtCc3TWhnzC2aJB86' THEN 'delete me' WHEN tx_to = '5m6CMxXG9oyFiRnzwvXcVRKMKx9uMsKHCiVBK8Rmoyq3' THEN 'ABSTRACT CONCEPT' WHEN tx_to = 'EQKuA7YUGAh76mMt5HoiyoBwEmjF3hhdWsu7ixf94bsz' THEN 'Shai-Hulud Brotherhood' WHEN tx_to = '9p7tFComarxTTGF2g1ddojdjjNskGyWmrjGx1ji9yo2N' THEN 'SUPREME' WHEN tx_to = '91T2PkmysJnmveksXPcDpUXP9viqnWS6D6Ex5ZKULybd' THEN 'SFireW' WHEN tx_to = 'DwBzMpKat6LMbHcLzhiWkh3EDC5p7qgEusNwRQnCTNgE' THEN 'Hidden Spring Pavilion' WHEN tx_to = 'gcthRpKbqkdnv2ASnx8DskfYqV1htCWf8o5fVJRoGV1' THEN 'MarrAtlasConsortium' WHEN tx_to = 'CnZRbQvSaPPC8hcDnBfSdbHW7WaG6djLh41iMS4H1yNh' THEN 'GRAND GALA' WHEN tx_to = '9vKTKBP81iES4hy4D2f1EPynAuF7ApV1UjHWLyAGmybv' THEN 'dalovz' WHEN tx_to = '13LuEU3UooEefR45cbdCzsj9o9PJ3E57fFLThC6eEJB2' THEN 'Atlas' WHEN tx_to = 'FGknTxRdEzALQa5cPweXXL435H78pvWvGHrvWygHyj8G' THEN 'Space Tour' WHEN tx_to = '9sYSVYpHEDvQrRhjs2xs6zmvVW7qJnUoKM5dW7yZdN3f' THEN 'Wagner' WHEN tx_to = 'EvwWeAporKyC5jG1vmmyPgdoNFYakSQuNUN3Sb66QVxn' THEN 'THE CULTURE' WHEN tx_to = '37pQCTrHA4ttag2cUQ5szVpZjeRXYqbmKUmTB5NS3sWZ' THEN 'Satoshinakamoto ' WHEN tx_to = 'AYwgAunGYdTtJqph9wv2eZxqHMMMgBGgVPaaMpPrcDCd' THEN '🅴🅰🆃 🅾🆄🆃🍴🐈 🅼🅾🆁🅴 🅾🅵🆃🅴🅽 - ᵖᵒʷᵉʳᵉᵈ ᵇʸ ˡᵉᵉᵏˢ 🌱' WHEN tx_to = '5nxYjHRTzs9fp1bLLtSUQUX1Xb6YMDGLmtHB5jZMgzkW' THEN 'RightHand' WHEN tx_to = 'AfwHtmPqPSdvqy4HiK6JM5V1FKwUXZArcP4gzE4cXX5V' THEN 'Union Aerospace Corporation' WHEN tx_to = 'BPoEipnWZyHd4DCC3esC4Sq24FMb8tsVcsuXRT6cqgXY' THEN 'Economic Vanguard' WHEN tx_to = '4nmqRyWZKDX2GT62uPE8aD9udDN1Wbb8okhD9avhX9mA' THEN 'Saltarats' WHEN tx_to = 'FB8fkGe1ovMxn5HiPxAB2Bz2Q6L9uqU73pszZHRZkpDN' THEN 'PURI' WHEN tx_to = 'H9DHbDVzx6iQTWrpP93jYSF1GkrASrN2CW1iUZLT99Yc' THEN 'Atlessio Family' WHEN tx_to = 'FVXmTpeCQh1q8w4d9DqHhYEcmgn7TqQq6fkWY3Rfi72M' THEN 'STAR FENIX' WHEN tx_to = 'M42pGGWBtrSVwWNp4Sx7XKYR7YyRLqs53axZi7HoxtA' THEN 'The Name Droppers' WHEN tx_to = 'EUmdX4G3mRsGu1jfiy9VgJCmeLtbzCRQaPXuUP5mcUWu' THEN 'Galia Ventures' WHEN tx_to = 'AK7ogPQaVEEqCo4Mv26D9hSVpGdb5Grtiijpt5RXmK3w' THEN 'DENEME' WHEN tx_to = '6kksSeq7JYxEXPEqrF56A26h9zgVxVJL5Qt1uu1F8BAy' THEN 'Lords Of Shadows' WHEN tx_to = '5imupwgxcFYghjr6tjbBGZyRSnNjvG5Z2LHwL69EXLUh' THEN 'LPCM' WHEN tx_to = 'DCMRdSHh8bxGz8YbT3wjdSeNu35P7BWpH1XYdXYYLyXC' THEN 'mstar333' WHEN tx_to = '2TZsTRdebJSXE31TUVcWQSu1thuVV7GhUQZCnygQXnYU' THEN 'Galia´s Mining Corporation' WHEN tx_to = 'HjZtaEVDHg2SPNGT28UBhcynanYiQnXACtJX14bX8Rcv' THEN 'Youth' WHEN tx_to = 'DvM4fFqcznfgXVw19KdMvHXMcM19eXEB4GB5U8CMPMPv' THEN 'ATLAS GRACE' WHEN tx_to = '9jKiT9DKUGLJPuHDBhptpZHNYf31ScNNZTSJVLugoYMK' THEN 'Shadow Loyal' WHEN tx_to = 'HT6bn4GgawvsJGFqtVbBAd9P9UzxkSKAKK9fqTkPtB3M' THEN 'RipperRoo' WHEN tx_to = 'FNakT4wpcV6ArAg4kTy2R7tV292NP5DWrUs8Wok8NshZ' THEN 'Phoenix DAC -Coex-' WHEN tx_to = 'DYfgqsqhPU6dxZqf6GiMhNeHyeeMickqAP8RVmDEW8Mw' THEN 'Benip8' WHEN tx_to = 'CQrEKeKdjTMU1JYNpZW9dXYgABMSgTuVun4Mgc2JYx4m' THEN 'GRAVITAS' WHEN tx_to = '8npUUoTj2GpXKhEhcV4tUwcmpfyvqMPeQYiHFJRkH34C' THEN 'Firefly Industries' WHEN tx_to = '6MjZLitwLeP8uXeR5v9M8ocXZScGmXLvmNkD5wAtTJGe' THEN 'ONE MAN GANG' WHEN tx_to = '2KkjsXgQPa9nb9JrAMC4iufZVKCNdKndcdfd52F8R2fP' THEN 'starsilaa' WHEN tx_to = 'UKSqCrZJSrWMK3jRpNE9Xdk51qGoa4vyPmHHRoWk2jL' THEN 'HERMES' WHEN tx_to = 'CmvBgv3hxVGNrVNiuibDcGdnUn4a4hRTMQmUrc3e4iMc' THEN 'Project SixQQ' WHEN tx_to = 'D2nTVhCvPMy4StrGdVJWpiHxnDjH5MJVqh36KD5xxn78' THEN 'Sinergy' WHEN tx_to = '9dgM8zzPBQsPvb9ir1yBr4ecjSkibVaTWEk99yrkKZcX' THEN 'PROYECTO 0RQUIDEA' WHEN tx_to = '3pXddTMPjQ49zbsVL7Tmkcvac9hAtR8HZwTcuSut3LBX' THEN 'Subverted Norms' WHEN tx_to = 'GbCrxVnc4C2JERuTxm5a3PvHE6avmGKeEc7cAgBGWTdc' THEN 'KlandelCuervo' WHEN tx_to = 'CaE93VFgxABy8iZBghS34MJuHF7nBbgEGfhXGfQhxAys' THEN 'SilC Road' WHEN tx_to = 'G8vG98hrn4feWz6xKRNwv3YJrK74LnUS68Ef56GTdwse' THEN 'United Warrior Unicorns' WHEN tx_to = '4g3rVLXTuD3BUtaHdPQAvcTkqniGyZn3acB7rCq1Am8A' THEN 'STAR GALACTIC80' WHEN tx_to = 'Gba9bTZeF1o4ziBPwLxspuvriwxyqLkh2jwF2stVCGAx' THEN 'Star Stat' WHEN tx_to = '2mjekqJ49Zc8MuH4Dyc97tRnbncA4r7DFJZDHeQu4qhR' THEN 'Nexus' WHEN tx_to = '6ssmRTykHfksQ4cjGf5Mz16MrhE4KC36xFbXvuPmffcn' THEN 'Help Meta' WHEN tx_to = 'CQ5q69MN7rasptK2TmuoaoJZv5YFJS443p47A2viZRGp' THEN 'Star Wars Brasil ' WHEN tx_to = '2Z5Wf2GzPCEx3QAysUdA9nkhCBUb94qEFBXrp1cPDgiR' THEN 'OutSkirts' WHEN tx_to = '2s91BYKyhjT8HRG8TsPkbwNEaAYdmbMPQgEXPgwANx3N' THEN 'Raiders' WHEN tx_to = 'BTsF4wHMR4TUAA2U9QzGqgZ8GcAsy8295mh7HeV3DNJf' THEN 'Intergalactic Gear' WHEN tx_to = '7hWARCMUNPpsLzSVtMSGGkBSrsNk5rCpbs4nvDp95qcF' THEN 'Jidut corps' WHEN tx_to = '2eubmkcQxfsa8PcChG2MH9yJDgFdvN7ZvGqCvSMvCeWF' THEN 'Outer Hell' WHEN tx_to = 'Ffws2e8ZGfA1Mtt8AjCYKPvoanBw4hFLo4xJYRAFKbdL' THEN 'Mafia Latina' WHEN tx_to = 'GDmCDetMiAhjW82WGXKM4sn9bWANS8K8zon1YMzSTaAH' THEN 'Epics DAO' WHEN tx_to = 'FwGBR1ohJ58grcZpfVp4Mw5nVKXNDvpFh9Z1rPL1gnbT' THEN 'Gargantua Industries' WHEN tx_to = 'AaBtyrSn2QLdwyF2tYrjqCgH3k8b1ySytx8Sp26vYtj9' THEN 'VEGETA-PR' WHEN tx_to = 'HnYs2tjQLNATKr9cVfxZ7pDHKcd56bUg62qrW5xn3ENS' THEN 'CONQUER THE WHALES' WHEN tx_to = '59aLtL4s5GXenHgh5FFdQ1S9Zf9dv3EdCBjBiToaPqS4' THEN 'Qubits' WHEN tx_to = '3GRSybEfPm3pBu9qKEeb9SkhfMdXJDLuAqLLExDmEJ3E' THEN 'Lords' WHEN tx_to = 'v1AEfkQhD43erYNKk2qpX7atqJurtpZfzSzPEBPEb3J' THEN 'Toolkits' WHEN tx_to = '4Thbab2DFi82cjN992iU6HHb1sYFgaxFxcjJWeVgJtk4' THEN 'ALPHA' WHEN tx_to = '4bSgWzTkGnHmgmLHaiWMnPCaXt2HwDf3k41Lsa2df3zh' THEN 'SpaceNIght' WHEN tx_to = '3b7KJbr7uqdkxJQAZ7UKYSCBoWZNAL2LNBURiHWt36Sm' THEN '' WHEN tx_to = '4xx4TFmztwfmYg2EWbqJAvkAM42oG4mCZ3cv65cSsWiy' THEN 'PANTHEON' WHEN tx_to = '4X1cFKvprP2Sat2FVjBda7r5MXkpf4UFgTGqtAG6TpoE' THEN 'Tempest Coalition' WHEN tx_to = 'FWnTbPMN2a7FuYqJXfC7Vuhns4cG2RjpDtjLyZqPA7sy' THEN 'Jupiter Corp' WHEN tx_to = '3pHXgvWoXCgvsxgc2gfvSVp2YdsGNwzvt7K7Xj6hoGrU' THEN 'Pirates of the Caribbean' WHEN tx_to = 'DExwFnpah9F65QWtSeUY7kvRsDDH7xg2y4i4VPptL7yK' THEN 'Gargantua Industries' WHEN tx_to = '48RFdXJF5hQ6pbGu35yeo8Sb4zQHAde3SNcGkPw1ApRn' THEN '' WHEN tx_to = 'GkNYLMb3nZJy4sm8xzzMD8gdUUJBifVj7PD1M8Q3zcUA' THEN 'DED' WHEN tx_to = 'CDnw43SCGmeoAccvV1ZxrHnmjjkSFWtPwgaMT1VLHZ5y' THEN 'OniFire' WHEN tx_to = 'ETLvny4TCYQ7VcB2Pf1DXgeaWzvdhiwRfYtptDZxdGac' THEN 'GALACTIC REPUBLIC' WHEN tx_to = 'EjvB3xJSsYg7Nm5FkK7G2ZHasq9zjAVGXxraexUkz3Xn' THEN 'My dyslexia is getting whores.' WHEN tx_to = 'E1pWvqaqkUW63u4NvPKw3eqEWouQGC3omXEs5WgwAFpX' THEN 'SAI-Ustur' WHEN tx_to = 'EXVZBAxkpHz8rvrvxzcdqzF4VbpvTWpsp5xfiSQGYoxk' THEN '' WHEN tx_to = '14rHdcRCEZscxZJsHHEw7oQCJYE8eF3pUwXtxXzretTt' THEN 'Hungary Force' WHEN tx_to = 'C5pCyujebLLSk9uS3UP5LktWy2hZY6dJxdo5Qp61s9sw' THEN 'Hijacker7500' WHEN tx_to = '6udQC86sHTxHPrGu7XFL2ruNECRnQ75MU7bD75X5doou' THEN 'CGG' WHEN tx_to = '4HHvQKCEPBCRAp8MAgXrCKQRxpaq1Ya4bcCok38qEkNo' THEN '' WHEN tx_to = 'D8maH1bPy7BBEnksEUXbCDKiy9SQuTkd5VkVpyuCc5Xw' THEN 'BoomBox Union' WHEN tx_to = 'DdKTJM83Mkskc3za4DHnBhzEVkQ3Z4cAKNZ2u3484Zrn' THEN 'BRASIL STELAR' WHEN tx_to = 'HzbKLXxc9Nb9RCF6yxbQP8i5jJ7snrv3H2piwcdK37cN' THEN 'SYNTAX' WHEN tx_to = 'EmNAp4qddEGHT2DHCVT4vHR5QhqxGQwceF9jmDi4YWar' THEN 'NxG - NextGenGaming' WHEN tx_to = 'F2jFYocCtWCJimHMCBzBV8m84aehFcYdBjbvPxbKLtBv' THEN 'Great Merchant Group' WHEN tx_to = '5fajf1fefX8jS9Q8c1brAHtfuTrwdK5HmM83WtewWH1S' THEN 'ENNEON ENTERPRISES' WHEN tx_to = '2rE6SBHCvw91mzRuWFJbHXhzkRcddGyjBDL4AyWekmqz' THEN 'The Protectorate' WHEN tx_to = '7tKmQqVgLcCErGysdbKXt1SQQDRx4P3S1icMMrmJU2cD' THEN 'GENESIS' WHEN tx_to = 'GYLTdPcQMKS3SWUt6eG5XhFj5ksdbzaNuZWwY4K4JAAY' THEN 'Galactic Merchant' WHEN tx_to = 'Bk1QbFR23rwaPgmEaBEF8GtH6uD2TjsrqPS6CTrkH8tS' THEN '' WHEN tx_to = '3J3bh1zmLXuBgAZ7gMS49xmqG56QYQttxzcUwcQSPQrW' THEN 'Mandalorian' WHEN tx_to = 'FdZp3buU9gxHHvPFTczchA64vacrbSYmHJD66vjnnZVQ' THEN 'Star Wars' WHEN tx_to = 'EUFZFPGxEpc3UTc5n77dtF23WauaXrKkZU81Cvwn7AAT' THEN 'Czech CORPS' WHEN tx_to = 'E6Vnb4bwcvv41d5yJUiZnKud3bon9aJpEMM15RCQ1CuY' THEN 'MUSES' WHEN tx_to = '8B8R2ZxtwaQk165uAVGQsyk9tZmsJhiPzvzswRZ2m8D' THEN 'KeXaM' WHEN tx_to = '84N6U4ifBfRWCvVVKEtKaKYMoQ4kn8vhwsYkc7WNtAYY' THEN 'serkan' WHEN tx_to = 'CR7WRwunD9EW5SuQJCZDQNsAhoYD34kYYfvf3bDvSa1f' THEN 'Hologram News Network' WHEN tx_to = '2ZVNfpM6ftNEqmehRt3k82Ppzsfy4qtvHgvo1Z5rrgG1' THEN 'blessjin' WHEN tx_to = 'HTS3nTLXp9oDwXuN9rpQA24mU9NKRReXUwbTuLceEqAT' THEN 'Shinsengumi' WHEN tx_to = '79eDKY9nZEM9wKkPcLyVoGpifoSo8WGFk54yTzUadx8A' THEN 'Dark Matter' WHEN tx_to = '4GW1A8ArGRQUZYAyLDtLixSS9MqwsHvN8wbkhiwu7nsw' THEN 'STARSOROCORP' WHEN tx_to = '4gCPGCP6NittnfdjHMLSjXgywmHaYSek4xfMp3TSoLZW' THEN 'OnePiece' WHEN tx_to = 'B1midyAtkJg1h96CH7EaW1i5Y8LicfjpRBjZwTWUWrKi' THEN 'Final Frontier' WHEN tx_to = '9qJAs5nPvXtQxo4bRNnnwrd1EihUWKGLecxHNzJmrLa2' THEN 'MK ULTRA' WHEN tx_to = '5tLQQeDWst7HrjmtDSrQrzV3rRZAnhd1QAS21cv3rE91' THEN 'Galactic Sheesh' WHEN tx_to = '6FKdJqPnFKdgC8myVg42j2rRa7KMjp43HrjJUCvnGdnv' THEN 'Armchair Miners' WHEN tx_to = '34rL3rTDfFwmjK7dbZxHVN1hiM47y5ugsE3U88JWYm9t' THEN 'Scythe' WHEN tx_to = '9K3y9PNd8dLxvaZyJdbxj2DNnJ42eGaVMKYwLbW9mAPm' THEN 'DIATOMEA LABS ' WHEN tx_to = 'BMfxUHiMFAMEbELmvkK8qPAkqTYY9C18DwG1446fcpPP' THEN 'ARS 8' WHEN tx_to = 'EMCtNAN8hH3v5W7RVvc4iHHvEZEk56AW3oX9QEzV8zif' THEN 'DePinDeGENz' WHEN tx_to = '38Bd2bSQi4GQcHCcWHQ66SSDjeskC6ZiNKYK6hjPfEpb' THEN 'Spacing Guild' WHEN tx_to = '9GTJa4EobPs9z4fG75to6yTMa2AukL2vWWX8So5uoVu1' THEN 'Entropy' WHEN tx_to = '6DUnGuvMZTrpUkHxAmPvdWfkLMmepS4gDDmVcCvHSyj7' THEN 'MIDAS' WHEN tx_to = '5htkzCJjYPdSLTFiSHYF83B6kGp3ZTypkaVJL6aKyBuR' THEN 'MUD-AlexMieJp' WHEN tx_to = '7izZQP3XUfGPoHhkXzX6iea4d5wUUxKJPZ66SM8PpiyV' THEN 'Mr972' WHEN tx_to = '5QW4BSfRzsLFjZdnuw8WXBfhxmpZqTZv7CRZYf2fTsqN' THEN 'Star Corp' WHEN tx_to = '2kGYs55EsurpoeuH63FEYJwTodiA6n4rsRtn1KxNuvQp' THEN 'Voltron' WHEN tx_to = '4XTNLfoqXDHSHujnwHmggqKCSFaD5uW4v28QFRU6VNvt' THEN 'Order of the Kraken' WHEN tx_to = 'FhZW5znegwHCkDZAQxLLAjAPk5wq1j9FBymY7bQWx4iD' THEN 'This DAC has been moderated for impersonating a government agency.' WHEN tx_to = 'DVNcVE55LZny5dBUmV7yGb4xejXvhANdwAUuuMHf1iY7' THEN 'Aephia Industries' WHEN tx_to = 'GcHtaKEYKQqCMKfUhGBkbDr2si1PeijTeFnN8u95Kte1' THEN 'Tufa Spirit DAC' WHEN tx_to = 'J5xGpKiWvb2TF9FemUsV422ycax5P18GkJpaiEfWeZJT' THEN 'Salta1' WHEN tx_to = '9RewNE2UR5ESwCsW984hBBcNNdo4iQv1nQtQX8DsDSpD' THEN 'CELESTA PRIME' else tx_to END AS wallet_label FROM solana.core.fact_events inner join solana.core.fact_transactions USING(block_timestamp, tx_id, succeeded) inner join solana.core.fact_transfers USING(block_timestamp, tx_id) where succeeded and block_timestamp > '2024-02-02' and fact_events.program_id = 'pprofELXjL5Kck7Jn5hCpwAL82DpTkSYBENzahVtbc9' and fact_transfers.tx_to = instruction:accounts[3] and array_contains('Program log: Instruction: JoinRole' ::variant, log_messages) ), count_reg as ( SELECT dac_reg.wallet_label, count(DISTINCT dac_reg.wallet) as members FROM dac_reg GROUP BY 1 ), mining AS ( select dac_reg.wallet_label, ---------------------------------------------------- sum(case when value:parsed:info:authority = '4AWSCx1WmDfmKfdg3sCgRyqvSqo8Tfn4sTSATxCpX6HE' then value:parsed:info:amount end) as LUMAN_mined, sum(case when value:parsed:info:authority = '6aJtfkpqJXSTJLMy9dpHXVWedkqYyXZdU5NQeW7EyEEr' then value:parsed:info:amount end) as ARCO_mined, sum(case when value:parsed:info:authority = 'HxuoW1YmXTBfEyJqXGhmzQL1JYyrrTY4ZBP5GTh26wsN' then value:parsed:info:amount end) as HYG_mined, sum(case when value:parsed:info:authority = 'EDjA54ZqrWE5BcigRG3aMHtLrwuRjFi9SQp1u7YjmMmU' then value:parsed:info:amount end) as BIOMASS_mined, sum(case when value:parsed:info:authority = 'BGa5Pes93c2k9caSQnvs3qaSk4Wafor2EyL9bKpyd2q8' then value:parsed:info:amount end) as DIAMOND_mined, sum(case when value:parsed:info:authority = '2gfKfpJ3Ne2Eb93XwDddLgjXLMLPgALJhYngJFCVve4x' then value:parsed:info:amount end) as CARBON_mined, sum(case when value:parsed:info:authority = '3M2oRa4iuu6fdFkhD3YuaLFzEBKyTxo89Y1Na23nH73e' then value:parsed:info:amount end) as FEORE_mined, sum(case when value:parsed:info:authority = 'BcfL3qARzi6tkeEoe4gKicR7B5oUrxhh2AGxefJVdtER' then value:parsed:info:amount end) as ROCHINOL_mined, sum(case when value:parsed:info:authority = '3cDPzgNgg8RgDDJRQVF2FKnZmsVqaG3QbUFXKgybyK8o' then value:parsed:info:amount end) as CUORE_mined, --------------------------------- zeroifnull(LUMAN_mined) + zeroifnull(ARCO_mined) + zeroifnull(HYG_mined) + zeroifnull(BIOMASS_mined) + zeroifnull(DIAMOND_mined) + zeroifnull(CARBON_mined) + zeroifnull(FEORE_mined) + zeroifnull(ROCHINOL_mined) + zeroifnull(CUORE_mined) as total_mined, zeroifnull(LUMAN_mined) * 2.5 + zeroifnull(ARCO_mined) * 4 + zeroifnull(HYG_mined) * 1 + zeroifnull(BIOMASS_mined) * 1 + zeroifnull(DIAMOND_mined) * 4 + zeroifnull(CARBON_mined) * 1 + zeroifnull(FEORE_mined) * 2 + zeroifnull(ROCHINOL_mined) * 4 + zeroifnull(CUORE_mined) * 2 as total_weighted FROM dac_reg left outer join solana.core.fact_events s ON dac_reg.wallet = s.signers[0] OR dac_reg.wallet = s.signers[1], lateral flatten(input => inner_instruction:instructions) WHERE program_id = 'SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6' AND succeeded = 'true' --AND tx_id = '44vjt5RwaQTeDstZ9Pe3X9JupLa6uVAYFJ2TZ8ZcpxQCXQsD3r6jAHLXrb2GtK2VVP5ii8QjQVBS6Gco1YwWmtau' --AND value:parsed:info:authority = signers[0]::string --AND signers[0] = '5MAwMwFWKHrtSWCBJRTpqD8uv5cEkioCBXtaFLU3jaot' --AND value:parsed:info:mint IN ('9ifQ16N5DdUFoejCwsgR73ihUwadAe3srCo9HhQe2zL2') --AND value:parsed:info:mint NOT IN ('ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK', 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG', 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim', 'tooLsNYLiVqzg8o4m3L2Uetbn62mvMWRqkog6PQeYKL') AND block_timestamp > '2023-09-22' --AND block_timestamp < current_date group by 1 --order by 1 desc ), final AS ( SELECT dac_reg.wallet_label, zeroifnull(members) as members, zeroifnull(ARCO_mined) as ARCO_mined, zeroifnull(BIOMASS_mined) as BIOMASS_mined, zeroifnull(CARBON_mined) as CARBON_mined, zeroifnull(CUORE_mined) as CUORE_mined, zeroifnull(DIAMOND_mined) as DIAMOND_mined, zeroifnull(FEORE_mined) as FEORE_mined, zeroifnull(HYG_mined) as HYG_mined, zeroifnull(LUMAN_mined) as LUMAN_mined, zeroifnull(ROCHINOL_mined)as ROCHINOL_mined, zeroifnull(total_mined) as total_mined, zeroifnull(total_weighted) as total_weighted from dac_reg left outer join mining x ON dac_reg.wallet_label = x.wallet_label left outer join count_reg ON dac_reg.wallet_label = count_reg.wallet_label group by ALL ) SELECT f.wallet_label as DAC, f.members as players, TO_VARCHAR(total_mined, 'FM999,999,999,999') as total_mined, TO_VARCHAR(total_weighted, 'FM999,999,999,999') as total_weighted, TO_VARCHAR(ARCO_mined, 'FM999,999,999,999') as ARCO_mined, TO_VARCHAR(BIOMASS_mined, 'FM999,999,999,999') as BIOMASS_mined, TO_VARCHAR(CARBON_mined, 'FM999,999,999,999') as CARBON_mined, TO_VARCHAR(CUORE_mined, 'FM999,999,999,999') as CUORE_mined, TO_VARCHAR(DIAMOND_mined, 'FM999,999,999,999') as DIAMOND_mined, TO_VARCHAR(FEORE_mined, 'FM999,999,999,999') as FEORE_mined, TO_VARCHAR(HYG_mined, 'FM999,999,999,999') as HYG_mined, TO_VARCHAR(LUMAN_mined, 'FM999,999,999,999') as LUMAN_mined, TO_VARCHAR(ROCHINOL_mined, 'FM999,999,999,999') as ROCHINOL_mined, f.total_mined as total_sort, f.total_weighted as total_w_sort, f.ARCO_mined as arco_sort, f.BIOMASS_mined as biomass_sort, f.CARBON_mined as carbon_sort, f.CUORE_mined as cuore_sort, f.DIAMOND_mined as diamond_sort, f.FEORE_mined as feore_sort, f.HYG_mined as hyg_sort, f.LUMAN_mined as luman_sort, f.ROCHINOL_mined as rochinol_sort FROM final f group by ALL order by total_sort desc NULLS LAST

Query	Creator	Created
2024-03-21 03:51 PM solana	witti	Mar 21, 2024
My mining copy solana	witti	Apr 16, 2024

witti