Project:SPARQL/examples: Difference between revisions

Project:SPARQL/examples (view source)

1,205 bytes added , 3 months ago

579

edits

@@ Line 594: / Line 594: @@
 ORDER BY ?personLabel ?s
+</sparql>
+=== Women corresponding with individuals ===
+<sparql tryit="1">
+#title:women corresponding with individuals
+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 ?person ?personLabel ?correspondent ?correspondentLabel  ?qualifier_label
+?qualifer ?qualifierLabel
+where
+{
+  ?person bnwdt:P3 bnwd:Q3 .
+  ?person bnp:P73 ?s .
+    ?s bnps:P73 ?correspondent . # corresponded with
+    ?correspondent bnwdt:P12 bnwd:Q2137 .  # correspondent is i/o human
+     optional
+      { ?s ?qual_p ?qualifier .
+        ?qual_prop wikibase:qualifier ?qual_p.
+        ?qual_prop rdfs:label ?qualifier_label. filter(lang(?qualifier_label)='en') .
+       }
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". }
+}
+ORDER BY ?person
 </sparql>