query-c0171e75be9af03135996a775c999d2d

rq turtle/ttl

(55) Scatter chart: characters in Water Margin chaptersNo.55 (2020.12.17T1159 created)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# scatter chart of characters in Water Margin chapters (also viewable as table)
#defaultView:ScatterChart
### Note: 1. The 1st non-item variable (?chapter_number) is X-axis,
### and the 2nd non-item variable (?characterLabel) is Y-axis.
### 2. The data type of P792 (chapter) is string, so ?chapter_number cannot be ordered as number in table's column.
### But ?chapter_number can be ordered as number in scatter chart's axis.
SELECT DISTINCT ?character ?chapter_number ?characterLabel
WHERE {
  # ?chapter is instance of (P31) chapter (Q1980247)
  ?chapter wdt:P31 wd:Q1980247;
           # and is part of (P361) [OneOrMorePath (+)] Water Margin's 120-chapter edition (Q70761009)
           wdt:P361+ wd:Q70761009;
           # ?chapter's chapter (P792) is ?chapter_number
           wdt:P792 ?chapter_number;
           # ?chapter's characters (P674) is ?character
           wdt:P674 ?character
  # show label in auto language as default, and English when no default label exists
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?chapter") v2("?chapter_number"):::projected v3("?character"):::projected c8(["bd:serviceParam"]):::iri c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal c2(["wd:Q1980247"]):::iri c4(["wd:Q70761009"]):::iri v1 --"wdt:P31"--> c2 v1 --"wdt:P361"--> c4 v1 --"wdt:P792"--> v2 v1 --"wdt:P674"--> v3 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end