query-ff748de11a903aa4911a469901ab899a

rq turtle/ttl

Items that don't have a label in Odia, but there is a main category that has a label in Odia. SELECT ?item ?_topic_s_main_category ?_topic_s_main_categoryLabelOD WHERE { ?item wdt:P910 ?_topic_s_main_category. ?_topic_s_main_category rdfs:label ?_topic_s_main_categoryLabelOD filter (lang(?_topic_s_main_categoryLabelOD) = "or") . FILTER NOT EXISTS {?item rdfs:label ?itemLabelOD filter (lang(?itemLabelOD) = "or")} . } LIMIT 234

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
# Items that don't have a label in Odia, but there is a main category that has a label in Odia.
SELECT ?item ?_topic_s_main_category ?_topic_s_main_categoryLabelOD
WHERE {
  ?item wdt:P910 ?_topic_s_main_category.
  ?_topic_s_main_category rdfs:label ?_topic_s_main_categoryLabelOD filter (lang(?_topic_s_main_categoryLabelOD) = "or") .
  FILTER NOT EXISTS {?item rdfs:label ?itemLabelOD filter (lang(?itemLabelOD) = "or")} .
  }
LIMIT 234

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?_topic_s_main_category"):::projected v3("?_topic_s_main_categoryLabelOD"):::projected v2("?item"):::projected v1("?itemLabelOD") f0[["not "]] subgraph f0e0["Exists Clause"] e0f0[["?itemLabelOD = 'or'"]] e0f0 --> e0v1 e0v2 --"rdfs:label"--> e0v1 e0v2("?item"):::projected e0v1("?itemLabelOD"):::projected end f0--EXISTS--> f0e0 f0 --> v1 f0 --> v2 f0 --> c2 f1[["?itemLabelOD = 'or'"]] f1 --> v1 v2 --"rdfs:label"--> v1 f2[["?_topic_s_main_categoryLabelOD = 'or'"]] f2 --> v3 v2 --"wdt:P910"--> v4 v4 --"rdfs:label"--> v3