Mints used by 3+ successive rulers

Mint Name	Rulers	Who
Amphipolis @en	4	Alexander III of Mace…
Abydus @en	3	Alexander III of Mace…
Lampsacus @en	3	Alexander III of Mace…
Magnesia ad Maeandrum @en	3	Alexander III of Mace…

Run this query → no server · no download · no account

caviri.github.io/rete

Run this query in the playground → 6 rows · 8.3 ms · no server, no download — the query runs in your browser.

The query

PREFIX nmo: <http://nomisma.org/ontology#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT ?mintName (COUNT(DISTINCT ?auth) AS ?rulers) (GROUP_CONCAT(DISTINCT ?authName; SEPARATOR=", ") AS ?who) WHERE { ?type a nmo:TypeSeriesItem ; nmo:hasMint ?mint ; nmo:hasAuthority ?auth . ?mint rdfs:label ?mintName . ?auth rdfs:label ?authName . } GROUP BY ?mintName HAVING(COUNT(DISTINCT ?auth) >= 3) ORDER BY DESC(?rulers)

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