query-5b932d4d80e91b424b52ba990325b261

rq turtle/ttl

(51) Timeline of points in time: publication dates of the Twenty-Six HistoriesNo.51 (2020.08.11T0256 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#>
# timeline of publication dates of the Twenty-Six Histories (also viewable as table)
#defaultView:Timeline
SELECT DISTINCT ?book ?bookLabel ?publication_date
WHERE {
  # ?book is any part of (P361) part of... Twenty-Six Histories (Q11371378)
  ?book wdt:P361* wd:Q11371378;
        # ?book's genre (P136) is jizhuanti (Q1619411) so that parts of each book,
        # whose genres are benji (Q1872234), liezhuan (Q2252176), et al., are excluded
        wdt:P136 wd:Q1619411
  # ?book should not be instance of (P31) book series (Q277759) so that groups of books,
  # e.g, Twenty-Four Histories (Q175077) and Seventeen Histories (Q9503010), are excluded
  FILTER NOT EXISTS {?book wdt:P31 wd:Q277759}
  # optional: show ?book's publication date (P577) as ?publication_date
  OPTIONAL {?book wdt:P577 ?publication_date}
  # 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("?book"):::projected v2("?publication_date"):::projected c2(["wd:Q277759"]):::iri c9(["bd:serviceParam"]):::iri c6(["wd:Q1619411"]):::iri c11(["#91;AUTO_LANGUAGE#93;,en"]):::literal c4(["wd:Q11371378"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P31"--> e0c2 e0v1("?book"):::projected e0c2(["wd:Q277759"]):::iri end f0--EXISTS--> f0e0 f0 --> v1 f0 --> c1 f0 --> c2 v1 --"wdt:P31"--> c2 v1 --"wdt:P361"--> c4 v1 --"wdt:P136"--> c6 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P577".-> v2 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 end