query-2c059e9787e27cf58e42ab73a3ca1960

rq turtle/ttl

List of TTRPG citing other TTRPG with date range

Use at

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 DISTINCT ?itemLabel ?cited_worksLabel (YEAR(?when) as ?date) WHERE {
    ?item wdt:P31 wd:Q1643932.
    ?item wdt:P2860 ?cited_works.
    OPTIONAL {?item wdt:P577 ?when.}
    ?cited_works wdt:P31 wd:Q1643932.

  FILTER(YEAR(?when) >= 1970 && YEAR(?when) <= 1979)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?cited_works") v4("?date") v2("?item") v1("?when"):::projected c8(["bd:serviceParam"]):::iri c4(["wd:Q1643932"]):::iri c10(["en"]):::literal f0[["year-from-dateTime(?when) >= '1970^^xsd:integer'year-from-dateTime(?when) <= '1979^^xsd:integer'"]] f0 --> v1 v2 --"wdt:P31"--> c4 v2 --"wdt:P2860"--> v3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P577".-> v1 end v3 --"wdt:P31"--> c4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end bind1[/"year-from-dateTime(?when)"/] v1 --o bind1 bind1 --as--o v4