reteplayground
Aggregate

Principios activos más frecuentes

Principio activoNº de medicamentos
HIDROCLOROTIAZIDA885
AMLODIPINO BESILATO527
OLMESARTAN MEDOXOMILO497
PARACETAMOL415
Run this query → no server · no download · no account
caviri.github.io/rete
Run this query in the playground → 50 rows · 1.3 s · 3.0 MB of 278.2 MB read over HTTP range · no server, no download — the query runs in your browser.

The query

PREFIX fmc: <https://w3id.org/rete/farmacos#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?principioActivo (COUNT(DISTINCT ?m) AS ?medicamentos) WHERE { ?m a fmc:Medicamento ; fmc:ingrediente ?i . ?i fmc:principioActivo ?p . ?p skos:prefLabel ?principioActivo . } GROUP BY ?principioActivo ORDER BY DESC(?medicamentos) LIMIT 50

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