Dedicated Dashboard

Title:

Dashboard query:
SELECT (COUNT(*) AS ?count) WHERE { BIND(<%COLUMN_VALUE%> AS ?position) . ?item wdt:P31 wd:Q5 ; wdt:P39 ?position . %CONDITION% }
List query:
SELECT ?item ?itemLabel WHERE { BIND(<%COLUMN_VALUE%> AS ?position) . ?item wdt:P31 wd:Q5 ; wdt:P39 ?position . SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } . %CONDITION% } ORDER BY ?itemLabel

Title:

Query:
SELECT ?column_value ?column_label WHERE { ?column_value p:P279 [ rdf:type wikibase:BestRank ; ps:P279 wd:Q16707842 ; pq:P2937 [ p:P31 [ rdf:type wikibase:BestRank ; pq:P1545 ?column_label ] ] ] . } ORDER BY xsd:integer(?column_label)