Truly Tabular RDF
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)
non tabular entries for academic conference(Q2020153) https://www.wikidata.org/wiki/Q2020153
query
# Count all academic conference(Q2020153) https://www.wikidata.org/wiki/Q2020153 items
# with the given location(P276) https://www.wikidata.org/wiki/Property:P276
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)
result
non tabular entries for academic conference(Q2020153) https://www.wikidata.org/wiki/Q2020153
query
# Count all academic conference(Q2020153) https://www.wikidata.org/wiki/Q2020153 items
# with the given proceedings(P4745) https://www.wikidata.org/wiki/Property:P4745
SELECT ?item (COUNT (?value) AS ?count)
WHERE
{
# instance of academic conference
?item wdt:P31 wd:Q2020153.
# proceedings
?item ^wdt:P4745 ?value.
} GROUP by ?item
HAVING (COUNT (?value) > 1)
ORDER BY DESC(?count)