query-6cb5bfc51f69ff4d9995f1cfe4fac59a

rq turtle/ttl

MLAs without an Odia Label SELECT DISTINCT ?item ?Len WHERE { ?item wdt:P31 wd:Q5. #<<< human ?item p:P39 ?statement. ?statement (ps:P39/wdt:P279*) wd:Q24546266.

?item rdfs:label ?Len. FILTER(NOT EXISTS { ?item rdfs:label ?Lor. FILTER((LANG(?Lor)) = "or")
}) FILTER((LANG(?Len)) = "en") } ORDER BY ?Len LIMIT 123

Use at

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/>
# MLAs without an Odia Label
SELECT DISTINCT ?item ?Len   WHERE {
   ?item wdt:P31 wd:Q5.    #<<< human
  ?item p:P39 ?statement.
  ?statement (ps:P39/wdt:P279*) wd:Q24546266.

  ?item rdfs:label ?Len.
  FILTER(NOT EXISTS {
    ?item rdfs:label ?Lor.
  FILTER((LANG(?Lor)) = "or")    
  })
  FILTER((LANG(?Len)) = "en")
}
ORDER BY ?Len
LIMIT 123

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?Len"):::projected v2("?Lor") v3("?item"):::projected v4("?statement") a1((" ")) c5(["wd:Q5"]):::iri c9(["wd:Q24546266"]):::iri f0[["?Len = 'en'"]] f0 --> v1 f1[["not "]] subgraph f1e0["Exists Clause"] e0f0[["?Lor = 'or'"]] e0f0 --> e0v1 e0v2 --"rdfs:label"--> e0v1 e0v1("?Lor"):::projected e0v2("?item"):::projected end f1--EXISTS--> f1e0 f1 --> v2 f1 --> v3 f1 --> c3 f2[["?Lor = 'or'"]] f2 --> v2 v3 --"rdfs:label"--> v2 v3 --"p:direct/P31"--> c5 v3 --"p:P39"--> v4 v4 --"p:statement/P39"--> a1 a1 --"p:direct/P279"--> c9 v3 --"rdfs:label"--> v1