query-c968acd616c91498268e893e6c4e6316

rq turtle/ttl

Authority control properties usage for painters

Make a list of the most used authority control properties for people for painters

SELECT ?propertyLabel ?propertyDescription ?count WHERE { { select ?propertyclaim (COUNT(*) AS ?count) where { ?item wdt:P106 wd:Q1028181 . ?item wdt:P31 wd:Q5 . ?item ?propertyclaim [] . } group by ?propertyclaim } ?property wikibase:propertyType wikibase:ExternalId . ?property wdt:P31 wd:Q19595382 . ?property wikibase:claim ?propertyclaim . SERVICE wikibase:label { # ... include the labels bd:serviceParam wikibase:language "en" . } } 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 painters
# Make a list of the most used authority control properties for people for painters
SELECT ?propertyLabel ?propertyDescription ?count WHERE { 
    {
        select ?propertyclaim (COUNT(*) AS ?count) where {
            ?item wdt:P106 wd:Q1028181 . 
            ?item wdt:P31 wd:Q5 .
            ?item ?propertyclaim [] .
        } group by ?propertyclaim 
    }
    ?property wikibase:propertyType wikibase:ExternalId .
    ?property wdt:P31 wd:Q19595382 .
    ?property wikibase:claim ?propertyclaim .
    SERVICE wikibase:label {            # ... include the labels
        bd:serviceParam wikibase:language "en" .
    }
} ORDER BY DESC (?count)
LIMIT 100

Query found at

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