Wikidata SPARQL: Get Property Value

Question

I used the query builder to find all instances where property Q1902is available. A portion of the query returned by the builder is:

SELECT DISTINCT ?item ?statement0 WHERE {
  ?item p:P1902 ?statement0.
  ?statement0 (ps:P1902) _:anyValueP1902.
}
LIMIT 100

How can I get the actual value (or label) of the property returned in the query rather than the link to it?

Answer 1

You need a variable (instead of a blank node) in place of the value. Currently, you are only querying if a value exists. With a variable, you can get the value in the results.

SELECT DISTINCT ?item ?statement0 ?value
WHERE {
  ?item p:P1902 ?statement0 .
  ?statement0 ps:P1902 ?value .
}
LIMIT 100

If you are not interested in the ?statement0 instances, you can use a sequence path:

SELECT DISTINCT ?item ?value
WHERE {
  ?item p:P1902/ps:P1902 ?value .
}
LIMIT 100