query-843734498dd4740cefb622883108f072

rq turtle/ttl

Bubble chart of numbers of male and female authors in srpELTeC and srpELTeC-extended

Use at

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#>
#defaultView:BubbleChart
SELECT ?polA ?pol (COUNT(DISTINCT ?author) as ?count) 
WHERE {
    VALUES ?collection { wd:Q106936149 wd:Q109123373  }
    ?novel  wdt:P31  wd:Q7725634;
            wdt:P50 ?author;
            wdt:P747 ?edition.
    ?edition wdt:P1433 ?collection.
    ?author wdt:P21 ?polA.
   OPTIONAL {
        ?polA rdfs:label ?pol
        filter (lang(?pol) = "sr")
    }
  }
GROUP BY ?polA ?pol 
ORDER BY DESC(?count) ASC(?pol)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?author"):::projected v3("?collection") v8("?count") v6("?edition") v4("?novel") v2("?pol"):::projected v7("?polA"):::projected c3(["wd:Q7725634"]):::iri bind0[/VALUES ?collection/] bind0-->v3 bind00(["wd:Q106936149"]) bind00 --> bind0 bind01(["wd:Q109123373"]) bind01 --> bind0 v4 --"wdt:P31"--> c3 v4 --"wdt:P50"--> v5 v4 --"wdt:P747"--> v6 v6 --"wdt:P1433"--> v3 v5 --"wdt:P21"--> v7 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v7 -."rdfs:label".-> v2 end bind2[/"count(?author)"/] v5 --o bind2 bind2 --as--o v8