query-3aff0a8a7b70673f9602fa3a480180f8

rq turtle/ttl

People not using he/she as a pronoun

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?itemLabel ?item ?pronounDisplay ?pronoun
WHERE
{
    ?item wdt:P31 wd:Q5 .

    ?item wdt:P6553 ?pronoun .

    # L484 => she
    FILTER ( ?pronoun != wd:L484 ) .

    # L485 => he
    FILTER ( ?pronoun != wd:L485 ) .

    ?pronoun wikibase:lemma ?label .

    # get the language of the lexem
    BIND( LANG(?label) AS ?language )

    # create a string to display
    BIND(CONCAT(STR(?label), " [", STR(?language), "]") AS ?pronounDisplay)

    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}

ORDER BY ?itemLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?item"):::projected v1("?itemLabel"):::projected v4("?label") v5("?language") v2("?pronoun"):::projected v6("?pronounDisplay"):::projected c8(["bd:serviceParam"]):::iri c4(["wd:Q5"]):::iri c10(["en"]):::literal f0[["?pronoun != 'wd:L485'"]] f0 --> v2 f1[["?pronoun != 'wd:L484'"]] f1 --> v2 v3 --"wdt:P31"--> c4 v3 --"wdt:P6553"--> v2 v2 --"wikibase:lemma"--> v4 bind2[/"?label"/] v4 --o bind2 bind2 --as--o v5 bind3[/"concat(str(?label),' #91;',str(?language),'#93;')"/] v4 --o bind3 v5 --o bind3 bind3 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end