Template:StatisticsRow: Difference between revisions

Revision as of 11:35, 24 May 2024

|- | {{{1}}} | [1]

@@ Line 4: / Line 4: @@
 [https://query.portal.mardi4nfdi.de/#{{urlencode:PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
 PREFIX wd: <https://portal.mardi4nfdi.de/entity/>
-SELECT (COUNT(*) as ?work)
+SELECT ?itemLabel ?value ?item # Replace with (COUNT(*) as ?cnt) to get the count
-WHERE { {{{2}}} }|PATH}} {{#invoke:MySPARQL|showFirstValue|
+WHERE {  {{{2}}} .
+         SERVICE wikibase:label {
+     bd:serviceParam wikibase:language "en" .
+   } }
+LIMIT 50 # Remove this line to get the counts
+|PATH}} {{#invoke:MySPARQL|showFirstValue|
 PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
 PREFIX wd: <https://portal.mardi4nfdi.de/entity/>
 SELECT (COUNT(*) as ?work)
 WHERE { {{{2}}} } }} ]