Truly Tabular RDF

From BITPlan Wiki
Revision as of 12:38, 14 March 2022 by Wf (talk | contribs) (Created page with "= Example Scientific Events and locations = <source lang='sparql'> # location ( https://www.wikidata.org/wiki/Property:P276 ):7244 # Count all items with the given location (...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Example Scientific Events and locations

# location ( https://www.wikidata.org/wiki/Property:P276 ):7244
# Count all items with the given location ( https://www.wikidata.org/wiki/Property:P276 ):
# and type academic conference(Q2020153):https://www.wikidata.org/wiki/Q2020153
SELECT ?item (COUNT (?value) AS ?count)
WHERE
{
  # instance of academic conference
  ?item wdt:P31 wd:Q2020153.
  # location
  ?item wdt:P276 ?value.
} GROUP by ?item
HAVING (COUNT (?value) > 1)
ORDER BY DESC(?count)

try it!