7,235
edits
Project:SPARQL/examples: Difference between revisions
no edit summary
No edit summary |
|||
| Line 385: | Line 385: | ||
} | } | ||
ORDER BY ?regionLabel | ORDER BY ?regionLabel | ||
</sparql> | |||
===People who proposed elections to SAL, sorted by the frequency of individual co-signatories=== | |||
<sparql tryit="1"> | |||
# people who proposed elections to SAL, sorted by the frequency of individual co-signatories | |||
# e.g. Q137 co-signed proposals from Q136 on the number of occasions recorded in the 'co-signatory_count' column | |||
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 ?SALproposerLabel ?SALproposer ?co_signatoryLabel ?co_signatory (count(?co_signatory) as ?co_signatory_count) WHERE { | |||
?person bnp:P16 ?SALstatement . | |||
?SALstatement bnps:P16 ?SALproposer . | |||
?SALstatement bnpq:P32 ?co_signatory . | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". | |||
} | |||
} | |||
GROUP BY ?SALproposerLabel ?SALproposer ?co_signatoryLabel ?co_signatory | |||
ORDER BY DESC(?co_signatory_count) | |||
</sparql> | </sparql> | ||