Project:SPARQL/admin: Difference between revisions

Project:SPARQL/admin (view source)

1,291 bytes added , 1 month ago

653

edits

@@ Line 481: / Line 481: @@
      }
 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>