query-7ada06f50e9197a2d5432776636a3f6a

rq turtle/ttl

Top used sites for P973. Unfortunately, some of them are time outing. Is it possible to get them working again? The first one already seems to be optimized, but unfortunately it's not enough anymore. Property talk:P973There are several maintenance queries at

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?count ?domain ?sampleitem ?sample (URI(concat("https://www.wikidata.org/w/index.php?title=Special:Search&ns120=1&search=",ENCODE_FOR_URI(?domain))) as ?search) 
{
  SELECT (COUNT(?item) as ?count) ?domain (SAMPLE(?item) as ?sampleitem) (SAMPLE(?value) as ?sample)
  {
  ?item wdt:P973 ?value .    
  ?item wdt:P31/wdt:P279* wd:Q41176 . 

    BIND(REPLACE(REPLACE(REPLACE(str(?value), "^.+://", ""), "/.*", ""), "^www\\.", "") as ?domain)
  }
  GROUP BY ?domain
}
ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?count"):::projected v4("?domain"):::projected v2("?item") v6("?sample"):::projected v5("?sampleitem"):::projected v7("?search") v3("?value") a1((" ")) c4(["wd:Q41176"]):::iri v2 --"wdt:P973"--> v3 v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c4 bind0[/"replace(replace(replace(str(?value),'^.+://',''),'/.*',''),'^www\.','')"/] v3 --o bind0 bind0 --as--o v4 bind4[/"count(?item)"/] v2 --o bind4 bind4 --as--o v5 bind5[/"sample(?item)"/] v2 --o bind5 bind5 --as--o v5 bind6[/"sample(?value)"/] v3 --o bind6 bind6 --as--o v6 bind7[/"concat('https://www.wikidata.org/w/index.php?title=Special:Search&ns120=1&search=',encode-for-uri(?domain))"/] v4 --o bind7 bind7 --as--o v7