query-62ad0e4f72d0e3fca035fa2b68e29166

rq turtle/ttl

Missing descriptions of rowing persons by language

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?str (COUNT(*) AS ?cnt) WHERE {
   {
  SELECT DISTINCT ?item WHERE {
    ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 .
    ?item wdt:P21 wd:Q6581072; wdt:P27 wd:Q183 .
  }
}.
  ?item schema:description ?str . FILTER(LANG(?str) = 'es') .
} GROUP BY ?str ORDER BY DESC(?cnt)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?cnt") v3("?item") v2("?str"):::projected a1((" ")) a2((" ")) c5(["wd:Q26270618"]):::iri c9(["wd:Q183"]):::iri c7(["wd:Q6581072"]):::iri f0[["?str = 'es'"]] f0 --> v2 v3 --"p:P106"--> a1 a1 --"p:statement/P106"--> a2 a2 --"p:direct/P279"--> c5 v3 --"p:direct/P21"--> c7 v3 --"p:direct/P27"--> c9 v3 --"schema:description"--> v2 bind2[/"count(*)"/] bind2 --as--o v4