query-319872361824226ea1ec7199e910dfd0
Simpler query just showing 50 names and without any refinement in regard to popularity TODO
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:P31 wd:Q101352 .
MINUS {?item wdt:P5452 [] } .
?item rdfs:label ?item_label FILTER(lang(?item_label) = 'en') .
wd:P5452 wdt:P1630 ?fmt .
BIND(IRI(REPLACE(str(?item_label), '(^.*)', ?fmt)) AS ?check_url) .
} LIMIT 50
Query found at
- https://www.wikidata.org/wiki/Property_talk:P5452
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/02
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:Q101352"]):::iri
c6(["wd:P5452"]):::iri
f0[["?item_label = 'en'"]]
f0 --> v1
v2 --"wdt:P31"--> c3
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v2 --"wdt:P5452"--> a1
end
v2 --"rdfs:label"--> v1
c6 --"wdt:P1630"--> v3
bind2[/"replace(str(?item_label),'(^.*)',?fmt)"/]
v1 --o bind2
v3 --o bind2
bind2 --as--o v4