Project:SPARQL/examples: Difference between revisions

Project:SPARQL/examples (view source)

Revision as of 01:13, 16 January 2023

1,688 bytes added , 1 year ago

no edit summary

Drjwbaker

Bureaucrats, Administrators

7,354

edits

@@ Line 137: / Line 137: @@
 GROUP BY ?SALproposerLabel ?SALproposer ?co_signatoryLabel ?co_signatory
 ORDER BY DESC(?co_signatory_count)
+</sparql>
+===Women who are listed as Fellows of the Society of Antiquaries of London (FSAs) on our wikibase and who are on Wikidata, but are not listed as FSAs on Wikidata===
+<sparql tryit="1">
+# Women who are listed as Fellows of the Society of Antiquaries of London (FSAs) on our wikibase and who are on Wikidata, but are not listed as FSAs on Wikidata
+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/>
+PREFIX wdt: <http://www.wikidata.org/prop/direct/>
+PREFIX wd:  <http://www.wikidata.org/entity/>
+SELECT ?person ?personLabel
+WHERE {
+  ?person bnwdt:P3 bnwd:Q3 . #select women
+  FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team
+  ?person bnp:P117 ?wikidata_ID . #look for wikidata ID on person page
+  ?wikidata_ID bnpq:P14 ?wikidata_url .
+  BIND(IRI(REPLACE(?wikidata_url,"https://www.wikidata.org/wiki/","http://www.wikidata.org/entity/")) as ?item )
+  SERVICE <https://query.wikidata.org/sparql> {
+        ?item wdt:P21 ?WD_gender. #get gender of person
+        FILTER NOT EXISTS {?item wdt:P166 wd:Q26196499 . } #not FSA on Wikidata
+      }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". }
+}
+ORDER BY ?personLabel
+# with thanks to @tagishsimon for writing this one initially!
 </sparql>