reteplayground
Select

🤝 Repositories shared by two institutions

RepositoryShared bySectors+1
k8upk8up + VSHN AGCommunities / IT
hitobitoHitobito + Puzzle ITCCommunities / IT
mf-geoadmin3Bundesamt für Landest…Gov Federal
web-mapviewerBundesamt für Landest…Gov Federal
Run this query → no server · no download · no account
caviri.github.io/rete
Run this query in the playground → 30 rows · 353 ms · no server, no download — the query runs in your browser.

The query

PREFIX ossb: <https://w3id.org/rete/oss-benchmark#> PREFIX pulse: <https://open-pulse.epfl.ch/ontology#> PREFIX gme: <https://openpulse.science/git-metadata-extractor#> PREFIX org: <http://www.w3.org/ns/org#> PREFIX schema: <http://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?repoName (GROUP_CONCAT(DISTINCT ?in; SEPARATOR=' + ') AS ?institutions) (GROUP_CONCAT(DISTINCT ?sec; SEPARATOR=' / ') AS ?sectors) (SAMPLE(?st) AS ?stars) WHERE { ?repo a schema:SoftwareSourceCode ; schema:name ?repoName ; ossb:attributedToInstitution ?i ; pulse:githubRepoStars ?st . ?i schema:name ?in ; ossb:sector ?s . ?s skos:prefLabel ?sec . } GROUP BY ?repo ?repoName HAVING (COUNT(DISTINCT ?i) > 1) ORDER BY DESC(?stars) LIMIT 30

rete playground · documentation · github.com/caviri/rete