DEFINE get:soft "replace"
DEFINE input:grab-var "?uriFB"

PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX fb-film: <http://rdf.freebase.com/ns/film.film.>
SELECT * 
FROM <http://rdf.freebase.com/ns/film.film> 
FROM <http://dbpedia.org>
WHERE 
{ 
<http://dbpedia.org/resource/E.T._the_Extra-Terrestrial> owl:sameAs ?uriFB .
optional {graph ?g {
?uriFB ?p ?o. }}

}

## GoodRelations Offers from other sources starting with Amazon	

DEFINE input:grab-var "o"
DEFINE input:grab-follow-predicate rdfs:seeAlso
DEFINE input:grab-depth 3
DEFINE input:grab-limit 50
select * where {<http://linkeddata.uriburner.com/about/id/entity/http/www.amazon.com/o/ASIN/1591842778> rdfs:seeAlso ?o. 
                 ?o a <http://purl.org/goodrelations/v1#Offering>. 
                 ?o ?p2 ?o2}

### New York Times DBpedia Join
## Using Sponger to remote HTTP GET and then make a local Named Graph from the Resource at
## URL: <http://data.nytimes.com/N66220017142656459133.rdf>

DEFINE get:soft "replace"
DEFINE input:grab-var "db"

SELECT *
FROM <http://data.nytimes.com/N66220017142656459133.rdf>
WHERE {
      <http://data.nytimes.com/N66220017142656459133> owl:sameAs ?db.
      graph ?g { ?db ?p ?o }
      }

### New York Times DBpedia Join
## Using Sponger to remote HTTP GET with Content Negotiation prior to making 
## local Named Graph from the Resource at
## URL: <http://data.nytimes.com/N66220017142656459133>

DEFINE get:soft "replace"
DEFINE input:grab-var "db"

SELECT *
FROM <http://data.nytimes.com/N66220017142656459133>
WHERE {
      <http://data.nytimes.com/N66220017142656459133> owl:sameAs ?db.
      graph ?g { ?db ?p ?o }
      }
	
### New York Times DBpedia Join
## Using Local Dataset Imported into Named Graph: <http://data.nytimes.com#people>

DEFINE input:grab-var "db"

SELECT *
FROM <http://data.nytimes.com#people>
WHERE {
      <http://data.nytimes.com/N66220017142656459133> owl:sameAs ?db.
      graph ?g { ?db ?p ?o }
      }

LIMIT 50


--- Semantic Web Client Library Sample Queries


-- Query 1

define input:grab-var "dev"
define input:grab-var "proj"
define input:grab-var "projectName"
define input:grab-follow-predicate <http://usefulinc.com/ns/doap#developer>
define input:grab-depth 10
define input:grab-limit 50
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX doap: <http://usefulinc.com/ns/doap#>

SELECT DISTINCT ?name ?mbox ?projectName
FROM NAMED <http://dig.csail.mit.edu/2005/ajar/ajaw/data>
WHERE {
 graph <http://dig.csail.mit.edu/2005/ajar/ajaw/data> {
   <http://dig.csail.mit.edu/2005/ajar/ajaw/data#Tabulator> doap:developer ?dev .

 ?dev foaf:name ?name .
 OPTIONAL { ?dev foaf:mbox ?mbox }
 OPTIONAL { ?dev doap:project ?proj .
            ?proj foaf:name ?projectName }
     }
}


-- Query 1 with transitivity option:

define input:grab-var "dev"
define input:grab-var "proj"
define input:grab-var "projectName"
define input:grab-follow-predicate <http://usefulinc.com/ns/doap#developer>
define input:grab-depth 10
define input:grab-limit 50
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX doap: <http://usefulinc.com/ns/doap#>

SELECT DISTINCT ?name ?mbox ?projectName
WHERE
  {
    {
      {
        {
          select ?start ?dev where { ?start doap:developer ?dev . }
        }
        option ( transitive, t_in (?start), t_out (?dev) )
        filter (?start = <http://dig.csail.mit.edu/2005/ajar/ajaw/data#Tabulator>)
      }

      ?dev foaf:name ?name .
    }

    OPTIONAL { ?dev foaf:mbox ?mbox }
    OPTIONAL { ?dev doap:project ?proj .
               ?proj foaf:name ?projectName
             }
  }


---
-- Variant with DISTINCT
define input:grab-var "dev"
define input:grab-var "proj"
define input:grab-var "projectName"
define input:grab-follow-predicate <http://usefulinc.com/ns/doap#developer>
define input:grab-depth 10
define input:grab-limit 50
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX doap: <http://usefulinc.com/ns/doap#>

SELECT DISTINCT *
FROM NAMED <http://dig.csail.mit.edu/2005/ajar/ajaw/data>
WHERE {
 graph <http://dig.csail.mit.edu/2005/ajar/ajaw/data> {
   <http://dig.csail.mit.edu/2005/ajar/ajaw/data#Tabulator> doap:developer ?dev .

 ?dev foaf:name ?name .
 OPTIONAL { ?dev foaf:mbox ?mbox }
 OPTIONAL { ?dev doap:project ?proj .
            ?proj foaf:name ?projectName }
     }
}

--- Variant with Sponging of the Source Graph (i.e., making the external graph URL an internal Graph IRI)
define get:soft "replacing"
define input:grab-var "dev"
define input:grab-var "proj"
define input:grab-var "projectName"
define input:grab-follow-predicate <http://usefulinc.com/ns/doap#developer>
define input:grab-depth 3
define input:grab-limit 50
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX doap: <http://usefulinc.com/ns/doap#>

SELECT DISTINCT ?name ?mbox ?projectName
FROM <http://dig.csail.mit.edu/2005/ajar/ajaw/data>
WHERE {<http://dig.csail.mit.edu/2005/ajar/ajaw/data#Tabulator> doap:developer ?dev .
       ?dev foaf:name ?name .
 OPTIONAL { ?dev foaf:mbox ?mbox }
 OPTIONAL { ?dev doap:project ?proj .
            ?proj foaf:name ?projectName }
     }

-- variant without FROM

define input:grab-all "yes"
define input:grab-var "dev"
define input:grab-var "proj"
define input:grab-var "projectName"
define input:grab-follow-predicate <http://usefulinc.com/ns/doap#developer>
define input:grab-depth 3
define input:grab-limit 50
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX doap: <http://usefulinc.com/ns/doap#>

SELECT DISTINCT ?name ?mbox ?projectName
FROM <http://dig.csail.mit.edu/2005/ajar/ajaw/data>
WHERE {<http://dig.csail.mit.edu/2005/ajar/ajaw/data#Tabulator> doap:developer ?dev .
       ?dev foaf:name ?name .
 OPTIONAL { ?dev foaf:mbox ?mbox }
 OPTIONAL { ?dev doap:project ?proj .
            ?proj foaf:name ?projectName }
     }


-- Friend of a Friend

-- Without FROM and Graph Restrictions

define input:grab-var "friend"
define input:grab-var "Others"
define input:grab-follow-predicate foaf:knows
define input:grab-depth 2
define input:grab-limit 50
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX doap: <http://usefulinc.com/ns/doap#>


SELECT DISTINCT *
WHERE {

      <http://demo.openlinksw.com/dataspace/person/demo#this> foaf:knows ?friend .
      ?friend foaf:knows ?Others.


}

-- with changed user URI and with transitivity option:
-- http://mypenlink.net/dataspace/person/kidehen#this

define input:grab-var "friend"
define input:grab-var "Others"
define input:grab-follow-predicate <http://xmlns.com/foaf/0.1/#knows>
define input:grab-depth 2
define input:grab-limit 50
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX doap: <http://usefulinc.com/ns/doap#>


SELECT DISTINCT *
WHERE
  {
    {
      {
        {
          select ?start ?friend where { ?start foaf:knows ?friend . }
        }
        option ( transitive, t_in (?start), t_out (?friend) )
        filter (?start = <http://mypenlink.net/dataspace/person/kidehen#this>)
      }
      ?friend foaf:knows ?Others .
    }
  }

--- Query 2

define input:grab-var "foaf"
define input:grab-var "?friend"
define input:grab-var "friendsURI"
define input:grab-follow-predicate <http://usefulinc.com/ns/doap#developer>
define input:grab-depth 10
define input:grab-limit 50
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX doap: <http://usefulinc.com/ns/doap#>


SELECT DISTINCT ?friendsname ?friendshomepage ?foafsname ?foafshomepage
FROM NAMED <http://richard.cyganiak.de/foaf.rdf>
WHERE { graph <http://richard.cyganiak.de/foaf.rdf> {
  { <http://richard.cyganiak.de/foaf.rdf#cygri> foaf:knows ?friend .
    ?friend foaf:mbox_sha1sum ?mbox .
    ?friendsURI foaf:mbox_sha1sum ?mbox .
    ?friendsURI foaf:name ?friendsname .
    ?friendsURI foaf:homepage ?friendshomepage . }
    OPTIONAL { ?friendsURI foaf:knows ?foaf .
               ?foaf foaf:name ?foafsname .
               ?foaf foaf:homepage ?foafshomepage .
             }
  }
 }


-- Distinct Variant

define input:grab-var "foaf"
define input:grab-var "?friend"
define input:grab-var "friendsURI"
define input:grab-follow-predicate <http://usefulinc.com/ns/doap#developer>
define input:grab-depth 10
define input:grab-limit 50
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX doap: <http://usefulinc.com/ns/doap#>


SELECT DISTINCT *
FROM NAMED <http://richard.cyganiak.de/foaf.rdf>
WHERE { graph <http://richard.cyganiak.de/foaf.rdf> {
  { <http://richard.cyganiak.de/foaf.rdf#cygri> foaf:knows ?friend .
    ?friend foaf:mbox_sha1sum ?mbox .
    ?friendsURI foaf:mbox_sha1sum ?mbox .
    ?friendsURI foaf:name ?friendsname .
    ?friendsURI foaf:homepage ?friendshomepage . }
    OPTIONAL { ?friendsURI foaf:knows ?foaf .
               ?foaf foaf:name ?foafsname .
               ?foaf foaf:homepage ?foafshomepage .
             }
  }
 }


-- Query 2 changed variant:

define input:grab-var "foaf"
define input:grab-var "?friend"
define input:grab-var "friendsURI"
define input:grab-follow-predicate <http://xmlns.com/foaf/0.1/#knows>
define input:grab-depth 5
define input:grab-limit 20
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX doap: <http://usefulinc.com/ns/doap#>


SELECT DISTINCT ?friendsname ?friendshomepage ?foafsname ?foafshomepage
FROM NAMED <http://richard.cyganiak.de/foaf.rdf>
WHERE { graph <http://richard.cyganiak.de/foaf.rdf> {
  { <http://richard.cyganiak.de/foaf.rdf#cygri> foaf:knows ?friend .
    ?friend foaf:mbox_sha1sum ?mbox .
    ?friendsURI foaf:mbox_sha1sum ?mbox .
    ?friendsURI foaf:name ?friendsname .
    ?friendsURI foaf:homepage ?friendshomepage . }
    OPTIONAL { ?friendsURI foaf:knows ?foaf .
               ?foaf foaf:name ?foafsname .
               ?foaf foaf:homepage ?foafshomepage .
             }
  }
 }


-- Query 2 changed variant with transitivity option:

define input:grab-all "yes"
define input:grab-depth 1
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT DISTINCT ?friendsname ?friendshomepage ?foafsname ?foafshomepage
WHERE
  {
    {
      {
        {
          select ?start ?friend where { ?start foaf:knows ?friend . }
        }
        option ( transitive, t_in (?start), t_out (?friend) )
        filter (?start = <http://richard.cyganiak.de/foaf.rdf#cygri>)
      }

      ?friend foaf:mbox_sha1sum ?mbox .
      ?friendsURI foaf:mbox_sha1sum ?mbox .
      ?friendsURI foaf:name ?friendsname .
      ?friendsURI foaf:homepage ?friendshomepage .
    }
    OPTIONAL {  ?friendsURI foaf:knows ?foaf .
                ?foaf foaf:name ?foafsname .
                ?foaf foaf:homepage ?foafshomepage .
             }
  }

--- MyOpenLink Sample Queries


-- Query 1
define input:grab-var "foaf"
define input:grab-var "?friend"
define input:grab-var "friendsURI"
define input:grab-follow-predicate <http://xmlns.com/foaf/0.1/knows>
define input:grab-depth 10
define input:grab-limit 50
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX doap: <http://usefulinc.com/ns/doap#>


SELECT DISTINCT *
FROM NAMED <http://community.linkeddata.org/dataspace/person/kidehen2>
WHERE { graph <http://community.linkeddata.org/dataspace/person/kidehen2> {
  { <http://community.linkeddata.org/dataspace/person/kidehen2#this> foaf:knows ?friend .
    optional {?friend foaf:mbox_sha1sum ?mbox .}
    optional {?friendsURI foaf:mbox_sha1sum ?mbox .}
    optional {?friendsURI foaf:name ?friendsname .}
    optional {?friendsURI foaf:homepage ?friendshomepage .} }
    OPTIONAL { ?friendsURI foaf:knows ?foaf .
               ?foaf foaf:name ?foafsname .
               ?foaf foaf:homepage ?foafshomepage .
             }
  }
 }

-- Query 1 with transitivitiy option

define input:grab-var "foaf"
define input:grab-var "?friend"
define input:grab-var "friendsURI"
define input:grab-follow-predicate <http://xmlns.com/foaf/0.1/knows>
define input:grab-depth 10
define input:grab-limit 50
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX doap: <http://usefulinc.com/ns/doap#>


SELECT DISTINCT *
WHERE
  {

    {
      {
        {
          select ?start ?friend where { ?start foaf:knows ?friend . }
        }
        option ( transitive, t_in (?start), t_out (?friend) )
        filter (?start = <http://community.linkeddata.org/dataspace/person/kidehen2#this>)
      }

      OPTIONAL { ?friend foaf:mbox_sha1sum ?mbox . }
      OPTIONAL { ?friendsURI foaf:mbox_sha1sum ?mbox . }
      OPTIONAL { ?friendsURI foaf:name ?friendsname . }
      OPTIONAL { ?friendsURI foaf:homepage ?friendshomepage . }
    }

    OPTIONAL { ?friendsURI foaf:knows ?foaf .
               ?foaf foaf:name ?foafsname .
               ?foaf foaf:homepage ?foafshomepage .
             }
 }

--- Query 2

PREFIX foaf: <http://xmlns.com/foaf/0.1/ >

SELECT DISTINCT ?friendsname ?friendshomepage ?foafsname ?foafshomepage
WHERE {
  { <http://myopenlink.net/dataspace/person/kidehen#this> foaf:knows ?friend .
    ?friend foaf:mbox_sha1sum ?mbox .
    ?friendsURI foaf:mbox_sha1sum ?mbox .
    ?friendsURI foaf:name ?friendsname .
    ?friendsURI foaf:homepage ?friendshomepage . }
    OPTIONAL { ?friendsURI foaf:knows ?foaf .
               ?foaf foaf:name ?foafsname .
               ?foaf foaf:homepage ?foafshomepage .
             }
  }

-- Query 2 with transitivitiy option

PREFIX foaf: <http://xmlns.com/foaf/0.1/ >
SELECT DISTINCT ?friendsname ?friendshomepage ?foafsname ?foafshomepage
WHERE
  {
    {
      {
        {
          select ?start ?friend where { ?start foaf:knows ?friend . }
        }
        option ( transitive, t_in (?start), t_out (?friend) )
        filter (?start = <http://myopenlink.net/dataspace/person/kidehen#this>)
      }

      ?friend foaf:mbox_sha1sum ?mbox .
      ?friendsURI foaf:mbox_sha1sum ?mbox .
      ?friendsURI foaf:name ?friendsname .
      ?friendsURI foaf:homepage ?friendshomepage .
    }
    OPTIONAL { ?friendsURI foaf:knows ?foaf .
               ?foaf foaf:name ?foafsname .
               ?foaf foaf:homepage ?foafshomepage .
             }
  }


-- Query 3
define input:grab-follow-predicate <foaf:knows>
define input:grab-depth 10
PREFIX sioc: <http://rdfs.org/sioc/ns#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
construct {?s ?p ?o} from <http://blogs.zdnet.com/semantic-web/?p=105>
where {?s ?p ?o filter regex(?o,".*Twine*")}


-- Query 4
define input:grab-follow-predicate <foaf:knows>
  define input:grab-var "their_id"
  define input:grab-depth 2
  define input:grab-limit 350
  prefix foaf: <http://xmlns.com/foaf/0.1/>
  prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
  prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
select distinct ?my_id ?firstname ?Knows ?their_id
from named <http://myopenlink.net/dataspace/person/kidehen>
where {

          graph ?g { ?my_id a foaf:Person;
                   foaf:firstName ?firstname;
                   foaf:knows ?their_id .
               ?their_id foaf:nick ?Knows.}
            }
limit 350


-- Query 5
define input:grab-var "?more"
  define input:grab-depth 10
  define input:grab-limit 100
  define input:grab-base <http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1300>
  prefix foaf: <http://xmlns.com/foaf/0.1/>
  prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
  prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
select ?id ?firstname ?nick
where {
    graph ?g {
               ?id rdf:type foaf:Person.
               ?id foaf:firstName ?firstname.
               ?id foaf:knows ?fn .
               ?fn foaf:nick ?nick.
               optional { ?id rdfs:SeeAlso ?more }
            }
}
limit 10

-- Query 6

#service:/sparql
#should-sponge:soft

	define input:same-as "yes"
	PREFIX geonames: <http://www.geonames.org/ontology#>

	SELECT *
	WHERE {?s geonames:parentFeature ?z}


#service:/sparql
#should-sponge:soft

-- Query 7
define input:grab-follow-predicate <http://dbpedia.org/property/hasPhotoCollection>
define input:grab-depth 10
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

SELECT distinct * WHERE {<http://dbpedia.org/resource/Munich> foaf:depiction ?z}



-- Query 8
define input:grab-follow-predicate <foaf:knows>
define input:grab-depth 10
define input:grab-limit 100
prefix foaf: <http://xmlns.com/foaf/0.1/>
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
select distinct ?my_id ?Knows ?their_id ?fname where

 {
   <http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/1300> foaf:maker ?my_id.
   ?my_id a foaf:Person .
   optional { ?my_id foaf:nick ?fname }.
   optional { ?my_id foaf:knows ?their_id }.
   optional { ?their_id foaf:nick ?Knows }.

 }


See Also:

1. http://www4.wiwiss.fu-berlin.de/bizer/ng4j/semwebclient/#examples