query-80410ae786b61f24a05389d4e6a4e29e

rq turtle/ttl

Labels for Wiktionary categories 13:22, 30 May 2018 (UTC)) talk (Infovarius:? --ValterVB! @parentheses expressions in don't omitI am running into a multitude of Wiktionary categories which has sitelink in language A but not label in A. Can anyone please add labels automatically? And please : Can you please run along ru-pages without ru-label? 3750 now:ValterVB@ 17:25, 30 May 2018 (UTC)) talk (ValterVB will be available, probably I restart my periodical task. Alternatively, I can do it with a SPARQL query (if I find a suitable one) --differential dump: The dumps have become too big (too much time to download and unzip), so I stopped to download them and update label description, or do other weekly task that using dump. If Infovarius@ 13:35, 30 May 2018 (UTC)) talk (InfovariusAnd labelless items are created by PetScan (can it be changed?) so their number is constantly increasing and there is need in a regular work. -- 13:31, 30 May 2018 (UTC)) talk (InfovariusEven AutoEdit doesn't work for Wiktionary sitelinks... --

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?sitelink ?itemLabel ?title WHERE {
  ?sitelink schema:isPartOf <https://ru.wiktionary.org/>;
     schema:about ?item; schema:name ?title 
    SERVICE wikibase:label { bd:serviceParam wikibase:language "ru,[AUTO_LANGUAGE],en" } .
   FILTER(NOT EXISTS {
   ?item rdfs:label ?lang_label.
   FILTER(LANG(?lang_label) = "ru") #with missing Russian label
 })
} ORDER BY ?itemLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?item"):::projected v1("?itemLabel"):::projected v2("?lang_label") v4("?sitelink"):::projected v5("?title"):::projected c4([https://ru.wiktionary.org/]):::iri c8(["bd:serviceParam"]):::iri c10(["ru,#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["not "]] subgraph f0e0["Exists Clause"] e0f0[["?lang_label = 'ru'"]] e0f0 --> e0v1 e0v2 --"rdfs:label"--> e0v1 e0v2("?item"):::projected e0v1("?lang_label"):::projected end f0--EXISTS--> f0e0 f0 --> v2 f0 --> v3 f0 --> c2 f1[["?lang_label = 'ru'"]] f1 --> v2 v3 --"rdfs:label"--> v2 v4 --"schema:isPartOf"--> c4 v4 --"schema:about"--> v3 v4 --"schema:name"--> v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end