query-b97188efe75689e8ece621c8354fb94f
title:deprecated mappings of MEXT school code (P11127) SELECT ?mismatch ?mismatchLabel ?mext ?item ?itemLabel ?rank WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "ja". } ?mismatch p:P11127 ?st1. ?st1 wikibase:rank wikibase:DeprecatedRank; ps:P11127 ?mext. OPTIONAL { ?item p:P11127 ?st2. ?st2 wikibase:rank ?rank; ps:P11127 ?mext. FILTER(?rank != wikibase:DeprecatedRank) } } ORDER BY (?mext)
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:deprecated mappings of MEXT school code (P11127)
SELECT ?mismatch ?mismatchLabel ?mext ?item ?itemLabel ?rank WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "ja". }
?mismatch p:P11127 ?st1.
?st1 wikibase:rank wikibase:DeprecatedRank;
ps:P11127 ?mext.
OPTIONAL {
?item p:P11127 ?st2.
?st2 wikibase:rank ?rank;
ps:P11127 ?mext.
FILTER(?rank != wikibase:DeprecatedRank)
}
}
ORDER BY (?mext)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?item"):::projected
v1("?mext"):::projected
v3("?mismatch"):::projected
v2("?rank"):::projected
v4("?st1")
v6("?st2")
c3(["bd:serviceParam"]):::iri
c5(["ja"]):::literal
c1(["wikibase:DeprecatedRank"]):::iri
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c3 --"wikibase:language"--> c5
end
v3 --"p:P11127"--> v4
v4 --"wikibase:rank"--> c1
v4 --"p:statement/P11127"--> v1
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v5 -."p:P11127".-> v6
v6 --"wikibase:rank"--> v2
v6 --"p:statement/P11127"--> v1
end