6,317
edits
Project:SPARQL/examples: Difference between revisions
→People elected to SAL or RAI, including who proposed or seconded them (seperated by type) and date proposals made
| Line 87: | Line 87: | ||
SELECT ?personLabel ? | SELECT ?personLabel ?RAIproposedLabel ?RAIsecondedLabel ?SALproposedLabel ?date WHERE | ||
{ | { | ||
?person ?y ?z . | ?person ?y ?z . | ||
?person b:P3 ?gender . | ?person b:P3 ?gender . | ||
?z bpq:P1 ?date . | ?z bpq:P1 ?date . | ||
{?person b:P7 ? | {?person b:P7 ?RAIproposed .} | ||
UNION | UNION | ||
{?person b:P8 ? | {?person b:P8 ?RAIseconded .} | ||
UNION | UNION | ||
{?person b:P16 ? | {?person b:P16 ?SALproposed .} | ||
SERVICE wikibase:label { | SERVICE wikibase:label { | ||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". | ||