query-6944f49bca6995c245ec98a12a8f29f5

rq turtle/ttl

Why is this querry so slow, can it be made faster?Hi all, I am trying to make a query that would return every entity associated in any way with Donald trump This is my query:

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 rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?p ?pLabel ?entity ?entityLabel ?prop ?property1Label WHERE 
{   
  ?property1 rdf:type wikibase:Property. #get all possible propreties
  ?property1 wikibase:directClaim ?prop . 
  filter(?prop not in(wdt:P1889,wdt:P1889))#filter out unwanted propreties (e.g. "different from")

  {?entity ?prop wd:Q22686 . }#select all entities that have Q as proprety 
   Union
  {wd:Q22686 ?prop  ?entity  .}#and select all propreties of Q

  ?entity wdt:P31 ?p.#check the category of ?entity
  ?p wdt:P279* ?p2.#and all of it's "subclasses"
  filter(?p2 in(wd:Q164509,wd:Q164509)) #and keep it only if it is a subclass of one of the following

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}group by ?p ?pLabel ?entity ?entityLabel ?prop ?property1Label

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2020/11