query-4708f2c54b5d84e964c275fbc2e62e49

rq turtle/ttl

title:scholarly papers by University of Leeds researchers in White Rose repository with a free licence SELECT DISTINCT ?paper ?paperLabel ?licenceLabel ?fulltext WHERE { ?author wdt:P108 wd:Q503424. # Employee of University of Leeds ?paper wdt:P31 wd:Q13442814; wdt:P50 ?author. # scholarly article by this author VALUES ?freelicence {wd:Q6905323 wd:Q6905942} # CC-BY or CC-BY-SA ?paper wdt:P275 ?licence . ?licence wdt:P629? ?freelicence. # Article has this licence, or a specific edition such as CC-BY 3.0 ?paper wdt:P953 ?fulltext FILTER(CONTAINS(STR(?fulltext), "whiterose.ac.uk")) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en"} } ORDER BY ?paper

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:scholarly papers by University of Leeds researchers in White Rose repository with a free licence
SELECT DISTINCT ?paper ?paperLabel ?licenceLabel ?fulltext WHERE {
  ?author wdt:P108 wd:Q503424.   # Employee of University of Leeds
  ?paper wdt:P31 wd:Q13442814; wdt:P50 ?author.   # scholarly article by this author
  VALUES ?freelicence {wd:Q6905323 wd:Q6905942}   # CC-BY or CC-BY-SA
  ?paper wdt:P275 ?licence . ?licence wdt:P629? ?freelicence.  # Article has this licence, or a specific edition such as CC-BY 3.0
  ?paper wdt:P953 ?fulltext FILTER(CONTAINS(STR(?fulltext), "whiterose.ac.uk"))
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en"}
} ORDER BY ?paper

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?author") v4("?freelicence") v2("?fulltext"):::projected v5("?licence") v1("?paper"):::projected c13(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal c5(["wd:Q13442814"]):::iri c11(["bd:serviceParam"]):::iri c3(["wd:Q503424"]):::iri f0[["contains(str(?fulltext),'whiterose.ac.uk')"]] f0 --> v2 v3 --"wdt:P108"--> c3 v1 --"wdt:P31"--> c5 v1 --"wdt:P50"--> v3 bind1[/VALUES ?freelicence/] bind1-->v4 bind10(["wd:Q6905323"]) bind10 --> bind1 bind11(["wd:Q6905942"]) bind11 --> bind1 v1 --"wdt:P275"--> v5 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v5 --"wdt:P629"--> v4 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; end union0r <== or ==> union0l end v1 --"wdt:P953"--> v2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end