query-565accb358b8c55a07cd3cb770d29436

rq turtle/ttl

Utsagn på Wikidata med referanse fra dn.no SELECT ?statement ?subject ?subjectLabel ?property ?propertyLabel ?object ?objectLabel ?refURL WITH { SELECT DISTINCT ?subject WHERE { { SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org"; wikibase:api "Generator"; mwapi:generator "exturlusage"; mwapi:geulimit "500"; mwapi:geuquery ".dn.no"; mwapi:geuprotocol "http"; mwapi:geunamespace "0" . ?subject wikibase:apiOutputItem mwapi:title. } } UNION { SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org"; wikibase:api "Generator"; mwapi:generator "exturlusage"; mwapi:geulimit "500"; mwapi:geuquery ".dn.no"; mwapi:geuprotocol "https"; mwapi:geunamespace "0" . ?subject wikibase:apiOutputItem mwapi:title. } } } } AS %i WHERE { INCLUDE %i .

hint:Query hint:optimizer "None".

?subject ?p ?statement . ?statement prov:wasDerivedFrom/pr:P854 ?refURL . FILTER (CONTAINS(str(?refURL), 'dn.no')) .

?property wikibase:claim ?p . ?property wikibase:statementProperty ?ps . ?statement ?ps ?object .

SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } }

Use at

PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Utsagn på Wikidata med referanse fra dn.no
SELECT ?statement ?subject ?subjectLabel ?property ?propertyLabel ?object ?objectLabel ?refURL
WHERE {
   {
  SELECT DISTINCT ?subject
  WHERE {
    {
      SERVICE wikibase:mwapi {
        bd:serviceParam wikibase:endpoint "www.wikidata.org";
          wikibase:api "Generator";
          mwapi:generator "exturlusage";
          mwapi:geulimit "500";
          mwapi:geuquery "*.dn.no";
          mwapi:geuprotocol "http";
          mwapi:geunamespace "0" .
        ?subject wikibase:apiOutputItem mwapi:title.
      }
    } UNION {
      SERVICE wikibase:mwapi {
        bd:serviceParam wikibase:endpoint "www.wikidata.org";
          wikibase:api "Generator";
          mwapi:generator "exturlusage";
          mwapi:geulimit "500";
          mwapi:geuquery "*.dn.no";
          mwapi:geuprotocol "https";
          mwapi:geunamespace "0" .
        ?subject wikibase:apiOutputItem mwapi:title.
      }
    }
  }
}.



  ?subject ?p ?statement .
  ?statement prov:wasDerivedFrom/pr:P854 ?refURL .
  FILTER (CONTAINS(str(?refURL), 'dn.no')) .

  ?property wikibase:claim ?p .
  ?property wikibase:statementProperty ?ps .
  ?statement ?ps ?object .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?object"):::projected v3("?p") v5("?property"):::projected v6("?ps") v1("?refURL"):::projected v4("?statement"):::projected v2("?subject"):::projected a1((" ")) c3(["bd:serviceParam"]):::iri c13(["*.dn.no"]):::literal c20(["https"]):::literal c5(["www.wikidata.org"]):::literal c27(["en"]):::literal c17(["0"]):::literal c11(["500"]):::literal c9(["exturlusage"]):::literal c15(["http"]):::literal c19(["mwapi:title"]):::iri c7(["Generator"]):::literal f0[["contains(str(?refURL),'dn.no')"]] f0 --> v1 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; subgraph s1["http://wikiba.se/ontology#mwapi"] style s1 stroke-width:4px; c3 --"mwapi:endpoint"--> c5 c3 --"mwapi:api"--> c7 c3 --"mwapi:generator"--> c9 c3 --"mwapi:geulimit"--> c11 c3 --"mwapi:geuquery"--> c13 c3 --"mwapi:geuprotocol"--> c20 c3 --"mwapi:geunamespace"--> c17 v2 --"mwapi:apiOutputItem"--> c19 end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; subgraph s1["http://wikiba.se/ontology#mwapi"] style s1 stroke-width:4px; c3 --"mwapi:endpoint"--> c5 c3 --"mwapi:api"--> c7 c3 --"mwapi:generator"--> c9 c3 --"mwapi:geulimit"--> c11 c3 --"mwapi:geuquery"--> c13 c3 --"mwapi:geuprotocol"--> c15 c3 --"mwapi:geunamespace"--> c17 v2 --"mwapi:apiOutputItem"--> c19 end end union0r <== or ==> union0l end v2 -->v3--> v4 v4 --"prov:wasDerivedFrom"--> a1 a1 --"pr:P854"--> v1 v5 --"mwapi:claim"--> v3 v5 --"mwapi:statementProperty"--> v6 v4 -->v6--> v7 subgraph s2["http://wikiba.se/ontology#label"] style s2 stroke-width:4px; c3 --"mwapi:language"--> c27 end