WITH
cointype AS
(SELECT 'TERRA.LUNA' AS coin),
coinspecific AS
(
SELECT DISTINCT asset_address, rune_address
FROM thorchain.stake_events, cointype
WHERE pool_name = coin
),
syms AS
(
SELECT DISTINCT asset_address, rune_address
FROM coinspecific
WHERE (asset_address IS NOT NULL) AND (rune_address IS NOT NULL)
),
assetasyms AS
(
SELECT DISTINCT asset_address
FROM coinspecific
WHERE (rune_address IS NULL)
AND (asset_address NOT IN (SELECT asset_address FROM syms))
),
runeasyms AS
(
SELECT DISTINCT rune_address
FROM coinspecific
WHERE (asset_address IS NULL)
AND (rune_address NOT IN (SELECT rune_address FROM syms))
),
counts AS
(