Wikidata SPARQL query not returning a known match

Asked Dec 26 '17 at 06:27

Active Dec 26 '17 at 06:27

Viewed 37 times

I was playing around on Wikidata trying to write a simple SPARQL query against a known match. I can see from Arnold Schwartzeneggers page that his listed occupations include: Actor, Politician and Restaurater. When I write the simple query:

    #Items that have occupations of actor AND politician AND restauratuer 
    SELECT ?item ?itemLabel WHERE {
           ?item wdt:P106 wd:Q33999.
           ?item wdt:P106 wd:Q82955.
           ?item wdt:P106 wd:Q3427922.

           SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

it returns Clint Eastwood (who also has these occupations) but no Arnold. Can anyone point to any errors in this query?

asked Dec 26 '17 at 06:27

Asderex

1

I.e. just replace all occurences of `wdt:P106` with `p:P106/ps:P106`. – Stanislav Kralin Dec 26 '17 at 07:34
1

In addition to the correct hint of StanislavKralin, feel free to use the "fancy" power of Turtle syntax in SPARQL queries: `?item p:P106/ps:P106 wd:Q33999, wd:Q82955, wd:Q3427922 .` – UninformedUser Dec 26 '17 at 08:08
Yes - that worked. Thank you both for your help on this! – Asderex Dec 26 '17 at 08:39
1

@Asderex, also, `SELECT DISTINCT ... p:P106/ps:P106/(wdt:P279*) ...` gives two more results. – Stanislav Kralin Dec 26 '17 at 08:41
@Stanislav - thanks for the follow up suggestion. These were great pointers for what I should be looking at. – Asderex Dec 29 '17 at 03:05

Wikidata SPARQL query not returning a known match

0 Answers0