query-ff36fd94a82ca20e3173abc369ddb28f

rq turtle/ttl

list of 100 podcasts that havnt ended

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?item WHERE {
  ?item p:P31 ?statement0.
  ?statement0 (ps:P31) wd:Q24634210.
  ?item p:P5842 ?statement1.
  ?statement1 (ps:P5842) _:anyValueP5842.
  MINUS {
    ?item p:P582 ?statement_2.
    ?statement_2 psv:P582 ?statementValue_2.
    ?statementValue_2 wikibase:timeValue ?P582_2.
  }
}
LIMIT 100

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?P582_2") v1("?item"):::projected v2("?statement0") v3("?statement1") v5("?statementValue_2") v4("?statement_2") a1((" ")) c3(["wd:Q24634210"]):::iri v1 --"p:P31"--> v2 v2 --"p:statement/P31"--> c3 v1 --"p:P5842"--> v3 v3 --"p:statement/P5842"--> a1 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v1 --"p:P582"--> v4 v4 --"p:statement/value/P582"--> v5 v5 --"wikibase:timeValue"--> v6 end