query-471fd0b3c5f8e3f30f412d22275254dd

rq turtle/ttl

PropertiesWikidata item of this property (P1629)instance of (P31)of (P642)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT 
  (SAMPLE(?subjectitem) as ?item) 
  (concat("\u007B\u007BP\u007C",strafter(str(?property),"y/"),"\u007D\u007D") as ?p) 
    ?propertyLabel  (COUNT(DISTINCT ?s) as ?ct) 
    ?total (100*?ct/?total AS ?percent) (strafter(str(?ptype),"#") as ?ptype)   (SAMPLE(?s) as ?sample) { 
    ?property wikibase:claim ?wdt .
    ?property wikibase:propertyType ?ptype . 
    OPTIONAL { ?property wdt:P1629 ?subjectitem } 
    ?s ?wdt ?value .
    ?s p:P31 ?statement. 
      ?statement ps:P31 wd:Q3241045. 
      ?statement pq:P642 wd:Q84263196. 
    FILTER (?s != wd:Q15397819 ) 
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } 
  { SELECT (COUNT(DISTINCT ?i) as ?total) { 
    ?i p:P31 ?statement. 
      ?statement ps:P31 wd:Q3241045. 
        ?statement pq:P642 wd:Q84263196. }
    } } 
GROUP BY ?property ?propertyLabel ?total ?ptype 
ORDER BY DESC(?ct) 
LIMIT 200

Query found at