query-53f8d060a471ce0cb7402d8ef1863a3a
List talk radio without an ID on the Allsides database that list political leaning
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?item ?item_label ?check_url WHERE {
?item wdt:P415 wd:Q502319 .
MINUS {?item wdt:P10006 [] } .
?item rdfs:label ?item_label FILTER(lang(?item_label) = 'en') .
wd:P10006 wdt:P4354 ?fmt .
BIND(IRI(REPLACE(str(?item_label), '(^.*)', ?fmt)) AS ?check_url) .
} LIMIT 50
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?check_url"):::projected
v3("?fmt")
v2("?item"):::projected
v1("?item_label"):::projected
a1((" "))
c3(["wd:Q502319"]):::iri
c6(["wd:P10006"]):::iri
f0[["?item_label = 'en'"]]
f0 --> v1
v2 --"wdt:P415"--> c3
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v2 --"wdt:P10006"--> a1
end
v2 --"rdfs:label"--> v1
c6 --"wdt:P4354"--> v3
bind2[/"replace(str(?item_label),'(^.*)',?fmt)"/]
v1 --o bind2
v3 --o bind2
bind2 --as--o v4