query-a9e9ab64ab56a889f7ba790dd37b4ff5
Public domain poems without an audio recordingI have been reading public domain poems and adding the recordings to commons, Wikipedia and Wikidata, and wondered if a query could help find me more that need doing. Looking at Q3072813 I can see that it would be something like copyright status P6216 = public domain Q19652 instance of P31 = poem Q5185279 and has no entry or value for spoken text audio (P989)and is either in English (Q1860) or not tagged in as having a language at all language of work or name (P407) I have tried adapting an existing querys but would welcome advice, sadly, it seems most of the results havn't been tagged for the language they are in,
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, without audio or a language
#defaultView:Table
SELECT ?item ?itemLabel ?pic
WHERE
{
?item wdt:P31 wd:Q5185279 .
?item wdt:P6216 wd:Q19652 .
MINUS {?item wdt:P989 [] } .
MINUS {?item wdt:P407 [] } .
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("?item"):::projected
a1((" "))
a2((" "))
c8(["bd:serviceParam"]):::iri
c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c4(["wd:Q19652"]):::iri
c2(["wd:Q5185279"]):::iri
v1 --"wdt:P31"--> c2
v1 --"wdt:P6216"--> c4
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P989"--> a1
end
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P407"--> a2
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end