query-659ccfa4aee5f5a31f541c8803ee72c7

rq turtle/ttl

Off • Holiday • Asleep • Wikibreak Away • Class • Busy • OnUpdate: for more info.historyCheck my status Somewhere is currently:Back ache My current project comes from the back of me needing to become prificanent in the computer language "powershell" and API's, rather then make examples , I am using this as an opportunity to "fill in the blanks" in wikidata entries by calling publicly available data using API's Users by language . español del básicoEste usuario tiene un conocimiento -1es . English understanding of nativeThis user has a -Nen . British English understanding of nativeThis user has a -Nen-GB Babel user information I have been reading public domain poems and adding the recordings to commons, Wikipedia and Wikidata, and wondered if a querys 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) https://hay.toolforge.org/vizquery/ I have tried adapting an existing query's as it seems more than 6000 of the poems haven'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 ?author 
WHERE
{
?item wdt:P31 wd:Q5185279 .
?item wdt:P6216 wd:Q19652 .
?item wdt:P50 ?author  
    MINUS {?item wdt:P989 [] } .
    MINUS {?item wdt:P407 [] } .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
ORDER BY DESC(?author)

Query found at

• https://www.wikidata.org/wiki/User:Back_ache