query-e70abfedb1569710bfdeef879af6b32a

rq turtle/ttl

title: Wikidata properties which English label contains "user" or account without being set to "Wikidata property to identify online accounts" SELECT DISTINCT ?prop ?propLabel WHERE { ?prop wdt:P31/wdt:P279 wd:Q18616576 . MINUS { ?prop wdt:P31 wd:Q105388954 } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?prop rdfs:label ?propLabelP }

FILTER(CONTAINS(?propLabel, "user")|| CONTAINS(?propLabel, "account")) }

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Wikidata properties which English label contains "user" or account without being set to "Wikidata property to identify online accounts"
SELECT DISTINCT ?prop ?propLabel WHERE {
  ?prop wdt:P31/wdt:P279 wd:Q18616576 .
  MINUS { ?prop wdt:P31 wd:Q105388954 }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    ?prop rdfs:label ?propLabelP
  }

  FILTER(CONTAINS(?propLabel, "user")|| CONTAINS(?propLabel, "account"))
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?prop"):::projected v1("?propLabel"):::projected v3("?propLabelP") a1((" ")) c6(["wd:Q105388954"]):::iri c8(["bd:serviceParam"]):::iri c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal c5(["wd:Q18616576"]):::iri f0[["(contains(?propLabel,'user') || contains(?propLabel,'account'))"]] f0 --> v1 v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c5 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v2 --"wdt:P31"--> c6 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 v2 --"rdfs:label"--> v3 end