80,516
edits
Querying: Difference between revisions
→Sample queries
| Line 131: | Line 131: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } | ||
} | } | ||
=== Status count === | |||
Which regions have the most status changes entered in Ottgaz? [https://tinyurl.com/2a2akktv run] | |||
SELECT (COUNT (DISTINCT ?statement) AS ?statementCount) (COUNT (DISTINCT ?status) AS ?statusCount) ?regionLabel | |||
WHERE | |||
{ | |||
?region ogp:P15 ?statement. | |||
?statement ogps:P15 ?status. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } | |||
} | |||
GROUP BY ?regionLabel | |||
ORDER BY desc(?statementCount) | |||
LIMIT 100 | |||
== Federated query with Wikidata == | == Federated query with Wikidata == | ||