query-674a188ba4da0517d972e922b5eb109d
This is the top 100 of painters on Wikidata with the most sitelinks on Wikipedia and at least 10 paintings on Wikidata, as of 25 December 2016. Query:
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(DISTINCT ?sitelink) AS ?linkcount) (COUNT(DISTINCT ?painting) AS ?paintingcount) WHERE {
?painting wdt:P31 wd:Q3305213.
?painting wdt:P170 ?item.
?sitelink schema:about ?item.
}
GROUP BY ?item HAVING (?paintingcount > 10)
ORDER BY DESC(?linkcount) LIMIT 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?item"):::projected
v6("?linkcount")
v3("?painting"):::projected
v6("?paintingcount")
v5("?sitelink"):::projected
c3(["wd:Q3305213"]):::iri
f0[["?paintingcount > '10^^xsd:integer'"]]
f0 --> v6
v3 --"wdt:P31"--> c3
v3 --"wdt:P170"--> v4
v5 --"schema:about"--> v4
bind3[/"count(?sitelink)"/]
v5 --o bind3
bind3 --as--o v6
bind4[/"count(?painting)"/]
v3 --o bind4
bind4 --as--o v6