query-101cfd88dd98c18b4c60adc5942a11bf

rq turtle/ttl

Propertiesauthor (P50)found in taxon (P703)stated in (P248) Propertiesauthor (P50)found in taxon (P703)stated in (P248) Propertiesauthor (P50)found in taxon (P703)stated in (P248) Propertiesauthor (P50)found in taxon (P703)stated in (P248) Propertiesauthor (P50)found in taxon (P703)stated in (P248) Propertiesauthor (P50)found in taxon (P703)stated in (P248)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: How many structures found in taxon have been referenced by certain authors? (Here, two senior natural products chemists are compared to the late Ferdinand Bohlmann)
#defaultView:BarChart
SELECT ?authors_namesLabel (COUNT(DISTINCT(?compound)) AS ?count) WHERE {
  ?compound p:P703/prov:wasDerivedFrom/pr:P248 ?art.  # Get the references
  VALUES ?authors_names {
    wd:Q56084663                                      # JLW
    wd:Q40259636                                      # GFP
    wd:Q1405133                                       # A german chemist of the 20th century ... Ferdinand Bohlmann
  }
  ?art wdt:P50 ?authors_names.                        # Limit to references containing the author
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?authors_namesLabel
ORDER BY DESC (?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?art") v4("?authors_names") v2("?compound"):::projected v5("?count") a1((" ")) a2((" ")) c6(["bd:serviceParam"]):::iri c8(["#91;AUTO_LANGUAGE#93;,en"]):::literal v2 --"p:P703"--> a1 a1 --"prov:wasDerivedFrom"--> a2 a2 --"p:reference/P248"--> v3 bind0[/VALUES ?authors_names/] bind0-->v4 bind00(["wd:Q56084663"]) bind00 --> bind0 bind01(["wd:Q40259636"]) bind01 --> bind0 bind02(["wd:Q1405133"]) bind02 --> bind0 v3 --"p:direct/P50"--> v4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 end bind2[/"count(?compound)"/] v2 --o bind2 bind2 --as--o v5