query-2b498905d05a7313dd3ed9e29f8bd405
2017-07-15: Party/Group Property • Scottish Parliament tidying • Legislative Membership stats statements: (Q10655178)member of the Swedish Riksdag : (P39)position held All the qualifiers used on TODO statements: (Q10655178)member of the Swedish Riksdag : (P39)position held All the qualifiers used on
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?qual ?qualLabel (COUNT(DISTINCT ?person) AS ?count)
WHERE {
?person p:P39 [ ps:P39 wd:Q10655178 ; ?pq_qual ?pq_obj ] .
?qual wikibase:qualifier ?pq_qual .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}
GROUP BY ?qual ?qualLabel
ORDER BY DESC (?count)
Query found at
- https://www.wikidata.org/wiki/Property_talk:P39
- https://www.wikidata.org/wiki/User:Oravrattas/daynotes
- https://www.wikidata.org/wiki/User:Oravrattas/daynotes/2017-07-15
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?count")
v4("?person"):::projected
v3("?pq_obj")
v2("?pq_qual")
v5("?qual"):::projected
a1((" "))
c6(["bd:serviceParam"]):::iri
c8(["en"]):::literal
c2(["wd:Q10655178"]):::iri
a1 --"p:statement/P39"--> c2
a1 -->v2--> v3
v4 --"p:P39"--> a1
v5 --"wikibase:qualifier"--> v2
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c6 --"wikibase:language"--> c8
end
bind1[/"count(?person)"/]
v4 --o bind1
bind1 --as--o v6