query-2a3a622492b7a428145deb0a69eccb17
Qualifiers used at statement for position held = MLA, Odisha SELECT ?qual ?qualLabel ?count WHERE { { SELECT ?qual (COUNT(DISTINCT ?statement) AS ?count) WHERE { ?person p:P39 ?statement. ?statement (ps:P39/wdt:P279*) wd:Q24546266. ?statement ?pq_qual ?pq_obj. ?qual wikibase:qualifier ?pq_qual. } GROUP BY ?qual } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } #<<< for generating label } ORDER BY DESC(?count)
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
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#>
# Qualifiers used at statement for position held = MLA, Odisha
SELECT ?qual ?qualLabel ?count WHERE {
{
SELECT ?qual (COUNT(DISTINCT ?statement) AS ?count) WHERE {
?person p:P39 ?statement.
?statement (ps:P39/wdt:P279*) wd:Q24546266.
?statement ?pq_qual ?pq_obj.
?qual wikibase:qualifier ?pq_qual.
}
GROUP BY ?qual
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } #<<< for generating label
}
ORDER BY DESC(?count)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v7("?count"):::projected
v2("?person")
v5("?pq_obj")
v4("?pq_qual")
v6("?qual"):::projected
v3("?statement")
a1((" "))
c7(["bd:serviceParam"]):::iri
c9(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c4(["wd:Q24546266"]):::iri
v2 --"p:P39"--> v3
v3 --"p:statement/P39"--> a1
a1 --"p:direct/P279"--> c4
v3 -->v4--> v5
v6 --"wikibase:qualifier"--> v4
bind1[/"count(?statement)"/]
v3 --o bind1
bind1 --as--o v7
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end