query-84f075b7edd151cb42a7b43c8862f89b
Subquery for 'joining'Hello, per Wikipedia site link. The query for that is fairly simple: (Q7889)video game This is kind of a not so good use case, but here we go: I want to make a Listeria-based dashboard of the count of
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
SELECT ?item (COUNT(?game) as ?count) WHERE {
?game wdt:P31 wd:Q7889.
?article schema:about ?game .
?article schema:isPartOf ?item.
} GROUP BY ?item
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?article")
v4("?count")
v1("?game"):::projected
v3("?item"):::projected
c2(["wd:Q7889"]):::iri
v1 --"wdt:P31"--> c2
v2 --"schema:about"--> v1
v2 --"schema:isPartOf"--> v3
bind1[/"count(?game)"/]
v1 --o bind1
bind1 --as--o v4