. . . . "Returns the contributed typed relations between two research products, with labels and contributor, excluding retracted or superseded nanopublications (example nanopublications are included, marked in the flags column). The status column links the latest valid approval or disapproval by a member of the given space." . . . "Get OpenAIRE research product relations" . . "prefix np: \nprefix npa: \nprefix npx: \nprefix nt: \nprefix dct: \nprefix foaf: \nprefix owl: \nprefix rdfs: \nprefix cito: \nprefix frbr: \nprefix skos: \nprefix frapo: \nprefix prov: \nprefix gen: \nprefix xsd: \nselect ?subject ?subject_label ?relation ?relation_label ?object ?object_label ?flags ?creator ?creator_label ?date ?action_target ?np ?np_label ?status ?status_label where {\n {\n select ?subject ?subject_label ?relation ?relation_label ?object ?object_label\n (if(?isExample, \"example\", \"\") as ?flags)\n ?creator ?creator_label ?date (?np as ?action_target) ?np (\"^\" as ?np_label)\n (max(if(contains(?memberPubkeys, ?vKey), ?vTag, \"\")) as ?latestTag)\n where {\n values ?_space_multi_iri {}\n service {\n select (group_concat(?mpk; separator=\" \") as ?memberPubkeys) where {\n graph npa:graph { npa:hasCurrentSpaceState ?stateG . }\n values ?_space_multi_iri {}\n graph ?stateG {\n ?ri a gen:RoleInstantiation ; npa:forSpace ?_space_multi_iri ; npa:forAgent ?agent ; npa:hasRoleType ?roleType .\n filter(?roleType in (gen:AdminRole, gen:MaintainerRole, gen:MemberRole))\n ?acct a npa:AccountState ; npa:agent ?agent ; npa:pubkey ?mpk .\n }\n }\n }\n values (?relation ?relation_label) { (cito:cites \"cites\") (cito:isDocumentedBy \"is documented by\") (frbr:partOf \"is part of\") (frbr:revisionOf \"is a revision of\") (frbr:supplement \"is supplemented by\") (skos:exactMatch \"is the same work as\") (prov:wasDerivedFrom \"was derived from\") }\n graph npa:graph {\n ?np npa:hasValidSignatureForPublicKeyHash ?pk .\n filter not exists { ?inp npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pk . }\n filter not exists { ?sup npx:supersedes ?np . }\n ?np dct:created ?date .\n ?np np:hasAssertion ?a .\n ?np np:hasPublicationInfo ?pi .\n }\n graph ?a { ?subject ?relation ?object . }\n filter( ( strstarts(str(?subject), \"https://doi.org/\") || strstarts(str(?subject), \"https://api.openaire.eu/\") ) && ( strstarts(str(?object), \"https://doi.org/\") || strstarts(str(?object), \"https://api.openaire.eu/\") ) )\n optional { graph ?pi { ?subject nt:hasLabelFromApi ?subject_label . } }\n optional { graph ?pi { ?object nt:hasLabelFromApi ?object_label . } }\n optional { graph npa:graph { ?np dct:creator ?creator . } }\n optional { graph ?pi { ?creator foaf:name ?creator_label . } }\n bind(exists { graph npa:graph { ?np npx:hasNanopubType npx:ExampleNanopub . } } as ?isExample)\n optional {\n { select (?vTarget as ?np) ?vKey ?vTag where {\n {\n service {\n graph npa:graph {\n ?vnp npa:hasValidSignatureForPublicKeyHash ?vKey .\n filter not exists { ?vinp npx:invalidates ?vnp ; npa:hasValidSignatureForPublicKeyHash ?vKey . }\n filter not exists { ?vsup npx:supersedes ?vnp . }\n ?vnp dct:created ?vDate .\n ?vnp np:hasAssertion ?va .\n ?vnp np:hasPublicationInfo ?vpi .\n }\n graph ?va { ?vagent npx:approvesOf ?vTarget . }\n optional { graph ?vpi { ?vagent foaf:name ?vName . } }\n bind(concat(str(?vDate), \">approved|\", coalesce(?vName, str(?vagent)), \"|\", str(?vnp)) as ?vTag)\n }\n } union {\n service {\n graph npa:graph {\n ?vnp npa:hasValidSignatureForPublicKeyHash ?vKey .\n filter not exists { ?vinp npx:invalidates ?vnp ; npa:hasValidSignatureForPublicKeyHash ?vKey . }\n filter not exists { ?vsup npx:supersedes ?vnp . }\n ?vnp dct:created ?vDate .\n ?vnp np:hasAssertion ?va .\n ?vnp np:hasPublicationInfo ?vpi .\n }\n graph ?va { ?vagent npx:disapprovesOf ?vTarget . }\n optional { graph ?vpi { ?vagent foaf:name ?vName . } }\n bind(concat(str(?vDate), \">disapproved|\", coalesce(?vName, str(?vagent)), \"|\", str(?vnp)) as ?vTag)\n }\n }\n }\n }\n }\n }\n group by ?subject ?subject_label ?relation ?relation_label ?object ?object_label ?creator ?creator_label ?date ?np ?isExample ?memberPubkeys\n }\n bind(coalesce(?latestTag, \"\") as ?lt)\n bind(strbefore(strafter(?lt, \">\"), \"|\") as ?verdict)\n bind(strafter(?lt, \"|\") as ?vrest)\n bind(strbefore(?vrest, \"|\") as ?vname)\n bind(iri(strafter(?vrest, \"|\")) as ?status)\n bind(xsd:dateTime(strbefore(?lt, \">\")) as ?vdt)\n bind((year(now())*525600 + month(now())*43800 + day(now())*1440 + hours(now())*60 + minutes(now())) - (year(?vdt)*525600 + month(?vdt)*43800 + day(?vdt)*1440 + hours(?vdt)*60 + minutes(?vdt)) as ?minsAgo)\n bind(coalesce(if(?minsAgo < 1, \"just now\", if(?minsAgo < 60, concat(str(?minsAgo), if(?minsAgo = 1, \" minute ago\", \" minutes ago\")), if(?minsAgo < 1440, concat(str(xsd:integer(floor(?minsAgo / 60))), if(xsd:integer(floor(?minsAgo / 60)) = 1, \" hour ago\", \" hours ago\")), concat(str(xsd:integer(floor(?minsAgo / 1440))), if(xsd:integer(floor(?minsAgo / 1440)) = 1, \" day ago\", \" days ago\"))))), \"\") as ?ago)\n bind(coalesce(if(?lt != \"\", concat(?verdict, \" by \", ?vname, \" \", ?ago), \"\"), \"\") as ?status_label)\n}\norder by desc(?date)" . . "Tobias Kuhn" . "2026-07-29T17:53:26Z"^^ . . . . . "Get OpenAIRE research product relations" . . . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" . "lOh+QKMaFHWs8pRZSL/ckM2bxQ37rmRfrJJBvGDdGq93b6UewBJ5y2l0bkayaNBSq/lSNb4RejyilqUwnDVgxY9ty7PXcFyO/AJhqJNNh9nk/uLnyu+jwgyu+3S9lGokOTts2T4Lyh8mMBKv/je6cr6JH6tUgHLAbjHZW4aEGe0=" . . .