query-e877f73230ae9b8044f62ee8b7588cd7

rq turtle/ttl

Descriptions of rowing persons

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?desc ?genderLbl ?cocLbl (COUNT(?desc) AS ?cnt) {
  ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 .
  OPTIONAL {
    ?item wdt:P21 ?gender .
    ?gender rdfs:label ?genderLbl .
    FILTER(LANG(?genderLbl) = 'de') .
  }
  OPTIONAL {
    ?item wdt:P27 ?coc .
    ?coc rdfs:label ?cocLbl .
    FILTER(LANG(?cocLbl) = 'de') .
  }
  ?item schema:description ?desc .
  FILTER(LANG(?desc) = 'de') .
} GROUP BY ?desc ?genderLbl ?cocLbl ORDER BY DESC(?cnt)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v8("?cnt") v7("?coc") v3("?cocLbl"):::projected v2("?desc"):::projected v6("?gender") v4("?genderLbl"):::projected v5("?item") a1((" ")) a2((" ")) c5(["wd:Q26270618"]):::iri f0[["?desc = 'de'"]] f0 --> v2 v5 --"p:P106"--> a1 a1 --"p:statement/P106"--> a2 a2 --"p:direct/P279"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:direct/P21".-> v6 v6 --"rdfs:label"--> v4 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:direct/P27".-> v7 v7 --"rdfs:label"--> v3 end v5 --"schema:description"--> v2 bind2[/"count(?desc)"/] v2 --o bind2 bind2 --as--o v8