Skip to content

Instantly share code, notes, and snippets.

@crssnky

crssnky/ライブで5回以上歌われた楽曲を数が多い順に並べる.sparql

Last active January 15, 2019 13:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save crssnky/d1d4f266dbc6b4785a9710467967bee2 to your computer and use it in GitHub Desktop.
Save crssnky/d1d4f266dbc6b4785a9710467967bee2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ライブで5回以上歌われた楽曲を数が多い順に並べる.sparql
PREFIX schema: <http://schema.org/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX imas: <https://sparql.crssnky.xyz/imasrdf/URIs/imas-schema.ttl#>
SELECT (count(?name)as ?回数) (sample(?name)as ?楽曲名)
WHERE {
?s rdf:type imas:SetlistNumber;
schema:name ?name;
}group by ?name having(?回数>4) order by DESC(?回数)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment