query-539f089772f32f3a88a38b5d114a42d3

rq turtle/ttl

Title: Ile sans étiquette en français avec le lien vers Wikipédia en cebuano prefix schema: http://schema.org/ PREFIX wikibase: http://wikiba.se/ontology# PREFIX wd: http://www.wikidata.org/entity/ PREFIX wdt: http://www.wikidata.org/prop/direct/

SELECT ?cid ?itemLabel ?article WHERE { ?cid wdt:P31 wd:Q23442.

FILTER(NOT EXISTS {
?cid rdfs:label ?itemLabel.
FILTER(LANG(?itemLabel) = "fr") # with missing French description

})

OPTIONAL {
    ?cid rdfs:label ?country filter (lang(?country) = "ceb") .
}
OPTIONAL {
  ?article schema:about ?cid .
  ?article schema:inLanguage "ceb" .
}

}

Use at

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#Title: Ile sans étiquette en français avec le lien vers Wikipédia en cebuano
prefix schema: <http://schema.org/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>

SELECT ?cid ?itemLabel ?article WHERE {
    ?cid wdt:P31 wd:Q23442.

    FILTER(NOT EXISTS {
    ?cid rdfs:label ?itemLabel.
    FILTER(LANG(?itemLabel) = "fr") # with missing French description
  })

    OPTIONAL {
        ?cid rdfs:label ?country filter (lang(?country) = "ceb") .
    }
    OPTIONAL {
      ?article schema:about ?cid .
      ?article schema:inLanguage "ceb" .
    }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?article"):::projected v2("?cid"):::projected v3("?country") v1("?itemLabel"):::projected c3(["ceb"]):::literal c5(["wd:Q23442"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0f0[["?itemLabel = 'fr'"]] e0f0 --> e0v1 e0v2 --"rdfs:label"--> e0v1 e0v2("?cid"):::projected e0v1("?itemLabel"):::projected end f0--EXISTS--> f0e0 f0 --> v1 f0 --> v2 f0 --> c2 f1[["?itemLabel = 'fr'"]] f1 --> v1 v2 --"rdfs:label"--> v1 v2 --"wdt:P31"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."rdfs:label".-> v3 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."schema:about".-> v2 v4 --"schema:inLanguage"--> c3 end