Last active
January 14, 2018 15:50
-
-
Save crssnky/3cbc2cbee2870bcb98188d4f4d76b0f0 to your computer and use it in GitHub Desktop.
im@sparql_Examples
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PREFIX schema: <http://schema.org/> | |
PREFIX imas: <https://sparql.crssnky.xyz/imasrdf/URIs/imas-schema.ttl#> | |
SELECT ?o ?h | |
WHERE { | |
?s schema:name|schema:alternateName ?o; | |
schema:height ?h. | |
}order by(?h) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 ?ユニット名 (group_concat(?名前;separator=", ")as ?メンバー) | |
WHERE { | |
?s rdf:type imas:Unit; | |
schema:name ?ユニット名; | |
schema:member ?m. | |
?m schema:name ?名前. | |
}group by (?ユニット名) order by(?ユニット名) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 ?ユニット名 (avg(?h) as ?平均身長) | |
WHERE { | |
?s rdf:type imas:Unit; | |
schema:name ?ユニット名; | |
schema:member ?m. | |
?m schema:height ?h. | |
}group by(?ユニット名) order by desc(?平均身長) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PREFIX schema: <http://schema.org/> | |
PREFIX imas: <https://sparql.crssnky.xyz/imasrdf/URIs/imas-schema.ttl#> | |
select ?利き手 ?名前 | |
where{ | |
?s schema:name|schema:alternateName ?name; | |
imas:Handedness ?利き手; | |
filter(regex(str(?name), "まゆ")). | |
?idol imas:Handedness ?利き手; | |
schema:name ?名前. | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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:SetlistNumer; | |
schema:name ?name; | |
}group by ?name having(?回数>4) order by ?回数 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 * | |
WHERE { | |
?s rdf:type imas:ScriptText; | |
imas:Source ?source; | |
schema:text ?text. | |
?source schema:name ?name; | |
filter(regex(str(?name),"千早")) | |
}order by ?text |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PREFIX imas: <https://sparql.crssnky.xyz/imasrdf/URIs/imas-schema.ttl#> | |
PREFIX schema: <http://schema.org/> | |
SELECT (SUM(?得票数) as ?総得票数) (Sample(?nm) as ?名前) | |
WHERE { | |
?s schema:member ?o; | |
imas:VoteNumber ?得票数. | |
?o schema:name ?nm | |
}group by(?o) order by(?総得票数) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 ?calling ?called | |
WHERE { | |
?s rdf:type imas:CallName; | |
imas:Source ?caller; | |
imas:Destination ?callee; | |
imas:Called ?called. | |
?caller schema:name ?name1. | |
?callee schema:name ?name2. | |
bind(concat(?name1,"→",?name2)as ?calling) | |
}order by rand() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PREFIX schema: <http://schema.org/> | |
PREFIX math: <http://www.w3.org/2005/xpath-functions/math#> | |
SELECT ?名前 (?height as ?身長) (?weight as ?体重) ?デュポア式 ?新谷式 ?藤本式 | |
WHERE { | |
?s schema:name ?名前; | |
schema:height ?height; | |
schema:weight ?weight; | |
bind(math:pow(?height,0.725)*math:pow(?weight,0.425)*0.007184 as ?デュポア式) | |
bind(math:pow(?height,0.725)*math:pow(?weight,0.425)*0.007358 as ?新谷式) | |
bind(math:pow(?height,0.663)*math:pow(?weight,0.444)*0.008883 as ?藤本式) | |
}order by ?デュポア式 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PREFIX imas: <https://sparql.crssnky.xyz/imasrdf/URIs/imas-schema.ttl#> | |
SELECT distinct ?ss ?cv | |
WHERE { | |
?s imas:cv ?cv. | |
service <http://ja.dbpedia.org/sparql>{ | |
?ss ?a ?cv. | |
bind(concat("http://ja.dbpedia.org/resource/",str(?cv))as ?cvs) | |
filter(str(?ss)=?cvs) | |
} | |
}order by ?cv |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment