6,317
edits
Project:SPARQL/examples: Difference between revisions
add new query
(add electors graph) |
(add new query) |
||
| Line 62: | Line 62: | ||
</sparql> | </sparql> | ||
===People elected to SAL or RAI linked to those who proposed their election=== | ===People elected to SAL or RAI linked in a graph to those who proposed their election=== | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
| Line 76: | Line 76: | ||
} | } | ||
# I don't know how to use 'edgeLabel' to show the types of interaction, but if you have an idea suggest an edit! | # I don't know how to use 'edgeLabel' to show the types of interaction, but if you have an idea suggest an edit! | ||
</sparql> | |||
===People elected to SAL or RAI, including who proposed or seconded them, seperated by type=== | |||
<sparql tryit="1"> | |||
PREFIX a: <http://beyond-notability.wiki.opencura.com/entity/> | |||
PREFIX b: <http://beyond-notability.wiki.opencura.com/prop/direct/> | |||
PREFIX bps: <http://beyond-notability.wiki.opencura.com/prop/statement/> | |||
PREFIX bpq: <http://beyond-notability.wiki.opencura.com/prop/qualifier/> | |||
SELECT ?personLabel ?RAIproposedLabel ?RAIsecondedLabel ?SALproposedLabel WHERE | |||
{ | |||
{?person b:P7 ?RAIproposed .} | |||
UNION | |||
{?person b:P8 ?RAIseconded .} | |||
UNION | |||
{?person b:P16 ?SALproposed .} | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". | |||
} | |||
} | |||
ORDER BY ?person | |||
# I don't know how to use bpq to give a date for each row: any suggestions appreciated! | |||
</sparql> | </sparql> | ||