query-6fd92b78e9ccfd2b78496e1978c9998f
rq turtle/ttl
Works of antiquity and slightly beyond
SELECT DISTINCT ?item ?itemLabel
(GROUP_CONCAT(DISTINCT ?bekker; separator=", ") as ?Bekker)
(GROUP_CONCAT(DISTINCT ?bhg; separator=", ") as ?BHG)
(GROUP_CONCAT(DISTINCT ?bhl; separator=", ") as ?BHL)
(GROUP_CONCAT(DISTINCT ?chap; separator=", ") as ?CHAP)
(GROUP_CONCAT(DISTINCT ?cpg; separator=", ") as ?CPG)
(GROUP_CONCAT(DISTINCT ?cpl; separator=", ") as ?CPL)
(GROUP_CONCAT(DISTINCT ?digiliblt; separator=", ") as ?Digiliblt)
(GROUP_CONCAT(DISTINCT ?dll; separator=", ") as ?DLL)
(GROUP_CONCAT(DISTINCT ?icl; separator=", ") as ?ICL)
(GROUP_CONCAT(DISTINCT ?mqdq; separator=", ") as ?MQDQ)
(GROUP_CONCAT(DISTINCT ?perry; separator=", ") as ?Perry)
(GROUP_CONCAT(DISTINCT ?pinakes; separator=", ") as ?Pinakes)
(GROUP_CONCAT(DISTINCT ?phi; separator=", ") as ?PHI)
(GROUP_CONCAT(DISTINCT ?topos; separator=", ") as ?Topos)
(GROUP_CONCAT(DISTINCT ?walther; separator=", ") as ?Waltger)
(GROUP_CONCAT(DISTINCT ?viaf; separator=", ") as ?VIAF)
WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],la". }
{ ?item wdt:P2683 ?bekker } UNION
{ ?item wdt:P7987 ?bhg } UNION
{ ?item wdt:P7924 ?bhl } UNION
{ ?item wdt:P11861 ?chap } UNION
{ ?item wdt:P7988 ?cpg } UNION
{ ?item wdt:P7980 ?cpl } UNION
{ ?item wdt:P8310 ?digiliblt } UNION
{ ?item wdt:P10934 ?icl } UNION
{ ?item wdt:P8312 ?mqdq } UNION
{ ?item wdt:P1852 ?perry } UNION
{ ?item wdt:P12200 ?pinakes } UNION
{ ?item wdt:P8311 ?phi } UNION
{ ?item wdt:P8070 ?topos } UNION
{ ?item wdt:P10973 ?walther }
OPTIONAL { ?item wdt:P8123 ?dll }
OPTIONAL { ?item wdt:P214 ?viaf } UNION
}
GROUP BY ?item ?itemLabel
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Works of antiquity and slightly beyond
SELECT DISTINCT ?item ?itemLabel
(GROUP_CONCAT(DISTINCT ?bekker; separator=", ") as ?Bekker)
(GROUP_CONCAT(DISTINCT ?bhg; separator=", ") as ?BHG)
(GROUP_CONCAT(DISTINCT ?bhl; separator=", ") as ?BHL)
(GROUP_CONCAT(DISTINCT ?chap; separator=", ") as ?CHAP)
(GROUP_CONCAT(DISTINCT ?cpg; separator=", ") as ?CPG)
(GROUP_CONCAT(DISTINCT ?cpl; separator=", ") as ?CPL)
(GROUP_CONCAT(DISTINCT ?digiliblt; separator=", ") as ?Digiliblt)
(GROUP_CONCAT(DISTINCT ?dll; separator=", ") as ?DLL)
(GROUP_CONCAT(DISTINCT ?icl; separator=", ") as ?ICL)
(GROUP_CONCAT(DISTINCT ?mqdq; separator=", ") as ?MQDQ)
(GROUP_CONCAT(DISTINCT ?perry; separator=", ") as ?Perry)
(GROUP_CONCAT(DISTINCT ?pinakes; separator=", ") as ?Pinakes)
(GROUP_CONCAT(DISTINCT ?phi; separator=", ") as ?PHI)
(GROUP_CONCAT(DISTINCT ?topos; separator=", ") as ?Topos)
(GROUP_CONCAT(DISTINCT ?walther; separator=", ") as ?Waltger)
# (GROUP_CONCAT(DISTINCT ?viaf; separator=", ") as ?VIAF)
WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],la". }
{ ?item wdt:P2683 ?bekker } UNION
{ ?item wdt:P7987 ?bhg } UNION
{ ?item wdt:P7924 ?bhl } UNION
{ ?item wdt:P11861 ?chap } UNION
{ ?item wdt:P7988 ?cpg } UNION
{ ?item wdt:P7980 ?cpl } UNION
{ ?item wdt:P8310 ?digiliblt } UNION
{ ?item wdt:P10934 ?icl } UNION
{ ?item wdt:P8312 ?mqdq } UNION
{ ?item wdt:P1852 ?perry } UNION
{ ?item wdt:P12200 ?pinakes } UNION
{ ?item wdt:P8311 ?phi } UNION
{ ?item wdt:P8070 ?topos } UNION
{ ?item wdt:P10973 ?walther }
OPTIONAL { ?item wdt:P8123 ?dll }
# OPTIONAL { ?item wdt:P214 ?viaf } UNION
}
GROUP BY ?item ?itemLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v18("?BHG")
v19("?BHL")
v17("?Bekker")
v20("?CHAP")
v21("?CPG")
v22("?CPL")
v24("?DLL")
v23("?Digiliblt")
v25("?ICL")
v26("?MQDQ")
v29("?PHI")
v27("?Perry")
v28("?Pinakes")
v30("?Topos")
v31("?Waltger")
v2("?bekker"):::projected
v3("?bhg"):::projected
v4("?bhl"):::projected
v5("?chap"):::projected
v6("?cpg"):::projected
v7("?cpl"):::projected
v8("?digiliblt"):::projected
v16("?dll"):::projected
v9("?icl"):::projected
v1("?item"):::projected
v10("?mqdq"):::projected
v11("?perry"):::projected
v13("?phi"):::projected
v12("?pinakes"):::projected
v14("?topos"):::projected
v15("?walther"):::projected
c4(["#91;AUTO_LANGUAGE#93;,la"]):::literal
c2(["bd:serviceParam"]):::iri
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c2 --"wikibase:language"--> c4
end
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
subgraph union1[" Union "]
subgraph union1l[" "]
style union1l fill:#abf,stroke-dasharray: 3 3;
subgraph union2[" Union "]
subgraph union2l[" "]
style union2l fill:#abf,stroke-dasharray: 3 3;
subgraph union3[" Union "]
subgraph union3l[" "]
style union3l fill:#abf,stroke-dasharray: 3 3;
subgraph union4[" Union "]
subgraph union4l[" "]
style union4l fill:#abf,stroke-dasharray: 3 3;
subgraph union5[" Union "]
subgraph union5l[" "]
style union5l fill:#abf,stroke-dasharray: 3 3;
subgraph union6[" Union "]
subgraph union6l[" "]
style union6l fill:#abf,stroke-dasharray: 3 3;
subgraph union7[" Union "]
subgraph union7l[" "]
style union7l fill:#abf,stroke-dasharray: 3 3;
subgraph union8[" Union "]
subgraph union8l[" "]
style union8l fill:#abf,stroke-dasharray: 3 3;
subgraph union9[" Union "]
subgraph union9l[" "]
style union9l fill:#abf,stroke-dasharray: 3 3;
subgraph union10[" Union "]
subgraph union10l[" "]
style union10l fill:#abf,stroke-dasharray: 3 3;
subgraph union11[" Union "]
subgraph union11l[" "]
style union11l fill:#abf,stroke-dasharray: 3 3;
subgraph union12[" Union "]
subgraph union12l[" "]
style union12l fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P10973"--> v15
end
subgraph union12r[" "]
style union12r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P8070"--> v14
end
union12r <== or ==> union12l
end
end
subgraph union11r[" "]
style union11r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P8311"--> v13
end
union11r <== or ==> union11l
end
end
subgraph union10r[" "]
style union10r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P12200"--> v12
end
union10r <== or ==> union10l
end
end
subgraph union9r[" "]
style union9r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P1852"--> v11
end
union9r <== or ==> union9l
end
end
subgraph union8r[" "]
style union8r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P8312"--> v10
end
union8r <== or ==> union8l
end
end
subgraph union7r[" "]
style union7r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P10934"--> v9
end
union7r <== or ==> union7l
end
end
subgraph union6r[" "]
style union6r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P8310"--> v8
end
union6r <== or ==> union6l
end
end
subgraph union5r[" "]
style union5r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P7980"--> v7
end
union5r <== or ==> union5l
end
end
subgraph union4r[" "]
style union4r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P7988"--> v6
end
union4r <== or ==> union4l
end
end
subgraph union3r[" "]
style union3r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P11861"--> v5
end
union3r <== or ==> union3l
end
end
subgraph union2r[" "]
style union2r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P7924"--> v4
end
union2r <== or ==> union2l
end
end
subgraph union1r[" "]
style union1r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P7987"--> v3
end
union1r <== or ==> union1l
end
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P2683"--> v2
end
union0r <== or ==> union0l
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P8123".-> v16
end
bind15[/"?bekker"/]
v2 --o bind15
bind15 --as--o v17
bind16[/"?bhg"/]
v3 --o bind16
bind16 --as--o v18
bind17[/"?bhl"/]
v4 --o bind17
bind17 --as--o v19
bind18[/"?chap"/]
v5 --o bind18
bind18 --as--o v20
bind19[/"?cpg"/]
v6 --o bind19
bind19 --as--o v21
bind20[/"?cpl"/]
v7 --o bind20
bind20 --as--o v22
bind21[/"?digiliblt"/]
v8 --o bind21
bind21 --as--o v23
bind22[/"?dll"/]
v16 --o bind22
bind22 --as--o v24
bind23[/"?icl"/]
v9 --o bind23
bind23 --as--o v25
bind24[/"?mqdq"/]
v10 --o bind24
bind24 --as--o v26
bind25[/"?perry"/]
v11 --o bind25
bind25 --as--o v27
bind26[/"?pinakes"/]
v12 --o bind26
bind26 --as--o v28
bind27[/"?phi"/]
v13 --o bind27
bind27 --as--o v29
bind28[/"?topos"/]
v14 --o bind28
bind28 --as--o v30
bind29[/"?walther"/]
v15 --o bind29
bind29 --as--o v31