neontribe / Linked_Development

Linked Development
1 stars 1 forks source link

New count query seems to produce no results? #49

Closed tobybatch closed 11 years ago

tobybatch commented 11 years ago

This query:

          define: ~
          select: select distinct ?region as ?url ?regionlabel as ?label count(distinct ?article) as ?count
          where: >
            where {
                 ?article a <http://purl.org/ontology/bibo/Article> .
                 ?article <http://purl.org/dc/terms/coverage> ?region .
                 ?region a <http://www.fao.org/countryprofiles/geoinfo/geopolitical/resource/geographical_region>.
                 { 
                    ?region <http://www.fao.org/countryprofiles/geoinfo/geopolitical/resource/nameList> ?regionlabel.
                 } UNION {
                    ?region <http://www.w3.org/2000/01/rdf-schema#label> ?regionlabel.
                 } 
                 FILTER(lang(?regionlabel) = 'en' || lang(?regionlabel) = "")
            }

Run as this seems to produce no matches:

http://ld.neontribe.org/sparql?default-graph-uri=&query=select+distinct+%3Fregion+as+%3Furl+%3Fregionlabel+as+%3Flabel+count%28distinct+%3Farticle%29+as+%3Fcount++from+%3Chttp%3A%2F%2Flinked-development.org%2Feldis%2F%3E+where+%7B++++++%3Farticle+a+%3Chttp%3A%2F%2Fpurl.org%2Fontology%2Fbibo%2FArticle%3E+.++++++%3Farticle+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2Fcoverage%3E+%3Fregion+.++++++%3Fregion+a+%3Chttp%3A%2F%2Fwww.fao.org%2Fcountryprofiles%2Fgeoinfo%2Fgeopolitical%2Fresource%2Fgeographical_region%3E.++++++%7B+++++++++%3Fregion+%3Chttp%3A%2F%2Fwww.fao.org%2Fcountryprofiles%2Fgeoinfo%2Fgeopolitical%2Fresource%2FnameList%3E+%3Fregionlabel.++++++%7D+UNION+%7B+++++++++%3Fregion+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23label%3E+%3Fregionlabel.++++++%7D++++++FILTER%28lang%28%3Fregionlabel%29+%3D+%27en%27+%7C%7C+lang%28%3Fregionlabel%29+%3D+%22%22%29+%7D+limit+0+offset+10&format=text%2Fhtml&debug=on&timeout=

practicalparticipation commented 11 years ago

This relies upon the updates to the ELDIS crawler, and R4D Crawlers which add more properties to regions etc.

http://ld.neontribe.org/sparql/ also appears to still be running SPARQL 6.1.3 so will not work with many of the updated queries...

tobybatch commented 11 years ago

bll*ks, neil is away all next week. it should be on the latest version.