Wikidata:Synia:language-publisher-index

From Wikidata
Jump to navigation Jump to search

Synia: language - publishers

[edit]

Publishers

[edit]
PREFIX target: <http://www.wikidata.org/entity/Q9035>

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