query-183a1b06df8a2f6ac627400adaa0e507

rq turtle/ttl

Authority control properties usage for paintings

Make a list of the most used authority control properties for works for paintings

SELECT ?propertyLabel ?propertyDescription (COUNT(?propertyclaim) AS ?count) WHERE { ?item wdt:P31 wd:Q3305213 .

?property wikibase:propertyType wikibase:ExternalId . ?property wdt:P31 wd:Q19833377 . ?property wikibase:claim ?propertyclaim .

?item ?propertyclaim [] . SERVICE wikibase:label { # ... include the labels bd:serviceParam wikibase:language "en" . }
} GROUP BY ?propertyLabel ?propertyDescription ORDER BY DESC (?count) LIMIT 100

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Authority control properties usage for paintings
# Make a list of the most used authority control properties for works for paintings
SELECT ?propertyLabel ?propertyDescription (COUNT(?propertyclaim) AS ?count) WHERE { 
  ?item wdt:P31 wd:Q3305213 .

  ?property wikibase:propertyType wikibase:ExternalId .
  ?property wdt:P31 wd:Q19833377 .
  ?property wikibase:claim ?propertyclaim .

  ?item ?propertyclaim [] .
    SERVICE wikibase:label {            # ... include the labels
        bd:serviceParam wikibase:language "en" .
    }   
} GROUP BY ?propertyLabel ?propertyDescription ORDER BY DESC (?count)
LIMIT 100

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?count") v2("?item") v3("?property") v4("?propertyclaim"):::projected a1((" ")) c2(["wd:Q3305213"]):::iri c8(["bd:serviceParam"]):::iri c10(["en"]):::literal c4(["wikibase:ExternalId"]):::iri c5(["wd:Q19833377"]):::iri v2 --"wdt:P31"--> c2 v3 --"wikibase:propertyType"--> c4 v3 --"wdt:P31"--> c5 v3 --"wikibase:claim"--> v4 v2 -->v4--> a1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end bind1[/"count(?propertyclaim)"/] v4 --o bind1 bind1 --as--o v5