memo

select 

    geonames_features.layer_1 as c0,

    time_instance.year as c1,

    time_instance.month as c2,

    time_instance.day as c3,

    time_instance.hour as c4,

    time_instance.min as c5,

    sum(neo_observation_instance_h.value) as m0,

    neo_observation_instance_h.subject as m1

from

    geonames_features as geonames_features,

    neo_observation_instance_h as neo_observation_instance_h,

    time_instance as time_instance

where

    neo_observation_instance_h.geonames = geonames_features.subject and 

    geonames_features.layer_1 = 'Earth' and 

    neo_observation_instance_h.time = time_instance.subject and 

    time_instance.year = '2011' and 

    time_instance.month = '3' and 

    time_instance.day = '15' and 

    time_instance.hour = '8' and 

    time_instance.min = '0'

group by 

    geonames_features.layer_1 , 

    time_instance.year , 

    time_instance.month , 

    time_instance.day , 

    time_instance.hour , 

    time_instance.min;

'Earth', '2011', '3', '15', '8', '0', '0', '4.230999999999999', 'http://www.kanzaki.com/works/2011/stat/ra/20110315/p01/t17 '

@prefix rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns# .

@prefix ev: http://purl.org/net/c4dm/event.owl# .

@prefix scv: http://purl.org/net/scovo# .

@prefix vcard: http://www.w3.org/2006/vcard/ns# .

@prefix geo: http://www.w3.org/2003/01/geo/wgs84_pos# .

@prefix rdfs: http://www.w3.org/2000/01/rdf-schema# .

@prefix tl: http://purl.org/net/c4dm/timeline.owl# .
http://www.kanzaki.com/works/2011/stat/ra/20110315/p01/t17 rdf:value "0.028"^^http://purl.org/net/ns/measure#microsv ;

                                                             ev:place http://sws.geonames.org/2128293/ ;

                                                             ev:time http://www.kanzaki.com/works/2011/stat/dim/d/20110315t17pt1h ;

                                                             scv:dataset http://www.kanzaki.com/works/2011/stat/ra/set/moe .
http://sws.geonames.org/2128293/ vcard:region "北海道"@ja ,

                                                "Hokkaido"@en ;

                                   vcard:locality "札幌市"@ja ,

                                                  "Sapporo"@en ;

                                   geo:lat "42.99383" ;

                                   geo:long "141.24935" .
http://www.kanzaki.com/works/2011/stat/dim/d/20110315t17pt1h rdfs:label "2011-03-15T17" ;

                                                               tl:at "2011-03-15T17:00:00+09:00"^^http://www.w3.org/2001/xmlschema#datetime ;

                                                               tl:duration "PT1H"^^http://www.w3.org/2001/xmlschema#duration .