query-31b2e47f214184df357fcc817eee164a
On focus list of / maintained by Wikiproject AAAll album items must be on both lists!
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT
?item ?itemLabel
?onfocuslistLabel ?onfocuslistP518 ?onfocuslistP518Label
?maintainedbyLabel ?maintainedbyP518 ?maintainedbyP518Label
WHERE
{
?item p:P31/ps:P31 wd:Q457843 .
?item p:P195/ps:P195 wd:Q1526131.
OPTIONAL {?item p:P5008 ?x.
?x ps:P5008 ?onfocuslist.
FILTER(?onfocuslist = wd:Q99484628) # only 'WikiProject Alba amicorum of the KB, national library of the Netherlands'
#?x pq:P518 ?onfocuslistP518 #aplies to part = P518
#FILTER(?onfocuslistP518 = ?item)
}
OPTIONAL {?item p:P6104 ?y.
?y ps:P6104 ?maintainedby.
FILTER(?maintainedby = wd:Q99484628) # only 'WikiProject Alba amicorum of the KB, national library of the Netherlands'
#?y pq:P518 ?maintainedbyP518 #aplies to part = P518
#FILTER(?maintainedbyP518 = ?item)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". }
}
ORDER BY ?itemLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?item"):::projected
v1("?itemLabel"):::projected
v2("?maintainedby")
v3("?onfocuslist")
v5("?x")
v6("?y")
a1((" "))
a2((" "))
c15(["#91;AUTO_LANGUAGE#93;,nl"]):::literal
c7(["wd:Q1526131"]):::iri
c13(["bd:serviceParam"]):::iri
c4(["wd:Q457843"]):::iri
v4 --"p:P31"--> a1
a1 --"p:statement/P31"--> c4
v4 --"p:P195"--> a2
a2 --"p:statement/P195"--> c7
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v4 -."p:P5008".-> v5
v5 --"p:statement/P5008"--> v3
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v4 -."p:P6104".-> v6
v6 --"p:statement/P6104"--> v2
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c13 --"wikibase:language"--> c15
end