Wikidata:Synia:publisher-index

From Wikidata
Jump to navigation Jump to search

Synia: Publishers

[edit]

Examples

[edit]
SELECT
  ?publisher ?publisherLabel
  (CONCAT("#publisher/", SUBSTR(STR(?publisher), 32)) AS ?publisherUrl)
  ?publisherDescription
WHERE {
  VALUES ?publisher {
    wd:Q73820 wd:Q7894897 wd:Q1065097
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
Try it!

Top publishers

[edit]
SELECT
  ?count 
  ?publisher ?publisherLabel
  (CONCAT("#publisher/", SUBSTR(STR(?publisher), 32)) AS ?publisherUrl)
  ?publisherDescription
WITH {
  SELECT
    (COUNT(*) AS ?count)
    ?publisher
  WHERE {
    [] wdt:P123 ?publisher .
  }
  GROUP BY ?publisher
  ORDER BY DESC(?count)
  LIMIT 200
} AS %publishers
WHERE {
  INCLUDE %publishers
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
ORDER BY DESC(?count)
Try it!