query-929905f59d3d911fb5746fc6748f9d3a

rq turtle/ttl

List of all economists in PM20

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select ?item ?itemLabel ?pm20
where {

  # items with PM20 id
  ?item wdt:P4293 ?pm20Id ;
        wdt:P106 ?occupation .

  # occupation: economist or business economist
  filter(?occupation in (wd:Q188094, wd:Q1860032))

  # restrict to items with online accessible articles
  ?item p:P4293/pq:P5592 ?workCount .
  filter(?workCount > 0)

  # add folder link
  bind(uri(concat('http://purl.org/pressemappe20/folder/', ?pm20Id)) as ?pm20)

  # add labels
  service wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en, de, fr, es, nl, pl, ru". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?item"):::projected v2("?occupation") v5("?pm20"):::projected v4("?pm20Id") v1("?workCount") a1((" ")) c9(["bd:serviceParam"]):::iri c11(["#91;AUTO_LANGUAGE#93;,en, de, fr, es, nl, pl, ru"]):::literal f0[["?workCount > '0^^xsd:integer'"]] f0 --> v1 list0c2(["wd:Q1860032"]):::iri list0c1(["wd:Q188094"]):::iri list0c1 --o f1 list0c2 --o f1 f1[[" in "]] f1 --> v2 v3 --"p:direct/P4293"--> v4 v3 --"p:direct/P106"--> v2 v3 --"p:P4293"--> a1 a1 --"p:qualifier/P5592"--> v1 bind2[/"concat('http://purl.org/pressemappe20/folder/',?pm20Id)"/] v4 --o bind2 bind2 --as--o v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 end