6,317
edits
Project:SPARQL/examples: Difference between revisions
no edit summary
No edit summary |
|||
| Line 103: | Line 103: | ||
# 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> | </sparql> | ||
===People whose signed nomination for SAL elections based on personal knowledge, sorted by frequency of signatures=== | |||
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/> | |||
SELECT ?SALsignatoryLabel ?SALsignatory (count(*) as ?count) WHERE { | |||
?person bnp:P16 ?SALstatement . | |||
?SALstatement bnps:P16 ?SALproposed . | |||
?SALstatement bnpq:P32 ?SALsignatory . | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". | |||
} | |||
} | |||
GROUP BY ?SALsignatoryLabel ?SALsignatory | |||
ORDER BY DESC(?count) | |||
===People whose elections were proposed to SAL or RAI, including who proposed, seconded, or signed (excluding 'general knowledge' signatures) their proposal for election, seperated by type, and including the date the proposals were made=== | ===People whose elections were proposed to SAL or RAI, including who proposed, seconded, or signed (excluding 'general knowledge' signatures) their proposal for election, seperated by type, and including the date the proposals were made=== | ||