@prefix this: <https://w3id.org/np/RAhzAprDuCF-20742WmzdkJ4luAdKW5zNHPqjU1joqJD8> .
@prefix sub: <https://w3id.org/np/RAhzAprDuCF-20742WmzdkJ4luAdKW5zNHPqjU1joqJD8/> .
@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/RAhzAprDuCF-20742WmzdkJ4luAdKW5zNHPqjU1joqJD8> a np:Nanopublication;
  np:hasAssertion sub:assertion;
  np:hasProvenance sub:provenance;
  np:hasPublicationInfo sub:pubinfo;
  dct:created "2026-06-23T13:37:43Z"^^xsd:dateTime;
  dct:creator orcid:0000-0002-1267-0234;
  dct:license <https://creativecommons.org/licenses/by/4.0/>;
  npx:introduces sub:get-ongoing-and-upcoming-sub-space-projects;
  npx:supersedes <https://w3id.org/np/RA35FBp7_6xTRnCGw20Y5JXHUp4byjNXzE5zZpPr1dJls>;
  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-ongoing-and-upcoming-sub-space-projects a grlc:grlc-query;
  dct:description "Returns the ongoing and upcoming projects (defined as Spaces) that are sub-spaces of the given space, together with their project lead. A project counts as ongoing/upcoming when it has no end date or its end date is today or later. A lead is only shown when it is a validated (top-down approved) holder of a project-lead role that is attached to that project at Member tier or above (observer-tier, self-attestable lead roles are excluded).";
  dct:license <http://www.apache.org/licenses/LICENSE-2.0>;
  rdfs:label "Get ongoing and upcoming 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 . }
    optional { ?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 .
        ?ra a gen:RoleAssignment ; npa:forSpace ?project ; gen:hasRole ?role .
        ?rd npa:role ?role ; (gen:hasRegularProperty|gen:hasInverseProperty) gen:hasProjectLead ; npa:hasRoleType ?roleType .
        filter(?roleType in (gen:MemberRole, gen:MaintainerRole, gen:AdminRole))
      }
      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(?datetime), 1, 10)) as ?startDate)
  bind(xsd:date(substr(str(?endDatetime), 1, 10)) as ?endDate)
  bind(xsd:date(substr(str(now()), 1, 10)) as ?today)
  filter(!bound(?endDate) || ?endDate >= ?today)
  bind(substr(str(?datetime), 1, 10) as ?startDay)
  bind(if(bound(?endDatetime), substr(str(?endDatetime), 1, 10), ?startDay) as ?endDay)
  bind(if(?startDay = ?endDay, concat(?startDay, \" \", substr(str(?datetime), 12, 5)), concat(?startDay, \" – \", ?endDay)) as ?dates)
} order by ?startDate""" .

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 "rcvO5tvImn/BUnFGhfEEpxQ05ekIQPj9K5Trg126SRXwHILOCNm4DlhGbmprXbfIRIvk1CDsW6Hdw78sZELsdzJmJHq2hi0rBN1n7BMaEZrFM7eKbvUfT9G4xJYMeDn+ilIwhDhehgwp9SQP1hwCte/gvJt+Nq/o5AhCyAOJ9VY=";
  npx:hasSignatureTarget <https://w3id.org/np/RAhzAprDuCF-20742WmzdkJ4luAdKW5zNHPqjU1joqJD8>;
  npx:signedBy orcid:0000-0002-1267-0234 .