query-9575ed40f57708bfeab2174623ce8e63
Video game items with labels and descriptions in some language
SELECT ?item ?itemLabel ?itemDescription
{
{
SELECT ?item (COUNT(?item) AS ?cnt) {
?item p:P31 [ ps:P31 wd:Q7889 ] .
?item p:P31 ?valueStatement .
?item schema:description ?itemDescription FILTER(LANG(?itemDescription) = "ro").
} GROUP BY ?item
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "ro". }
FILTER(?cnt = 1)
}
LIMIT 500
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Video game items with labels and descriptions in some language
SELECT ?item ?itemLabel ?itemDescription
{
{
SELECT ?item (COUNT(?item) AS ?cnt) {
?item p:P31 [ ps:P31 wd:Q7889 ] .
?item p:P31 ?valueStatement .
?item schema:description ?itemDescription FILTER(LANG(?itemDescription) = "ro").
} GROUP BY ?item
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "ro". }
FILTER(?cnt = 1)
}
LIMIT 500
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?cnt")
v3("?item"):::projected
v2("?itemDescription"):::projected
v4("?valueStatement")
a1((" "))
c8(["bd:serviceParam"]):::iri
c4(["wd:Q7889"]):::iri
c2(["ro"]):::literal
f0[["?cnt = '1^^xsd:integer'"]]
f0 --> v5
f1[["?itemDescription = 'ro'"]]
f1 --> v2
a1 --"p:statement/P31"--> c4
v3 --"p:P31"--> a1
v3 --"p:P31"--> v4
v3 --"schema:description"--> v2
bind3[/"count(?item)"/]
v3 --o bind3
bind3 --as--o v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c2
end