query-1ca07a63fccbf1207a4d8edeb43f0cff

rq turtle/ttl

PropertiesDOI (P356)stated in (P248)nature of statement (P5102)sourcing circumstances (P1480)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
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#>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?subjectLabel ?predicateLabel ?objectLabel ?qualifier ?source_doi WHERE {
  VALUES ?subject {wd:Q84263196 wd:Q82069695 wd:Q81068910}
  VALUES ?qual {pq:P5102 pq:P1480}
  ?subject ?p [?prop ?object; ?qual ?nos].
  ?object rdfs:label ?objectLabel.
  FILTER(LANG(?objectLabel)="en")
  FILTER(?object != ?nos)
  ?predicate wikibase:claim ?p.
  OPTIONAL {
    ?subject ?p ?statement.
    ?statement ?p1 ?object.
    ?statement (prov:wasDerivedFrom/pr:P248) ?source.
    ?source wdt:P356 ?source_doi. 
  }
  BIND(IF(?qual = pq:P5102, "Nature of statement", "Sourcing circumstances") AS ?qualifier).
  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; v2("?nos") v1("?object") v3("?objectLabel"):::projected v7("?p") v10("?p1") v8("?predicate") v6("?prop") v5("?qual") v13("?qualifier"):::projected v11("?source") v12("?source_doi"):::projected v9("?statement") v4("?subject") a1((" ")) a2((" ")) c8(["bd:serviceParam"]):::iri c1(["en"]):::literal f0[["?object != ?nos"]] f0 --> v1 f0 --> v2 f1[["?objectLabel = 'en'"]] f1 --> v3 bind2[/VALUES ?subject/] bind2-->v4 bind20(["wd:Q84263196"]) bind20 --> bind2 bind21(["wd:Q82069695"]) bind21 --> bind2 bind22(["wd:Q81068910"]) bind22 --> bind2 bind3[/VALUES ?qual/] bind3-->v5 bind30(["pq:P5102"]) bind30 --> bind3 bind31(["pq:P1480"]) bind31 --> bind3 a1 -->v6--> v1 a1 -->v5--> v2 v4 -->v7--> a1 v1 --"rdfs:label"--> v3 v8 --"wikibase:claim"--> v7 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -->v7--> v9 v9 -->v10--> v1 v9 -."prov:wasDerivedFrom".-> a2 a2 --"pr:P248"--> v11 v11 --"wdt:P356"--> v12 end bind4[/"if(?qual = 'pq:P5102','Nature of statement','Sourcing circumstances')"/] v5 --o bind4 bind4 --as--o v13 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c1 end