query-a4c4cdf7aa05c94039fc1ba38bcdbcc6

rq turtle/ttl

ATC code (P267) statements, code begins "D" (dermatological drugs) SELECT DISTINCT ?item ?itemLabel WHERE {?item wdt:P267 ?string . FILTER (STRSTARTS(?string, "D")) SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } }

Use at

https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#ATC code (P267) statements, code begins "D" (dermatological drugs)
SELECT DISTINCT ?item ?itemLabel
WHERE {?item wdt:P267 ?string .
       FILTER (STRSTARTS(?string, "D"))
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}

Query found at

https://www.wikidata.org/wiki/User:Charles_Matthews/Queries

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?item"):::projected v1("?string") c4(["bd:serviceParam"]):::iri c6(["en"]):::literal f0[["starts-with(?string,'D')"]] f0 --> v1 v2 --"wdt:P267"--> v1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c4 --"wikibase:language"--> c6 end