query-7d6cfdae8513e729846bade00879c84a

rq turtle/ttl

Obviamente se pueden añadir más condiciones a la consulta. Y otro ejemplo que me pasan por Telegram que no sé realmente interpretar pq a esta hora estoy empanao :-)

Use at

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

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
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/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select distinct ?item ?itemLabel {
  ?a ?p1 wd:Q1631944.

  # ignore sitelinks
  minus { ?a schema:about wd:Q1631944 }

  # if ?a is a statement node (has a rank), ?p1 is a predicate like ps: or pq:
  # so select triples which use the statement node as a value (?p2 is a p: predicate)
  optional {
    ?a wikibase:rank [].
    ?b ?p2 ?a.
  }

  # if ?a is a reference node, a statement node links to it using prov:wasDerivedFrom
  # again, select triples which use the statement node as a value
  optional {
    ?c ?p3 [ prov:wasDerivedFrom ?a ].
  }

  # assign ?item to the first assigned value out of ?b (ps:/pq:), ?c (pr:) and ?a (wdt: and any cases not caught by the previous two)
  bind (coalesce(?b, ?c, ?a) as ?item)

  service wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} order by ?itemLabel ?item

Query found at

• https://www.wikidata.org/wiki/User:Olea/Ejemplos_de_consultas_WDQS