query-05bfdb50ccfcdad669b20f2f5f25934c

rq turtle/ttl

Do we need this item? ]reply[11:09, 14 June 2022 (UTC)) talk (Horcrux: Hello, may you explain me what's the point in having this item? --Daniel Mietchen@

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#title: Word cloud based on titles of works tagged as being about the Zika virus
#defaultView:BubbleChart
#Based on https://w.wiki/KG$
SELECT ?word (COUNT(DISTINCT ?title) as ?count)


WHERE
{

{    SELECT * { 
{  SELECT ?title  (CONCAT( REPLACE(str(?title),"[\\.:,\\[\\]()$]",""), ?formatterstring) as ?input) 
   { INCLUDE %a0 [] wdt:P921 wd:Q202864 ; wdt:P1476 ?title . FILTER(lang(?title)="en") }   LIMIT 1000
} 
{    SELECT ?re ?nv { ?n wdt:P5176 []; wdt:P1181 ?nv . FILTER( ?nv < 51) 
     BIND( CONCAT( "^([^ ]+ ){", str( ?nv - 1 ),"}([^ ]+) .*") as ?re) }
} FILTER (strlen(?word) > 3 )  BIND( REPLACE(?input, ?re, "$2") as ?word) }
}    FILTER ( ?word != "from" && ?word != "with" && ?word != "after"
           )               
}
GROUP BY ?word
ORDER BY DESC(?count)
LIMIT 200

Query found at