@prefix this: <https://w3id.org/np/RA65q4mwINEvg2wTYHGpcH1F6BkOqaBYZ_iijX_JXSJ0A> .
@prefix sub: <https://w3id.org/np/RA65q4mwINEvg2wTYHGpcH1F6BkOqaBYZ_iijX_JXSJ0A/> .
@prefix np: <http://www.nanopub.org/nschema#> .
@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: np:hasAssertion sub:assertion;
    np:hasProvenance sub:provenance;
    np:hasPublicationInfo sub:pubinfo;
    a np:Nanopublication .
}

sub:assertion {
  sub:find-gofair-qualified-things dct:description "This query allows for searching for resources (FERs etc.) together with the info about whether GO FAIR qualified them.";
    dct:license <http://www.apache.org/licenses/LICENSE-2.0>;
    a <https://w3id.org/kpxl/grlc/grlc-query>;
    rdfs:label "Find GO FAIR qualified things (TESTING)";
    <https://w3id.org/kpxl/grlc/endpoint> <https://w3id.org/np/l/nanopub-query-1.1/repo/full>;
    <https://w3id.org/kpxl/grlc/sparql> """prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix np: <http://www.nanopub.org/nschema#>
prefix npa: <http://purl.org/nanopub/admin/>
prefix npx: <http://purl.org/nanopub/x/>
prefix xsd: <http://www.w3.org/2001/XMLSchema#>
prefix dct: <http://purl.org/dc/terms/>
prefix fip: <https://w3id.org/fair/fip/terms/>

select distinct ?thing ?label ?description ?np ?date ?pubkey ?retraction ?newversion ?qualifier ?qualification_np (group_concat(distinct ?recommender; separator=\" \") as ?recommenders) (group_concat(distinct ?recommendation_np; separator=\" \") as ?recommendation_nps) (count(distinct ?recommender) as ?recommender_count) where {
  graph npa:graph {
    ?np npx:hasNanopubType ?__type_iri .
    ?np npa:hasValidSignatureForPublicKey ?pubkey .
    optional { ?retraction npx:retracts ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
    optional { ?newversion npx:supersedes ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
    ?np (npx:introduces|npx:describes) ?thing .
    ?np rdfs:label ?label .
    ?np dct:description ?description .
    ?np dct:created ?date .
    filter(str(?date) > \"2022\")
  }
  bind(concat(\" \",lcase(str(?label)),\" \",lcase(str(?description)),\" \") as ?text)
  filter( contains(?text, lcase(str(?_searchterm))) )

  optional {
    graph npa:graph {
      ?disapproval np:hasAssertion ?da .
      ?disapproval npa:hasValidSignatureForPublicKey ?dpubkey .
      filter not exists { ?disapproval_x npx:invalidates ?disapproval ; npa:hasValidSignatureForPublicKey ?dpubkey . }
    }
    graph <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y/assertion> {
      ?dpubkeys npx:hasPublicKey ?dpubkey .
    }
    graph ?da {
      ?dsomebody ( npx:disapproves-of | npx:disapprovesOf ) ?np .
    }
  } filter(!bound(?disapproval))  # Faster than \"filter not exists\" for some reason

  optional {
    graph npa:graph {
      ?qualification_np npx:hasNanopubType npx:qualifies .
      ?qualification_np np:hasAssertion ?qa .
      ?qualification_np npa:hasValidSignatureForPublicKey ?qpubkey .
      filter not exists { ?qualification_np_x npx:invalidates ?qualification_np ; npa:hasValidSignatureForPublicKey ?qpubkey . }
    }
    graph <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y/assertion> {
      ?qpubkeys npx:hasPublicKey ?qpubkey .
    }
    graph ?qa {
      ?qualifier npx:qualifies ?np .
    }
  }

  optional {
    graph npa:graph {
      ?recommendation_np npx:hasNanopubType fip:recommended-by .
      ?recommendation_np np:hasAssertion ?ra .
      ?recommendation_np npa:hasValidSignatureForPublicKey ?rpubkey .
      filter not exists { ?recommendation_np_x npx:invalidates ?recommendation_np ; npa:hasValidSignatureForPublicKey ?rpubkey . }
    }
    graph <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y/assertion> {
      ?rpubkeys npx:hasPublicKey ?rpubkey .
    }
    graph ?ra {
      ?thing fip:recommended-by ?recommender .
    }
    filter exists {
      graph npa:graph {
        ?fip_np npx:hasNanopubType fip:Reference-FAIR-Implementation-Profile .
        ?fip_np npa:hasValidSignatureForPublicKey ?fip_pubkey .
        filter not exists { ?fip_np_x npx:invalidates ?fip_np ; npa:hasValidSignatureForPublicKey ?fip_pubkey . }
        ?fip_np np:hasAssertion ?fip_np_a .
      }
      graph <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y/assertion> {
        ?dpubkeys npx:hasPublicKey ?fip_pubkey .
      }
      graph ?fip_np_a {
        ?fip fip:has-declaration-index ?index .
      }
      graph npa:graph {
        ?index np:hasAssertion ?index_a .
      }
      graph ?index_a {
        ?index npx:includesElement ?decl_np .
      }
      graph npa:graph {
        ?decl_np npx:hasNanopubType fip:FIP-Declaration .
        ?decl_np np:hasAssertion ?decl_np_a
      }
      graph ?decl_np_a {
        ?subj ?pred ?thing .
        values ?pred { fip:declares-current-use-of fip:declares-planned-use-of }
        ?decl fip:declared-by ?recommender .
      }
    }
  }
}
group by ?thing ?label ?description ?np ?date ?pubkey ?retraction ?newversion ?qualifier ?qualification_np
order by desc(?recommender_count) asc(?label)""" .
}

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 "2025-07-09T18:55:57.174Z"^^xsd:dateTime;
    dct:creator orcid:0000-0002-1267-0234;
    dct:license <https://creativecommons.org/licenses/by/4.0/>;
    npx:embeds sub:find-gofair-qualified-things;
    npx:supersedes <https://w3id.org/np/RAh0Y7U-SW6PbLjqN6bRm4yZhpifie2TgWapsy7IuW7l0>;
    npx:wasCreatedAt <https://nanodash.knowledgepixels.com/>;
    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/RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k> .
  
  sub:sig npx:hasAlgorithm "RSA";
    npx:hasPublicKey "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQD4Wj537OijfOWVtsHMznuXKISqBhtGDQZfdO6pbb4hg9EHMcUFGTLbWaPrP783PHv8HMAAPjvEkHLaOHMIknqhaIa5236lfBO3r+ljVdYBElBcLvROmwG+ZGtmPNZf7lMhI15xf5TfoaSa84AFRd5J2EXekK6PhaFQhRm1IpSYtwIDAQAB";
    npx:hasSignature "qCW09muatHmnlEJ0Blg4V20+/LaTXIQF598Dg1WJro22qEvM9C1lXBjdsKsJKZYZ03V9xbwVXYA5lU807sgMj7yVqqzniHVHEJJqcZYIedcsdYVt0vMZ7a+aNT2rGKxKI0nmfoO3H59QcljYPLbrKwfF5AeF34H3GXrt1VbV9WY=";
    npx:hasSignatureTarget this:;
    npx:signedBy orcid:0000-0002-1267-0234 .
}