query-3cc766cc5261e08941cd7cad436372f9
TODO
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 ?item ?itemLabel {
?item wdt:P31 wd:Q4022 .
filter not exists {
?sitelink schema:about ?item; schema:inLanguage ?lang .
filter (?lang = 'ru')
}
filter exists {
?sitelink schema:about ?item; schema:inLanguage ?lang .
filter (?lang in ("uk","be","pl","cs","sk","bg","mk","sh","hr","sl","bs","hsb","csb","rue","szl"))
}
service wikibase:label { bd:serviceParam wikibase:language "ru,uk,be,pl,cs,sk,bg,mk,sh,hr,sl,bs,hsb,csb,rue,szl" }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?item"):::projected
v1("?lang")
v2("?sitelink")
c22(["bd:serviceParam"]):::iri
c20(["wd:Q4022"]):::iri
c24(["ru,uk,be,pl,cs,sk,bg,mk,sh,hr,sl,bs,hsb,csb,rue,szl"]):::literal
f0[[" "]]
subgraph f0e0["Exists Clause"]
e0list0c2(["be"]):::literal
e0list0c14(["rue"]):::literal
e0list0c15(["szl"]):::literal
e0list0c6(["bg"]):::literal
e0list0c9(["hr"]):::literal
e0list0c4(["cs"]):::literal
e0list0c11(["bs"]):::literal
e0list0c13(["csb"]):::literal
e0list0c8(["sh"]):::literal
e0list0c1(["uk"]):::literal
e0list0c12(["hsb"]):::literal
e0list0c5(["sk"]):::literal
e0list0c10(["sl"]):::literal
e0list0c3(["pl"]):::literal
e0list0c7(["mk"]):::literal
e0list0c1 --o e0f0
e0list0c2 --o e0f0
e0list0c3 --o e0f0
e0list0c4 --o e0f0
e0list0c5 --o e0f0
e0list0c6 --o e0f0
e0list0c7 --o e0f0
e0list0c8 --o e0f0
e0list0c9 --o e0f0
e0list0c10 --o e0f0
e0list0c11 --o e0f0
e0list0c12 --o e0f0
e0list0c13 --o e0f0
e0list0c14 --o e0f0
e0list0c15 --o e0f0
e0f0[[" in "]]
e0f0 --> e0v1
e0v2 --"schema:about"--> e0v3
e0v2 --"schema:inLanguage"--> e0v1
e0v3("?item"):::projected
e0v1("?lang"):::projected
e0v2("?sitelink"):::projected
end
f0--EXISTS--> f0e0
f0 --> v1
f0 --> v2
f0 --> c16
f0 --> v3
f0 --> c17
list1c2(["be"]):::literal
list1c14(["rue"]):::literal
list1c15(["szl"]):::literal
list1c6(["bg"]):::literal
list1c9(["hr"]):::literal
list1c4(["cs"]):::literal
list1c11(["bs"]):::literal
list1c13(["csb"]):::literal
list1c8(["sh"]):::literal
list1c1(["uk"]):::literal
list1c12(["hsb"]):::literal
list1c5(["sk"]):::literal
list1c10(["sl"]):::literal
list1c3(["pl"]):::literal
list1c7(["mk"]):::literal
list1c1 --o f1
list1c2 --o f1
list1c3 --o f1
list1c4 --o f1
list1c5 --o f1
list1c6 --o f1
list1c7 --o f1
list1c8 --o f1
list1c9 --o f1
list1c10 --o f1
list1c11 --o f1
list1c12 --o f1
list1c13 --o f1
list1c14 --o f1
list1c15 --o f1
f1[[" in "]]
f1 --> v1
v2 --"schema:about"--> v3
v2 --"schema:inLanguage"--> v1
f2[["not "]]
subgraph f2e2["Exists Clause"]
e2f0[["?lang = 'ru'"]]
e2f0 --> e2v1
e2v2 --"schema:about"--> e2v3
e2v2 --"schema:inLanguage"--> e2v1
e2v3("?item"):::projected
e2v1("?lang"):::projected
e2v2("?sitelink"):::projected
end
f2--EXISTS--> f2e2
f2 --> v1
f2 --> v2
f2 --> c16
f2 --> v3
f2 --> c17
f3[["?lang = 'ru'"]]
f3 --> v1
v2 --"schema:about"--> v3
v2 --"schema:inLanguage"--> v1
v3 --"wdt:P31"--> c20
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c22 --"wikibase:language"--> c24
end