Wikidata:Topics/Wikidata/WikiProjects

SELECT ?project ?projectLabel ?inception (GROUP_CONCAT(?subject) as ?subjects) (GROUP_CONCAT(?subjectLabel; SEPARATOR = '\n') as ?subjectLabels)
WHERE 
{
  ?project wdt:P31/wdt:P279* wd:Q115473050.
  
  OPTIONAL {?project wdt:P571 ?inception}
  OPTIONAL {?project wdt:P921 ?subject}

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    ?project rdfs:label ?projectLabel.
    ?subject rdfs:label ?subjectLabel.
  }
} GROUP BY ?project ?linkcount ?projectLabel ?inception ORDER BY ?projectLabel

Try it!