query-ed448f0170ebce56b7e6cf589c746090

rq turtle/ttl

title:Video game items with Steam Deck "playable" rating SELECT DISTINCT ?video_game ?item ?statement WHERE { ?item (wdt:P31/(wdt:P279*)) wd:Q7889; p:P8956 ?statement. FILTER(EXISTS { ?statement pq:P1552 wd:Q117413405. }) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?item rdfs:label ?video_game. } } ORDER BY (UCASE(STR(?video_game)))

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:Video game items with Steam Deck "playable" rating
SELECT DISTINCT ?video_game ?item ?statement WHERE {
  ?item (wdt:P31/(wdt:P279*)) wd:Q7889;
  p:P8956 ?statement.
  FILTER(EXISTS { ?statement pq:P1552 wd:Q117413405. })
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    ?item rdfs:label ?video_game.
  }
}
ORDER BY (UCASE(STR(?video_game)))

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?item"):::projected v2("?statement"):::projected v1("?video_game"):::projected a1((" ")) c8(["bd:serviceParam"]):::iri c5(["wd:Q7889"]):::iri c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal c2(["wd:Q117413405"]):::iri f0[[" "]] subgraph f0e0["Exists Clause"] e0v1 --"p:qualifier/P1552"--> e0c2 e0v1("?statement"):::projected e0c2(["wd:Q117413405"]):::iri end f0--EXISTS--> f0e0 f0 --> v2 f0 --> c1 f0 --> c2 v2 --"p:qualifier/P1552"--> c2 v3 --"p:direct/P31"--> a1 a1 --"p:direct/P279"--> c5 v3 --"p:P8956"--> v2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 v3 --"rdfs:label"--> v1 end