query-db95edd8a2dd8cb8dc5d5683ed4aea4a

rq turtle/ttl

Falta label em Braileiro com label em Portuguese. QuickStatementsSearch for labels in other languages that do not exist in a target language. Can be input for Wikidata:SPARQL query service/queries#Missing labels for a target languageCopia de Example: instance of human with country of citizenship Belgium with missing Brasilia label:

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?itemDescription ?langlabel1Label ?langlabelLabel WHERE {

# ?item wdt:P31 wd:Q5.
# ?item wdt:P27 wd:Q31.
  ?item (p:P31/ps:P31/wdt:P279*) wd:Q28797.  #item é instance of  applied science (Q28797) e todas as subclasses

 SERVICE wikibase:label { bd:serviceParam wikibase:language "pt,pt-br,en". }

  ?item rdfs:label ?langlabel1.
  FILTER((LANG(?langlabel1)) = "pt")   #tem label em Portugues

 FILTER(NOT EXISTS {
   ?item rdfs:label ?langlabel.
   FILTER(LANG(?langlabel) = "pt-br")    #falta label em Brasileiro 
 })
}
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("?langlabel") v4("?langlabel1") a1((" ")) a2((" ")) c7(["wd:Q28797"]):::iri c9(["bd:serviceParam"]):::iri c11(["pt,pt-br,en"]):::literal f0[["not "]] subgraph f0e0["Exists Clause"] e0f0[["?langlabel = 'pt-br'"]] e0f0 --> e0v1 e0v2 --"rdfs:label"--> e0v1 e0v2("?item"):::projected e0v1("?langlabel"):::projected end f0--EXISTS--> f0e0 f0 --> v2 f0 --> v3 f0 --> c2 f1[["?langlabel = 'pt-br'"]] f1 --> v2 v3 --"rdfs:label"--> v2 f2[["?langlabel1 = 'pt'"]] f2 --> v4 v3 --"p:P31"--> a1 a1 --"p:statement/P31"--> a2 a2 --"p:direct/P279"--> c7 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 end v3 --"rdfs:label"--> v4