726
edits
(→Admin) |
|||
Line 356: | Line 356: | ||
ORDER BY ?itemLabel ?item | ORDER BY ?itemLabel ?item | ||
</sparql> | |||
=== Localities in the UK that are in more than one P33 admin territory === | |||
<sparql tryit="1"> | |||
#title:UK localities in multiple P33 admin territories | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | |||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | |||
PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/> | |||
PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/> | |||
PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/> | |||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | |||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | |||
select ?item ?itemLabel (count (distinct ?admin) as ?count) | |||
where { | |||
values ?region { bnwd:Q1231 bnwd:Q67 bnwd:Q75 bnwd:Q200 bnwd:Q1202 bnwd:Q85 bnwd:Q204 bnwd:Q1215 bnwd:Q72 bnwd:Q425 bnwd:Q1224 bnwd:Q1740 } | |||
# english regions; wales q425; scotland q1224; n.ire q1740 | |||
?item bnwdt:P12 bnwd:Q2147 . # i/o locality | |||
?item bnwdt:P33* ?region. # in ?region | |||
?item bnwdt:P33 ?admin . # parent p33 | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | |||
group by ?item ?itemLabel | |||
having (?count>1) | |||
order by ?itemLabel | |||
</sparql> | </sparql> | ||
edits