@prefix this: <https://w3id.org/np/RAIy6NKfnpmPM35UbS0PZOqaykhOumFrzSKZMCzdIXMvw> .
@prefix sub: <https://w3id.org/np/RAIy6NKfnpmPM35UbS0PZOqaykhOumFrzSKZMCzdIXMvw/> .
@prefix np: <http://www.nanopub.org/nschema#> .
@prefix grlc: <https://w3id.org/kpxl/grlc/> .
@prefix dct: <http://purl.org/dc/terms/> .
@prefix nt: <https://w3id.org/np/o/ntemplate/> .
@prefix npx: <http://purl.org/nanopub/x/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix orcid: <https://orcid.org/> .
@prefix prov: <http://www.w3.org/ns/prov#> .
@prefix foaf: <http://xmlns.com/foaf/0.1/> .

<https://w3id.org/np/RAIy6NKfnpmPM35UbS0PZOqaykhOumFrzSKZMCzdIXMvw> a np:Nanopublication;
  np:hasAssertion sub:assertion;
  np:hasProvenance sub:provenance;
  np:hasPublicationInfo sub:pubinfo;
  dct:created "2026-06-23T13:17:12Z"^^xsd:dateTime;
  dct:creator orcid:0000-0002-1267-0234;
  dct:license <https://creativecommons.org/licenses/by/4.0/>;
  npx:introduces sub:get-concluded-sub-space-projects;
  npx:supersedes <https://w3id.org/np/RA7jpBIHPH90uYPSddZosaZx00ltGz14gtsz9znaw6ThA>;
  nt:wasCreatedFromProvenanceTemplate <https://w3id.org/np/RA7lSq6MuK_TIC6JMSHvLtee3lpLoZDOqLJCLXevnrPoU>;
  nt:wasCreatedFromPubinfoTemplate <https://w3id.org/np/RA0J4vUn_dekg-U1kK3AOEt02p9mT2WO03uGxLDec1jLw>,
    <https://w3id.org/np/RAukAcWHRDlkqxk7H2XNSegc1WnHI569INvNr-xdptDGI>;
  nt:wasCreatedFromTemplate <https://w3id.org/np/RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k> .

sub:get-concluded-sub-space-projects a grlc:grlc-query;
  dct:description "Returns the concluded projects (defined as Spaces) that are sub-spaces of the given space, together with their top-down approved project lead. A project counts as concluded when it has an end date that lies before today.";
  dct:license <http://www.apache.org/licenses/LICENSE-2.0>;
  rdfs:label "Get concluded sub-space projects";
  grlc:endpoint <https://w3id.org/np/l/nanopub-query-1.1/repo/type/8ad572d99071cc1ba0c16e54087b43594bdd9e8b2cfb62d2a0b16945fc49e53c>;
  grlc:sparql """prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix dct: <http://purl.org/dc/terms/>
prefix np: <http://www.nanopub.org/nschema#>
prefix npa: <http://purl.org/nanopub/admin/>
prefix npx: <http://purl.org/nanopub/x/>
prefix gen: <https://w3id.org/kpxl/gen/terms/>
prefix schema: <http://schema.org/>
prefix foaf: <http://xmlns.com/foaf/0.1/>
prefix xsd: <http://www.w3.org/2001/XMLSchema#>

select distinct ?project ?project_label ?dates ?lead ?lead_label ?description ?np (\"^\" as ?np_label) where {
  graph npa:graph {
    ?np npa:hasValidSignatureForPublicKeyHash ?pubkey .
    filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . }
    filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }
    ?np npx:introduces ?project .
    ?np np:hasAssertion ?a .
    ?np dct:created ?npDate .
    filter not exists {
      ?np2 npx:introduces ?project .
      ?np2 npa:hasValidSignatureForPublicKeyHash ?pubkey2 .
      filter not exists { ?npx2 npx:invalidates ?np2 ; npa:hasValidSignatureForPublicKeyHash ?pubkey2 . }
      ?np2 dct:created ?npDate2 .
      filter(?npDate2 > ?npDate)
    }
  }
  graph ?a {
    ?project a gen:Space .
    ?project a gen:Project .
    ?project rdfs:label ?project_label .
    optional { ?project dct:description ?description . }
    optional { ?project schema:startDate ?datetime . }
    ?project schema:endDate ?endDatetime .
  }
  service <https://w3id.org/np/l/nanopub-query-1.1/repo/spaces> {
    graph npa:graph { npa:thisRepo npa:hasCurrentSpaceState ?stateG . }
    graph ?stateG { ?_resource_iri npa:hasSubSpace ?project . }
    optional {
      graph npa:spacesGraph {
        ?riStem (npa:regularProperty|npa:inverseProperty) gen:hasProjectLead ;
                npa:forSpace ?project ; npa:forAgent ?lead .
      }
      graph ?stateG { ?riFull npa:forSpace ?project ; npa:forAgent ?lead . }
      filter(strstarts(str(?riFull), concat(str(?riStem), \"__\")))
      optional { graph ?stateG { ?lead foaf:name ?lead_label } }
    }
  }
  bind(xsd:date(substr(str(?endDatetime), 1, 10)) as ?endDate)
  bind(xsd:date(substr(str(now()), 1, 10)) as ?today)
  filter(?endDate < ?today)
  bind(substr(str(?datetime), 1, 10) as ?startDay)
  bind(substr(str(?endDatetime), 1, 10) as ?endDay)
  bind(if(!bound(?datetime), ?endDay, if(?startDay = ?endDay, concat(?startDay, \" \", substr(str(?datetime), 12, 5)), concat(?startDay, \" – \", ?endDay))) as ?dates)
} order by ?startDay""" .

sub:assertion prov:wasAttributedTo orcid:0000-0002-1267-0234 .

orcid:0000-0002-1267-0234 foaf:name "Tobias Kuhn" .

sub:sig npx:hasAlgorithm "RSA";
  npx:hasPublicKey "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB";
  npx:hasSignature "H1F4pPFJMeIPMP95fpMwC9ebT57LsRevSNlqGtRb/FEWr6M/6pUhRwDpkG3Gtdcye47CsCx5X1dsr0XKJcL6Otg1kqAaCkzPyesuIPd1UzQYJIZg+eYbBIzGd3gGjhIoeQv1d/A6elw6rpDlo0X68Mos+BScvF1ALVMyKicoRBU=";
  npx:hasSignatureTarget <https://w3id.org/np/RAIy6NKfnpmPM35UbS0PZOqaykhOumFrzSKZMCzdIXMvw>;
  npx:signedBy orcid:0000-0002-1267-0234 .