586
edits
Project:SPARQL/examples: Difference between revisions
→Archaeological sites/Historic houses and their owners/operators in Wikidata
| Line 2,584: | Line 2,584: | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title:archaeological sites/historic houses in wikidata | #title:archaeological sites/historic houses in wikidata | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
| Line 2,594: | Line 2,593: | ||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | 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 | SELECT distinct ?item ?itemLabel ?instanceLabel ?wikidata ?wd_owner_label ?wd_operator_label ?wd_member_label #?wd_owner ?wd_operator | ||
WHERE { | WHERE { | ||
| Line 2,601: | Line 2,600: | ||
union | union | ||
{ ?item bnwdt:P12 bnwd:Q2961 . } # instance of historic house | { ?item bnwdt:P12 bnwd:Q2961 . } # instance of historic house | ||
?item bnwdt:P12 ?instance . # which instance of is it | |||
filter ( ?instance in (bnwd:Q86, bnwd:Q2961) ) . # (need filter as a few have multiple instance of) | |||
?item bnwdt:P117 ?wikidata_id . | ?item bnwdt:P117 ?wikidata_id . | ||