051

• License: https://www.gnu.org/licenses/gpl-3.0

• Uses method in: https://github.com/WDscholia/scholia/tree/master/scholia/app/templates/chemical_structural-identifiers.sparql

rq turtle/ttl

Chemical aspect: structural identifiers for this chemical structure

Use at

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

PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://wikidata.org/entity/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX target: <http://www.wikidata.org/entity/Q2270>

# title: structural identifiers for this chemical structure
SELECT
  ?Structural_identifier ?Structural_identifierLabel
  ?idLit (SAMPLE(?idUrls) as ?idUrl)
WITH {
  SELECT ?Structural_identifier ?idLit ?formatterurl WHERE {
    VALUES ?Structural_identifier { wd:P233 wd:P234 wd:P2017 }
    target: ?IDdir ?idLit .
    ?Structural_identifier wikibase:directClaim ?IDdir ;
            wdt:P31 wd:Q19833835 .
    OPTIONAL {
      ?Structural_identifier wdt:P1630 ?formatterurl .
    }
  } LIMIT 500
} AS %RESULTS {
  INCLUDE %RESULTS
  BIND(IRI(REPLACE(?formatterurl, '\\$1', str(?idLit))) AS ?idUrls).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}
GROUP BY ?Structural_identifier ?Structural_identifierLabel ?idLit
ORDER BY ASC(?ID_TypeLabel)

graph TD