SELECT
?items
?wikiproject ?wikiprojectLabel
(CONCAT("#wikiproject/", SUBSTR(STR(?wikiproject), 32)) AS ?wikiprojectUrl)
?wikiprojectDescription
("Wikidata ↗" AS ?wikidata)
(CONCAT("https://www.wikidata.org/wiki/", SUBSTR(STR(?wikiproject), 32)) AS ?wikidataUrl)
("Scholia ↗" AS ?scholia)
(CONCAT("https://scholia.toolforge.org/wikiproject/", SUBSTR(STR(?wikiproject), 32)) AS ?scholiaUrl)
WITH {
SELECT
(COUNT(?item) AS ?items)
?wikiproject
WHERE {
?wikiproject wdt:P31 wd:Q16695773 ;
^wdt:P6104 ?item .
}
GROUP BY ?wikiproject
} AS %wikiprojects
WHERE {
INCLUDE %wikiprojects
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?items)