SPARQL query

SELECT ?item (CONCAT("[[Wikidata:WikiProject sum of all paintings/Creator/",?name, "|list]]") AS ?listlink) (COUNT(DISTINCT ?rkdimages) AS ?rkdcount) ?paintingcount WHERE { ?item wdt:P106 wd:Q1028181 . ?item wdt:P31 wd:Q5 . ?painting wdt:P170 ?item . ?painting wdt:P31 wd:Q3305213 . ?painting wdt:P350 ?rkdimages . { # To filter out the painting dictators SELECT ?item (COUNT(?item) as ?paintingcount) WHERE { ?painting wdt:P31 wd:Q3305213 . ?painting wdt:P170 ?item . } GROUP BY ?item HAVING (?paintingcount > 10) } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?name . } } GROUP BY ?item ?name ?listlink ?paintingcount HAVING (?rkdcount > 50) ORDER BY DESC(?rkdcount) LIMIT 500
Design your query here.

Start date

Alternatively, use a text like "last week" or such, as described here.

End date

Alternatively, use a text like "last week" or such, as described here. Leave empty for current date.

Preferred languages
for item labels

Sort order

By last edit (latest first) By label

Options

No bot edits Skip unchanged items

SPARQL query

SELECT ?item (CONCAT("[[Wikidata:WikiProject sum of all paintings/Creator/",?name, "|list]]") AS ?listlink) (COUNT(DISTINCT ?rkdimages) AS ?rkdcount) ?paintingcount WHERE {     ?item wdt:P106 wd:Q1028181 .     ?item wdt:P31 wd:Q5 .     ?painting wdt:P170 ?item .      ?painting wdt:P31 wd:Q3305213 .      ?painting wdt:P350 ?rkdimages .   { # To filter out the painting dictators     SELECT ?item (COUNT(?item) as ?paintingcount) WHERE {     ?painting wdt:P31 wd:Q3305213 .       ?painting wdt:P170 ?item .       } GROUP BY ?item        HAVING (?paintingcount > 10)   }       SERVICE wikibase:label {     bd:serviceParam wikibase:language "en" .     ?item rdfs:label ?name .    }   } GROUP BY ?item ?name ?listlink ?paintingcount HAVING (?rkdcount > 50) ORDER BY DESC(?rkdcount) LIMIT 500

has failed