GeoLink: Person Awards

#SPARQL Endpoint: http://data.geolink.org/sparql

PREFIX gl: <http://schema.geolink.org/1.0/base/main#>

SELECT DISTINCT ?person ?award ?award_title ?abstract ?start ?end ?sponsor_name (group_concat(distinct ?org_name;separator=":::") as ?sub_sponsor_names) ?match ?id_value ?id_scheme ?id_uri
WHERE {

  {
    ?award a gl:Award .
    ?cruise gl:hasAward ?award .
    ?cruise a gl:Cruise .
    ?person ?pred ?cruise .
  
    {
     SELECT DISTINCT ?person
     WHERE {
       {
         ?person a gl:Person .
         ?person owl:sameAs <http://data.rvdata.us/id/person/109399> .
       }
       UNION {
         ?person a gl:Person .
         <http://data.rvdata.us/id/person/109399> owl:sameAs ?person .
       }
       UNION {
         ?person a gl:Person .
         <http://data.rvdata.us/id/person/109399> owl:sameAs ?match .
         ?match owl:sameAs ?person .
       }
       UNION {
         ?person a gl:Person .
         <http://data.rvdata.us/id/person/109399> owl:sameAs ?match .
         ?person owl:sameAs ?match .
       }
       UNION {
         ?person a gl:Person .
         FILTER (?person = <http://data.rvdata.us/id/person/109399>)
       }
     }
   }
  } UNION {
    ?award a gl:Award .
    ?award ?role ?person .
  
    {
     SELECT DISTINCT ?person
     WHERE {
       {
         ?person a gl:Person .
         ?person owl:sameAs <http://data.rvdata.us/id/person/109399> .
       }
       UNION {
         ?person a gl:Person .
         <http://data.rvdata.us/id/person/109399> owl:sameAs ?person .
       }
       UNION {
         ?person a gl:Person .
         <http://data.rvdata.us/id/person/109399> owl:sameAs ?match .
         ?match owl:sameAs ?person .
       }
       UNION {
         ?person a gl:Person .
         <http://data.rvdata.us/id/person/109399> owl:sameAs ?match .
         ?person owl:sameAs ?match .
       }
       UNION {
         ?person a gl:Person .
         FILTER (?person = <http://data.rvdata.us/id/person/109399>)
       }
     }
   }
  }
  OPTIONAL {
    ?award gl:hasTitle ?award_title .
  }
  OPTIONAL {
    ?award gl:hasIdentifier ?identifier .
    ?identifier gl:hasIdentifierValue ?id_value .
    OPTIONAL {
      ?identifier gl:hasIdentifierScheme ?id_scheme .
    }
    OPTIONAL {
      ?identifier gl:hasIdentifierResolveURI ?id_uri .
    }
  }
  OPTIONAL {
    ?award gl:hasAbstract ?abstract .
  }
  OPTIONAL {
    ?award gl:hasStartDate ?start .
  }
  OPTIONAL {
    ?award gl:hasEndDate ?end .
  }
  OPTIONAL {
    ?award gl:hasSponsor ?sponsor .
    ?sponsor gl:hasTitle ?sponsor_name .
    OPTIONAL {
      ?org gl:hasSubOrganization+ ?sponsor .
      ?org gl:hasTitle ?org_name .
    }
  }
  OPTIONAL {
    ?award owl:sameAs ?match .
    ?match a gl:Award .
  }
}
ORDER BY ?start ?sponsor_name ?award_title ?end