query-337579e07734c9e1ef9b1d31e7b933a0

rq turtle/ttl

TODO

Use at

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#>
SELECT ?item ?item_label ?check_url WHERE {
  ?item wdt:P31 wd:Q5 .
  MINUS {?item wdt:P734 [] } .
  ?item rdfs:label ?item_label FILTER(lang(?item_label) = 'en') .

  wd:P5452 wdt:P1630 ?fmt .
  BIND(IRI(REPLACE(str(?item_label), '(^.*)', ?fmt)) AS ?check_url) .
  FILTER regex(?item_label, " ", "i")
} LIMIT 50

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?check_url"):::projected v3("?fmt") v2("?item"):::projected v1("?item_label"):::projected a1((" ")) c8(["wd:P5452"]):::iri c5(["wd:Q5"]):::iri f0[["regex(?item_label,' ','i')"]] f0 --> v1 f1[["?item_label = 'en'"]] f1 --> v1 v2 --"wdt:P31"--> c5 subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; v2 --"wdt:P734"--> a1 end v2 --"rdfs:label"--> v1 c8 --"wdt:P1630"--> v3 bind3[/"replace(str(?item_label),'(^.*)',?fmt)"/] v1 --o bind3 v3 --o bind3 bind3 --as--o v4