query-bae8675ae082049da6a92b611dce9ed0
Middle name finder. Check for string in label of human, not at end of label. Nationality condition to limit search. SELECT ?item ?itemLabel ?test WHERE {?item wdt:P31 wd:Q5; wdt:P27 wd:Q174193. ?item rdfs:label ?itemLabel . FILTER (lang(?itemLabel) = "en") FILTER(CONTAINS(str(?itemLabel), 'Burrowes')) BIND(STRENDS(str(?itemLabel), 'Burrowes') AS ?test) } LIMIT 5
Use at
- https://query.wikidata.org/sparql
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#>
#Middle name finder. Check for string in label of human, not at end of label. Nationality condition to limit search.
SELECT ?item ?itemLabel ?test
WHERE {?item wdt:P31 wd:Q5;
wdt:P27 wd:Q174193.
?item rdfs:label ?itemLabel .
FILTER (lang(?itemLabel) = "en")
FILTER(CONTAINS(str(?itemLabel), 'Burrowes'))
BIND(STRENDS(str(?itemLabel), 'Burrowes') AS ?test)
}
LIMIT 5
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item"):::projected
v1("?itemLabel"):::projected
v3("?test"):::projected
c6(["wd:Q174193"]):::iri
c4(["wd:Q5"]):::iri
f0[["contains(str(?itemLabel),'Burrowes')"]]
f0 --> v1
f1[["?itemLabel = 'en'"]]
f1 --> v1
v2 --"wdt:P31"--> c4
v2 --"wdt:P27"--> c6
v2 --"rdfs:label"--> v1
bind2[/"ends-with(str(?itemLabel),'Burrowes')"/]
v1 --o bind2
bind2 --as--o v3