query-4b70b406bcd347b14a0062ecae56eb22

rq turtle/ttl

(Q47461344)written work

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?type_of_work ?type_of_workLabel ?count
WHERE
{
  {
    SELECT ?type_of_work (COUNT(*) as ?count)
    WHERE
    {
      ?work wdt:P50 ?p .
      ?p wikibase:sitelinks 1 .
      [] schema:about ?p ; schema:isPartOf / wikibase:wikiGroup "wikisource" .
      ?work wdt:P31 ?type_of_work .
      MINUS
      {
        ?type_of_work wdt:P279* wd:Q47461344 . # Exclude written works

      }
    }
    GROUP BY ?type_of_work
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?count"):::projected v3("?p") v4("?type_of_work"):::projected v2("?work") a1((" ")) a2((" ")) c10(["wd:Q47461344"]):::iri c3(["1^^xsd:integer"]):::literal c12(["bd:serviceParam"]):::iri c14(["#91;AUTO_LANGUAGE#93;,en"]):::literal c7(["wikisource"]):::literal v2 --"wdt:P50"--> v3 v3 --"wikibase:sitelinks"--> c3 a1 --"schema:about"--> v3 a1 --"schema:isPartOf"--> a2 a2 --"wikibase:wikiGroup"--> c7 v2 --"wdt:P31"--> v4 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v4 --"wdt:P279"--> c10 end bind2[/"count(*)"/] bind2 --as--o v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end