query-0ad0efd9e1b97396346513875ae4cf45
Fixing descriptions with a certain errorI am trying to fix an error with Bengali descriptions that was propagated by those using namescript.js, namely the change from the incorrect "পারিবারিক নামাম" to the correct "পারিবারিক নাম". I have this query, which should list those family name items with the faulty description, but it has timed out as written and in several of its previous revisions:
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select ?item ?itemLabel ?description where {
?item wdt:P31 wd:Q101352.
?item schema:description ?description.
filter(lang(?description) = "bn" && regex(str(?description), "পারিবারিক নামাম.*"))
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],bn,en". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?description"):::projected
v2("?item"):::projected
c4(["wd:Q101352"]):::iri
c7(["bd:serviceParam"]):::iri
c9(["#91;AUTO_LANGUAGE#93;,bn,en"]):::literal
f0[["?description = 'bn'regex(str(?description),'পারিবারিক নামাম.*')"]]
f0 --> v1
v2 --"wdt:P31"--> c4
v2 --"schema:description"--> v1
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end