sparql-examples

A set of SPARQL examples that are used in different TGX resources

View the Project on GitHub BiGCAT-UM/sparql-examples

056

rq turtle/ttl

Complex aspect: identifiers

Use at

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#>
# tool: scholia
PREFIX target: <http://www.wikidata.org/entity/Q90012272>

SELECT
  ?Identifier ?IdentifierLabel
  ?id (SAMPLE(?idUrls) as ?idUrl)
  ?IdentifierDescription
WITH {
  SELECT ?Identifier ?id ?formatterurl WHERE {
    VALUES ?complex { target: }
    ?complex ?IDdir ?id .
    ?Identifier wikibase:directClaim ?IDdir ;
            wdt:P31/wdt:P279* wd:Q19847637 .
    OPTIONAL {
      ?Identifier wdt:P1630 ?formatterurl .
    }
    FILTER (?Identifier != wd:P233)
    FILTER (?Identifier != wd:P234)
    FILTER (?Identifier != wd:P2017)
  } LIMIT 500
} AS %RESULTS {
  { SELECT * WHERE {
      INCLUDE %RESULTS
      FILTER (?Identifier = wd:P234)
      BIND(IRI(REPLACE(?formatterurl, '\\$1', ENCODE_FOR_URI(str(?id)))) AS ?idUrls).
    }
  } UNION {
    SELECT * WHERE {
      INCLUDE %RESULTS
      FILTER (?Identifier != wd:P234)
      BIND(IRI(REPLACE(?formatterurl, '\\$1', str(?id))) AS ?idUrls).
    }
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}
GROUP BY ?Identifier ?IdentifierLabel ?IdentifierDescription ?id
ORDER BY ASC(?IdentifierLabel)


graph TD