579
edits
Project:SPARQL/examples: Difference between revisions
→Wikidata URL is not a URL
| Line 3,847: | Line 3,847: | ||
} | } | ||
ORDER BY ?itemLabel | ORDER BY ?itemLabel | ||
</sparql> | |||
=== Oxford and Cambridge academic degrees potential date problems === | |||
<sparql tryit="1"> | |||
#title:academic degree Oxford/Cambridge date issues | |||
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 bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | |||
SELECT distinct ?personLabel ?degreeLabel ?byLabel ?subjectLabel | |||
?date ?date_label ?s ?person #?subject ?degree ?by ?university | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . #select women | |||
# academic degree = P59. | |||
?person bnp:P59 ?s . | |||
?s bnps:P59 ?degree . # type of degree | |||
# optional qualifiers for degree | |||
# P60 subject | |||
optional { ?s bnpq:P60 ?subject} | |||
# P61 conferred by | |||
?s bnpq:P61 ?by . | |||
# date with type | |||
?s ?pq ?date . | |||
?qual_prop wikibase:qualifier ?pq; | |||
wikibase:propertyType wikibase:Time ; # nb excludes edtf dates | |||
rdfs:label ?date_label . filter(lang(?date_label)="en") . # what kind of date is it. | |||
# filter: (cambridge (Q1181) and before 1948) OR (oxford (Q364) and before 1920) | |||
filter( ( year(?date)<1920 && ?by=bnwd:Q364 ) || ( year(?date)<1948 && ?by=bnwd:Q1181 ) ) | |||
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en".} | |||
} | |||
order by ?byLabel ?personLabel ?date ?degreeLabel | |||
</sparql> | </sparql> | ||