query-2f8cb008ea23135809be054f4318f81f
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
- https://query.wikidata.org/sparql
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