query-faedb40b404b26ac6e97f37567ea7681
Regex search in descriptions
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
SELECT ?item ?desc
WHERE {
?item wdt:P549 ?mgp .
MINUS { ?item wdt:P214 ?viaf . }
#?m wdt:P802 ?item . MINUS { ?m wdt:P1412 ?l . }
?item schema:description ?desc .
FILTER(LANG(?desc) = "en").
#FILTER(STRSTARTS(?desc, "University")).
FILTER(REGEX(?desc, "1[6-7]{1}[0-9]{2}")).
}
Query found at
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/Queries
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/sandbox
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?desc"):::projected
v2("?item"):::projected
v3("?mgp")
v4("?viaf")
f0[["regex(?desc,'1#91;6-7#93;{1}#91;0-9#93;{2}')"]]
f0 --> v1
f1[["?desc = 'en'"]]
f1 --> v1
v2 --"wdt:P549"--> v3
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v2 --"wdt:P214"--> v4
end
v2 --"schema:description"--> v1