579
edits
Project:SPARQL/examples: Difference between revisions
→Women and their work activities, with employers/organisations and dates
| Line 453: | Line 453: | ||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | ||
SELECT distinct ?personLabel ? | SELECT distinct ?personLabel ?workLabel ?positionLabel ?date_pLabel ?date | ||
?employerLabel ?organisedLabel ?ofLabel | ?employerLabel ?organisedLabel ?ofLabel ?person | ||
?s ? | #?s ?position ?of ?work ?employer ?organised | ||
WHERE { | WHERE { | ||
| Line 465: | Line 465: | ||
?person ?work_p ?s . # for activity type label | ?person ?work_p ?s . # for activity type label | ||
?work wikibase:claim ?work_p | ?work wikibase:claim ?work_p . | ||
# more about the position | # more about the position | ||
| Line 482: | Line 481: | ||
?s ?pq ?date . | ?s ?pq ?date . | ||
? | ?date_p wikibase:qualifier ?pq; | ||
#wikibase:propertyType ?date_prop_type; # can check date property types if needed | #wikibase:propertyType ?date_prop_type; # can check date property types if needed | ||
wikibase:propertyType wikibase:Time | wikibase:propertyType wikibase:Time . # nb *does not* include edtf dates but AFAICT there are none in qualifiers. | ||
rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # what kind of date is it. | #rdfs:label ?date_label . filter(lang(?date_label)="en-gb") . # what kind of date is it. | ||
} # /dates | } # /dates | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | ||
} # /where | } # /where | ||