Project:SPARQL/examples: Difference between revisions
From Beyond Notability
(→Admin) |
(→Place) |
||
| Line 391: | Line 391: | ||
UNION | UNION | ||
{?county bnwdt:P33 bnwd:Q85 .} | {?county bnwdt:P33 bnwd:Q85 .} | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | |||
ORDER BY ?regionLabel ?countyLabel ?districtLabel ?residenceLabel | |||
</sparql> | |||
===People whose residence was at one time in North East England or Yorkshire and the Humber=== | |||
<sparql tryit="1"> | |||
# People whose residence was at one time in North East England or Yorkshire and the Humber | |||
PPREFIX 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 ?resident ?residentLabel ?residenceLabel ?districtLabel ?countyLabel ?regionLabel | |||
WHERE { | |||
?resident bnwdt:P29 ?residence . | |||
?residence bnwdt:P33 ?district . | |||
?district bnwdt:P33 ?county . | |||
?county bnwdt:P33 ?region . | |||
{?county bnwdt:P33 bnwd:Q72 .} | |||
UNION | |||
{?county bnwdt:P33 bnwd:Q200 .} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | ||
} | } | ||
