6,317
edits
Project:SPARQL/examples: Difference between revisions
no edit summary
No edit summary |
|||
| Line 139: | Line 139: | ||
ORDER BY ?date | ORDER BY ?date | ||
# I only got how to do this when I read https://wdqs-tutorial.toolforge.org/index.php/category/simple-queries/qualifiers/ Huge thanks to @Tagishsimon for pointing out my error and forcing me to do it properly :) | # I only got how to do this when I read https://wdqs-tutorial.toolforge.org/index.php/category/simple-queries/qualifiers/ Huge thanks to @Tagishsimon for pointing out my error and forcing me to do it properly :) | ||
</sparql> | |||
===People not in London linked by a county at which they were once resident=== | |||
<sparql tryit="1"> | |||
PREFIX bnwd: <http://beyond-notability.wiki.opencura.com/entity/> | |||
PREFIX bnwds: <http://beyond-notability.wiki.opencura.com/entity/statement/> | |||
PREFIX bnwdv: <http://beyond-notability.wiki.opencura.com/value/> | |||
PREFIX bnwdt: <http://beyond-notability.wiki.opencura.com/prop/direct/> | |||
PREFIX bnp: <http://beyond-notability.wiki.opencura.com/prop/> | |||
PREFIX bnps: <http://beyond-notability.wiki.opencura.com/prop/statement/> | |||
PREFIX bnpq: <http://beyond-notability.wiki.opencura.com/prop/qualifier/> | |||
#defaultView:Graph | |||
SELECT ?resident ?residentLabel ?county ?countyLabel | |||
WHERE { | |||
?resident bnwdt:P29 ?residence . | |||
FILTER NOT EXISTS {?resident bnwdt:P29 bnwd:Q39 .} | |||
?residence bnwdt:P33 ?district . | |||
?district bnwdt:P33 ?county . | |||
?county bnwdt:P33 ?region . | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | |||
</sparql> | </sparql> | ||