query-7dfcbffc8b84842c17d6320d4019a7aa

rq turtle/ttl

TODO

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT (REPLACE(STR(?item), "http://www.wikidata.org/entity/", "") as ?i) WHERE {
  ?item wdt:P98 wd:Q4233718.
  ?item p:P98 ?statement.
  ?statement ?qual ?qualValue.
  BIND(STR(?qual) as ?qualUri).
  BIND(IF(STRSTARTS(?qualUri, "http://www.wikidata.org/prop/qualifier/"), 1, 0) as ?badQual).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?item
HAVING (SUM(?badQual) < 1)
LIMIT 1000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?_anon_d00291b7e9a143df8ec0be8c8ebd714c97889") v6("?badQual") v8("?i") v1("?item"):::projected v3("?qual") v5("?qualUri") v4("?qualValue") v2("?statement") a1((" ")) c6(["bd:serviceParam"]):::iri c3(["wd:Q4233718"]):::iri c8(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[[" < '1^^xsd:integer'"]] f0 --> a1 v1 --"p:direct/P98"--> c3 v1 --"p:P98"--> v2 v2 -->v3--> v4 bind1[/"str(?qual)"/] v3 --o bind1 bind1 --as--o v5 bind2[/"if(starts-with(?qualUri,'http://www.wikidata.org/prop/qualifier/'),'1^^xsd:integer','0^^xsd:integer')"/] v5 --o bind2 bind2 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 end bind4[/"sum(?badQual)"/] v6 --o bind4 bind4 --as--o v7 bind5[/"replace(str(?item),'http://www.wikidata.org/entity/','')"/] v1 --o bind5 bind5 --as--o v8