Main Page: Difference between revisions

Revision as of 10:32, 20 December 2022

NLW Wikibase....aim to produce UI like this

@@ Line 5: / Line 5: @@
-<iframe style="width: 80vw; height: 50vh; border: none;" src="https://query.wikidata.org/embed.html#%23Goats%0ASELECT%20%3Fitem%20%3FitemLabel%20%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ2934.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D" referrerpolicy="origin" sandbox="allow-scripts allow-same-origin allow-popups"></iframe>
+{| width=100%
+| width=50% |
+{{Graph:Pie chart
+| height=50
+| title= Type of place
+| valueColumn=count
+| labelColumn=instanceLabel
+| query=
+SELECT ?instance ?instanceLabel ?count { {
+    SELECT ?instance (COUNT(DISTINCT ?item) as ?count) {
+          {?item wdt:P131 wd:Q25 . }
+  UNION { ?item wdt:P131 ?pob . ?pob wdt:P131* wd:Q25 }
+          ?item  wdt:P31 ?instance.}
+    GROUP BY ?instance
+    HAVING (?count > 100)}
+ SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } }
+ORDER BY DESC(?count)
+LIMIT 15
+OFFSET 0
+}}