query-51e57447636e61439d6137ea1af3476d

rq turtle/ttl

Yes E446 502,752 (Q2668072)collection 22 Yes E445 512,977 (Q871232)editorial 21 Yes E339 528,196 (Q8502)mountain 20 Yes E36 533,510 (Q3331189)version, edition or translation 19 Yes E443 559,846 (Q486972)human settlement 18 Yes E442 588,385 (Q13100073)village of the People's Republic of China 17 Wikidata:WikiProject Names Yes E734 621,564 (Q101352)family name 16 Yes E444 629,800 (Q13433827)encyclopedia article 15 Yes E317 678,855 (Q79007)street 14 Yes E439 822,170 (Q11266439)Wikimedia template 13 Wikidata:WikiProject sum of all paintings Yes E130 935,380 (Q3305213)painting 12 Yes E167 1,005,740 (Q8054)protein 11 No, Yes E75, E258 1,222,105 (Q7187)gene 10 Wikidata:WikiProject Chemistry Yes E406 1,277,010 (Q113145171)type of chemical entity 9 Wikidata:WikiProject Disambiguation pages Yes E438 1,482,835 (Q4167410)Wikimedia disambiguation page 8 Yes E441 2,094,845 (Q318)galaxy 7 Yes E414 2,099,699 (Q7318358)review article 6 Yes E440 3,284,179 (Q523)star 5 Yes E433 3,727,070 (Q16521)taxon 4 Wikidata:WikiProject_Categories Yes E315 5,410,315 (Q4167836)Wikimedia category 3 Yes E10 11,309,750 (Q5)human 2 Wikidata:WikiProject Periodicals Yes E292 42,202,338 (Q13442814)scholarly article 1 Wikiproject Documentation Associated Entityschema Quantity (P31)instance of No

Use at

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 wikibase: <http://wikiba.se/ontology#>
SELECT ?p ?label (count(?p) as ?count) WHERE {
  ?s wdt:P31 wd:Q2668072.
  ?s ?p ?o.
  ?pd wikibase:directClaim ?p.
  ?pd rdfs:label ?label.  
  filter (LANG(?label) = "en") .
  filter contains (str(?p),  "prop/direct/P")
}
group by ?p ?label
order BY desc(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?count") v3("?label"):::projected v5("?o") v2("?p"):::projected v6("?pd") v4("?s") c4(["wd:Q2668072"]):::iri f0[["contains(str(?p),'prop/direct/P')"]] f0 --> v2 f1[["?label = 'en'"]] f1 --> v3 v4 --"wdt:P31"--> c4 v4 -->v2--> v5 v6 --"wikibase:directClaim"--> v2 v6 --"rdfs:label"--> v3 bind3[/"count(?p)"/] v2 --o bind3 bind3 --as--o v7