User:SixTwoEight/Easy anonymous replacements
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