View node.jsで、im@sparqlに当日の誕生日を訊いてつぶやくやつ+.js
var twitter = require('twitter');
var request=require('request');
var fs= require('fs');
var webshot=require('webshot');
var Q=require('q');
// Tweet module
var client = new twitter({
consumer_key: '',
consumer_secret: '',
View node.jsで誕生日つぶやく.js
var twitter = require('twitter');
var request=require('request');
// Tweet module
var client = new twitter({
consumer_key: '',
consumer_secret: '',
access_token_key: '',
access_token_secret: '',
});
View いずみんユニット.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 ?uName group_concat(?name)
WHERE {
?s rdf:type imas:Unit;
schema:name ?uName;
schema:member ?OI;
schema:member ?mem.
View BMI近い順.sparql
PREFIX schema: <http://schema.org/>
SELECT ?name ?BMI1 ?BMI2 ?diff2
WHERE {
?s schema:name|schema:alternateName ?name;
schema:height ?height;
schema:weight ?weight.
bind((自分の身長)as ?myHeight).
bind((自分の体重)as ?myWeight).
bind((?weight/(?height*?height*0.01*0.01))as ?BMI1)
View CVのDBpedia JapaneseでのURIを取得.sparql
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)
}
View アイドルの体表面積を3つの計算方法で取得し、デュポア式で並び替え.sparql
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 ?新谷式)
View 呼称リストランダム順.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 ?calling ?called
WHERE {
?s rdf:type imas:CallName;
imas:Source ?caller;
imas:Destination ?callee;
imas:Called ?called.
View アイドルごとの総選挙での全獲得票数.sparql
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(?総得票数)
View 千早のセリフテキストを取得.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 *
WHERE {
?s rdf:type imas:ScriptText;
imas:Source ?source;
schema:text ?text.
?source schema:name ?name;
View ライブで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:SetlistNumer;
schema:name ?name;
}group by ?name having(?回数>4) order by DESC(?回数)