query-1d01af9cf6305406c926a774f99ec54c

rq turtle/ttl

List Archival Collections and Oral Histories related to Historic Westside Legacy Park HonoreesGenerate list of Legacy Park honorees and their related archival collections

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
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 ?honoree ?honoreeLabel ?honoreeDescription ?relatedCollections ?inventoryNum ?collectionGuide (year(?c) AS ?cohort)  
WHERE
{
  ?honoree wdt:P166 wd:Q105719274 ;
             p:P166 ?statement ;
             p:P485 ?statement2 .
     OPTIONAL {?statement ps:P166 ?awardRecieved . }
     OPTIONAL {?statement pq:P585 ?c . }
     OPTIONAL {?statement2 pq:P1810 ?relatedCollections . }
     OPTIONAL {?statement2 pq:P217 ?inventoryNum . }
     OPTIONAL {?statement2 pq:P973 ?collectionGuide . }
     SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
     FILTER(?awardRecieved IN(wd:Q105719274 ) ) #DISPLAY Legacy Park honorees (Q105719274)
}ORDER BY ?honoreeLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?awardRecieved") v6("?c"):::projected v10("?cohort") v9("?collectionGuide"):::projected v3("?honoree"):::projected v1("?honoreeLabel"):::projected v8("?inventoryNum"):::projected v7("?relatedCollections"):::projected v4("?statement") v5("?statement2") c13(["en"]):::literal c11(["bd:serviceParam"]):::iri c1(["wd:Q105719274"]):::iri f0[["?awardRecieved = 'wd:Q105719274'"]] f0 --> v2 v3 --"p:direct/P166"--> c1 v3 --"p:P166"--> v4 v3 --"p:P485"--> v5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:statement/P166".-> v2 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:qualifier/P585".-> v6 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:qualifier/P1810".-> v7 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:qualifier/P217".-> v8 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:qualifier/P973".-> v9 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end bind1[/"year-from-dateTime(?c)"/] v6 --o bind1 bind1 --as--o v10