query-0cc86d6a6e251abeda728a78a832548d

rq turtle/ttl

title:Items containing a specific word that should not be in the value. Sample is based on "Wikidata usage instructions (P2559) property" values. SELECT DISTINCT ?affected_item ?problematic_value WHERE { ?affected_item wdt:P2559 ?problematic_value. FILTER(REGEX(?problematic_value, "(Ctrl\+F|Humble Bundle store)") ). #Words like "Ctrl+F" and "Humble Bundle store" shouldn't be in the values. Just an example. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:Items containing a specific word that should not be in the value. Sample is based on "Wikidata usage instructions (P2559) property" values.
SELECT DISTINCT ?affected_item ?problematic_value WHERE {
  ?affected_item wdt:P2559 ?problematic_value.
  FILTER(REGEX(?problematic_value, "(Ctrl\\+F|Humble Bundle store)") ).               #Words like "Ctrl+F" and "Humble Bundle store" shouldn't be in the values. Just an example.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?affected_item"):::projected v1("?problematic_value"):::projected c4(["bd:serviceParam"]):::iri c6(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["regex(?problematic_value,'(Ctrl\+F|Humble Bundle store)')"]] f0 --> v1 v2 --"wdt:P2559"--> v1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c4 --"wikibase:language"--> c6 end