@prefix this: <https://w3id.org/np/RAvO2pFGy2AONKhIur4XAE_aJcVVeM9pEBoZPfxjl1NUY> .
@prefix sub: <https://w3id.org/np/RAvO2pFGy2AONKhIur4XAE_aJcVVeM9pEBoZPfxjl1NUY/> .
@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/> .

sub:Head {
  this: a np:Nanopublication;
    np:hasAssertion sub:assertion;
    np:hasProvenance sub:provenance;
    np:hasPublicationInfo sub:pubinfo .
}

sub:assertion {
  sub:get-all-spaces a grlc:grlc-query;
    dct:description "Returns one row per known space with its label, type IRI and short type name, plus the number of members (Admin + Maintainer + Member tiers) and the number of observers (Observer tier), ordered by member count (most first), then alphabetically by space label. Intended for the /spaces table view.";
    dct:license <http://www.apache.org/licenses/LICENSE-2.0>;
    rdfs:label "Get all spaces";
    grlc:endpoint <https://w3id.org/np/l/nanopub-query-1.1/repo/spaces>;
    grlc:sparql """prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix npa: <http://purl.org/nanopub/admin/>
prefix npx: <http://purl.org/nanopub/x/>
prefix gen: <https://w3id.org/kpxl/gen/terms/>

select ?space_iri (sample(?lbl) as ?space_iri_label) (sample(?t) as ?type) (sample(?tlbl) as ?type_label) (coalesce(sample(?mc), 0) as ?members_count) (coalesce(sample(?oc), 0) as ?observers_count) where {
  graph npa:spacesGraph {
    ?spaceRef a npa:SpaceRef ; npa:spaceIri ?space_iri .
    ?def a npa:SpaceDefinition ;
         npa:forSpaceRef ?spaceRef ;
         npa:viaNanopub  ?np .
  }
  graph npa:graph {
    ?np rdfs:label ?lbl .
    ?np npx:hasNanopubType ?t .
    filter(strstarts(str(?t), \"https://w3id.org/kpxl/gen/terms/\"))
    filter(?t != gen:Space)
  }
  filter not exists { graph npa:graph { ?invNp npx:invalidates ?np . } }
  bind(strafter(str(?t), \"https://w3id.org/kpxl/gen/terms/\") as ?tlbl)
  optional {
    select ?space_iri (count(distinct ?memberAgent) as ?mc) (count(distinct ?observerAgent) as ?oc) where {
      graph npa:graph { <http://purl.org/nanopub/admin/thisRepo> npa:hasCurrentSpaceState ?g . }
      graph ?g {
        ?ri a gen:RoleInstantiation ; npa:forSpace ?space_iri ; npa:forAgent ?agent ; npa:hasRoleType ?tier .
      }
      bind(if(?tier != gen:ObserverRole, ?agent, ?unboundM) as ?memberAgent)
      bind(if(?tier = gen:ObserverRole, ?agent, ?unboundO) as ?observerAgent)
    } group by ?space_iri
  }
} group by ?space_iri order by desc(coalesce(sample(?mc), 0)) lcase(sample(?lbl))""" .
}

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

sub:pubinfo {
  orcid:0000-0002-1267-0234 foaf:name "Tobias Kuhn" .
  
  this: dct:created "2026-06-24T11:50:46Z"^^xsd:dateTime;
    dct:creator orcid:0000-0002-1267-0234;
    dct:license <https://creativecommons.org/licenses/by/4.0/>;
    npx:introduces sub:get-all-spaces;
    npx:supersedes <https://w3id.org/np/RAlSgMFS1RJc1z7DM69BQ6HT2FEo46fm9JER7bQ6q1TA8>;
    nt:wasCreatedFromProvenanceTemplate <https://w3id.org/np/RA7lSq6MuK_TIC6JMSHvLtee3lpLoZDOqLJCLXevnrPoU>;
    nt:wasCreatedFromPubinfoTemplate <https://w3id.org/np/RA0J4vUn_dekg-U1kK3AOEt02p9mT2WO03uGxLDec1jLw>,
      <https://w3id.org/np/RAoTD7udB2KtUuOuAe74tJi1t3VzK0DyWS7rYVAq1GRvw>, <https://w3id.org/np/RAukAcWHRDlkqxk7H2XNSegc1WnHI569INvNr-xdptDGI>;
    nt:wasCreatedFromTemplate <https://w3id.org/np/RARuOLDzf45L_wBceBownrcLLvAKP-2yB-uwJJx8H7IWI> .
  
  sub:sig npx:hasAlgorithm "RSA";
    npx:hasPublicKey "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB";
    npx:hasSignature "NgstlKnIqUOmZslb6NXywgfnVFJLoiR+WNYJ+gI6nEg96wIjQqCx8RTiooHxuxd9Am2T194XEOb9q40d1ruEizluNnZgkTAmSLDo7M2nn6Upim6Mxtj94OUmJCvwlj9WOefs6gOeM3swa7G4WJhb8P+XZCn3uCYUqQLwqg3vjck=";
    npx:hasSignatureTarget this:;
    npx:signedBy orcid:0000-0002-1267-0234 .
}