query-19413a17f2cb9a839a966b7edd3aa481
図書館に分類されている項目でISILが入っていないもの+ラベルに"立"を含むもの
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
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#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?__ ?__Label ?loc ?jawp WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
?__ (wdt:P31/wdt:P279*) wd:Q7075;
wdt:P17 wd:Q17.
OPTIONAL {?__ wdt:P791 ?isil;}
FILTER (!BOUND(?isil))
OPTIONAL { ?__ rdfs:label ?l. FILTER (lang(?l) = 'ja') }
FILTER (BOUND(?l))
FILTER (CONTAINS(?l, "立"@ja))
}
LIMIT 1000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?__"):::projected
v2("?isil")
v1("?l")
a1((" "))
c11(["wd:Q17"]):::iri
c9(["wd:Q7075"]):::iri
c4(["bd:serviceParam"]):::iri
c6(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["contains(?l,s立^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#langString>')"]]
f0 --> v1
f1[["bound(?l)"]]
f1 --> v1
f2[["not bound(?isil)"]]
f2 --> v2
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c4 --"wikibase:language"--> c6
end
v3 --"wdt:P31"--> a1
a1 --"wdt:P279"--> c9
v3 --"wdt:P17"--> c11
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P791".-> v2
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v3 -."rdfs:label".-> v1
end