query-a9cb700b2ac4a85b4e5b82c840a66391
Strange items from DACS
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?item ?enLabel ?nlLabel ?frLabel ?caLabel WHERE {
?item wdt:P4663 [] .
?item wikibase:sitelinks 0 .
OPTIONAL { ?item rdfs:label ?enLabel . FILTER(lang(?enLabel) = "en") }
OPTIONAL { ?item rdfs:label ?nlLabel . FILTER(lang(?nlLabel) = "nl") }
OPTIONAL { ?item rdfs:label ?frLabel . FILTER(lang(?frLabel) = "fr") }
OPTIONAL { ?item rdfs:label ?caLabel . FILTER(lang(?caLabel) = "ca") }
FILTER(REGEX(COALESCE(?enLabel, ""), "^[A-Z][a-z]*[A-Z]") ||
REGEX(COALESCE(?nlLabel, ""), "^[A-Z][a-z]*[A-Z]") ||
REGEX(COALESCE(?frLabel, ""), "^[A-Z][a-z]*[A-Z]") ||
REGEX(COALESCE(?caLabel, ""), "^[A-Z][a-z]*[A-Z]"))
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?caLabel"):::projected
v1("?enLabel"):::projected
v3("?frLabel"):::projected
v5("?item"):::projected
v2("?nlLabel"):::projected
a1((" "))
c9(["0^^xsd:integer"]):::literal
f0[["(regex(?enLabel'','^#91;A-Z#93;#91;a-z#93;*#91;A-Z#93;') || (regex(?nlLabel'','^#91;A-Z#93;#91;a-z#93;*#91;A-Z#93;') || (regex(?frLabel'','^#91;A-Z#93;#91;a-z#93;*#91;A-Z#93;') || regex(?caLabel'','^#91;A-Z#93;#91;a-z#93;*#91;A-Z#93;'))))"]]
f0 --> v1
f0 --> v2
f0 --> v3
f0 --> v4
v5 --"wdt:P4663"--> a1
v5 --"wikibase:sitelinks"--> c9
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v5 -."rdfs:label".-> v1
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v5 -."rdfs:label".-> v2
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v5 -."rdfs:label".-> v3
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v5 -."rdfs:label".-> v4
end