Query editor
-- Which paymaster pays gas for accounts we have confirmed are Glider portfolios?WITH confirmed AS (SELECT * FROM (VALUES(0xf8de0777517f34e4138183ae996edf1825706215),(0x2b69c7ff79cedae3560437ea2e2c01a749d6dd57),(0x12c9d3afeff4f5cf403e20dc9bcb4aa85cee54b5),(0x5ba16f3587cc0fe2c5cf8cf7a9b31aae8421e0ef),(0xc7cdcf11c2e7ff0c422b0c6c16c478956b9b6077),(0xdbfe0d3f67fb3520601537b0f7c28101c3972036),(0xb0d205316e5c856001cfea6000198a2b88ecf5de),(0xfb077da35e2f57a6059fbc0005e361a5fe090596),(0x054b2cab9d2655838089499c85fe3ba9cef439d4),(0x1ecd4304e1f4fd7207aae722e43df86ad8df7f4e),(0xea0cba7a407354537adef9fc88837293ca9816fd),(0x221b322b4473b41837ad65b5cc6b587d9cd135ee),(0x3e60adaf32653a5cbf7c0f7729ffc6eaa599fc4e),(0xaf24875e5b108385e70d9bac3c599a8e4fecb9e4),(0xe0975eeaedf16b03544acf7b2579afa4e21d133d),(0x596dd94346782de9077d862d22dec34fbaecff43),(0x99243a2d7389e977581aabf8c9cf23b8e3c08d7a),(0x68b4f112952d1d1f4dc9852ce7035ff75e80f0cf),(0x5ccefa9baae900fb402e7e3eb410dc4da13c90f0),(0x17e5a57f15f0a04bc77ff6b69657d9bea6a5c237),(0x92f09560e0263e3bd0b7bdd90708d9c5dd167fcf),(0x65d0c5a96f565627b06a8375a95169bbab7a5ade),(0xfa9a4cd3d99707da3e28dafa71d8a8538982634d),(0x0437ae446685275eeb53ebdb698ddd84f5ceeace)) AS t(a)),ops AS (SELECT chain, paymaster, sender, evt_block_time, evt_tx_fromFROM erc4337_multichain.entrypoint_v0_7_evt_useroperationevent uJOIN confirmed c ON c.a = u.senderUNION ALLSELECT chain, paymaster, sender, evt_block_time, evt_tx_fromFROM erc4337_multichain.entrypoint_evt_useroperationevent uJOIN confirmed c ON c.a = u.sender)SELECT chain, paymaster,COUNT(*) AS n_userops,COUNT(DISTINCT sender) AS n_vaults,COUNT(DISTINCT evt_tx_from) AS n_bundlers,MIN(evt_block_time) AS first_seen,MAX(evt_block_time) AS last_seenFROM opsGROUP BY 1,2ORDER BY n_userops DESC