query-2f8cb008ea23135809be054f4318f81f

rq turtle/ttl

Items that don't have a label in French, but there is a main category that has a label in French. SELECT ?item ?itemLabel ?_topic_s_main_category ?_topic_s_main_categoryLabelFR WHERE { ?item wdt:P910 ?_topic_s_main_category. ?_topic_s_main_category rdfs:label ?_topic_s_main_categoryLabelFR filter (lang(?_topic_s_main_categoryLabelFR) = "fr") . FILTER NOT EXISTS {?item rdfs:label ?itemLabelFR filter (lang(?itemLabelFR) = "fr")} . } LIMIT 1000

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 French, but there is a main category that has a label in French.
SELECT ?item ?itemLabel ?_topic_s_main_category ?_topic_s_main_categoryLabelFR WHERE {
  ?item wdt:P910 ?_topic_s_main_category.
  ?_topic_s_main_category rdfs:label ?_topic_s_main_categoryLabelFR filter (lang(?_topic_s_main_categoryLabelFR) = "fr") .
  FILTER NOT EXISTS {?item rdfs:label ?itemLabelFR filter (lang(?itemLabelFR) = "fr")} .
  }
LIMIT 1000

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_categoryLabelFR"):::projected v2("?item"):::projected v1("?itemLabelFR") f0[["not "]] subgraph f0e0["Exists Clause"] e0f0[["?itemLabelFR = 'fr'"]] e0f0 --> e0v1 e0v2 --"rdfs:label"--> e0v1 e0v2("?item"):::projected e0v1("?itemLabelFR"):::projected end f0--EXISTS--> f0e0 f0 --> v1 f0 --> v2 f0 --> c2 f1[["?itemLabelFR = 'fr'"]] f1 --> v1 v2 --"rdfs:label"--> v1 f2[["?_topic_s_main_categoryLabelFR = 'fr'"]] f2 --> v3 v2 --"wdt:P910"--> v4 v4 --"rdfs:label"--> v3