WITH custom_labels AS (

--SELECT '51LAUnnqk8PTPribSTRb5rmF867dz5mEQbpxfk13Nu1C' AS address, 'custom' AS label_type, 'subtype' AS LABEL_SUBTYPE, 'Phoenix DEX' AS label

--UNION ALL

SELECT 'CPK8fQYShAmERZmysQRAGWPvV5qs3AvazQsiR9ctC6ED' AS address, 'custom' AS label_type, 'subtype' AS LABEL_SUBTYPE, 'Raydium' AS label

UNION ALL

SELECT 'GtKKKs3yaPdHbQd2aZS4SfWhy8zQ988BJGnKNndLxYsN', 'custom', 'subtype', 'Raydium'

UNION ALL

SELECT 'G7mw1d83ismcQJKkzt62Ug4noXCjVhu3eV7U5EMgge6Z', 'custom', 'subtype', 'Raydium'

UNION ALL

SELECT 'Dwq4PxyBQ8dHPmP5u5H7bHsjHp46StGtkSy2gEVedDm', 'custom', 'subtype', 'Raydium'

UNION ALL

SELECT 'HVNwzt7Pxfu76KHCMQPTLuTCLTm6WnQ1esLv4eizseSv', 'custom', 'subtype', 'Raydium'

UNION ALL

SELECT 'DxibGjCDKBmsFpisqxYYRrpx9R22eb1yzSePc3vSXjEZ', 'custom', 'subtype', 'Lifinity'

UNION ALL

SELECT 'GBMoNx84HsFdVK63t8BZuDgyZhSBaeKWB4pHHpoeRM9z', 'custom', 'subtype', 'Phoenix'

UNION ALL

SELECT 'FicF181nDsEcasznMTPp9aLa5Rbpdtd11GtSEa1UUWzx', 'custom', 'subtype', 'Phoenix'

), wallets as (

SELECT

address,

label_type,

LABEL_SUBTYPE,

label

FROM solana.core.dim_labels

WHERE label_type IN ('dex')

UNION ALL

SELECT

address,

label_type,