query-abff0591f32394332c25b9257b353519

rq turtle/ttl

title: Which are the available referenced structure-organism pairs on Wikidata? (limited to 1mio) SELECT DISTINCT ?structure ?taxon ?reference WHERE { ?structure p:P235 []; p:P703 [ ps:P703 ?taxon; (prov:wasDerivedFrom/pr:P248) ?reference; wikibase:rank wikibase:NormalRank; ] . hint:Prior hint:rangeSafe true. } LIMIT 1000000

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
#title: Which are the available referenced structure-organism pairs on Wikidata? (limited to 1mio)
SELECT DISTINCT ?structure ?taxon ?reference WHERE {
  ?structure p:P235 [];
    p:P703 [
      ps:P703 ?taxon;
              (prov:wasDerivedFrom/pr:P248) ?reference;
              wikibase:rank wikibase:NormalRank;
    ] . 
}
LIMIT 1000000

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products