query-4b6a7330362dce7f90b2ced891bdc057

rq turtle/ttl

Propertiesmaintained by WikiProject (P6104)DOI (P356)title (P1476)language of work or name (P407)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT  
  DISTINCT
    ?item ?title
    (CONCAT(
      ENCODE_FOR_URI(REPLACE(STR(?item), ".*Q", "Q")), "|P407|Q1860|S887|Q69652283") AS ?QuickStatements)
WHERE {
   {
  SELECT ?item ?title WHERE {
  ?item wdt:P6104 wd:Q56241615 ;
  wdt:P356 [] ;
        wdt:P1476 ?title .
  MINUS {?item wdt:P407 []. }
  }
  LIMIT 20000
}  FILTER (REGEX(LCASE(?title), "\\b(the|and|which|with|why|where|what|from)\\b"))
  FILTER (!REGEX(LCASE(?title), "^\\[.*\\]$"))
}
ORDER BY DESC(?QuickStatements)
LIMIT 10000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?QuickStatements") v3("?item"):::projected v2("?title"):::projected a1((" ")) a2((" ")) c4(["wd:Q56241615"]):::iri f0[["not regex(lower-case(?title),'^\#91;.*\#93;$')"]] f0 --> v2 f1[["regex(lower-case(?title),'\b(the|and|which|with|why|where|what|from)\b')"]] f1 --> v2 v3 --"wdt:P6104"--> c4 v3 --"wdt:P356"--> a1 v3 --"wdt:P1476"--> v2 subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; v3 --"wdt:P407"--> a2 end bind3[/"concat(encode-for-uri(replace(str(?item),'.*Q','Q')),'|P407|Q1860|S887|Q69652283')"/] v3 --o bind3 bind3 --as--o v4