query-9ec9aa9e4afb3b14e4c385241757a492
title: Which are the available referenced structure-organism pairs on Wikidata? (with P1582 and not P703 we are using) SELECT DISTINCT (REPLACE(STR(?item), ".Q", "Q") AS ?qid) (REPLACE(STR(?taxon), ".Q", "Q") AS ?P703) (REPLACE(STR(?art), ".Q", "Q") AS ?S248) WHERE { VALUES ?classes { wd:Q113145171 wd:Q59199015 } ?item wdt:P31 ?classes. { ?item p:P1582 ?stmt. ?stmt ps:P1582 ?taxon; prov:wasDerivedFrom ?ref. ?ref pr:P248 ?art. } } LIMIT 1000 title: Which are the available referenced structure-organism pairs on Wikidata? (with P1582 and not P703 we are using) SELECT DISTINCT (REPLACE(STR(?item), ".Q", "Q") AS ?qid) (REPLACE(STR(?taxon), ".Q", "Q") AS ?P703) (REPLACE(STR(?art), ".Q", "Q") AS ?S248) WHERE { VALUES ?classes { wd:Q113145171 wd:Q59199015 } ?item wdt:P31 ?classes. { ?item p:P1582 ?stmt. ?stmt ps:P1582 ?taxon; prov:wasDerivedFrom ?ref. ?ref pr:P248 ?art. } } LIMIT 1000 title: Which are the available referenced structure-organism pairs on Wikidata? (with P1582 and not P703 we are using) SELECT DISTINCT (REPLACE(STR(?item), ".Q", "Q") AS ?qid) (REPLACE(STR(?taxon), ".Q", "Q") AS ?P703) (REPLACE(STR(?art), ".Q", "Q") AS ?S248) WHERE { VALUES ?classes { wd:Q113145171 wd:Q59199015 } ?item wdt:P31 ?classes. { ?item p:P1582 ?stmt. ?stmt ps:P1582 ?taxon; prov:wasDerivedFrom ?ref. ?ref pr:P248 ?art. } } LIMIT 1000 title: Which are the available referenced structure-organism pairs on Wikidata? (with P1582 and not P703 we are using) SELECT DISTINCT (REPLACE(STR(?item), ".Q", "Q") AS ?qid) (REPLACE(STR(?taxon), ".Q", "Q") AS ?P703) (REPLACE(STR(?art), ".Q", "Q") AS ?S248) WHERE { VALUES ?classes { wd:Q113145171 wd:Q59199015 } ?item wdt:P31 ?classes. { ?item p:P1582 ?stmt. ?stmt ps:P1582 ?taxon; prov:wasDerivedFrom ?ref. ?ref pr:P248 ?art. } } LIMIT 1000 title: Which are the available referenced structure-organism pairs on Wikidata? (with P1582 and not P703 we are using) SELECT DISTINCT (REPLACE(STR(?item), ".Q", "Q") AS ?qid) (REPLACE(STR(?taxon), ".Q", "Q") AS ?P703) (REPLACE(STR(?art), ".Q", "Q") AS ?S248) WHERE { VALUES ?classes { wd:Q113145171 wd:Q59199015 } ?item wdt:P31 ?classes. { ?item p:P1582 ?stmt. ?stmt ps:P1582 ?taxon; prov:wasDerivedFrom ?ref. ?ref pr:P248 ?art. } } LIMIT 1000 title: Which are the available referenced structure-organism pairs on Wikidata? (with P1582 and not P703 we are using) SELECT DISTINCT (REPLACE(STR(?item), ".Q", "Q") AS ?qid) (REPLACE(STR(?taxon), ".Q", "Q") AS ?P703) (REPLACE(STR(?art), ".Q", "Q") AS ?S248) WHERE { VALUES ?classes { wd:Q113145171 wd:Q59199015 } ?item wdt:P31 ?classes. { ?item p:P1582 ?stmt. ?stmt ps:P1582 ?taxon; prov:wasDerivedFrom ?ref. ?ref pr:P248 ?art. } } LIMIT 1000
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
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? (with P1582 and not P703 we are using)
SELECT DISTINCT (REPLACE(STR(?item), ".*Q", "Q") AS ?qid) (REPLACE(STR(?taxon), ".*Q", "Q") AS ?P703) (REPLACE(STR(?art), ".*Q", "Q") AS ?S248) WHERE {
VALUES ?classes {
wd:Q113145171
wd:Q59199015
}
?item wdt:P31 ?classes.
{
?item p:P1582 ?stmt.
?stmt ps:P1582 ?taxon;
prov:wasDerivedFrom ?ref.
?ref pr:P248 ?art.
}
}
LIMIT 1000
Query found at
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products/de
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products/en
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products/fr
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products/it
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products/nl
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chemistry_Natural_products/ru