Wikidata:Wikiproject Looted heritage/Useful queries

From Wikidata
Jump to navigation Jump to search

All Properties associated with Items related to Wikiproject Looted heritage (Q124538244)[edit]

SELECT DISTINCT ?property ?propertyLabel ?count ?report
WITH {
  SELECT ?property (COUNT(DISTINCT ?item) AS ?count)
  WHERE {
    ?item wdt:P5008 wd:Q124538244 .  # On the focus list of Wikiproject Looted Heritage
    ?item ?predicate ?value .
    ?property wikibase:directClaim ?predicate .
  }
  GROUP BY ?property
} AS %i
WHERE {
  INCLUDE %i
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
  BIND(IRI(CONCAT("https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3Fvalue%20%3FvalueLabel%20WHERE%20%7B%0A%20%20%20%20%3Fitem%20wdt%3AP31%20wd%3AQ124538244%20.%20%0A%20%20%20%20%3Fitem%20%3Fpredicate%20%3Fvalue%20.%20%0A%20%20%20%20%3Fproperty%20wikibase%3AdirectClaim%20%3Fpredicate%20.%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%7D%0A%7D%0A")) AS ?report)
}
ORDER BY DESC(?count)
Try it!