query-b9a75e1b73f687558d7d8a4bf8161451

rq turtle/ttl

Find objects/values with an exact value in different variants of a language SELECT ?s ?p ?o (LANG(?o) AS ?lc) WITH { SELECT DISTINCT ?lcs WHERE { [] wdt:P424 ?lcs . FILTER(SUBSTR(?lcs, 1, 2) = "zh") } } AS %lcs WHERE { INCLUDE %lcs BIND (STRLANG("史密森尼学会", ?lcs) AS ?o) ?s ?p ?o . } LIMIT 1000

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
# Find objects/values with an exact value in different variants of a language
SELECT ?s ?p ?o (LANG(?o) AS ?lc)
WHERE {
   { SELECT DISTINCT ?lcs WHERE { 
    [] wdt:P424 ?lcs . FILTER(SUBSTR(?lcs, 1, 2) = "zh")
} }  BIND (STRLANG("史密森尼学会", ?lcs) AS ?o)
  ?s ?p ?o .
}
LIMIT 1000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?lc") v1("?lcs") v2("?o"):::projected v4("?p"):::projected v3("?s"):::projected a1((" ")) f0[["substring(?lcs,'1^^xsd:integer','2^^xsd:integer') = 'zh'"]] f0 --> v1 a1 --"wdt:P424"--> v1 bind1[/"STRLANG('史密森尼学会',?lcs)"/] v1 --o bind1 bind1 --as--o v2 v3 -->v4--> v2 bind2[/"?o"/] v2 --o bind2 bind2 --as--o v5