query-90925afa3afbcc26c930a79d12aec26e
All family names 22:18, 15 June 2018 (UTC)) talk (Mike Peel). A single query times out, so I've been fetching them in sets of 500 and stepping an offset, see the query below. However, that times out with offsets in the 40k region. Can anyone suggest a better query / way to get the complete list? Thanks. Wikidata:Requests for permissions/Bot/Pi bot 5 items (for (Q101352)family name =(P31)instance of I've been trying to get a list of all
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel WHERE {
?item wdt:P31 wd:Q101352 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } .
} LIMIT 500 OFFSET 42000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?item"):::projected
c2(["wd:Q101352"]):::iri
c4(["bd:serviceParam"]):::iri
c6(["#91;AUTO_LANGUAGE#93;,en"]):::literal
v1 --"wdt:P31"--> c2
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c4 --"wikibase:language"--> c6
end