query-7b59ea9903150905587c316011191078
Most common title of paintingsHi, 12:09, 25 March 2018 (UTC)) 🙋 (TubezlobI would like to see the result of this query: the most common titles of paintings, based on the label in English. Thanks in advance! TODO
Use at
- https://query.wikidata.org/sparql
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#>
SELECT ?itemLabel (COUNT(?item) as ?count) WHERE {
?item wdt:P31 wd:Q3305213 .
?item rdfs:label ?itemLabel .
FILTER (lang(?itemLabel)="en")
} GROUP BY ?itemLabel
ORDER BY DESC(?count)
Query found at
- https://www.wikidata.org/wiki/User:Tubezlob
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2018/03
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?count")
v3("?item"):::projected
v2("?itemLabel"):::projected
c3(["wd:Q3305213"]):::iri
f0[["?itemLabel = 'en'"]]
f0 --> v2
v3 --"wdt:P31"--> c3
v3 --"rdfs:label"--> v2
bind2[/"count(?item)"/]
v3 --o bind2
bind2 --as--o v4