Wikidata:WikiProject sum of all paintings/Christian religious art/Suggestions/Label (high)
Jump to navigation
Jump to search
main subject (P921) suggestions based on same label in a language. This is a subset of Wikidata:WikiProject sum of all paintings/Christian religious art/Suggestions/Label where we have a high (50+) number of matches.
This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!
WDQS | PetScan | TABernacle | Find images | Recent changes | Query:SELECT ?item ?itemLabel ?label ?item2 ?mainsubject ?addlink ?count WITH { SELECT DISTINCT ?item ?label WHERE { ?item wdt:P31 wd:Q3305213 ; wdt:P136 wd:Q2864737 . # Remove when we run out of suggestions MINUS { ?item wdt:P136 ?genre . FILTER ( ?genre!=wd:Q2864737 ) } . MINUS { ?item wdt:P921 [] } . FILTER NOT EXISTS { ?item wdt:P31/wdt:P279* wd:Q1278452 } . ?item rdfs:label ?label . } } AS %missingmainsubject WITH { SELECT DISTINCT ?label ?mainsubject (COUNT(CONCAT(LANG(?label),STR(?label), STR(?mainsubject))) AS ?count) (SAMPLE(?item2) AS ?item2) WHERE { ?item2 wdt:P136 wd:Q2864737 ; wdt:P921 ?mainsubject ; wdt:P31 wd:Q3305213 ; rdfs:label ?label . FILTER NOT EXISTS { ?item2 wdt:P31/wdt:P279* wd:Q1278452 } . } GROUP BY ?label ?mainsubject HAVING (?count > 49) ORDER BY DESC(?count) } AS %mainsubjects WHERE { INCLUDE %missingmainsubject. INCLUDE %mainsubjects. BIND(CONCAT("[https://www.wikidata.org/w/index.php?title=", REPLACE(STR(?item), "http://www.wikidata.org/entity/", ""), "&action=edit&withJS=MediaWiki:AddQuickClaim.js&propertyid=P921&entityid=", REPLACE(STR(?mainsubject), "http://www.wikidata.org/entity/", ""), " Add]") AS ?addlink) SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?count) LIMIT 400
End of automatically generated list.