community AS (

SELECT

nft_to_address AS user

FROM

ethereum.core.ez_nft_transfers

WHERE

project_name IS NOT NULL

AND nft_to_address NOT LIKE '0x00000%'

),

social_users AS (

SELECT DISTINCT

nft_to_address AS user,

'Lens' AS project_name,

'Social' AS category,

'Polygon' AS chain

FROM

polygon.core.ez_nft_transfers

WHERE

nft_address LIKE LOWER('0xDb46d1Dc155634FbC732f92E853b10B288AD5a1d')

UNION ALL

SELECT DISTINCT

from_address AS user,

'Cyberconnect' AS project_name,

'Social' AS category,

'BSC' AS chain

FROM

bsc.core.fact_transactions

WHERE

to_address LIKE LOWER('0x2723522702093601e6360CAe665518C4f63e9dA6')

UNION ALL

SELECT DISTINCT

from_address AS user,

'Cyberconnect' AS project_name,

'Social' AS category,