Skip to content

Instantly share code, notes, and snippets.

@crssnky

crssnky/前後3日間の誕生日.sparql

Last active December 20, 2020 05:29
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/61d836872b4b9704aa362f474ea91dd4 to your computer and use it in GitHub Desktop.
Save crssnky/61d836872b4b9704aa362f474ea91dd4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
前後3日間の誕生日.sparql
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX schema: <http://schema.org/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT (sample(?o) as ?date) (sample(?n) as ?name)
WHERE {
?sub schema:birthDate ?o;
rdfs:label ?n;
bind("--xx-xx"^^xsd:gMonthDay as ?3ago)
bind("--xx-xx"^^xsd:gMonthDay as ?3later)
FILTER(?o>=?3ago && ?o<=?3later).
}group by(?sub) order by(?o))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment