query-093b33aaa1f82bb80c35b3413a7a85d2
title: Which chemical structures found in taxon were reassigned (Q116482192)? List deprecated and actual SMILES SELECT ?item ?valueDeprecated ?valueNew ?referenceOld ?referenceNew WHERE { ?item p:P233 ?st, ?st2. ?st ps:P233 ?valueDeprecated; wikibase:rank wikibase:DeprecatedRank; pq:P2241 wd:Q116482192; (prov:wasDerivedFrom/pr:P248) ?referenceOld. ?st2 ps:P233 ?valueNew; wikibase:rank wikibase:PreferredRank; pq:P7452 wd:Q116482192; (prov:wasDerivedFrom/pr:P248) ?referenceNew. FILTER(?referenceOld != ?referenceNew) } LIMIT 100000 title: Which chemical structures found in taxon were reassigned (Q116482192)? List deprecated and actual SMILES SELECT ?item ?valueDeprecated ?valueNew ?referenceOld ?referenceNew WHERE { ?item p:P233 ?st, ?st2. ?st ps:P233 ?valueDeprecated; wikibase:rank wikibase:DeprecatedRank; pq:P2241 wd:Q116482192; (prov:wasDerivedFrom/pr:P248) ?referenceOld. ?st2 ps:P233 ?valueNew; wikibase:rank wikibase:PreferredRank; pq:P7452 wd:Q116482192; (prov:wasDerivedFrom/pr:P248) ?referenceNew. FILTER(?referenceOld != ?referenceNew) } LIMIT 100000 title: Which chemical structures found in taxon were reassigned (Q116482192)? List deprecated and actual SMILES SELECT ?item ?valueDeprecated ?valueNew ?referenceOld ?referenceNew WHERE { ?item p:P233 ?st, ?st2. ?st ps:P233 ?valueDeprecated; wikibase:rank wikibase:DeprecatedRank; pq:P2241 wd:Q116482192; (prov:wasDerivedFrom/pr:P248) ?referenceOld. ?st2 ps:P233 ?valueNew; wikibase:rank wikibase:PreferredRank; pq:P7452 wd:Q116482192; (prov:wasDerivedFrom/pr:P248) ?referenceNew. FILTER(?referenceOld != ?referenceNew) } LIMIT 100000 title: Which chemical structures found in taxon were reassigned (Q116482192)? List deprecated and actual SMILES SELECT ?item ?valueDeprecated ?valueNew ?referenceOld ?referenceNew WHERE { ?item p:P233 ?st, ?st2. ?st ps:P233 ?valueDeprecated; wikibase:rank wikibase:DeprecatedRank; pq:P2241 wd:Q116482192; (prov:wasDerivedFrom/pr:P248) ?referenceOld. ?st2 ps:P233 ?valueNew; wikibase:rank wikibase:PreferredRank; pq:P7452 wd:Q116482192; (prov:wasDerivedFrom/pr:P248) ?referenceNew. FILTER(?referenceOld != ?referenceNew) } LIMIT 100000 title: Which chemical structures found in taxon were reassigned (Q116482192)? List deprecated and actual SMILES SELECT ?item ?valueDeprecated ?valueNew ?referenceOld ?referenceNew WHERE { ?item p:P233 ?st, ?st2. ?st ps:P233 ?valueDeprecated; wikibase:rank wikibase:DeprecatedRank; pq:P2241 wd:Q116482192; (prov:wasDerivedFrom/pr:P248) ?referenceOld. ?st2 ps:P233 ?valueNew; wikibase:rank wikibase:PreferredRank; pq:P7452 wd:Q116482192; (prov:wasDerivedFrom/pr:P248) ?referenceNew. FILTER(?referenceOld != ?referenceNew) } LIMIT 100000 title: Which chemical structures found in taxon were reassigned (Q116482192)? List deprecated and actual SMILES SELECT ?item ?valueDeprecated ?valueNew ?referenceOld ?referenceNew WHERE { ?item p:P233 ?st, ?st2. ?st ps:P233 ?valueDeprecated; wikibase:rank wikibase:DeprecatedRank; pq:P2241 wd:Q116482192; (prov:wasDerivedFrom/pr:P248) ?referenceOld. ?st2 ps:P233 ?valueNew; wikibase:rank wikibase:PreferredRank; pq:P7452 wd:Q116482192; (prov:wasDerivedFrom/pr:P248) ?referenceNew. FILTER(?referenceOld != ?referenceNew) } LIMIT 100000
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
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 pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
#title: Which chemical structures found in taxon were reassigned (Q116482192)? List deprecated and actual SMILES
SELECT ?item ?valueDeprecated ?valueNew ?referenceOld ?referenceNew WHERE {
?item p:P233 ?st, ?st2.
?st ps:P233 ?valueDeprecated;
wikibase:rank wikibase:DeprecatedRank;
pq:P2241 wd:Q116482192;
(prov:wasDerivedFrom/pr:P248) ?referenceOld.
?st2 ps:P233 ?valueNew;
wikibase:rank wikibase:PreferredRank;
pq:P7452 wd:Q116482192;
(prov:wasDerivedFrom/pr:P248) ?referenceNew.
FILTER(?referenceOld != ?referenceNew)
}
LIMIT 100000
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