query-392b5f9851d46dfbde989b34973a81f8

rq turtle/ttl

Glottolog (P1394)Glottolog code and no (P220)ISO 639-3 code has still to be add wihtin the language items. This query shows some of them that have a (P1394)Glottolog code Hello, a lot of ]reply[06:18, 29 September 2017 (UTC)) talk (Pamputtit seems that the line "?item rdf:type wdno:P1394 ." does not do what I want. Actually, I would like that the elements that have P1394=novalue are not listed in the results. How to do that? Thanks in advance. Actually, I found how to do what I wanted to do. The query is here ]reply[17:25, 13 October 2017 (UTC) Jura--- might do. FILTER NOT EXISTS { ?item p:P1394 [] }: If you don't want either (value or "no value"), Pamputt@

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wdno: <http://www.wikidata.org/prop/novalue/>
PREFIX schema: <http://schema.org/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?itemDescription ?iso
{  
    ?item wdt:P220 ?iso . # looking for language that has a ISO 639-3 code
    MINUS { ?item wdt:P1394 ?glottolog .} # with missing Glottolog ID
    MINUS { ?item rdf:type wdno:P1394 .} # without those with a « no value » Glottolog ID
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
    FILTER(NOT EXISTS {
        ?item schema:description ?itemDescription .
        FILTER(LANG(?itemDescription) = "[AUTO_LANGUAGE],en") # with missing "your language" description
    })
}
ORDER BY ?itemLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?glottolog") v4("?iso"):::projected v3("?item"):::projected v2("?itemDescription"):::projected v1("?itemLabel"):::projected c8(["bd:serviceParam"]):::iri c1(["#91;AUTO_LANGUAGE#93;,en"]):::literal c6(["wdno:P1394"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0f0[["?itemDescription = '#91;AUTO_LANGUAGE#93;,en'"]] e0f0 --> e0v1 e0v2 --"schema:description"--> e0v1 e0v2("?item"):::projected e0v1("?itemDescription"):::projected end f0--EXISTS--> f0e0 f0 --> v2 f0 --> v3 f0 --> c2 f1[["?itemDescription = '#91;AUTO_LANGUAGE#93;,en'"]] f1 --> v2 v3 --"schema:description"--> v2 v3 --"wdt:P220"--> v4 subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; v3 --"wdt:P1394"--> v5 end subgraph minus3["MINUS"] style minus3 stroke-width:6px,fill:pink,stroke:red; v3 --"a"--> c6 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c1 end