query-efad58d802eca9bf60ca0aeb9c87c512

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?work    (CONCAT (?workMainTitle,    ". ", GROUP_CONCAT(DISTINCT ?workSubTitles; SEPARATOR=". "))    AS ?workTitle) (YEAR(?workDate) AS ?workYear)
       ?edition (CONCAT (?editionMainTitle, ". ", GROUP_CONCAT(DISTINCT ?editionSubTitles; SEPARATOR=". ")) AS ?editionTitle) (YEAR(?editionDate) AS ?editionYear)
       ?volume  (CONCAT (?volumeMainTitle,  ". ", GROUP_CONCAT(DISTINCT ?volumeSubTitles; SEPARATOR=". "))  AS ?volumeTitle) ?volumeNr (YEAR(?volumeDate) AS ?volumeYear)
WHERE {
  BIND(wd:Q51880 as ?author).
  ?work wdt:P31 wd:Q47461344; wdt:P50 ?author.
  OPTIONAL {?work wdt:P1476 ?workMainTitle.}
  OPTIONAL {?work wdt:P1680 ?workSubTitles.}
  OPTIONAL {?work wdt:P571 ?workDate.}
  OPTIONAL {?work wdt:P747 ?edition.
            ?edition wdt:P629 ?work.
            ?edition wdt:P31 wd:Q3331189.
            OPTIONAL {?edition wdt:P1476 ?editionMainTitle.}
            OPTIONAL {?edition wdt:P1680 ?editionSubTitles.}
            OPTIONAL {?edition wdt:P577 ?editionDate.}
            OPTIONAL {?edition wdt:P527 ?volume.
                      ?volume wdt:P361 ?edition.
                      ?volume wdt:P31 wd:Q1238720.
                      OPTIONAL {?volume wdt:P1476 ?volumeMainTitle.}
                      OPTIONAL {?volume wdt:P1680 ?volumeSubTitles.}
                      OPTIONAL {?volume wdt:P1545 ?volumeNr.}
                      OPTIONAL {?volume wdt:P577 ?volumeDate.}
                     }
           }
}
GROUP BY ?volume          ?edition          ?work
         ?volumeMainTitle ?editionMainTitle ?editionDate ?workMainTitle ?volumeNr ?volumeDate ?workDate
ORDER BY ?workYear ?volumeNr

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?author") v8("?edition"):::projected v11("?editionDate"):::projected v9("?editionMainTitle"):::projected v10("?editionSubTitles") v17("?editionTitle") v18("?editionYear") v12("?volume"):::projected v15("?volumeDate"):::projected v13("?volumeMainTitle"):::projected v2("?volumeNr"):::projected v14("?volumeSubTitles") v19("?volumeTitle") v20("?volumeYear") v4("?work"):::projected v7("?workDate"):::projected v5("?workMainTitle"):::projected v6("?workSubTitles") v16("?workTitle") v17("?workYear") c13(["wd:Q1238720"]):::iri c9(["wd:Q3331189"]):::iri c2(["wd:Q47461344"]):::iri bind0[/"'wd:Q51880'"/] bind0 --as--o v3 v4 --"wdt:P31"--> c2 v4 --"wdt:P50"--> v3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P1476".-> v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P1680".-> v6 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P571".-> v7 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P747".-> v8 v8 --"wdt:P629"--> v4 v8 --"wdt:P31"--> c9 subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v8 -."wdt:P1476".-> v9 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v8 -."wdt:P1680".-> v10 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v8 -."wdt:P577".-> v11 end subgraph optional7["(optional)"] style optional7 fill:#bbf,stroke-dasharray: 5 5; v8 -."wdt:P527".-> v12 v12 --"wdt:P361"--> v8 v12 --"wdt:P31"--> c13 subgraph optional8["(optional)"] style optional8 fill:#bbf,stroke-dasharray: 5 5; v12 -."wdt:P1476".-> v13 end subgraph optional9["(optional)"] style optional9 fill:#bbf,stroke-dasharray: 5 5; v12 -."wdt:P1680".-> v14 end subgraph optional10["(optional)"] style optional10 fill:#bbf,stroke-dasharray: 5 5; v12 -."wdt:P1545".-> v2 end subgraph optional11["(optional)"] style optional11 fill:#bbf,stroke-dasharray: 5 5; v12 -."wdt:P577".-> v15 end end end bind4[/"concat(?workMainTitle,'. ',)"/] v5 --o bind4 null --o bind4 bind4 --as--o v16 bind5[/"year-from-dateTime(?workDate)"/] v7 --o bind5 bind5 --as--o v17 bind6[/"concat(?editionMainTitle,'. ',)"/] v9 --o bind6 null --o bind6 bind6 --as--o v17 bind7[/"year-from-dateTime(?editionDate)"/] v11 --o bind7 bind7 --as--o v18 bind8[/"concat(?volumeMainTitle,'. ',)"/] v13 --o bind8 null --o bind8 bind8 --as--o v19 bind9[/"year-from-dateTime(?volumeDate)"/] v15 --o bind9 bind9 --as--o v20