query-f61dca9f27000ea97e5ff50d83276556

rq turtle/ttl

Problem with TimeoutHello, i wrote a Query, when i took Limit 10, it works. With more Limit, it doesn't work. If i want to us the Statement "minus { ?item1 p:P397 [] }" it also gets a Timeout. How can it get optimized?:

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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item1 ?item1Label ?labelnew1 ?item2 ?item2Label
where {
          { SELECT DISTINCT ?item1 ?item2 ?labelnew1 
            where {
             ?item1 wdt:P31 wd:Q44559 .
                  ##minus { ?item1 p:P397 [] }.
                  ?item2 wdt:P31 wd:Q523 .   
                  ?item1 rdfs:label ?label1.
                  ?item2 rdfs:label ?label2.
                  FILTER(LANG(?label1) = "en").
                  FILTER(LANG(?label2) = "en").
                  bind(substr(?label1, 1, strlen(?label1)-1) as ?labelnew1).
                  FILTER(?labelnew1 = ?label2).
                 }
        LIMIT 10
    }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2017/06