# DEI advocates data

match 
    (wallet:Wallet)-[:HAS_BALANCE]->(token:Token)-[:_HAS_MEMBERSHIP_TOKEN]-(element:_Element {_communityId: "porCom038b30"})
match
    (wallet:Wallet)-[r:_HAS_CONTEXT]->(wic:_Context:_Dei)-[:_HAS_CONDITION]-(condition:_Condition)
with 
    condition._displayName as category,
    count(distinct(wallet)) as count_wallets
with 
    collect(distinct({
        category: category,
        count_wallets: count_wallets
    })) as dei_advocates_data
match 
    (dei:Wallet)-[:HAS_BALANCE]->(token:Token)-[:_HAS_MEMBERSHIP_TOKEN]-(element:_Element {_communityId: "porCom038b30"})
match
    (dei:Wallet)-[r:_HAS_CONTEXT]->(wic:_Context:_Dei)-[:_HAS_CONDITION]-(condition:_Condition)
with
    count(distinct(dei)) as count_all, dei_advocates_data


return 
{
    dei_advocates_data: dei_advocates_data,
    count_dei_advocates: count_all
}

## Aligned communities

match
    (wallet:Wallet)-[r:HAS_BALANCE]-(token:Token)-[:_HAS_MEMBERSHIP_TOKEN]-(element:_Element {_communityId: $_communityId})
match 
    (wallet:Wallet)-[:_HAS_CONTEXT]->(context:_Context:_Dei)
where not
    (wallet)-[:_HAS_CONTEXT]->(:_IncentiveFarming)
with 
    wallet 
match  
    (wic:_Dei)
match 
    (wallet)-[]-(proposal:Proposal)-[:_HAS_CONTEXT]-(wic)
match
    (proposal)-[:_HAS_PROPOSAL]-(e:Entity)
with 
    e.name as entity, 
    count(distinct(wallet)) as count_wallets
with 
    collect(distinct({
        entity: entity, 
        count_wallets: count_wallets
    })) as aligned_communities_data
return 
    {
        aligned_communities_data: aligned_communities_data
    }

## Languages spoken

match 
    (wallet:Wallet)-[r:HAS_BALANCE]->(token:Token)-[:_HAS_MEMBERSHIP_TOKEN]-(element:_Element {_communityId: $communityId})
match
    (wallet:Wallet)-[:_HAS_CONTEXT->(wic:_Language)
with 
    wic.language as language, 
    count(distinct(wallet)) as count_wallets 
with 
    collect(distinct({
        language: language, 
        count_wallets: count_wallets
    })) as language_data
return 
    {
        language_data: language_data
    }