Wikidata:Synia:wikiproject-index

Synia: Wikiprojects

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)

Try it!