query-d96336345381463e9494a42ab4c634ba

rq turtle/ttl

Personenliste - Alle Personen, die Maler in der Renaissance waren (Tätigkeitliste, Epochenliste) TODO

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel 
(GROUP_CONCAT(DISTINCT ?occupation; SEPARATOR = ",") AS ?occupationUID) 
(GROUP_CONCAT(DISTINCT ?occupationLabel; SEPARATOR = ",") AS ?occupations) 
(GROUP_CONCAT(DISTINCT ?movementLabel; SEPARATOR = ",") AS ?movements) 

WHERE {
  ?item wdt:P106 ?o;              # constrain what items are returned by predicate values in the filters
        wdt:P135 ?m.
  FILTER(?m IN(wd:Q4692, wd:Q1472236, wd:Q1474884, wd:Q979160))
  FILTER(?o IN(wd:Q1028181))

  ?item wdt:P106 ?occupation;    # find out all values of these two predicates
      wdt:P135 ?movement.
#  FILTER(?occupation NOT IN(wd:Q1028181))

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    ?item rdfs:label ?itemLabel.
    ?occupation rdfs:label ?occupationLabel.
    ?movement rdfs:label ?movementLabel.
  }
}
GROUP BY ?item ?itemLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?item"):::projected v6("?itemLabel"):::projected v2("?m") v5("?movement") v8("?movementLabel"):::projected v11("?movements") v1("?o") v4("?occupation"):::projected v7("?occupationLabel"):::projected v9("?occupationUID") v10("?occupations") c9(["bd:serviceParam"]):::iri c11(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["?o = 'wd:Q1028181'"]] f0 --> v1 list0c4(["wd:Q979160"]):::iri list0c1(["wd:Q4692"]):::iri list0c3(["wd:Q1474884"]):::iri list0c2(["wd:Q1472236"]):::iri list0c1 --o f1 list0c2 --o f1 list0c3 --o f1 list0c4 --o f1 f1[[" in "]] f1 --> v2 v3 --"wdt:P106"--> v1 v3 --"wdt:P135"--> v2 v3 --"wdt:P106"--> v4 v3 --"wdt:P135"--> v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 v3 --"rdfs:label"--> v6 v4 --"rdfs:label"--> v7 v5 --"rdfs:label"--> v8 end bind5[/"?occupation"/] v4 --o bind5 bind5 --as--o v9 bind6[/"?occupationLabel"/] v7 --o bind6 bind6 --as--o v10 bind7[/"?movementLabel"/] v8 --o bind7 bind7 --as--o v11