query-a1a6d61c0ffd832534e30b3923187717

rq turtle/ttl

identical label - optimization 10 LIMIT } # FILTER NOT EXISTS { ?item wdt:P31 wd:Q4167410 } # FILTER NOT EXISTS { ?dab wdt:P31 ?inst . FILTER( ?inst != wd:Q4167410 ) } ) ?item != ?dab (FILTER } ?dab P1889:wdt ?item { NOT EXISTS FILTER . Q4167410:wd P31:wdt ; ?l label:rdfs ?dab # "en" or another language )"en" = )?l(lang (FILTER . ?l label:rdfs ; Q101352:wd P31:wdt ?item { WHERE ?l ?dab ?item SELECT 10:41, 22 September 2021 (UTC) JuraI tried various hints to optimize the above query, but it ends up timing out when I increase the limit. The idea is to find missing P1889 statements (maybe not many are left). There are about 500k family name items and 1.3 million dab items. ---

Use at

• https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT *
WHERE
{


{
  SELECT * { ?item wdt:P31 wd:Q101352 .
    MINUS { ?item p:P1889 [] }
  } OFFSET 75000 LIMIT 25000
}    ?item rdfs:label ?l . FILTER(  lang(?l) = "en") 
    ?dab  rdfs:label ?l ; wdt:P31 wd:Q4167410 .
    FILTER( ?dab != ?item )   
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2021/09