Wikidata:Synia:venue-index

From Wikidata
Jump to navigation Jump to search

Synia: venues

[edit]

Venues

[edit]
SELECT 
  ?count

  ?venue ?venueLabel
  (CONCAT("#venue/", SUBSTR(STR(?venue), 32)) AS ?venueUrl)
WITH {
  SELECT 
    (COUNT(*) AS ?count)
    ?venue
  WHERE {
    [] wdt:P1433 ?venue .
  }
  GROUP BY ?venue
  ORDER BY DESC(?count)
  LIMIT 200
} AS %venues
WHERE {
  INCLUDE %venues
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?count)
Try it!