query-32dbb451ad6b2f70b6849c882e30502f
Filter using P1435 items with multiple values but include if item has any other P1435 values. Single item can have multiple different P1435 values so it can have Q31027091 AND some other value which is reason why it should be in the list. However, my problem is that filtering will drop these multiple value cases too. (Q31027091)registered archaeological site in Finland = (P1435)heritage designation Hi, I am trying to do a query where I would filter out items with is the test case which will be filtered out. (Q113617253)Keitele boundary stone Example: The 1.) All results without filtering
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?p1435
WHERE
{
?item wdt:P131 wd:Q1534714 .
?item wdt:P1435 ?p1435
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fi". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?item"):::projected
v2("?p1435"):::projected
c5(["bd:serviceParam"]):::iri
c7(["#91;AUTO_LANGUAGE#93;,fi"]):::literal
c2(["wd:Q1534714"]):::iri
v1 --"wdt:P131"--> c2
v1 --"wdt:P1435"--> v2
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c5 --"wikibase:language"--> c7
end