659
edits
(→Place) |
|||
Line 481: | Line 481: | ||
} | } | ||
order by ?depth ?loc1Label ?loc2Label | order by ?depth ?loc1Label ?loc2Label | ||
</sparql> | |||
== Excavations == | |||
=== Excavation directors whose linked excavation isn't an instance of excavation === | |||
<sparql tryit="1"> | |||
# tends to be because of a lack of information about the excavation but possible that some need reviewing | |||
# NB an excavation that does have i/o excavation could still be listed here if it has more than one i/o | |||
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/> | |||
#title:Excavation directors without excavations | |||
SELECT distinct ?person ?personLabel ?excavationLabel ?excavation ?ioLabel | |||
WHERE { | |||
?person bnwdt:P12 bnwd:Q2137 . | |||
?person (bnwdt:P36 | bnwdt:P37 ) ?excavation . | |||
?excavation bnwdt:P12 ?io . | |||
filter not exists { ?excavation bnwdt:P12 bnwd:Q38 . } # io not excavation | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | |||
ORDER BY ?ioLabel ?personLabel | |||
</sparql> | </sparql> | ||
edits