query-8b4043e4c68ce82c95b061efdf3823d1
Missing descriptions instead of missing labels. I thought I could just replace rdfs:label with rds:comment, but that didn't work. [1]Hi, I tried to figure this out on my own by reading Coul you please modify the following query so it will display all the missing descriptions instead of the missing labels? Many thanks in advance. TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?item (COUNT(DISTINCT ?article) AS ?count) WHERE
{
?item wdt:P31 wd:Q9143. # item is a programming language
FILTER(NOT EXISTS { ?item rdfs:label ?lang_label. FILTER(LANG(?lang_label) = "de") })
# no label in German
?article schema:about ?item . FILTER (SUBSTR(str(?article), 11, 15) = ".wikipedia.org/") .
# has some number of sitelinks which are WP articles
} group by ?item order by ?count
Query found at
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2019/02
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2019/03
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?article"):::projected
v5("?count")
v4("?item"):::projected
v3("?lang_label")
c7(["wd:Q9143"]):::iri
f0[["substring(str(?article),'11^^xsd:integer','15^^xsd:integer') = '.wikipedia.org/'"]]
f0 --> v2
f1[["not "]]
subgraph f1e0["Exists Clause"]
e0f0[["?lang_label = 'de'"]]
e0f0 --> e0v1
e0v2 --"rdfs:label"--> e0v1
e0v2("?item"):::projected
e0v1("?lang_label"):::projected
end
f1--EXISTS--> f1e0
f1 --> v3
f1 --> v4
f1 --> c5
f2[["?lang_label = 'de'"]]
f2 --> v3
v4 --"rdfs:label"--> v3
v4 --"wdt:P31"--> c7
v2 --"schema:about"--> v4
bind4[/"count(?article)"/]
v2 --o bind4
bind4 --as--o v5