Hello all,

Finally I think I solved it.

A query with 11 results at the time of writing

http://tinyurl.com/hofewk3

Entries with 'de' lang in label: Uncomment:

#FILTER EXISTS { # ?h rdfs:label ?label . # FILTER ( langMatches(lang(?label), 'de' ) ) #}

Entries missing 'de' lang in label:

Uncomment: #FILTER NOT EXISTS { # ?h rdfs:label ?label . # FILTER ( langMatches(lang(?label), 'de' ) ) #}

Thanks for all!

El 29/04/16 a les 13:07, Toni Hermoso Pulido ha escrit:

Hi Jerven,

I tried with:

SELECT distinct ?h ?label ?ll WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . ?h wdt:P19 ?birthplace . ?birthplace wdt:P31*/wdt:P131* wd:Q5720 . ?h rdfs:label ?label . FILTER (NOT EXISTS { BIND (lang(?label) as ?ll) FILTER ( ?ll = "ca" ) . }) } ORDER BY ?label LIMIT 100

and I would expect that one of the results:

h

label

ll wd:Q377947 http://www.wikidata.org/entity/Q377947 Adrián Palomares wd:Q5660653 http://www.wikidata.org/entity/Q5660653 Agustín Galiana wd:Q5662450 http://www.wikidata.org/entity/Q5662450 Alba Rico wd:Q5663315 http://www.wikidata.org/entity/Q5663315 Alberto Mira wd:Q3753762 http://www.wikidata.org/entity/Q3753762 Alberto Miralles wd:Q451736 http://www.wikidata.org/entity/Q451736 Amadeo Gabino wd:Q3779647 http://www.wikidata.org/entity/Q3779647 Ambrós wd:Q5673275 http://www.wikidata.org/entity/Q5673275 Amparo Valle wd:Q3326138 http://www.wikidata.org/entity/Q3326138 Ana Duato wd:Q2844983 http://www.wikidata.org/entity/Q2844983 Ana Juan wd:Q5673898 http://www.wikidata.org/entity/Q5673898 Ana María Drack

https://www.wikidata.org/wiki/Q5673275 would not have a 'ca' label... but it seems to have.

El 04/29/2016 a les 11:19 AM, Jerven Tjalling Bolleman ha escrit:

...

This seems to work.

SELECT distinct ?h ?label ?ll WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . ?h wdt:P19 ?birthplace . ?birthplace wdt:P31*/wdt:P131* wd:Q5720 . ?h rdfs:label ?label . FILTER (NOT EXISTS { BIND (lang(?label) as ?ll) FILTER ( ?ll = "de" ) . }) } ORDER BY ?label LIMIT 100

On 29/04/16 09:24, Toni Hermoso Pulido wrote:

...

Hello,

I'm trying to retrieve via SPARQL those entries missing a label in a certain language (e.g. "de"). Example from this query: http://tinyurl.com/zazewyx

How this could be done straight from a SPARQL query?