SELECT * FROM arbitrum.core.dim_labels WHERE label_type = 'dapp'
UNION
SELECT * FROM avalanche.core.dim_labels WHERE label_type = 'dapp'
UNION
SELECT * FROM bsc.core.dim_labels WHERE label_type = 'dapp'
UNION
SELECT * FROM ethereum.core.dim_labels WHERE label_type = 'dapp'
UNION
SELECT * FROM gnosis.core.dim_labels WHERE label_type = 'dapp'
UNION
SELECT * FROM optimism.core.dim_labels WHERE label_type = 'dapp'
UNION
SELECT * FROM polygon.core.dim_labels WHERE label_type = 'dapp'
UNION
SELECT * FROM solana.core.dim_labels WHERE label_type = 'dapp';