Project:SPARQL/examples: Difference between revisions

Line 78: Line 78:
</sparql>
</sparql>


===People elected to SAL or RAI, including who proposed, seconded, or signed them (seperated by type) and date proposals made===
===People elected to SAL or RAI, including who proposed them for election (seperated by type) and date proposals made===


<sparql tryit="1">
<sparql tryit="1">
Line 87: Line 87:




SELECT ?personLabel ?RAIproposedLabel ?RAIsecondedLabel ?SALproposedLabel ?date WHERE
SELECT ?personLabel ?RAIproposedLabel ?SALproposedLabel ?date WHERE
{
{
   ?person ?y ?z .
   ?person ?y ?z .
Line 93: Line 93:
   ?z bnpq:P1 ?date .
   ?z bnpq:P1 ?date .
     {?person bnwdt:P7 ?RAIproposed .}
     {?person bnwdt:P7 ?RAIproposed .}
    UNION
    {?person bnwdt:P8 ?RAIseconded .}
     UNION
     UNION
     {?person bnwdt:P16 ?SALproposed .}   
     {?person bnwdt:P16 ?SALproposed .}   
6,317

edits