select * from (

VALUES

('0xe30fedd158a2e3b13e9badaeabafc5516e95e8c7', 'WSEI',18),

('0xb75d0b03c06a926e488e2659df1a861f860bd3d1', 'USDT',6),

('0x3894085ef7ff0f0aedf52e2a2704928d1ec074f1', 'USDC',6),

('0x5f0e07dfee5832faa00c63f2d33a0d79150e8598', 'SEIYAN',6),

('0xc18b6a15fb0ceaf5eb18696eefcb5bc7b9107149', 'POPO',18),

('0x17fe1101af2dab1af0317d1ad1bd66cd06da4b5c', 'SeiPepe',18),

('0x263090d507377f47e944c4da0d4ed2eebecf59dd', 'SeilorV2',18),

('0xc6bc81a0e287cc8103cc002147a9d76cae4cd6e5', 'BALLZ',18),

('0x5cf6826140c1c56ff49c808a1a75407cd1df9423', 'iSEI',6),

('0x71d2115967111a399d5fb619929fa0fda1ee93f7', 'WASB',18),

('0x86fff10d3cd57d0b1e2abb1c21a081c4649c9718', 'SEIMOON',18),

('0x11131ccf0406ad0670f1e1ee37e85b66e8761757', 'Maga',18),

('0x29a1d64f61f333aeac33caf0ee18521002b3cbd2', 'DOB',18),

('0xb684e8fafdf9db710e044780a382d6fe9559f56b','STASH',18),

('0xf1db2416fd551f4b65c978d85efe02c0f14fb5ed','SEIMPLE',18),

('0x47b676e7ebce3b1961658334d4e09e23c87e787e','ROCKET',18),

('0x2556db239c49e7964b9e087b360821473cc6caf8','Ponk',18),

('0xd8549278b3db213f70f9bb3e9c7f5373280769a6','POPO (F2)',6)

) as a (token_address, symbol, decimals)

,

pool_created as (

select

lower('0x' || substr(topics[1]::string, 27, 40) :: string) as token0,

lower('0x' || substr(topics[2]::string, 27, 40) :: string) as token1,

lower('0x' || substr(REGEXP_SUBSTR_ALL(SUBSTR(data, 3, len(data)), '.{64}')[0]::string, 25, 40 ) :: string) as pool_address

from sei.core_evm.fact_event_logs

where topics[0] = '0x0d3648bd0f6ba80134a33ba9275ac585d9d315f0ad8355cddefde31afa28d0e9'

and contract_address = '0x71f6b49ae1558357bbb5a6074f1143c46cbca03d' -- dragonswapfactory

and tx_status = 'SUCCESS'