query-7c0a84f33e7a8e53cb8fff0d8658c060

rq turtle/ttl

Norwegian properties SELECT ?itemLabel ?itemDescription ?regex1 ?regex2 ?item #?modified (URI(CONCAT("https://www.wikidata.org/wiki/Property_talk:", SUBSTR(STR(?item), 32))) AS ?talkpage) #(URI(CONCAT("https://www.wikidata.org/wiki/Wikidata:Database_reports/Constraint_violations/", SUBSTR(STR(?item), 32))) AS ?crep) #(URI(CONCAT("https://www.wikidata.org/wiki/Wikidata:Database_reports/Complex_constraint_violations/", SUBSTR(STR(?item), 32))) AS ?ccrep) WHERE { ?item rdf:type wikibase:Property; wikibase:propertyType wikibase:ExternalId; wdt:P17 wd:Q20; schema:dateModified ?modified. OPTIONAL { ?item wdt:P1793 ?regex1 . } OPTIONAL { ?item p:P2302 ?cst . ?cst a wikibase:BestRank . ?cst ps:P2302 wd:Q21502404 . ?cst pq:P1793 ?regex2 . } SERVICE wikibase:label { bd:serviceParam wikibase:language "nb,en". } } ORDER BY xsd:integer(SUBSTR(STR(?item), 33))

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Norwegian properties
SELECT
  ?itemLabel ?itemDescription ?regex1 ?regex2 ?item #?modified
  (URI(CONCAT("https://www.wikidata.org/wiki/Property_talk:", SUBSTR(STR(?item), 32))) AS ?talkpage)
  #(URI(CONCAT("https://www.wikidata.org/wiki/Wikidata:Database_reports/Constraint_violations/", SUBSTR(STR(?item), 32))) AS ?crep)
  #(URI(CONCAT("https://www.wikidata.org/wiki/Wikidata:Database_reports/Complex_constraint_violations/", SUBSTR(STR(?item), 32))) AS ?ccrep)
WHERE {
  ?item rdf:type wikibase:Property;
    wikibase:propertyType wikibase:ExternalId;
    wdt:P17 wd:Q20;
    schema:dateModified ?modified.
  OPTIONAL { ?item wdt:P1793 ?regex1 . }
  OPTIONAL {
    ?item p:P2302 ?cst .
    ?cst a wikibase:BestRank .
    ?cst ps:P2302 wd:Q21502404 .
    ?cst pq:P1793 ?regex2 .
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "nb,en". }
}
ORDER BY xsd:integer(SUBSTR(STR(?item), 33))

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?cst") v1("?item"):::projected v2("?modified") v3("?regex1"):::projected v5("?regex2"):::projected v6("?talkpage") c3(["wikibase:Property"]):::iri c7(["wd:Q20"]):::iri c11(["wikibase:BestRank"]):::iri c5(["wikibase:ExternalId"]):::iri c16(["bd:serviceParam"]):::iri c18(["nb,en"]):::literal c13(["wd:Q21502404"]):::iri v1 --"a"--> c3 v1 --"wikibase:propertyType"--> c5 v1 --"p:direct/P17"--> c7 v1 --"schema:dateModified"--> v2 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v1 -."p:direct/P1793".-> v3 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v1 -."p:P2302".-> v4 v4 --"a"--> c11 v4 --"p:statement/P2302"--> c13 v4 --"p:qualifier/P1793"--> v5 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c16 --"wikibase:language"--> c18 end bind0[/"concat('https://www.wikidata.org/wiki/Property_talk:',substring(str(?item),'32^^xsd:integer'))"/] v1 --o bind0 bind0 --as--o v6