query-26ad4f523a16b34a45ce95960a7c0fc0
find items with a label in English starting with uppercase
SELECT ?item ?l
{
?item wdt:P31 wd:Q29791211 .
?item rdfs:label ?l . FILTER (lang(?l) = "en" && REGEX(str(?l),"^[A-Z].*") && !CONTAINS(str(?l),"American football") && !CONTAINS(str(?l),"Australian rules") )
}
ORDER BY ?l
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#>
#find items with a label in English starting with uppercase
SELECT ?item ?l
{
?item wdt:P31 wd:Q29791211 .
?item rdfs:label ?l . FILTER (lang(?l) = "en" && REGEX(str(?l),"^[A-Z].*") && !CONTAINS(str(?l),"American football") && !CONTAINS(str(?l),"Australian rules") )
}
ORDER BY ?l
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item"):::projected
v1("?l"):::projected
c6(["wd:Q29791211"]):::iri
f0[["?l = 'en'regex(str(?l),'^#91;A-Z#93;.*')not contains(str(?l),'American football')not contains(str(?l),'Australian rules')"]]
f0 --> v1
v2 --"wdt:P31"--> c6
v2 --"rdfs:label"--> v1