query-a9cb700b2ac4a85b4e5b82c840a66391

rq turtle/ttl

Strange items from DACS

Use at

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