query-36026edceb01c477d21ddc9eaa67bb7d
: Try this query.Doraemonplus@03:49, 29 November 2021 (UTC)) talk (Doraemonplus-- .(P1559)name in native language as (Q5287)Japanese OR to whom is given a name in (P27)country of citizenship as (Q17)Japan to whom is given (Q5)human How to find .(Q5287)Japanese given in any languages except (P1559)name in native language AND with (Q17)Japan includes (P27)country of citizenship whose (Q5)human How to find : Excellent! It surprised me that it can tell the difference among type of characters as well as of languages if it is designated. All right. Let me ask you last two more questions for my study. Larske@: Experimented another query below for myself. Larske, Jura1@
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 schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?sitelink WHERE
{
?item wdt:P31 wd:Q5.
?item wdt:P1814 ?p1814.
FILTER NOT EXISTS
{
{
?item wdt:P1477 ?p1477.
FILTER((LANG(?p1477)) = "ja")
}
UNION
{
?item wdt:P1559 ?p1559.
FILTER((LANG(?p1559)) = "ja")
}
}
?sitelink schema:about ?item;
schema:isPartOf <https://ja.wikipedia.org/>.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item"):::projected
v1("?p1477")
v3("?p1559")
v4("?p1814")
v5("?sitelink"):::projected
c11(["bd:serviceParam"]):::iri
c5(["wd:Q5"]):::iri
c9([https://ja.wikipedia.org/]):::iri
c13(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["not "]]
subgraph f0e0["Exists Clause"]
subgraph unione00[" Union "]
subgraph unione00l[" "]
style unione00l fill:#abf,stroke-dasharray: 3 3;
e0f0[["?p1559 = 'ja'"]]
e0f0 --> e0v3
e0v2 --"wdt:P1559"--> e0v3
end
subgraph unione00r[" "]
style unione00r fill:#abf,stroke-dasharray: 3 3;
e0f1[["?p1477 = 'ja'"]]
e0f1 --> e0v1
e0v2 --"wdt:P1477"--> e0v1
end
unione00r <== or ==> unione00l
end
e0v2("?item"):::projected
e0v1("?p1477"):::projected
e0v3("?p1559"):::projected
end
f0--EXISTS--> f0e0
f0 --> v1
f0 --> v2
f0 --> c2
f0 --> v3
f0 --> c3
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
f1[["?p1559 = 'ja'"]]
f1 --> v3
v2 --"wdt:P1559"--> v3
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
f2[["?p1477 = 'ja'"]]
f2 --> v1
v2 --"wdt:P1477"--> v1
end
union0r <== or ==> union0l
end
v2 --"wdt:P31"--> c5
v2 --"wdt:P1814"--> v4
v5 --"schema:about"--> v2
v5 --"schema:isPartOf"--> c9
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c11 --"wikibase:language"--> c13
end