query-53a169acf6449fb6b57cb7e888f4737d
Public Domain Poems, in English or with no P407 but without audio
SELECT ?item ?itemLabel WHERE
{
?item wdt:P31 wd:Q5185279 .
?item wdt:P6216 wd:Q19652 .
filter not exists {?item wdt:P989 []. }
{?item wdt:P407 wd:Q1860 .}
UNION
{FILTER NOT EXISTS {?item wdt:P407 [].} }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Use at
- https://query.wikidata.org/sparql
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#>
#Public Domain Poems, in English or with no P407 but without audio
SELECT ?item ?itemLabel WHERE
{
?item wdt:P31 wd:Q5185279 .
?item wdt:P6216 wd:Q19652 .
filter not exists {?item wdt:P989 []. }
{?item wdt:P407 wd:Q1860 .}
UNION
{FILTER NOT EXISTS {?item wdt:P407 [].} }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Query found at
- https://www.wikidata.org/wiki/User:Back_ache
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2021/06
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?item"):::projected
a1((" "))
a2((" "))
c9(["bd:serviceParam"]):::iri
c11(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c5(["wd:Q19652"]):::iri
c3(["wd:Q5185279"]):::iri
c7(["wd:Q1860"]):::iri
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"wdt:P989"--> e0a1
e0v1("?item"):::projected
e0a1((" ")):::projected
end
f0--EXISTS--> f0e0
f0 --> v1
f0 --> c1
f0 --> a1
v1 --"wdt:P989"--> a1
v1 --"wdt:P31"--> c3
v1 --"wdt:P6216"--> c5
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
f1[["not "]]
subgraph f1e1["Exists Clause"]
e1v1 --"wdt:P407"--> e1a1
e1v1("?item"):::projected
e1a1((" ")):::projected
end
f1--EXISTS--> f1e1
f1 --> v1
f1 --> c6
f1 --> a2
v1 --"wdt:P407"--> a2
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v1 --"wdt:P407"--> c7
end
union0r <== or ==> union0l
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c9 --"wikibase:language"--> c11
end