586
edits
Project:SPARQL/examples: Difference between revisions
→BN Men in Wikidata: Spouses
| Line 2,578: | Line 2,578: | ||
} | } | ||
ORDER BY ?proposerLabel | ORDER BY ?proposerLabel | ||
</sparql> | |||
=== Archaeological sites/Historic houses and their owners/operators in Wikidata === | |||
<sparql tryit="1"> | |||
#title:archaeological sites/historic houses in wikidata | |||
##todo get instance of label for the type of location | |||
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 distinct ?item ?itemLabel ?wikidata ?wd_owner_label ?wd_operator_label ?wd_member_label #?wd_owner ?wd_operator | |||
WHERE { | |||
{ ?item bnwdt:P12 bnwd:Q86 . } # instance of archaeological site | |||
union | |||
{ ?item bnwdt:P12 bnwd:Q2961 . } # instance of historic house | |||
?item bnwdt:P117 ?wikidata_id . | |||
bind(iri(concat("http://www.wikidata.org/entity/", str(?wikidata_id))) as ?wikidata) . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
optional { ?wikidata wdt:P127 ?wd_owner .} # can be individuals and multiple. | |||
optional { ?wikidata wdt:P137 ?wd_operator . } | |||
optional { ?wikidata wdt:P463 ?wd_member . } | |||
## at least some had *both* owned by *and* operator, but not always the case. | |||
## owned by P127 / operator P137 | |||
## English Heritage Q936287 National Trust (Q333515) | |||
## member of P463 Historic Houses Association (Q5773523) | |||
# automatic *Label doesn't work with a federated query; rdfs:label instead. | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "en". | |||
?wd_owner rdfs:label ?wd_owner_label. | |||
?wd_operator rdfs:label ?wd_operator_label. | |||
?wd_member rdfs:label ?wd_member_label. | |||
} | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | |||
order by ?itemLabel | |||
</sparql> | </sparql> | ||