BlockTrackermain query (bridge)
    Updated 2024-05-20
    WITH chains as (
    select * from (
    VALUES
    ('Ethereum', 1),
    ('Arbitrum', 42161),
    ('Optimism ', 10),
    ('BNB Smart chain', 56),
    ('Avalanche_C', 43114),
    ('Polygon', 137),
    ('Base', 8453),
    ('Gnosis', 100),
    ('Polygon zkEVM',1101),
    ('zkSync Era', 324),
    ('Fantom', 250),
    ('Linea', 59144),
    ('Aurora',1313161554),
    ('Mantle',5000),
    ('Scroll', 534352),
    ('Blast', 81457),
    ('Solana',1151111081099710),
    ('Velas', 106),
    ('Fuse', 122),
    ('Boba', 288),
    ('Moonbeam', 1284),
    ('Moonriver', 1285),
    ('Cronos',25),
    ('Evmos', 9001),
    ('OKExChain', 66),
    ('Harmony', 1666600000),
    ('Metis', 1088),
    ('Mode', 34443),
    ('opBNB', 204)
    ) as a (chain, chain_id)
    )
    ,
    ethereum_chain_data as (
    QueryRunArchived: QueryRun has been archived