query-95503d201773fac22740f1457595cbeb
Things with a CBDB ID but no country (/ gender)
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
SELECT ?wd (CONCAT("http://db1.ihp.sinica.edu.tw/cbdbc/cbdbkmeng?~~AAA",?cbdb) AS ?cbdb_url) ?period WHERE {
?wd wdt:P497 ?cbdb.
OPTIONAL {?wd wdt:P2348 ?period}
MINUS {?wd wdt:P27 [] } # country
#MINUS {?wd wdt:P21 [] } # gender
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?cbdb"):::projected
v4("?cbdb_url")
v3("?period"):::projected
v1("?wd"):::projected
a1((" "))
v1 --"wdt:P497"--> v2
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P2348".-> v3
end
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P27"--> a1
end
bind1[/"concat('http://db1.ihp.sinica.edu.tw/cbdbc/cbdbkmeng?~~AAA',?cbdb)"/]
v2 --o bind1
bind1 --as--o v4