query-31b2e47f214184df357fcc817eee164a

rq turtle/ttl

On focus list of / maintained by Wikiproject AAAll album items must be on both lists!

Use at

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