579
edits
Project:SPARQL/examples: Difference between revisions
→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
| Line 202: | Line 202: | ||
} | } | ||
ORDER BY ?personLabel | ORDER BY ?personLabel | ||
</sparql> | |||
=== Women's interactions with SAL (Q1 and Q8)=== | |||
<sparql tryit="1"> | |||
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 distinct ?person ?personLabel ?prop ?propLabel ?pq_value ?qual_prop_label ?sal | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . # women | |||
?person ?p ?s . | |||
?prop wikibase:claim ?p; | |||
wikibase:statementProperty ?ps; | |||
wikibase:statementValue ?psv; | |||
wikibase:propertyType ?prop_type. | |||
# union query to get both q8 and q1 | |||
{ ?s ?ps bnwd:Q8 . } union { ?s ?ps bnwd:Q1 . } | |||
?s ?ps ?sal. | |||
optional { | |||
?s ?pq ?pq_value . | |||
?qual_prop wikibase:qualifier ?pq . | |||
?qual_prop rdfs:label ?qual_prop_label. filter(lang(?qual_prop_label)="en-gb") . | |||
?qual_prop wikibase:propertyType ?qual_prop_type | |||
} # /qualifiers | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | |||
ORDER BY ?personLabel ?propLabel ?s | |||
</sparql> | </sparql> | ||