This query returns plain-text messages and discourse statements (schema:Statement) about the given resource, about its sub-spaces and maintained resources, as well as replies (via as:inReplyTo) to any of these. The 'about' column shows the specific (sub-)space or resource each message is about.
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix foaf: <http://xmlns.com/foaf/0.1/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix schema: <https://schema.org/> prefix schemah: <http://schema.org/> prefix as: <https://www.w3.org/ns/activitystreams#> select ?text (group_concat(distinct concat('link'); separator=", ") as ?link) ?about_multi_iri ?about_label_multi ?user ?date ?np ("^" as ?np_label) where { { select ?a ?s ?text (group_concat(?target; separator=" ") as ?about_multi_iri) (group_concat(replace(replace(?target_label, "\\\\", "\\\\\\\\"), "[\r\n]+", "\\\\n"); separator="\n") as ?about_label_multi) where { select distinct ?a ?s ?text ?target ?target_label where { { select distinct ?target where { service <https://w3id.org/np/l/nanopub-query-1.1/repo/spaces> { graph npa:graph { <http://purl.org/nanopub/admin/thisRepo> npa:hasCurrentSpaceState ?g . } graph ?g { values ?_resource_multi_iri {} ?target (npa:isSubSpaceOf|npa:isMaintainedBy)* ?_resource_multi_iri . } } } } optional { { select ?target (max(concat(str(?tdate), " ", ?tl)) as ?tagged) where { graph ?tg { ?target rdfs:label|dct:title|foaf:name ?tl . } graph npa:graph { ?tnp np:hasAssertion ?tg . ?tnp dct:created ?tdate . ?tnp npa:hasValidSignatureForPublicKeyHash ?tpubkey . filter not exists { ?tnpx npx:invalidates ?tnp ; npa:hasValidSignatureForPublicKeyHash ?tpubkey . } } service <https://w3id.org/np/l/nanopub-query-1.1/repo/spaces> { graph npa:graph { <http://purl.org/nanopub/admin/thisRepo> npa:hasCurrentSpaceState ?g2 . } graph ?g2 { values ?_resource_multi_iri {} ?target (npa:isSubSpaceOf|npa:isMaintainedBy)* ?_resource_multi_iri . } } } group by ?target } } bind(coalesce(strafter(?tagged, " "), replace(str(?target), "^.*[/#]([^/#]+)$", "$1")) as ?target_label) { graph ?a { { ?a rdfs:label ?text . ?a schema:about|schemah:about ?target . bind(?a as ?s) } union { ?s a ?stype . filter(?stype in (schema:Statement, schemah:Statement)) ?s rdf:value ?text . ?s schema:about|schemah:about ?target . } } } union { ?anchor schema:about|schemah:about ?target . ?s as:inReplyTo+ ?anchor . graph ?a { ?s a ?stype2 . filter(?stype2 in (schema:Statement, schemah:Statement)) ?s rdf:value ?text . } } } } group by ?a ?s ?text } optional { graph ?a { ?s rdfs:seeAlso ?link . } } graph npa:graph { ?np np:hasAssertion ?a . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } } optional { graph npa:graph { ?np dct:created ?date . } } optional { graph npa:graph { ?np dct:creator ?user . } } } group by ?text ?about_multi_iri ?about_label_multi ?user ?date ?np order by desc(?date)