query-06e22b5f862aa8f05c63db313093bcbf
List of entries with an Apple podcast id, but without an episode count or "link rot"
Use at
- https://query.wikidata.org/sparql
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:P5842 ?statement0.
?statement0 (ps:P5842) _:anyValueP5842.
MINUS {
?item p:P1113 ?statement1.
?statement1 (psv:P1113/wikibase:quantityAmount) ?numericQuantity.
}
MINUS {
?item p:P1534 ?statement2.
?statement2 (ps:P1534) wd:Q1193907.
}
}
LIMIT 1000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?item"):::projected
v4("?numericQuantity")
v2("?statement0")
v3("?statement1")
v5("?statement2")
a1((" "))
a2((" "))
c8(["wd:Q1193907"]):::iri
v1 --"p:P5842"--> v2
v2 --"p:statement/P5842"--> a1
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v1 --"p:P1113"--> v3
v3 --"p:statement/value/P1113"--> a2
a2 --"wikibase:quantityAmount"--> v4
end
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v1 --"p:P1534"--> v5
v5 --"p:statement/P1534"--> c8
end