query-af3415317c5852115693abe31e1f2bb1
Result empty after 440th row though result is >2000, where is the error?I'm doing this search for Swedish speaking Finns with a few bits of information and their Wikipedia page title in four languages. Why is the result empty after row 440 even though the result is over 2000 rows? Is it a Wikidata query error, or something else? https://w.wiki/m4fPlease help: The way to get around this is to make each of the bits independently optional, with something like: of the pieces of information are missing. This means anyone with no death-date, or who doesn't have all four Wikipedia articles, will be blank and you'll only get the first two datapoints, person and label.any: The problem here is that the OPTIONAL clause asks for a lot of different things, all within the same section, and so it will be blank if Robertsilen@
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT distinct ?person ?personLabel ?genderLabel ?occupationLabel ?birthdateLabel ?birthplaceLabel ?deathdateLabel ?deathplaceLabel ?sv_title ?fi_title ?en_title ?de_title
WHERE {
?person wdt:P172 wd:Q726673.
?person wdt:P31 wd:Q5.
OPTIONAL { ?person wdt:P21 ?gender }
OPTIONAL { ?person wdt:P106 ?occupation }
OPTIONAL { ?person wdt:P569 ?p569. BIND(SUBSTR(STR(?p569),1,10) as ?birthdate) }
...
}