On Fri, Apr 16, 2010 at 9:23 PM, Kingsley Idehen <[email protected]> wrote: > Dan Brickley wrote: >> >> On Fri, Apr 16, 2010 at 11:43 PM, Kingsley Idehen >> <[email protected]> wrote: >> >>> >>> Tom Morris wrote: >>> >>>> >>>> This example query from the DBpedia page returns a list of companies >>>> which all have exactly 151,000 employees: >>>> >>>> >>>> http://dbpedia.org/snorql/?query=SELECT+%3Fsubject+%3Femployees+%3Fhomepage+WHERE+{%0D%0A%3Fsubject+rdf:type+%3Chttp://dbpedia.org/class/yago/Company108058098%3E.%0D%0A%3Fsubject+dbpedia2:numEmployees+%3Femployees%0D%0AFILTER+(xsd:integer(%3Femployees)+%3E%3D+50000).%0D%0A%3Fsubject+foaf:homepage+%3Fhomepage.%0D%0A}+ORDER+BY+DESC(xsd:integer(%3Femployees))%0D%0ALIMIT+20%0D%0A >>>> >>>> That seems a rather improbable result. I'm not a real SPARQL guru, >>>> but I don't see anything obviously wrong with the query. Is the query >>>> incorrect or is the issue with the database or the server? >>>> >>>> Tom >>> >>> To save time (i.e. decoding the URL), could you please do the following: >>>
>> >> > > Problem: > > The Home Page URLs aren't uniform. > > I added DISTINCT and removed ?homepage. > > So not a bug :-) > > Try > > PREFIX owl: <http://www.w3.org/2002/07/owl#> > PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> > PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> > PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> > PREFIX foaf: <http://xmlns.com/foaf/0.1/> > PREFIX dc: <http://purl.org/dc/elements/1.1/> > PREFIX : <http://dbpedia.org/resource/> > PREFIX dbpedia2: <http://dbpedia.org/property/> > PREFIX dbpedia: <http://dbpedia.org/> > PREFIX skos: <http://www.w3.org/2004/02/skos/core#> > > SELECT distinct ?subject ?employees WHERE { > ?subject rdf:type <http://dbpedia.org/class/yago/Company108058098>. > ?subject dbpedia2:numEmployees ?employees > FILTER (xsd:integer(?employees) >= 50000). > ?subject foaf:homepage ?homepage. > } ORDER BY DESC(xsd:integer(?employees)) > LIMIT 20 > > Links: > > 1. http://bit.ly/byXSGf -- SPARQL Protocol URL Thanks! That did the trick. It looks like the DISTINCT keyword was the main issue since it also seems to work with the homepages included as long as the DISTINCT keyword is there. Hopefully one of the DBpedians will see this and update the example at http://wiki.dbpedia.org/Datasets#h18-12. (The other two example queries in that section seem to work as expected). Tom ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Dbpedia-discussion mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
