query-0f160a6bd20231b2095159812f39ebf7

rq turtle/ttl

List of properties linking a creative work to a book series, ordered by frequency of use SELECT ?property ?propertyLabel ?count WITH { SELECT ?property ?value (COUNT(DISTINCT ?item) AS ?count) WHERE { ?bookseries wdt:P31/wdt:P279 wd:Q277759. ?item ?wdt ?bookseries. ?item wdt:P31/wdt:P279 wd:Q17537576. ?property a wikibase:Property; wikibase:directClaim ?wdt. FILTER(?property != wd:P31) } GROUP BY ?property ?value ORDER BY DESC(?count) LIMIT 10 } AS %results WHERE { INCLUDE %results. SERVICE wikibase:label { bd:serviceParam wikibase:language "en-US,en,en". } } ORDER BY DESC(?count)

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 bd: <http://www.bigdata.com/rdf#>
#List of properties linking a creative work to a book series, ordered by frequency of use
SELECT ?property ?propertyLabel ?count WHERE {
   {
  SELECT ?property ?value (COUNT(DISTINCT ?item) AS ?count) WHERE {
    ?bookseries wdt:P31/wdt:P279* wd:Q277759.
    ?item ?wdt ?bookseries.
    ?item wdt:P31/wdt:P279* wd:Q17537576.
    ?property a wikibase:Property;
              wikibase:directClaim ?wdt.
    FILTER(?property != wd:P31)
  }
  GROUP BY ?property ?value
  ORDER BY DESC(?count)
  LIMIT 10
}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en-US,en,en". }
}
ORDER BY DESC(?count)

Query found at

• https://www.wikidata.org/wiki/User:Beat_Estermann/WD-Atelier_2018
• https://www.wikidata.org/wiki/User:Beat_Estermann/WD_Intro_Swiss_National_Library_2018