Query editor
SELECT l.blockchain, l.address, l.name, l.category, l.model_name,CASEWHEN l.address IN (0xb1bcca2ac714a6eed7742866a2ec772394e9ea1a,0xe7538bfa89e46ce0a00b49d6724821e9806c5bf8,0x591dc14b5cd66c104bdeb17d5e2bc844ca3179ca,0x9d4c1c9e1f850f22e5940b8385aa5a580798e5de,0x6c9d96942e4dc17d558e13ce679d197ea9b579f1,0x57c5115fe9f1cffdf0607a9b9beefa56a9125870,0xb2f52cb5a2094a00101d91eeb65b85cb1d86431e,0xdb034a1485da0300175b07282f5a84af69c2493e,0x9c4bd019cf2f4ce5945afa82b807e412b820acfd,0xac7ca4b036b55399cc8a4826347750bb29b3e9fe) THEN 'candidate_bundler'WHEN l.address = 0x15f75d7452ee4dbc92dc5488cd0ad7af5dfacfe0 THEN 'shared_gas_funder'WHEN l.address = 0x777777777777aec03fd955926dbf81597e66834c THEN 'paymaster_seen_on_arbitrum'WHEN l.address IN (0xb01caea8c6c47bbf4f4b4c5080ca642043359c2e,0xb42f812a44c22cc6b861478900401ee759ebead6,0xc066ac5d385419b1a8c43a0e146fa439837a8b8c) THEN 'glider_agent'ELSE 'glider_router_or_fee_collector' END AS roleFROM labels.all lWHERE l.address IN (0xb1bcca2ac714a6eed7742866a2ec772394e9ea1a,0xe7538bfa89e46ce0a00b49d6724821e9806c5bf8,0x591dc14b5cd66c104bdeb17d5e2bc844ca3179ca,0x9d4c1c9e1f850f22e5940b8385aa5a580798e5de,0x6c9d96942e4dc17d558e13ce679d197ea9b579f1,0x57c5115fe9f1cffdf0607a9b9beefa56a9125870,0xb2f52cb5a2094a00101d91eeb65b85cb1d86431e,0xdb034a1485da0300175b07282f5a84af69c2493e,0x9c4bd019cf2f4ce5945afa82b807e412b820acfd,0xac7ca4b036b55399cc8a4826347750bb29b3e9fe,0x15f75d7452ee4dbc92dc5488cd0ad7af5dfacfe0,0x777777777777aec03fd955926dbf81597e66834c,0xb01caea8c6c47bbf4f4b4c5080ca642043359c2e,0xb42f812a44c22cc6b861478900401ee759ebead6,0xc066ac5d385419b1a8c43a0e146fa439837a8b8c,0x7e2b68118307ec9669573905de52e394c36399c8,0x7c5bb330ea12806b2340d7ddba2c062b9c840728)ORDER BY role, l.address