query-d5639ab7aff9eccfdac76cae06b4f7ab

rq turtle/ttl

External ID vs. reference URL (P854)

Use at

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

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
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/>
SELECT ?item ?id ?taxonName ?urlAsSource ?importedFromWikimediaProject ?statedIn WHERE {
      ?item wdt:P225 ?taxonName .
      ?item p:P685/ps:P685 ?id .
      ?item p:P685 ?idStatement .      
      ?idStatement prov:wasDerivedFrom ?ref . 
      OPTIONAL {?ref pr:P854 ?urlAsSource} .
      OPTIONAL {?ref pr:P143 ?importedFromWikimediaProject} .
      OPTIONAL {?ref pr:P248 ?statedIn} . 
      BIND(str(?urlAsSource) as ?urlAsSourceString)
      FILTER(!bound(?statedIn))
      FILTER(strStarts(?urlAsSourceString, "https://www.ncbi.nlm.nih.gov/"))
      #FILTER(bound(?statedIn) && !sameTerm(?statedIn, wd:Q13711410))
}
ORDER BY ASC(xsd:integer(?id)) ASC(?taxonName)

Query found at

• https://www.wikidata.org/wiki/User:Succu/SPARQL