query-f82c549d9bf9fab760b3348ccfd05705

rq turtle/ttl

Tool : List of misc. properties from a set of Wikidata items

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:Most used properties of TTRPG (adapted from a query by https://twitter.com/JeanFred https://w.wiki/5Fvr)
#defaultView:BubbleChart
SELECT ?property ?propertyLabel ?propertyDescription  (COUNT(DISTINCT ?item) AS ?count)
WHERE {
   {
  SELECT DISTINCT ?property ?propertyLabel WHERE {
    VALUES ?type {
      wikibase:ExternalId
      wikibase:Url
    }
    #?property wikibase:propertyType ?type;
    #  (wdt:P31/(wdt:P279*)) wd:Q28147643;
    #  rdfs:label ?propertyLabel.
    #FILTER((LANG(?propertyLabel)) = "en")
    #MINUS { ?property wdt:P1629 wd:Q96096761. }
    #MINUS { ?property wdt:P1629 wd:Q27631547. }
  }
}
  ?item wdt:P31 wd:Q1643932 .
  ?property wikibase:claim ?propertyclaim.
  ?item ?propertyclaim _:b4.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

GROUP BY ?property ?propertyLabel ?propertyDescription ORDER BY DESC (?count)

Query found at

• https://www.wikidata.org/wiki/User:Pmartinolli/OtSoCG