updated SPARQL ================================================== #1 http://sparql.org/sparql?query=PREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+rev%3A+%3Chttp%3A%2F%2Fwww.purl.org%2Fstuff%2Frev%23%3E%0D%0A%0D%0ASELECT+DISTINCT+%3Fname+%3Frating%0D%0A%0D%0AFROM+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2Fsw%2Fgrddl-wg%2Fdoc29%2Fhotel-data.rdf%3E%0D%0A%0D%0AWHERE+%7B%0D%0A%3Fx+rev%3AhasReview+%3Freview.%0D%0A%3Freview+rev%3Arating+%3Frating+.%0D%0AFILTER+%28%3Frating+%3E+2%29.%0D%0A%3Freview+rev%3Areviewer+%3Freviewer.%0D%0A%3Freviewer+foaf%3Aname+%3Fname+.%0D%0A%7D%0D%0A&default-graph-uri=&stylesheet=xml-to-html.xsl PREFIX foaf: PREFIX rev: SELECT DISTINCT ?name ?rating FROM WHERE { ?x rev:hasReview ?review. ?review rev:rating ?rating . FILTER (?rating > 2). ?review rev:reviewer ?reviewer. ?reviewer foaf:name ?name . } =================================================== #2 http://sparql.org/sparql?query=PREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+rev%3A+%3Chttp%3A%2F%2Fwww.purl.org%2Fstuff%2Frev%23%3E%0D%0APREFIX+vcard%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Fvcard%2Fns%23%3E%0D%0A%0D%0ASELECT+DISTINCT+%3Frating+%3Fname+%3Fregion%0D%0A%0D%0AFROM+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2Fsw%2Fgrddl-wg%2Fdoc29%2Fhotel-data.rdf%3E%0D%0A%0D%0AWHERE+%7B%0D%0A%3Fx+rev%3AhasReview+%3Freview%3B%0D%0A++++vcard%3AADR+%3Faddress.%0D%0A%3Freview+rev%3Arating+%3Frating+.%0D%0A%3Faddress+vcard%3ALocality+%3Fregion.%0D%0A%0D%0AFILTER+%28%3Frating+%3E+2+%26%26+%3Fregion+%3D+%22Edinburgh%22%29.%0D%0A%0D%0A%3Freview+rev%3Areviewer+%3Freviewer.%0D%0A%3Freviewer+foaf%3Aname+%3Fname.%0D%0A%7D&default-graph-uri=&stylesheet=xml-to-html.xsl PREFIX foaf: PREFIX rev: PREFIX vcard: SELECT DISTINCT ?rating ?name ?region FROM WHERE { ?x rev:hasReview ?review; vcard:ADR ?address. ?review rev:rating ?rating . ?address vcard:Locality ?region. FILTER (?rating > 2 && ?region = "Edinburgh"). ?review rev:reviewer ?reviewer. ?reviewer foaf:name ?name. } ================================================== #3 http://sparql.org/sparql?query=PREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+rev%3A+%3Chttp%3A%2F%2Fwww.purl.org%2Fstuff%2Frev%23%3E%0D%0APREFIX+vcard%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Fvcard%2Fns%23%3E%0D%0APREFIX+xfn%3A+%3Chttp%3A%2F%2Fgmpg.org%2Fxfn%2F11%23%3E%0D%0A%0D%0ASELECT+DISTINCT+%3Frating+%3Fname+%3Fregion+%3Fhomepage+%3Fxfnhomepage%0D%0A%0D%0AFROM+%3Chttp%3A%2F%2Fsuda.co.uk%2Fsandbox%2FGRDDL%2Freview.rdf%3E%0D%0AFROM+%3Chttp%3A%2F%2Fsuda.co.uk%2Fsandbox%2FGRDDL%2Fxfn.rdf%3E%0D%0A%0D%0A%0D%0AWHERE+%7B%0D%0A%3Fx+rev%3AhasReview+%3Freview%3B%0D%0A++++vcard%3AADR+%3Faddress.%0D%0A%3Freview+rev%3Arating+%3Frating+.%0D%0A%3Faddress+vcard%3ALocality+%3Fregion.%0D%0A%0D%0AFILTER+%28%3Frating+%3E+2+%26%26+%3Fregion+%3D+%22Edinburgh%22%29.%0D%0A%0D%0A%3Freview+rev%3Areviewer+%3Freviewer.%0D%0A%3Freviewer+foaf%3Aname+%3Fname%3B%0D%0A+++++++++++++++foaf%3Ahomepage+%3Fhomepage.%0D%0A%0D%0A%3Fy+xfn%3Afriend+%3Fxfnfriend.%0D%0A%3Fxfnfriend+foaf%3Ahomepage+%3Fxfnhomepage.%0D%0AFILTER+%28%3Fxfnhomepage+%3D+%3Fhomepage%29.%0D%0A%7D%0D%0A&default-graph-uri=&stylesheet=xml-to-html.xsl PREFIX foaf: PREFIX rev: PREFIX vcard: PREFIX xfn: SELECT DISTINCT ?rating ?name ?region ?homepage ?xfnhomepage FROM FROM WHERE { ?x rev:hasReview ?review; vcard:ADR ?address. ?review rev:rating ?rating . ?address vcard:Locality ?region. FILTER (?rating > 2 && ?region = "Edinburgh"). ?review rev:reviewer ?reviewer. ?reviewer foaf:name ?name; foaf:homepage ?homepage. ?y xfn:friend ?xfnfriend. ?xfnfriend foaf:homepage ?xfnhomepage. FILTER (?xfnhomepage = ?homepage). }