Project:SPARQL/examples: Difference between revisions

Project:SPARQL/examples (view source)

Revision as of 15:28, 2 October 2023

1,329 bytes added , 7 months ago

→‎Women with publications listed in indexes of archaeological papers circa 1870 - 1907

Sharon

586

edits

@@ Line 316: / Line 316: @@
 <sparql tryit="1">
-# Women with publications listed in indexes of archaeological papers circa 1870 - 1907
+# Women with publications listed in indexes of archaeological papers by journal
 PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/>
@@ Line 334: / Line 334: @@
 }
 ORDER BY ?personLabel
+</sparql>
+===Women with publications in indexes of archaeological papers, listed by name of journal ===
+<sparql tryit="1">
+# Women with publications listed in indexes of archaeological papers circa 1870 - 1907
+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  ?inLabel ?personLabel ?in ?person
+WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . # select women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?person bnwdt:P76 bnwd:Q419 . # select people with publications listed in indexes of archaeological papers
+  ?person bnp:P76 ?s .
+    #?s ?p ?fish .
+    # anything of note apart from recorded in? some P83 collaborated with. a few dates; a few text notes.
+  ## works published in P101
+    #optional {
+      ?s bnpq:P101 ?in .
+    #}
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+ORDER BY ?inLabel ?personLabel
 </sparql>